A good simple database connection program. If you need a php mysql database connection class, please refer to this article.
| The Code is as follows: |
Copy code |
|
<? PHP
Require_once ("mssql. 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 a database
$ Dbname = $ db-> select_db ("test ");
// 4. Allow debugging
$ Db-> debug = true;
// 5. Execute an SQL statement that does not return results
$ Db-> execute ("insert into test01 (name) values ('This is a test! ')");
// $ Db-> exec ("");
// 6. Execute an SQL statement that returns the result
$ Rs = $ db-> query ("select * from test01 ");
// 7. Display Results in row Mode
Echo "<br> display result sets in row mode <br> ";
While ($ r = $ db-> fetch_row ($ rs )){
Echo $ r [0]. ":". $ r [1]. "<br> ";
}
// 8. Display Results in array Mode
$ Rs2 = $ db-> query ("select * from test01 ");
Echo "<br> display result set in array mode <br> ";
While ($ r = $ db-> fetch_array ($ rs2 )){
Echo $ r ["id"]. ":". $ r ["name"]. "<br> ";
}
// X. Release
$ Db-> db_close ();
?>
|