Viewing file: class.mysqldb.php (1.63 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
class mysqldb {
var $link;
var $result;
function connect($config) {
$this->link = mysqli_connect($config['hostname'], $config['username'], $config['password']);
if($this->link) {
mysqli_query($this->link,"SET NAMES 'utf8'");
return true;
}
$this->show_error("Connection failed", mysqli_connect_error());
return false;
}
function connect_manual($dbServer,$dbUser,$dbPass) {
$this->link = mysqli_connect($dbServer,$dbUser,$dbPass);
if($this->link) {
mysqli_query($this->link, "SET NAMES 'utf8'");
return true;
}
$this->show_error("Manual connection failed", mysqli_connect_error());
return false;
}
function selectdb($database) {
if($this->link) {
//$this->link->selectdb($database);
mysqli_select_db($this->link, $database);
return true;
}
$this->show_error("Not connect the database before", "selectdb($database)");
return false;
}
function query($sql) {
$this->result = mysqli_query($this->link, $sql) or die(mysqli_error($this->link));
return $this->result;
}
function getnext() {
return mysqli_fetch_object($this->result);
}
function num_rows() {
return mysqli_num_rows($this->result);
}
function show_error($errmsg, $func) {
echo "<b><font color=red>" . $func . "</font></b> : " . $errmsg . "<BR>\n";
exit(1);
}
function Disconnect(){
return mysqli_close($this->link);
}
function last_insert_id() {
return mysqli_insert_id($this->link);
}
function fetch_assoc() {
//return mysql_fetch_assoc($this->result);
return mysqli_fetch_assoc($this->result);
}
}
?>
|