


Detailed explanation of PHP script database functions (Part 2)_PHP tutorial
Jul 21, 2016 pm 04:04 PM
Use classes to speed up PHP database development
There are many database access functions, and improper use will reduce efficiency and even lead to errors. PHP itself is open and extensible, and many people develop source code for various functions for it. Every PHP programmer should be good at inheriting the results of others and saving time and energy. Only by standing on the shoulders of giants can we see further. Of course, you can also share your code and experience the sense of accomplishment that comes from having your work recognized and creating value.
Using database classes allows us to completely ignore the specific database type and focus on program development.
Among the many development toolkits, PHPLib is one with more stable performance and more complete functions. PHPLib is available at http://phplib.netuse.de/. It contains database support classes. Taking the MySQL database as an example, PHPLib comes with a class named DB_Sql. It packages functions such as database connection, query, result retrieval, and database table traversal.
Using database classes allows us to completely ignore the specific database type and focus on program development. Even if the database system type is changed, the program code does not need to be changed. At the same time, the database class provides a complete and robust database access method, which may be the biggest advantage of using class packaging.
Next, we will use the database class provided by PHPLib to access the database we just created and display the content. 〈?
//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, user password
if ($db-〉Link_ID)
// Determine whether it is correctly established Connection
{
$db-〉query("select ID,Name,Intro FROM Resume");
//Query
if ($ db-〉nf())
// Determine whether the result set is empty
{
while ($db-〉next_record())
//Get the record value of the next row until the record set content is fetched
{
echo "ID:", $db-〉f("ID"); //f() function Return the value of a subsection of the current record
echo "〈br〉";
echo "Name:";
$db-〉p("Name");
// The p() function directly prints the value of a certain subsection
// Equivalent to echo $db-〉f("name")
echo "〈 br〉";
echo "Introduction:";
echo $db-〉f("Intro");
echo "〈br〉";
echo "〈a href= "download.php?ID=".$db-〉f("ID").""〉View Word document〈/a〉";
echo "〈 br〉〈hr〉"; ??
}
}
$db->free ();
// Release resources
}
?〉
As can be seen from the above process, the method of accessing the database using classes is basically the same as the method of directly accessing the database. The difference is that the methods we call here are all class methods, rather than functions specific to a certain database. Due to the separation of code and specific database types, when the database system changes, we do not need to change the program code, we only need to change the implementation method of the base class.
If combined with PHPLib template for design, the separation of program and display can be achieved. It will also make the program structure clear and facilitate web page art design and production.
Simple usage, reasonable task allocation, and thoughtful object packaging will greatly improve the efficiency of website development.
Attachment: Code testing platform
All the above program codes were tested on the following platform and passed
RedHat Linux 6.1+Apache1.3.12+
PHP4.0+MySql3. 22.32
The installation and configuration process of the database is:
cd /usr/local/src/mysql*
./configure --refix=/usr/local/mysql
make
make install
The installation and configuration process of Apache is:
cd /usr/local/src/apache*
. /configure --prefix=/usr/local/apache --enable-shared=max
make
make install
The installation and configuration process of PHP is:
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:
Copy php.ini-dist to /usr/local/
apache /conf/php.ini
Edit httpd.conf and remove the comments from the following two lines
AddType application/x-httpd-php .php .php3
AddType application /x-httpd-php-source .phps
<

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

In PHP, you can use square brackets or curly braces to obtain string specific index characters, but square brackets are recommended; the index starts from 0, and the access outside the range returns a null value and cannot be assigned a value; mb_substr is required to handle multi-byte characters. For example: $str="hello";echo$str[0]; output h; and Chinese characters such as mb_substr($str,1,1) need to obtain the correct result; in actual applications, the length of the string should be checked before looping, dynamic strings need to be verified for validity, and multilingual projects recommend using multi-byte security functions uniformly.

AgeneratorinPHPisamemory-efficientwaytoiterateoverlargedatasetsbyyieldingvaluesoneatatimeinsteadofreturningthemallatonce.1.Generatorsusetheyieldkeywordtoproducevaluesondemand,reducingmemoryusage.2.Theyareusefulforhandlingbigloops,readinglargefiles,or

To prevent session hijacking in PHP, the following measures need to be taken: 1. Use HTTPS to encrypt the transmission and set session.cookie_secure=1 in php.ini; 2. Set the security cookie attributes, including httponly, secure and samesite; 3. Call session_regenerate_id(true) when the user logs in or permissions change to change to change the SessionID; 4. Limit the Session life cycle, reasonably configure gc_maxlifetime and record the user's activity time; 5. Prohibit exposing the SessionID to the URL, and set session.use_only

The urlencode() function is used to encode strings into URL-safe formats, where non-alphanumeric characters (except -, _, and .) are replaced with a percent sign followed by a two-digit hexadecimal number. For example, spaces are converted to signs, exclamation marks are converted to!, and Chinese characters are converted to their UTF-8 encoding form. When using, only the parameter values ??should be encoded, not the entire URL, to avoid damaging the URL structure. For other parts of the URL, such as path segments, the rawurlencode() function should be used, which converts the space to . When processing array parameters, you can use http_build_query() to automatically encode, or manually call urlencode() on each value to ensure safe transfer of data. just

You can use substr() or mb_substr() to get the first N characters in PHP. The specific steps are as follows: 1. Use substr($string,0,N) to intercept the first N characters, which is suitable for ASCII characters and is simple and efficient; 2. When processing multi-byte characters (such as Chinese), mb_substr($string,0,N,'UTF-8'), and ensure that mbstring extension is enabled; 3. If the string contains HTML or whitespace characters, you should first use strip_tags() to remove the tags and trim() to clean the spaces, and then intercept them to ensure the results are clean.

There are two main ways to get the last N characters of a string in PHP: 1. Use the substr() function to intercept through the negative starting position, which is suitable for single-byte characters; 2. Use the mb_substr() function to support multilingual and UTF-8 encoding to avoid truncating non-English characters; 3. Optionally determine whether the string length is sufficient to handle boundary situations; 4. It is not recommended to use strrev() substr() combination method because it is not safe and inefficient for multi-byte characters.

To set and get session variables in PHP, you must first always call session_start() at the top of the script to start the session. 1. When setting session variables, use $_SESSION hyperglobal array to assign values ??to specific keys, such as $_SESSION['username']='john_doe'; it can store strings, numbers, arrays and even objects, but avoid storing too much data to avoid affecting performance. 2. When obtaining session variables, you need to call session_start() first, and then access the $_SESSION array through the key, such as echo$_SESSION['username']; it is recommended to use isset() to check whether the variable exists to avoid errors

Key methods to prevent SQL injection in PHP include: 1. Use preprocessing statements (such as PDO or MySQLi) to separate SQL code and data; 2. Turn off simulated preprocessing mode to ensure true preprocessing; 3. Filter and verify user input, such as using is_numeric() and filter_var(); 4. Avoid directly splicing SQL strings and use parameter binding instead; 5. Turn off error display in the production environment and record error logs. These measures comprehensively prevent the risk of SQL injection from mechanisms and details.
