An example of php calling database class

/**
 desc: Database class call instance Assume your data class is db_class.php
 link: bbs.it-home.org
 date: 2013/2/24
*/
require_once("db_class.php");
//1. Create a class, And connect to the database
$db = new mssql("dns=aaa;uid=sa;pwd=sa;dbname=test");
//2. Connect to the database
$conn = $ db->config("dns=aaa;uid=sa;pwd=sa;dbname=test");
//3. Select database
$dbname = $db-> select_db("test");
//4.Set to allow debugging
$db->debug = true;
//5.Execute a SQL statements that do not return results
$db->execute("insert into test01(name) values('This is a test!')");
//$db->exec("");< /p>
//6. Execute a SQL statement that returns results
$rs = $db->query("select * from test01");
// 7. Display the results in row format
echo "Display the result set in row format";
while($r = $db->fetch_row($rs)){
echo $r[0 ].":".$r[1]."";
}
//8. Display the results in array format
$rs2 = $db->query ("select * from test01");
echo "Display the result set in array format";
while($r = $db->fetch_array( $rs2)){
echo $r["id"] . ":" . $r["name"] . "";
}
//X. Release
$db->db_close();
?>