For instance (I'll assume you can anticipate what the methods would actually look like)
Code: Select all
$firstname = $myClass->getFirstName($id);
$lastname = $myClass->getLastName($id);As a way to save space, I'll sometimes do if statements and add an argument:
Code: Select all
$firstname = $myClass->getName($id, FIRST);
$lastname = $myClass->getName($id, LAST);I'm kind of thinking I want to start doing something like this on methods that return 1 value:
Code: Select all
$firstname = $myClass->singleValueQuery($tablename, firstname, $id);
$lastname = $myClass->singleValueQuery($tablename, lastname, $id);Code: Select all
function singleValueQuery($tbl, $field) {
$this->query = "SELECT " . $field . " FROM " . $tbl . " WHERE id=" . $id;
$this->SQL = mysql_query($this->query, $this->link);
while($this->row = mysql_fetch_array($this->SQL))
return $this->row['".$field."'];
}