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);

?>