Application of ADODB
Include_once ('adodb5/adodb. inc. php ');
$ Db = NewADOConnection ('mysql ');
$ Db-> Connect ("localhost", "root", "", "php100") or die ("error ");
$ Db-> Execute ("set names 'utf8 '");
$ Query = $ db-> execute ("select * from 'php100 "');
While ($ row = $ query-> FetchRow ()){
Print_r ($ row );
}
?>
Include_once ('adodb5/adodb. inc. php ');
$ Db = NewADOConnection ('mysql ');
$ Db-> Connect ("localhost", "root", "", "php100") or die ("error ");
$ Db-> Execute ("set names 'utf8 '");
$ Arr = array (
"Name" => "patzi ",
"Hit" = & gt; "111"
);
$ Db-> AutoExecute ("php100", $ arr, "INSERT ")
?>
Include_once ('adodb5/adodb. inc. php ');
$ Db = NewADOConnection ('MySQL: // root: @ localhost/php100 ');
$ Db-> Execute ("set names 'utf8 '");
$ SQL = "select * from 'php100 "';
$ Db-> SetFetchMode (ADODB_FETCH_ASSOC );
$ Sr1 = $ db-> Execute ($ SQL );
Print_r ($ sr1-> fields );
$ Db = NewADOConnection ('mysql ');
$ Db-> Connect ("localhost", "root", "", "php100") or die ("error ");
$ Db-> Execute ("set names 'utf8 '");
$ Query = $ db-> execute ("select * from 'php100 "');
While ($ row = $ query-> fetchnextobject ()){
Echo $ row-> NAME;
}
Include_once ('adodb5/tohtml. inc. php ');
$ Db = NewADOConnection ('mysql ');
$ Db-> Connect ("localhost", "root", "", "php100") or die ("error ");
$ Db-> Execute ("set names 'utf8 '");
$ Query = $ db-> execute ("select * from 'php100 "');
Echo rs2html ($ query );
Include_once ('adodb5/adodb-pager.inc.php ');
Session_start ();
$ Db = NewADOConnection ('MySQL: // root: @ localhost/php100 ');
$ Db-> Execute ("set names 'utf8 '");
$ SQL = "select * from 'php100 "';
$ Pager = new adodb_pager ($ db, $ SQL );
$ Pager-> render (3 );
?>