问题:Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /
下面贴上代码
<?php
$dbhost = 'xxx';
$dbuser = 'xxx';
$dbpass = 'xxx';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
mysql_query("set character set 'utf8'");
mysql_query("set names 'utf8'");
mysql_select_db('database');
?>
看了n遍还是觉得数据库链接代码没有问题,google了很多发现 原因php7.0已经不支持 mysql_connect了。。。于是改用mysqli_connect();
修改后代码:
<?php
$dbhost = 'xxx';
$dbuser = 'xxx';
$dbpass = 'xxx';
$conn = mysqli_connect($dbhost, $dbuser, $dbpass,'database');
if(mysqli_connect_errno($conn) )
{
echo "please try again!";
echo "Could not connect: ". mysqli_connect_error();
exit;
}
mysqli_query($conn,"set character set 'utf8'");
mysqli_query($conn,"set names 'utf8'");
mysqli_select_db($conn,'database');
//var_dump($conn);
//mysqli_close($conn);
?>
mysqli 具体使用方法见如下网址:
http://php.net/mysqli_query