Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > The role of PHP PEAR DB class in website construction_PHP tutorial

The role of PHP PEAR DB class in website construction_PHP tutorial

WBOY
Release： 2016-07-15 13:33:53
Original
983 people have browsed it

In PHP website development, because it supports various database engines, such as Mysql, Mssql, Pgsql, sqlite, etc., and provides various database systems Different functions are used as interfaces, which brings a lot of convenience to PHP website developers.

But it also brings about the problem of platform portability. As the underlying database changes, the PHP code must also change. There are various solutions to this problem, such as using the PHP ADODB class, PHP PEAR DB class or writing your own PHP DB class to aggregate the function operations of various databases, etc. Today I will share with you how to install and use the PHP PEAR DB class , to achieve access functions of different databases.

Preparation work

1. Before using the PHP PEAR DB class to access the database, you need to install PHP PEAR, and then download and install the DB class through PEAR, that is, pear install db

2. Install relevant databases as needed, such as Mysql, Mssql, Pgsql, Sqlite, etc. At the same time, find Dynamic Extensions in PHP.INI, introduce the DLL file corresponding to the data, and restart Apache.

Note: Since I am using DedeAMPZ, when installing PHP PEAR, it must be installed in the DedeAMPZWebRootDefault directory. Otherwise, when introducing DB.php, a Failedopening required 'DB.php' error will be reported, that is, it cannot be found. DB class (could not find pear db library), because DedeAMPZ may have restrictions on related directories.

Example of using PHP PEAR DB class

<ol class="dp-xml">
<li class="alt"><span><span class="tag"><</span><span> ?  </span></span></li><li><span>require_once("DB.php");  </span></li><li class="alt"><span>$</span><span class="attribute">userName</span><span> = </span><span class="attribute-value">'root'</span><span>;  </span></li><li><span>$</span><span class="attribute">password</span><span> = </span><span class="attribute-value">'123456'</span><span>;  </span></li><li class="alt"><span>$</span><span class="attribute">hostName</span><span> = </span><span class="attribute-value">'localhost'</span><span>;  </span></li><li><span>$</span><span class="attribute">dbName</span><span> = </span><span class="attribute-value">'test'</span><span>;  </span></li><li class="alt"><span>$</span><span class="attribute">dsn</span><span> = </span><span class="attribute-value">"mysql://$userName:<br />$password@$hostName/$dbName"</span><span>;  </span></li><li><span>$</span><span class="attribute">dbCon</span><span> = </span><span class="attribute-value">DB</span><span>::connect($dsn);  </span></li><li class="alt"><span>if (DB::isError($dbCon)) {  </span></li><li><span>die ($dbCon-</span><span class="tag">></span><span>getMessage());  </span></span></li>
<li class="alt"><span>}  </span></li>
<li>
<span>$</span><span class="attribute">sql</span><span> = </span><span class="attribute-value">"CREATE TABLE leapsoul ("</span><span>.  </span>
</li>
<li class="alt"><span>"`id` INT( 11 ) UNSIGNED NOT NULL ,".  </span></li>
<li><span>"`name` VARCHAR( 30 ) CHARACTER <br>SET gbk COLLATE gbk_chinese_ci NOT NULL ,".  </span></li>
<li class="alt"><span>"`age` INT( 2 ) NOT NULL ,".  </span></li>
<li><span>"`birthday` VARCHAR( 30 ) CHARACTER <br>SET gbk COLLATE gbk_chinese_ci NOT NULL ,".  </span></li>
<li class="alt"><span>"`sex` INT( 1 ) NOT NULL ,".  </span></li>
<li><span>"PRIMARY KEY ( `id` )".  </span></li>
<li class="alt">
<span>") </span><span class="attribute">ENGINE</span><span> = </span><span class="attribute-value">MYISAM</span><span> CHARACTER SET gbk <br>COLLATE gbk_chinese_ci";  </span>
</li>
<li>
<span>$</span><span class="attribute">result</span><span> = $dbCon-</span><span class="tag">></span><span>query($sql);  </span>
</li>
<li class="alt"><span>if (DB::isError($result)) {  </span></li>
<li>
<span>die ($result-</span><span class="tag">></span><span>getMessage());  </span>
</li>
<li class="alt"><span>}  </span></li>
<li>
<span>$</span><span class="attribute">sql</span><span> = </span><span class="attribute-value">"insert into leapsoul(id,name,<br>age,birthday,sex) values(1,'leapsoul',1,<br>'2009-05-13',1),(2,'leapsoul',1,'2009-05<br>-13',1),(3,'leapsoul',1,'2009-05-13',1)"</span><span>;  </span>
</li>
<li class="alt">
<span>$</span><span class="attribute">result</span><span> = $dbCon-</span><span class="tag">></span><span>query($sql);  </span>
</li>
<li><span>if (DB::isError($result)) {  </span></li>
<li class="alt">
<span>die ($result-</span><span class="tag">></span><span>getMessage());  </span>
</li>
<li><span>}  </span></li>
<li class="alt">
<span>$dbCon-</span><span class="tag">></span><span>setFetchMode(DB_FETCHMODE_ASSOC);  </span>
</li>
<li>
<span>$</span><span class="attribute">sql</span><span> = </span><span class="attribute-value">"select * from leapsoul"</span><span>;  </span>
</li>
<li class="alt">
<span>$</span><span class="attribute">result</span><span> = $dbCon-</span><span class="tag">></span><span>query($sql);  </span>
</li>
<li><span>if (DB::isError($result)) {  </span></li>
<li class="alt">
<span>die ($result-</span><span class="tag">></span><span>getMessage());  </span>
</li>
<li><span>}  </span></li>
<li class="alt">
<span>for($</span><span class="attribute">i</span><span>=</span><span class="attribute-value">0</span><span>;$i</span><span class="tag"><</span><span>$result-</span><span class="tag">></span><span>numRows();$i++)  </span>
</li>
<li><span>{  </span></li>
<li class="alt">
<span>$</span><span class="attribute">info</span><span> = &$result-</span><span class="tag">></span><span>fetchRow();  </span>
</li>
<li><span>echo "name:".$info['name'];  </span></li>
<li class="alt">
<span>echo "birthday:".$info['birthday']."</span><span class="tag"><</span><span class="tag-name">br</span><span class="tag">></span><span>";  </span>
</li>
<li><span>}  </span></li>
<li class="alt">
<span>$result-</span><span class="tag">></span><span>free();  </span>
</li>
<li>
<span>$dbCon-</span><span class="tag">></span><span>disconnect();  </span>
</li>
<li class="alt"><span>}  </span></li>
</ol>
Copy after login

The above is a detailed introduction to the use of PHP PEAR DB class.


www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/446030.htmlTechArticleIn PHP website development, due to its support for various database engines, such as Mysql, Mssql, Pgsql, sqlite, etc., It also provides different functions as interfaces to various database systems for PHP websites...
Related labels：
pear php effect exist engine support database kind Website building website development
source：php.cn
Previous article：PHP function printarray() cannot output objects_PHP tutorial Next article：Detailed explanation of the correct method to modify PHP time zone_PHP tutorial
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
Problems encountered when using opentbs to generate odt files: values ​​of the same key are displayed in the same row instead of separate columns. I'm using a library called OpenTbs to create odt using PHP, I'm using it because columns a...
From 2024-04-06 20:18:18
0
1
483
Group MySQL results by ID for looping over I have a table with flight data in mysql. I'm writing a php code that will group and displ...
From 2024-04-06 17:27:56
0
1
406
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template