MySql数据库AdoDB函数实例详解

<?php
include_once("libs/adodb/adodb.inc.php");

// 创建一个mysql连接实例对象
$db = NewADOConnection("mysql");

// 打开一个数据库连接
$db->Connect("localhost", "root", "root", "library") or die("Unable to connect!");

// 构造并执行一个查询
$query = "SELECT title, id FROM library";
$result = $db->Execute($query) or die("Error in query: $query. " . $db->ErrorMsg());

//显示HTML下拉列表菜单
echo $result->GetMenu("library", '', false);

// 关闭数据库连接
$db->Close();
?>