部分代码如下
<?php
$searchtype=$_POST['searchtype'];
$searchterm=trim($_POST['searchterm']);
if(!$searchtype||!$searchterm)
{
echo 'You have not entered search details.Please go back and try again.';
exit;
}
if(!get_magic_quotes_gpc())
{
$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);
}
@$db = new MySQLi('localhost','bookorama','bookorama123','books');
if(mysqli_connect_errno())
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
$query = "select * from books where ".$searchtype."like '%".$searchterm."%'";
$result = $db->query($query);
$dd = mysql_connect("localhost",'bookorama','bookorama123');
echo mysql_error();
$dd = mysql_select_db('books',$dd);
$result2 = mysql_query($query);
if($dd) echo "mysql Not connection<br>";
else echo "mysql Connection<br>";
if($result2) echo "Not null<br>";
else echo "Null<br>";
//判断
$num_results2 = mysql_num_rows($result2);
echo "<br>";
if($db) echo "mysqli Not connection<br>";
else echo "mysqli Connection<br>";
if($result) echo "Not null<br>";
else echo "Null<br>";
//判断
$num_results = $result->num_rows;
$result->free();
?>
执行结果：
环境配置没有问题，php.ini中的mysql和mysqli都打开了，用cmd直接进数据库能查询到结果，不知道为什么会这样
我是刚学PHP的新人，照书上的代码写的，书上用的是mysqli连接，出错后我又加了mysql连接，然后加了两个if判断，发现两种方式都不行，数据库好像没有连接上，有哪位高手能帮我解答一下么？谢谢啦~
