Copy Code code as follows:
? Php
Require_once ("mssql.class.php");
1. Create a class and connect to a database
$DB = new MSSQL ("Dns=aaa;uid=sa;pwd=sa;dbname=test");
2. Connecting to the database
$conn = $db->config ("Dns=aaa;uid=sa;pwd=sa;dbname=test");
3. Select Database
$dbname = $db->select_db ("test");
4. Set Allow debugging
$db->debug = true;
5. Execute a SQL statement that does not return results
$db->execute ("INSERT into test01 (name) values (' This is a test! ')");
$db->exec ("");
6. Execute a SQL statement that returns results
$rs = $db->query ("SELECT * from test01");
7. Display results in row mode
echo "<br> display result set <br> in row mode";
while ($r = $db->fetch_row ($rs)) {
echo $r [0]. ":". $r [1]. " <br> ";
}
8. Display results in array mode
$rs 2 = $db->query ("SELECT * from test01");
echo "<br> display result set <br> in array mode";
while ($r = $db->fetch_array ($rs 2)) {
echo $r ["id"]. ":" . $r [' name ']. "<br>";
}
X. Release
$db->db_close ();
?>