10-11-2007, 12:11 PM
|
#7 (permalink)
|
|
The Contributor
Join Date: Sep 2007
Posts: 31
Thanks: 0
|
Looks good. This is a MySQL database connection I wrote.
PHP Code:
define("DB_HOST", "localhost");
define("DB_USER", "root");
define("DB_PASS", "");
interface Database {
public function connect();
public function selectDB($database);
public function query($szQuery);
public function queryRow($szQuery);
}
class MySQL implements Database {
public $result = "";
private $szQuery = "";
private $connect;
public function __construct() {
$this->connect();
}
public function __destruct() {
mysql_close($this->connect);
}
public function connect() {
$this->connect = @mysql_connect(DB_HOST, DB_USER, DB_PASS)
or die ("MySQL: Cannot connect to server!");
}
public function selectDB($database) {
mysql_select_db($database) or die ("MySQL: Cannot select database!");
}
public function query($szQuery) {
$this->result = mysql_query($szQuery) or die("MySQL: Cannot perform query!");
if ($this->result) {
return true;
}
return false;
}
public function queryRow($szQuery) {
$this->result = mysql_query($szQuery) or die("MySQL: Cannot perform query!");
if (mysql_num_rows($this->result) >= 1) {
return true;
}
return false;
mysql_free_result($this->result);
}
}
|
|
|
|