Revision: 14734
Updated Code
at August 6, 2009 21:42 by StrawMan
Updated Code
////////////////////////////////////
//Simple DB Connection class.
////////////////////////////////////
class dbconnect {
//Variables.
private $host;
private $user;
private $password;
private $database;
private $lnk;
public $result;
////////////////////////////
//Constructor.
////////////////////////////
public function __construct($a, $b, $c, $d) {
$this -> host = $a;
$this -> user = $b;
$this -> password = $c;
$this -> database = $d;
}
////////////////////////////
//Public class functions.
////////////////////////////
//Query
public function func_query($qstring) {
$this -> func_connect();
mysql_query("SET NAMES 'utf8'");
$this -> result = mysql_query($qstring);
return $this -> result;
mysql_close($this -> lnk);
mysql_free_result($this -> result);
}
////////////////////////////
//Private class functions.
////////////////////////////
//Connect.
private function func_connect() {
$this -> lnk = mysql_connect($this -> host, $this -> user, $this -> password, true) OR die('Could not connect to the database - Why: '.mysql_error());
mysql_select_db($this -> database) OR die('Could not find database: '.mysql_error());
}
////////////////////////////
//Destructor.
////////////////////////////
public function __destruct() {
unset ($this -> user, $this -> password);
}
}
////////////////////////////////////
Revision: 14733
Updated Code
at August 5, 2009 20:09 by StrawMan
Updated Code
////////////////////////////////////
//Simple DB Connection class.
////////////////////////////////////
class dbconnect {
//Variables.
private $host;
private $user;
private $password;
private $database;
private $lnk;
public $result;
//Constructor.
public function __construct($a, $b, $c, $d) {
$this -> host = $a;
$this -> user = $b;
$this -> password = $c;
$this -> database = $d;
}
//Connect.
private function func_connect() {
$this -> lnk = mysql_connect($this -> host, $this -> user, $this -> password, true) OR die('Could not connect to the database - Why: '.mysql_error());
mysql_select_db($this -> database) OR die('Could not find database: '.mysql_error());
}
//Query
public function func_query($qstring) {
$this -> func_connect();
mysql_query("SET NAMES 'utf8'");
$this -> result = mysql_query($qstring);
return $this -> result;
mysql_close($this -> lnk);
mysql_free_result($this -> result);
}
//Destructor.
public function __destruct() {
unset ($this -> user, $this -> password);
}
}
////////////////////////////////////
Revision: 14732
Updated Code
at August 3, 2009 00:39 by StrawMan
Updated Code
////////////////////////////////////
//Simple DB Connection class.
////////////////////////////////////
class dbconnect {
//Variables.
private $host;
private $user;
private $password;
private $database;
private $lnk;
public $result;
//Constructor.
public function __construct($a, $b, $c, $d) {
$this -> host = $a;
$this -> user = $b;
$this -> password = $c;
$this -> database = $d;
}
//Connect.
private function func_connect() {
$this -> lnk = mysql_connect($this -> host, $this -> user, $this -> password, true) OR die('Could not connect to the database - Why: '.mysql_error());
mysql_select_db($this -> database) OR die('Could not find database: '.mysql_error());
}
//Query
public function func_query($qstring) {
$this -> func_connect();
mysql_query("SET NAMES 'utf8'");
$this -> result = mysql_query($qstring);
return $this -> result;
mysql_close($this -> lnk);
}
//Destructor.
public function __destruct() {
unset ($this -> user, $this -> password);
mysql_free_result($this -> result);
}
}
////////////////////////////////////
Revision: 14731
Updated Code
at June 10, 2009 00:22 by StrawMan
Updated Code
////////////////////////////////////
//DB Connection class.
////////////////////////////////////
class dbconnect {
//Variables.
public $host;
public $user;
public $password;
public $database;
public $lnk;
//Constructor.
public function __construct($a, $b, $c, $d) {
$this -> host = $a;
$this -> user = $b;
$this -> password = $c;
$this -> database = $d;
}
//Connect.
public function func_connect() {
$this -> lnk = mysql_connect($this -> host, $this -> user, $this -> password) OR die('Could not connect to the database - Why: '.mysql_error());
mysql_select_db($this -> database) OR die('Could not find database: '.mysql_error());
}
//Query
public function func_query($qstring) {
mysql_query("SET NAMES 'utf8'");
$result = mysql_query($qstring);
return $result;
}
//Destructor.
public function __destruct() {
unset ($this -> user, $this -> password);
mysql_close($this -> lnk);
}
}
////////////////////////////////////
Revision: 14730
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at June 10, 2009 00:20 by StrawMan
Initial Code
////////////////////////////////////
//DB Connection class.
////////////////////////////////////
class dbconnect {
//Variables.
public $host;
public $user;
public $password;
public $database;
public $lnk;
//Constructor.
public function __construct($a, $b, $c, $d) {
$this -> host = $a;
$this -> user = $b;
$this -> password = $c;
$this -> database = $d;
}
//Connect.
public function func_connect() {
$this -> lnk = mysql_connect($this -> host, $this -> user, $this -> password) OR die('Could not connect to the database - Why: '.mysql_error());
mysql_select_db($this -> database) OR die('Could not find database: '.mysql_error());
}
//Query
public function func_query($qstring) {
mysql_query("SET NAMES 'utf8'");
$result = mysql_query($qstring);
return $result;
}
//Destructor.
public function __destruct() {
unset ($this -> user, $this -> password);
mysql_close($this -> lnk);
}
}
////////////////////////////////////
Initial URL
Initial Description
Initial Title
Simple DB Connection Class
Initial Tags
database, php
Initial Language
PHP