更新时间:2023-02-19 13:59:14
you can try it by creating a mysqli object like described here: http://www.php.net/manual/en/class.mysqli.php
或者仅仅是这样:
$db = new mysqli($hostname, $username, $password, $database);
然后像这样查询它:
$result = $db->query('SQL HERE');
在您的情况下,mysqli的代码应如下所示
in your case the code for mysqli would look like this
$db = new mysqli("localhost","root","","searchengine");
$result = $db->query(sprintf(
"SELECT * FROM searchengine WHERE pagecontent LIKE '%s' LIMIT 0,%d",
'%'. mysqli_real_escape_string($_GET['term']) .'%',
$_GET['results'])
);
while($ser = mysqli_fetch_array($result)) {
echo "<h2><a href='$ser[pageurl]'>$ser[pageurl]</a></h2>";
}