Detailed analysis of the new version of PHP 5.3_PHP Tutorial
1. mysql tutorial driver mysqlnd
For a long time, PHP tutorials have been connecting to MySQL through the MySQL client. Now MySQL has officially launched the PHP version of the MySQL client, and this MySQLnd can effectively reduce memory usage and improve performance. For details, see:
http://dev.mysql.com/downloads/connector/php-mysqlnd/
http://forge.mysql.com/wiki/PHP_MYSQLND
As can be seen from the figure, using mysqlnd eliminates the step of copying data from the mysql driver to the php extension. Mysqlnd uses copy-on-write, which means copy-on-write and read-reference.
mysqlnd has been built into the source code of php5.3. When compiling, use --with-mysql=mysqlnd, --with-mysqli=mysqlnd and --with-pdo-mysql=mysqlnd to install the mysqlnd driver.
Advantages of mysqlnd
Compiling PHP is more convenient, no need for libmysql, it is already built into the source code
- Compiling PHP is more convenient, no need for libmysql, it is already built into the source code
- Use php license to avoid copyright issues
- Use PHP memory management and support PHP memory limit (memory_limit)
- There is only one copy of all data in the memory. The previous libmysql had two copies. Refer to the picture above
- Provides performance statistics function to help analyze bottlenecks
- mysqli supports persistent connections
- The performance is definitely faster than libmysql
- Add caching mechanism in driver layer
- md5() probably improves performance by 10%-15%
- Better stack implementation in the engine, I don’t understand
- Constants are stored in ROM (Constants moved to read-only memory), I don’t understand the meaning here
- Improve exception handling and make the opcode more concise
- Solved the problem of repeatedly opening include(require)_once. Before, I used static variables to implement once, and finally solved this problem
- Binaries compiled with gcc4 will be smaller
- Overall performance improved by 5%-15%
4. Namespace
This is a very good function. Before it was added, prefixes were used to solve naming pollution. The method was a bit copycat, haha.5. Late Static Binding I estimate that the static nature of PHP is fixed during pre-compilation, so when inheriting, self in the parent class refers to the parent class, not the subclass. PHP5.3 adds a new syntax, static, which can capture the current class at runtime. A typical example is the singleton mode:
class ParentClass { <br>static private $_instance; <br>private function __construct() { <br>} <br>static public function getInstance() { <br>if (!isset(self::$_instance)) { <br>self::$_instance = new self(); <br>} <br>return self::$_instance; <br>} <br>} Copy after login |
class ParentClass { <br>static private $_instance; <br>private function __construct() { <br>} <br>static public function getInstance() { <br>if (!isset(self::$_instance)) { <br>$class = static::getClass();// 使用static延迟绑定 <br>self::$_instance = new $class(); <br>} <br>return self::$_instance; <br>} <br>static public function getClass() { <br>return __CLASS__; <br>} <br>} Copy after login |
$date = strtotime("08-01-07 00:00:00");//php 认为格式 是年-月-日 <br>var_dump(date("Y-m-d", $date)); // string(10) "2008-01-07" <br>$date = date_create_from_format("m-d-y", "08-01-07");//告诉php格式是 月-日-年 <br>var_dump($date->format('Y-m-d')); // string(10) "2007-08-01" Copy after login |
$lambda = function () { echo "Hello World!n"; }; Copy after login |
function replace_spaces ($text) { <br>$replacement = function ($matches) { <br>return str_replace ($matches[1], ' ', ' ').' '; <br>}; <br>return preg_replace_callback ('/( +) /', $replacement, $text); <br>} Copy after login |
function replace_spaces ($text) { <br>return preg_replace_callback ('/( +) /', <br>function ($matches) { <br>return str_replace ($matches[1], ' ', ' ').' '; <br>}, $text); <br>} Copy after login |
function (normal parameters) use ($var1, $var2, &$refvar) {} Copy after login |
$foo = <<this is $fubar <br>ONE; Copy after login |
$bar = <<<'TWO' this is $fubar TWO; Copy after login |
php的GC机制采用引用计数机制,引用计数是很简单高效的GC机制,不过缺点也很明显,不能完全回收所有已无效的变量,例如变量相互引用了,就无法回收了,5.3里加入的GC函数,其实就是起到增强GC机制的作用。
gc_enable(); // 激活GC,增强GC机制,回收循环引用的无效变量 <br>var_dump(gc_collect_cycles()); // 强制回收已无效的变量 <br>gc_disable(); // 禁用GC Copy after login |

Hot AI Tools

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

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

Undress AI Tool
Undress images for free

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











MySQL and phpMyAdmin can be effectively managed through the following steps: 1. Create and delete database: Just click in phpMyAdmin to complete. 2. Manage tables: You can create tables, modify structures, and add indexes. 3. Data operation: Supports inserting, updating, deleting data and executing SQL queries. 4. Import and export data: Supports SQL, CSV, XML and other formats. 5. Optimization and monitoring: Use the OPTIMIZETABLE command to optimize tables and use query analyzers and monitoring tools to solve performance problems.

AI can help optimize the use of Composer. Specific methods include: 1. Dependency management optimization: AI analyzes dependencies, recommends the best version combination, and reduces conflicts. 2. Automated code generation: AI generates composer.json files that conform to best practices. 3. Improve code quality: AI detects potential problems, provides optimization suggestions, and improves code quality. These methods are implemented through machine learning and natural language processing technologies to help developers improve efficiency and code quality.

session_start()iscrucialinPHPformanagingusersessions.1)Itinitiatesanewsessionifnoneexists,2)resumesanexistingsession,and3)setsasessioncookieforcontinuityacrossrequests,enablingapplicationslikeuserauthenticationandpersonalizedcontent.

In MySQL, add fields using ALTERTABLEtable_nameADDCOLUMNnew_columnVARCHAR(255)AFTERexisting_column, delete fields using ALTERTABLEtable_nameDROPCOLUMNcolumn_to_drop. When adding fields, you need to specify a location to optimize query performance and data structure; before deleting fields, you need to confirm that the operation is irreversible; modifying table structure using online DDL, backup data, test environment, and low-load time periods is performance optimization and best practice.

To safely and thoroughly uninstall MySQL and clean all residual files, follow the following steps: 1. Stop MySQL service; 2. Uninstall MySQL packages; 3. Clean configuration files and data directories; 4. Verify that the uninstallation is thorough.

Efficient methods for batch inserting data in MySQL include: 1. Using INSERTINTO...VALUES syntax, 2. Using LOADDATAINFILE command, 3. Using transaction processing, 4. Adjust batch size, 5. Disable indexing, 6. Using INSERTIGNORE or INSERT...ONDUPLICATEKEYUPDATE, these methods can significantly improve database operation efficiency.

MySQL functions can be used for data processing and calculation. 1. Basic usage includes string processing, date calculation and mathematical operations. 2. Advanced usage involves combining multiple functions to implement complex operations. 3. Performance optimization requires avoiding the use of functions in the WHERE clause and using GROUPBY and temporary tables.

Installing MySQL on macOS can be achieved through the following steps: 1. Install Homebrew, using the command /bin/bash-c"$(curl-fsSLhttps://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)". 2. Update Homebrew and use brewupdate. 3. Install MySQL and use brewinstallmysql. 4. Start MySQL service and use brewservicesstartmysql. After installation, you can use mysql-u
