且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

怎么把mysql转换成mysqli?

更新时间:2023-02-19 13:59:14

您可以通过创建mysqli对象来尝试使用它,如下所述:

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>";
}