PHP Help – Creating database connection in objects

//VVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVV
// PHP Help – Creating database connection in objects
//VVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVV

Click Here To Download

<?

/*==============================
# Module : PHP database class
# Programmer : Mohd Izzairi Yamin
# Date : 07/06/2007 10:00
# Modified : 07/06/2007 11:15
================================*/
class connection{

function db_conn(){

$db = mysql_connect(”localhost”,”root”,”root”);
mysql_select_db(”testdb”);
}

function db_query($sql) {
global $res_rs,$res;

$res = “$sql”;
$res_rs=mysql_query($res);

return $res_rs;

}

function show_sql(){
global $res;

print $res;

}

function db_fetch_array($res_rs) {
global $res_rs,$arr;

$arr = mysql_fetch_array($res_rs);

return $arr;

}

function show_arr(){
global $arr;

echo “<pre>”;
print_r($arr);

}

}
?>

About this entry

You’re currently reading “PHP Help – Creating database connection in objects,” an entry on Xyiry PHP Blog | Where Open Source Lives

Published:
08.10.07 / 4pm
Category:
PHP