===============================
PHP ADODB 地址方式连接数据库:
复制代码 代码如下:
include_once("adodb5/adodb.inc.php");
$db = NewADOConnection('mysql://root:@localhost/upload');
$sql="SELECT * FROM `pic`";
$db->SetFetchMode(ADODB_FETCH_ASSOC);//ADODB_FETCH_NUM这里和那个fetch_array和 fetch_row区别有点类似
//mysql_fetch_array()
$sr1 = $db->Execute($sql);
print_r($sr1->fields);
PHP ADODB 对象方式获取数据库内容
复制代码 代码如下:
$db = NewADOConnection('mysql');
$db->PConnect("localhost", "root", "", "upload");
$sql="SELECT * FROM `pic`";
$rs2=$db->Execute($sql);
while($row=$rs2->FetchNextObject()){
echo $row->NAME;
}
PHP ADODB HTML代码方式显示内容
复制代码 代码如下:
include_once("adodb5/tohtml.inc.php");
$db = NewADOConnection('mysql');
$db->Connect("localhost", "root", "", "upload");
$sql="SELECT * FROM `pic`";
$rs2=$db->Execute($sql);
echo rs2html($rs2);
PHP ADODB 实现内容自动分页功能
复制代码 代码如下:
include_once("adodb5/adodb-pager.inc.php");
session_start();
$db = NewADOConnection('mysql');
$db->Connect("localhost", "root", "", "upload");
$db->Execute("set names 'GBK'");
$sql="SELECT * FROM `pic`";
$pager=new ADODB_Pager($db,$sql);
$pager->Render(2);
http://www.bkjia.com/PHPjc/788639.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/788639.htmlTechArticleADODB PHP数据库万能引擎类特点: 1.可以在PHP规范各类数据库的链接和使用 2.可以帮助我们在PHP提供开发效率和快速转换各类数据库 3.使用相...