PHP database universal engine class adodb configuration usage and example collection_PHP tutorial

ADODB PHP database universal engine class features:
1. Can standardize the linking and use of various databases in PHP
2. Can help us provide development efficiency and quickly convert various databases in PHP
3 .Relatively simple to use
4. Strict writing requirements, pay attention to capitalization
5. Rich built-in functions

How to configure and use ADODB PHP
1. Download the ADODB For PHP class library compressed package
2. Unzip it to any folder in the website directory
3. Introduce the ADODB configuration file
4. Configure the required database connection
5 Use built-in methods to operate the linked database

Connect MySql:

Copy code The code is as follows:

include_once("adodb5/adodb.inc.php" ); //Contains adodb class library file
$db = NewADOConnection('mysql');
$db->Connect('localhost', 'root', 'root', 'test')or die ("df"); //Connect to MySQL database
?>

Connect Access:

Copy code The code is as follows:

include_once("adodb/adodb.inc.php" ); //Contains adodb class library file
$conn = NewADOConnection('access'); //Connect to Access database
$conn->Connect("test.mb")or die("cuowu") ;
?>

Connect DB2:

Copy code The code is as follows:

include("adodb/adodb.inc.php" ); //Contains adodb class library file
$conn=NewADOConnection('db2'); //Connect to DB2 database
$conn->Connect("driver={IBM db2 odbc DRIVER};database=mydb ;hostname=localhost;port=50000;
protocol=TCPIP;uid=root; pwd=pass");
?>

Connect to PostgreSQL:

Copy code The code is as follows:

include("adodb/adodb.inc.php" ); //Contains adodb class library file
$conn = NewADOConnection('postgres');
$conn->Connect('localhost', 'root', 'pass', 'mydb'); / /Connect PostgreSQL database
?>

ADODB PHP implements fast query function

Copy code The code is as follows:

include_once("adodb5/adodb.inc.php");
$db = &NewADOConnection('mysql');
$db->Connect("localhost", "root", "", "db")or die("error");
$db->Execute ("set names 'GBK'");
$q=$db->Execute("select * from up_admin_user");
while($row=$q->FetchRow()){
print_r($row);
}

ADODB PHP implements smart insertion function

Copy code The code is as follows:

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

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

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

Example sharing:
Query:

Copy code The code is as follows:

include_once("adodb5/adodb.inc.php" ); //Contains adodb class library file
$db = NewADOConnection('mysql');
$db->Connect('localhost', 'root', '', 'think_zw')or die( "error"); //Connect to MySQL database
$db->Execute("set names 'GBK'");
$query=$db->Execute("select * from think_zw");
while($row=$query->FetchRow()){
print_r($row);
}
?>

Insert : It will automatically filter out useless arrays when inserting. Eliminate useless arrays.
Fields can be inserted without correspondence.

Copy code The code is as follows:

include_once("adodb5/adodb.inc.php"); //Include adodb class library file
$db = NewADOConnection('mysql');
$ db->Connect('localhost', 'root', '', 'think_zw')or die("error"); //Connect to MySQL database
$db->Execute("set names 'GBK' ");
$arr=array("id"=>"",
"name"=>"Xiaojun",
"details"=>"Xiaojun likes to see beautiful women" );//Be careful not to write double quotes as single quotes
$db->AutoExecute("think_zw",$arr,"INSERT");
$query=$db->Execute("select * from think_zw");
while($row=$query->FetchRow()){
echo $row[name]."
";
}
?>

================================

PHP ADODB address method to connect to the database:

Copy code The code is as follows:

include_once("adodb5/adodb.inc.php");
$db = NewADOConnection('mysql://root:@localhost/upload');
$sql="SELECT * FROM `pic`";
$db->SetFetchMode(ADODB_FETCH_ASSOC);//ADODB_FETCH_NUM here and The difference between fetch_array and fetch_row is somewhat similar
//mysql_fetch_array()
$sr1 = $db->Execute($sql);
print_r($sr1->fields);

PHP ADODB object method to obtain database content

Copy code The code is as follows:

$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 code display content

Copy code The code is as follows:

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 implements automatic content paging function

Copy code The code is as follows:

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 database universal engine class features: 1. Can standardize the linking and use of various databases in PHP 2. Can Help us provide development efficiency and quickly convert various databases in PHP 3. Use the corresponding...