Adodb configuration and use_PHP tutorial

============================================
php100:80:ADODB PHP database universal engine class

ADODB PHP database introduction and features
ADODB is a compatible application programming interface (API) for various databases, and can be used with various databases. MySQL, PostgreSQL, Interbase, Firebird, Informix, Oracle, MS SQL 7, Foxpro, Access, ADO, Sybase, FrontBase, DB2

ADODB standardizes the linking and use of various databases in PHP
ADODB helps us provide development efficiency and quickly convert various databases in PHP
ADODB is relatively simple to use
ADODB writing requirements are strict, pay attention to capitalization
ADODB has a rich set of built-in functions

How to configure and use ADODB PHP
Download the ADODB For PHP class library compressed package
Unzip it to any folder in the website directory
Introduce the ADODB configuration file
Configure the required database connection
Manipulate linked databases using built-in methods

Connect to MySql:

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

Connect Access:

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

Connect to DB2:

include("adodb/adodb.inc.php"); //Include 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:

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

*******
ADODB PHP implements fast query function
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

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");
************
Instance:
Query:
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);
}
?>

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

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]."
";
}
?>
===============================
php100:81:PHP ADODB address method to connect to the database

1. PHP ADODB connects to the database by address
2. PHP ADODB obtains database content by object
3. PHP ADODB displays content by HTML code
4. PHP ADODB implements automatic paging of content

PHP ADODB address method to connect to the database:
include_once("adodb5/adodb.inc.php");

/* $db = NewADOConnection('mysql://root:@localhost/upload ');
$sql="SELECT * FROM `pic`";
$db->SetFetchMode(ADODB_FETCH_ASSOC);//ADODB_FETCH_NUM The difference between fetch_array and fetch_row is somewhat similar here
//mysql_fetch_array( )
$sr1 = $db->Execute($sql);
print_r($sr1->fields);
*/
************* *************
PHP ADODB object method to obtain database content
$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 to display content
/*
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
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/781923.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/781923.htmlTechArticle======================== ================= php100:80:ADODB PHP database universal engine class ADODB PHP database introduction and characteristics ADODB is a compatible various database application program interfaces (...