& #65279; & lt ;? Php * CreatedByRexLeeMySQL class ** PHPfileSQL. php2012-8-13 * classMySQL {private $ host; private $ name; private $ password; private $ dbname; database name priva
Bytes
Open ($ server, $ dbuser, $ psw);} private function open ($ server, $ dbuser, $ psw) {// connection host $ this-> host = $ server; $ this-> name = $ dbuser; $ this-> password = $ psw; $ this-> link = mysql_connect ($ this-> host, $ this-> name, $ this-> password) or die ("host connection failed! ");} Public function to2DArray ($ result) {$ _ 2 DArray = Array (); $ arr = new ArrayObject ($ _ 2 DArray ); while ($ row = mysql_fetch_array ($ result) {$ arr-> append ($ row);} return $ arr;} public function opendb ($ database, $ charset) {// connect to the database $ this-> dbname = $ database; mysql_query ("set names ". $ charset); // set the character set $ this-> db = mysql_select_db ($ this-> dbname, $ this-> link); if (! $ This-> db) {$ this-> errmsg = "database connection error! ";}} Public function query ($ SQL) {$ result = mysql_query ($ SQL); if (! $ Result) {$ this-> errmsg = "statement running error! ";} Return $ result;} private function _ call ($ n, $ v) {// The error method absorbs return" does not exist ". $ n. "() method" ;}}// Example // $ c = new MySQL ("localhost", "root", "lijun "); // $ c-> opendb ("demo", "utf8"); // $ r = $ c-> query ("select * from test "); // echo $ r ,'
'; // $ Ar = $ c-> to2DArray ($ r); // print_r ($ ar [0]); // echo'
'; // Print_r ($ ar [1]); // echo'
'; // Echo $ c-> hi ();?>