PHP脚本所有的量(变量/常量/静态/全局等)只存在于每一次请求的生命周期里.
比如可以在函数cn_db内用静态变量存储数据库连接对象,在一个请求内,实现两个数据库操作函数只连接一次数据库.
header('Content-Type: text/plain;charset=utf-8');
// config.php
$app = array(
'db_host' => '127.0.0.1',
'db_username' => 'root',
'db_password' => 'pass',
'db_name' => 'mysql'
);
// functions.php
function cn_db() {
global $app;
static $db;
if ($db) {
return $db;
} else {
$db = @new mysqli($app['db_host'], $app['db_username'], $app['db_password'], $app['db_name']);
register_shutdown_function(function() use ($db) { $db->close(); });
return $db;
}
}
function cn_foo1() {
$db = cn_db();
return $db->query('select user,host from user where user = \'root\'')->fetch_all();
}
function cn_foo2() {
$db = cn_db();
return $db->query('select user,host from user')->fetch_all();
}
// controller + view
print_r(cn_foo1());
print_r(cn_foo2());
sudo tail /png/percona/5.6.23/logs/log.sql
查看MySQL的general_log_file日志,可见两个Query只进行了一次Connect:
Connect root@localhost on mysql
Query select user,host from user where user = 'root'
Query select user,host from user
Quit
如果开启了持久连接,则请求结束后,PHP不会释放到MySQL的连接,以便下次重用,这个对程序是透明的.