PHP database call class call instance, php database call instance

PHP database call class call instance, php database call instance

<? PHPrequire_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 database $ dbname = $ db-> select_db ("test"); // 4. set $ db-> debug = true; // 5. execute an SQL statement without returning results $ db-> execute ("insert into test01 (name) values ('This is a test! ') "); // $ Db-> exec (" "); // 6. execute an SQL statement $ rs = $ db-> query ("select * from test01"); // 7. display result echo in row mode "<br> display result set in row mode <br>"; while ($ r = $ db-> fetch_row ($ rs )) {echo $ r [0]. ":". $ r [1]. "<br>";} // 8. display result $ 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 ();?>