ADODB的应用
include_once ('adodb5/adodb.inc.php');
$db = NewADOConnection ('mysql');
$db->Connect("localhost", "root", "", "php100")or die("错误");
$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("错误");
$db->Execute("set names 'UTF8'");
$arr=array(
"name"=>"patzi",
"hit"=>"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("错误");
$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("错误");
$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);
?>