Shulou(Shulou.com)06/03 Report--

How to use classes to speed up PHP database development, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

There are many access functions to the database, and improper use will reduce efficiency and even lead to errors. PHP itself is open and extensible, and many people have developed source code for various functions for it. Every PHP programmer should be good at inheriting the work of others and saving time and energy. Standing on the shoulders of giants, you can see farther. Of course, you can also share your code, the following editor to explain how to use classes to speed up PHP database development?

How to use classes to Speed up the Development of PHP Database

The use of database classes allows us to focus on program development without considering specific database types at all.

Among the many development kits, PHPLib is one with stable performance and perfect function. PHPLib is available at http://phplib.netuse.de/. It contains the supporting classes for the database. Taking the MySQL database as an example, PHPLib comes with a class named DB_Sql. It packages the functions of database connection, query, taking results, traversing database tables and so on.

The use of database classes allows us to focus on program development without considering specific database types at all. Even if the database system type is changed, the program code does not need to be changed. At the same time, database classes provide complete and robust database access methods, which is probably the biggest advantage of using class wrappers.

Next, we will use the database class provided by PHPLib to access the database we just created and display the content.

Require "db_mysql.php"

/ / contains the generation file of the database class

$db=newDB_Sql

/ / declare an instance of the database class

Db- > connect ("ResumeDB", "localhost", "root", "")

/ / Connect to the database server

/ / the parameters provided are: database name, host name, user name, and user password.

If ($db- > Link_ID)

/ / determine whether the connection is established correctly

{

$db- > query ("selectID,Name,IntroFROMResume")

/ / query

If ($db- > nf ())

/ / determine whether the result set is empty

{

While ($db- > next_record ())

/ / get the value of the next row of records until the contents of the recordset are finished

{

Echo "ID:", $db- > f ("ID"); / / f () function returns the value of a subsegment of the current record

Echo "< br >"

Echo "name:"

$db- > p ("Name")

The / / p () function directly prints the value of a subsegment.

/ / equivalent to echo$db- > f ("name")

Echo "< br >"

Echo "introduction:"

Echo$db- > f ("Intro")

Echo "< br >"

Echo "< ahref=" download.php?ID= ". $db- > f (" ID ")."> View Word documents < / a >"

Echo "< br > < hr >"

}

}

$db- > free ()

/ / release resources

}

? >

How to use classes to Speed up the Development of PHP Database

As can be seen from the above process, the method of accessing the database with classes is basically the same as that of accessing the database directly. The difference is that the methods we call here are methods of the class, not functions specific to a particular database. Because of the separation of the code and the specific database type, when the database system changes, we do not have to change the program code, just change the implementation method of the base class.

If the PHPLib template is used to design, the separation of the program and the display can be realized. It will also make the structure of the program clear and the design and production of web artists convenient.

Simple usage, reasonable task allocation and thinking object packaging will greatly improve the efficiency of website development.

Attached: code testing platform

The above program code has all passed the test on the following platform

RedHatLinux6.1+Apache1.3.12+

PHP4.0+MySql3.22.32

The installation and configuration of the database is as follows:

Cd/usr/local/src/mysql*

. / configure--refix=/usr/local/mysql

Make

Makeinstall

The installation and configuration process of Apache is as follows:

Cd/usr/local/src/apache*

. / configure--prefix=/usr/local/apache--enable-shared=max

Make

Makeinstall

The installation and configuration process of PHP is as follows:

Cd/usr/local/src/php*

. / configure--with-apxs=/usr/local/apache/bin/apxs

-- with-config-file-path=/usr/local/

Apache/conf

-- with-mysql=/usr/local/mysql

-- enable-debug=no

-- enable-track-vars

The php.ini configuration process is as follows:

Copy php.ini-dist to / usr/local/

Apache/conf/php.ini

Edit httpd.conf to remove the comments from the following two lines

AddTypeapplication/x-httpd-php.php.php3

AddTypeapplication/x-httpd-php-source.phps

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.