The MySQL native driver for PHP is an additional, alternative way to connect from PHP 5 and PHP 6 to the MySQL Server 4.1 or newer. It is a replacement for the libmysql, the MySQL Client Library. From now on you can use ext/mysqli either together with libmysql as you did in the past or with mysqlnd.
We have no plans to remove libmysql support from ext/mysqli, which would break existing applications. We just add a new, superior alternative to our PHP offerings.
Installation
You need the PHP source code to install the new development. In the current development state the new MySQL native driver comes as a patch for ext/mysqli.
1.Get the PHP 5 or 6 source code from http://www.php.net. You can check out the source code from the CVS repository on http://www.php.net or download a source distribution of PHP.
For example, follow the instructions for Anonymous CVS Access to check out PHP 6:
cvs -d :pserver:cvsread@cvs.php.net:/repository checkout php6
2.Replace the ext/mysqli directory in your PHP source tree
Remove the ext/mysqli directory from your source tree. Copy the ext/mysqli directory from the mysqlnd source tree into the source tree.
3.Run buildconf --force in the PHP source directory
4.Run configure --with-mysqli --enable-mysqlnd in the PHP source directory
5.Build PHP: make
Advantages of mysqlnd
The new development is licensed under the terms of the PHP license to solve any license issues.
During the early stage of the development we will offer it from MySQL. As soon as mysqlnd is feature complete and production ready we will move it to the PHP project CVS repository on http://cvs.php.net.
On the C-level mysqlnd uses many of the proven and stable PHP internal functions. All the code of the new driver is contained in the ext/mysqli source directory. There is no need to link any external libraries. Thus you neither need to install the MySQL client library to compile PHP with ext/mysqli support nor do you need to take care of versions. Compiling has been made easier.
The performance of some functions has been improved. We have measured considerable performance improvements, for example when fetching buffered result sets.
Features and Limitations
The 5.0.1-beta release covers the functionality of the libmysql beside some functions that are marked as experimental in the ext/mysqli documentation. Support for Prepared Statements and Unicode has been added.
From the API additions discussed with Community members in November 2006 during the Frankfurt PHP conference, we managed implement:
* improved persistent connections
* mysqli_fetch_all()
* performance statistics call: mysqli_get_cache_stats(), mysqli_get_client_stats(), mysqli_get_connection_stats()
courtsy: mysql.com
Think Different: Your FREE daily tech stories on AI, Data Science, ML, IoT, Cloud, Open Source, Python, Rust, Golang, DevOps, Management & the future of human-machine interaction. All the latest tech, from around the world.
Subscribe to:
Post Comments (Atom)
LLM for Humanoid Robot
Photo by Tara Winstead Let's consider a scenario where we aim to integrate Long-Term Memory (LLM) into a humanoid robot to enhance its...
-
The client want to have a shop where regular customers to be able to see products with their retail price, while Wholesale partners to see t...
-
URL based session management does not only have additional security risks compared to cookie based session management, but it can cause also...
-
I have curated the learning pathway for you to learn Machine Learning and Data Science. You can follow the Google Classroom paths below: E...
-
Widgets and gadgets are small applications that run on your desktop or in your web browser which enable you to keep track of things like the...
-
When developing a Web application, it's standard practice to create a database structure on which server-side code is placed for the lo...
-
IoT (Internet of Things) : IoT refers to the interconnection of everyday objects, devices, and appliances to the internet, allowing them t...
-
Photo by Acharaporn Kamornboonyarush Let's compare MongoDB and InfluxDB by prov...
-
Abstract: A solar tracking system is a device or mechanism designed to orient solar panels, solar collectors, or other solar energy harvest...
-
pic: microsoft Power BI Overview: Power BI is a business analytics tool by Microsoft that allows you to visualize and share insights from ...
-
Photo by Nana Dua Let first recap what is CPU and GPU. Image courtesy: researchgate Central Processing Unit ...
No comments:
Post a Comment