10-11-2007, 11:43 AM
|
#6 (permalink)
|
|
The Acquainted
Join Date: Oct 2007
Posts: 170
Thanks: 18
|
I've now written 2 classes, a Database and a Member class. I'm able to execute a query with the Database class, and find a member-name with the Member class by giving an member-id.
Am I heading into the right way? (PS. Don't mind security holes, yet)
PHP Code:
class Database {
public function __construct() {
$this->connect();
}
public function connect() {
@mysql_connect('localhost', 'root', '') or die('Could not connect to the database!');
@mysql_select_db("debron") or die(mysql_error());
}
public function query($string) {
$result = mysql_query($this->secureQuery($string));
return $result;
}
public function fetch($string) {
$result = mysql_fetch_array($string);
return $result;
}
public function secureQuery($string) {
$result = mysql_real_escape_string($string);
return $result;
}
public function disconnect() {
mysql_close();
}
}
class Member {
public function __construct() {
$this->db = new Database();
}
public function findById($int) {
$sql = $this->db->query('SELECT Name FROM Members WHERE Id='.$int);
$result = $this->db->fetch($sql);
echo '<br /> <strong>Member with id '.$int.':</strong> '.$result[0];
}
}
$db = new Database();
$blaat = $db->query('SELECT Id, Name FROM Members');
echo '<strong>Names:</strong><br />';
while($row = $db->fetch($blaat)) {
echo $row['Name'].'<br />';
}
$test = new Member();
$test->findById(1);
$db->disconnect();
|
|
|
|