比如原来连接数据库,用的conn.php,代码为:
<?php
$dbhost = '127.0.0.1';
$dbuser = 'root';
$dbpass = 'root';
$dataname = "xxxx";
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(!$conn)
{
die('Could not connect1: ' . mysql_error());
}
mysql_query("create database IF NOT EXISTS ".$dataname." default charset utf8 COLLATE utf8_general_ci");
if(!mysql_select_db($dataname, $conn))
{
die('Could not connect2: ' . mysql_error());
}
require 'ct.php';//一些建表的Sql函数
?>
升级到PHP7.x后,当然是不行的,因为php7中去掉了mysql_xxx开头的函数库,从而用mysqli_开头的函数库代替,解决方法,就是新建一个php文件,比如php7.php,内容如下:
<?php
// *************** PHP7 START ***************
if(!function_exists('mysql_connect')){
function mysql_connect($host,$user,$passwd){
return mysqli_connect($host,$user,$passwd);
}
function mysql_select_db($dbname,$conn){
return mysqli_select_db($conn,$dbname);
}
function mysql_errno($cxn=null){
return mysqli_errno($cxn);
}
function mysql_error($cxn=null){
return mysqli_error($cxn);
}
function mysql_fetch_array($result){
return mysqli_fetch_array($result);
}
function mysql_fetch_assoc($result){
return mysqli_fetch_assoc($result);
}
function mysql_fetch_row($result){
return mysqli_fetch_row($result);
}
function mysql_insert_id(){
global $conn;
return mysqli_insert_id($conn);
}
function mysql_num_rows($result){
return mysqli_num_rows($result);
}
function mysql_query($sql){
global $conn;
return mysqli_query($conn,$sql);
}
function mysql_real_escape_string($data){
return mysqli_real_escape_string($cxn,$data);
}
function mysql_get_server_info($cxn){
return mysqli_get_server_info($cxn);
}
function mysql_ping($cxn){
return mysqli_ping($cxn);
}
}
?>
然后在原来的conn.php前面,加一行就搞定了
<?php
require 'php7.php';//加入此行,让php5.x的代码,支持php7中的mysqli_xxx系列函数
$dbhost = '127.0.0.1';
$dbuser = 'root';
$dbpass = 'root';
$dataname = "xxxx";
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(!$conn)
{
die('Could not connect1: ' . mysql_error());
}
mysql_query("create database IF NOT EXISTS ".$dataname." default charset utf8 COLLATE utf8_general_ci");
if(!mysql_select_db($dataname, $conn))
{
die('Could not connect2: ' . mysql_error());
}
require 'ct.php';//一些建表的Sql函数
?>