Hi all,
I am thinking about writing a web based work order system for myself. I am the lone IT guy for a small company (about 90 employees) and I seemed to be swamped with little jobs here and the along with the big jobs that my boss wants me to accomplish. Instead of trying to keep track of the thousands of emails that I get asking me to do this or fix that, I would like to develop a web based work order system. I would like to write it in php (with a database backing in mySQL), mostly because I feel pretty comfortable in it, but I am just starting to get into the more object oriented parts of php.
My thought is to make three different classes, one for submitters, one for workers (it will probably be more than just me using it eventually) and one for the work order itself.
I started working on the submitter (or user) class, and I started worndering:
Do you really need private data members if all of the data is stored in the mySQL database? Or should the class just be an amalgamation of functions to create an object and return data? Here is what i have so far:
Code:
<?php
//Connect to database
//User class
class User {
private $id;
private $name;
private $email;
private $password;
function __construct ($subName, $subEmail, $subPass) {
//Create new user in table
$query = "INSERT INTO `user` ( `id` , `name` , `email` , `pass` ) ";
$query .= "VALUES ('', '$subName', '$subEmail', '$subPass');";
$result = mysql_query($query);
mysql_close();
}
}
?>
Any comments or suggestions would be appreciated.
<edit> after mulling it over, I need to look into "worker" being a subclass of "user". Although I'm not entirely sure how sub classes work in php</edit>