Support for Persistent Connections
ext/mysqli does not support persistent connections when built with libmysql. However ext/mysqli does support persistent connections when built with mysqlnd. To establish a persistent connection with the MySQL server using ext/mysqli and mysqlnd, prepend the database host with the string "p:" (p stands for persistent) as shown below.
$host="p:localhost"; $port=3306; $socket="/tmp/mysql.sock"; $user="root"; $password="admin"; $dbname="test"; $cxn = new mysqli($host, $user, $password, $dbname, $port, $socket) or die ('Could not connect to the database server' . mysqli_connect_error());
ext/mysql, ext/mysqli and PDO_MySQL support persistent connections when built with mysqlnd.
The new API call mysqli_fetch_all()
mysqlnd extends the ext/mysqli API with one brand new method, …
[Read more]