


How to implement a PHP framework series of articles [6] mysql database, _PHP tutorial
Jul 12, 2016 am 08:57 AMHow to implement a php framework series of articles [6] mysql database,
Issues to consider when implementing a mysql database package
-
Ease of use
Adopt direct sql statement operation method. As long as you can write SQL statements, there will be no other learning costs.
The dba auxiliary encapsulation class provided by the uctphp framework will be hard to put down after using it.
Do you need to explicitly initialize and connect to the database before use? Of course not.
Until the first sql statement is executed, the database will not be connected, or even a new db object will not be created.
dba will connect to the database at the appropriate time and perform initial character encoding operations.
Query statement. There is no need for a new query constructor and it does not provide a chained operation method, which is so complex and inefficient.
dba provides the following query auxiliary functions.
1 2 3 4 5 6 7 8 9 10 11 12 |
//讀一個值
Dba::readOne( $sql );
//讀一行
Dba::readRowAssoc( $sql );
//讀所有行
Dba::readAllAssoc( $sql );
//讀所有行的第一列
Dba::readAllOne( $sql );
?
//在實(shí)際業(yè)務(wù)場景中,經(jīng)常會有分頁讀取部分?jǐn)?shù)據(jù)的情況。
//只要一個函數(shù)即可返回指定頁碼的數(shù)據(jù)內(nèi)容和數(shù)據(jù)總條數(shù)
Dba::readCountAndLimit( $sql ,? $page ,? $limit );
|
ps: Some of the above functions can provide a map function to process each row of the returned array.
Write sentences. Why should we distinguish between read and write? Obviously it can be extended to control read and write separation, double writing and other functions.
Today, with various cloud databases and database middleware, implementation at the database layer is a better choice.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
Dba::write( $sql );
?
/*?直接插入或更新kv形式的array數(shù)組
會自動對value進(jìn)行轉(zhuǎn)義,也支持array類型的值。
?
如果自己寫sql語句要注意使用addslashes或mysql_real_escape_string來保證安全
*/
Dba::insert( $table ,? $insert );????
Dba::update( $table ,? $update ,? $where );
?
/*
???? 對批量插入數(shù)據(jù)有更高的效率
???? 當(dāng)然過多的行數(shù)應(yīng)該用array_chunk來分批插入。
*/
Dba::insertS( $table ,? $inserts );
|
2. Affairs
Use pdo to support transactions
1 2 3 |
Dba::beginTransaction();
Dba::commit();
Dba::rollBack();
|
3. Long time running
In some long-running scenarios such as swoole services, background workers, etc., the database connection may time out.
When the database connection is found to have timed out, the DBA will automatically try to reconnect.

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.

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.

The method to get the current session ID in PHP is to use the session_id() function, but you must call session_start() to successfully obtain it. 1. Call session_start() to start the session; 2. Use session_id() to read the session ID and output a string similar to abc123def456ghi789; 3. If the return is empty, check whether session_start() is missing, whether the user accesses for the first time, or whether the session is destroyed; 4. The session ID can be used for logging, security verification and cross-request communication, but security needs to be paid attention to. Make sure that the session is correctly enabled and the ID can be obtained successfully.

To extract substrings from PHP strings, you can use the substr() function, which is syntax substr(string$string,int$start,?int$length=null), and if the length is not specified, it will be intercepted to the end; when processing multi-byte characters such as Chinese, you should use the mb_substr() function to avoid garbled code; if you need to intercept the string according to a specific separator, you can use exploit() or combine strpos() and substr() to implement it, such as extracting file name extensions or domain names.

UnittestinginPHPinvolvesverifyingindividualcodeunitslikefunctionsormethodstocatchbugsearlyandensurereliablerefactoring.1)SetupPHPUnitviaComposer,createatestdirectory,andconfigureautoloadandphpunit.xml.2)Writetestcasesfollowingthearrange-act-assertpat

Execution of SELECT queries using PHP's preprocessing statements can effectively prevent SQL injection and improve security. 1. Preprocessing statements separate SQL structure from data, send templates first and then pass parameters to avoid malicious input tampering with SQL logic; 2. PDO and MySQLi extensions commonly used in PHP realize preprocessing, among which PDO supports multiple databases and unified syntax, suitable for newbies or projects that require portability; 3. MySQLi is specially designed for MySQL, with better performance but less flexibility; 4. When using it, you should select appropriate placeholders (such as? or named placeholders) and bind parameters through execute() to avoid manually splicing SQL; 5. Pay attention to processing errors and empty results to ensure the robustness of the code; 6. Close it in time after the query is completed.

In PHP, the most common method is to split the string into an array using the exploit() function. This function divides the string into multiple parts through the specified delimiter and returns an array. The syntax is exploit(separator, string, limit), where separator is the separator, string is the original string, and limit is an optional parameter to control the maximum number of segments. For example $str="apple,banana,orange";$arr=explode(",",$str); The result is ["apple","bana
