Database, php: PHP database call class call instance: config (dnsaaa; u); 3. select database $ dbname $ db-& gt; select
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"
Display result sets in row mode
"; While ($ r = $ db-> fetch_row ($ rs) {echo $ r [0].": ". $ r [1]."
";}// 8. display the result in array format $ rs2 = $ db-> query (" select * from test01 "); echo"
Display result sets in array mode
"; While ($ r = $ db-> fetch_array ($ rs2) {echo $ r [" id "].": ". $ r [" name "]."
";}// X. release $ db-> db_close ();?>
The above introduces PHP database call class call instances, including the database and php content, and hopes to help friends who are interested in PHP tutorials.