Adodb学习

<? php // 快速连接

include_once ( " adodb5/adodb.inc.php " );

$db = NewADOConnection ( ' mysql ' );
$db -> Connect( " localhost " , " root " , "" , " upup360 " ) or die ( " 错误 " );

$db -> Execute( " set names 'GBK' " );
$q = $db -> Execute( " select * from up_admin_user " );

while ( $row = $q -> FetchRow()){
print_r ( $row );
}

?>


<? php // 实现快速查询功能

include_once ( " adodb5/adodb.inc.php " );

$db = & NewADOConnection( ' mysql ' );
$db -> Connect( " localhost " , " root " , "" , " db " ) or die ( " 错误 " );
$db -> Execute( " set names 'GBK' " );

$arr = rray( ' m_id ' => ' 2 ' , ' password ' => ' 333333 ' , ' 33333 ' => ' 4444444 ' );
$db -> AutoExecute( " up_admin_user " , $arr , " INSERT " );

?>


<? php // PHP ADODB 地址方式连接数据库

$db = NewADOConnection( ' mysql://root:pwd@localhost/upload ' );
$sql = " SELECT * FROM `pic` " ;

$db -> SetFetchMode(ADODB_FETCH_NUM);
// ADODB_FETCH_NUM 以下标展开
//ADODB_FETCH_ASSOC 以字段名展开

$sr1 = $db -> Execute( $sql );

print_r ( $sr1 -> fields);

?>



<? php // PHP ADODB 对象方式获取数据库内容

$db = NewADOConnection( ' mysql ' );
$db -> PConnect( " localhost " , " root " , "" , " upload " );
$sql = " SELECT * FROM `pic` " ;
$rs2 = $db -> Execute( $sql );

while ( $row = $rs2 -> FetchNextObject()){
print_r ( $row );
}

?>


<? php // 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 // PHP ADODB 实现内容自动分页功能

include_once ( " adodb5/adodb-pager.inc.php " );

session_start ();
$db = NewADOConnection( ' mysql ' );
$db -> Connect( " localhost " , " root " , "" , " upload " );

$sql = " SELECT * FROM `pic` " ;
$pager = new ADODB_Pager( $db , $sql );
$pager -> Render( 3 );

?>

 

转载于:https://www.cnblogs.com/touchsunlight/archive/2010/05/04/1727599.html