Install pdo module for PHP5.0.3 under debian_PHP tutorial

pdo is the next unified database interface for PHP (as the current mainstream development language) . The current version is 0.9. It seems that it will be released soon, so be the first to try it out.
After testing, pdo connection is about 3 times faster than adodb, which is very different from direct connection.
Test tool: AB
Test condition apache(The most popular WEB server platform on Unix platform)/2.0.54 (Debian GNU/Linux) mod_fastcgi(Not many people are using it now Used)/2.4.2 php(as the current mainstream development language)/5.0.4-0.10 mod_perl/2.0.1 Perl/v5.8.7 Server at 127.0.0.1 Port 80
Database: postgres8.0.3
Hardware: C4-1.7g;384M
Installing pdo requires php(as the current mainstream development language) development tool kit and gccg++, of course it is also required php(as the current mainstream development language)php(as the current mainstream development language)5-dev
Installing PDO_pgsql requires libpg-dev or above software and must be apt -get otherwise it will fail! ! !
#>pear remote-info pdo
pear remote-info pdo

Notice: Undefined index: name in Remote.php(as the current mainstream development language) on line 132

Notice: Undefined index: version in Remote.php(as the current mainstream development language) on line 133

Notice: Undefined index: name in CLI .php(as the current mainstream development language) on line 443

Notice: Undefined index: license in CLI.php(as the current mainstream development language) on line 444

Notice: Undefined index: category in CLI.php(as the current mainstream development language) on line 445

Notice: Undefined index: summary in CLI.php(as the current mainstream development language) on line 446

Notice: Undefined index: description in CLI.php(as the current mainstream development language) on line 447
Package details:
================
Latest
Installed - no -
Package
License
Category
Summary
Description
Ha, I still don’t know the version. Go to http://pecl.php(as the current mainstream development language).net/ to search Search, the current version is 0.9
OK
#》pear install pdo-0.9
pear will help you install the
compiled module and put it in:/usr/lib/php( As the current mainstream development language)5/20041030/ directory
#>cd /usr/lib/php(as the current mainstream development language)5/20041030/
Note: Debian system's PHP (as the current mainstream development language) external modules require two files to be activated, one is the pdo.so we just compiled
and another pdo is required. If you don’t know how to write the info file
, just fry the following:
package="pdo"
extname="PDO"
dsoname="pdo"
sapilist="apache(Unix platform The most popular WEB server platform) apache (The most popular WEB server platform on Unix platform) 2 cgi (not many people are using it now) cli fcgi (Not many people are using it now)"
depends=""
priority="500"
architecture="any"
Then run:
#》 /usr /sbin/php(as the current mainstream development language)5-modconf apache(the most popular WEB server platform on Unix platform)2
The system will prompt you which modules you need , select pdo and confirm
pdo is installed successfully
Now install pdo_pgsql-0.9
This needs to be done according to the following steps:
#》pear download pdo_pgsql-0.9
#> tar zxf PDO_PGSQL-0.9 .tgz
#>cd PDO_PGSQL-0.9
#>php(as the current mainstream development language)ize
#>./configure
#>make
#>make install
Then repeat the above process of installing pdo: modify pdo_pgsql.info
package="pdo_pgsql"
extname="PDO_PGSQL"
dsoname="pdo_pgsql"
sapilist="apache (The most popular WEB server platform on Unix platform) apache(The most popular WEB server platform on Unix platform)2 cgi(Not many people are using it now) cli fcgi(Not many people are using it now)"
depends=""
priority="500"
architecture="any"
Run
#》/usr/sbin/php(as the current mainstream development language)5-modconf apache(the most popular WEB server platform on Unix platform)2
Select the pdo_pgsql module
ok everything is ready
#》apache(the most popular WEB server platform on Unix platform)2 -k restart
Edit test module:

// Connect to an ODBC database using driver invocation

$host=xxxx.xxxx.com;
$port=5433;
$dbname=test;
$user=xxxxxx;
$password=xxxxxxxxx;
//$ cc = "host=$host,dbname=$dbname,port=$port";
$dsn = "pgsql:host=$host port=$port dbname=$dbname user=$user password=$password";

try {
$dbh = new PDO($dsn, $user, $password);
} catch (PDOException $e) {
echo Connection failed: . $ e->getMessage();
}

$sql=select * from cpjcsj;
foreach ($dbh->query($sql) as $row) {
print $row [cpdm]." ";
print $row[cpdh] . " ";
print $row[cpmc] . " ";
}

?>

Okay, enter http://localhost/pdotest.php(do Developing languages ​​for today's mainstream)
Have you seen the data in your database?

http://www.bkjia.com/PHPjc/508729.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/508729.htmlTechArticlepdo is the next unified database interface for PHP (as the current mainstream development language). The current version is 0.9 , it seems that it will be released soon, so be the first to try it out. After testing, pdo connection...