将mysql转换为mysqli? [英] Convert mysql to mysqli?
本文介绍了将mysql转换为mysqli?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试将代码更改为mysqli
,听说不推荐使用mysql
,并且在将代码更改为mysqli
时遇到了麻烦.
I'm trying to change my code to mysqli
, I heard mysql
isn't recommended and I'm having trouble changing my code to mysqli
.
我设法连接到我的数据库,但是其余代码似乎不起作用,我尝试将所有mysql
更改为mysqli
,但是没有用.我该怎么做,所以代码可以在mysqli
中正常工作?
I managed to connect to my database but the rest of the code doesn't seem to work, I tried changing all mysql
to mysqli
but it didn't work. What could I do so the code works the same but in mysqli
?
有人可以重写它,以便我看到其中的区别.我还没有看过任何好的教程.
Could someone rewrite it so I could see the difference. I haven't seen any good tutorials.
<?php
$db = new mysqli('localhost','root', '', 'searchengine');
if($db->connect_errno) {
die('sorry we are having some problbems');
}
$sql = mysql_query(sprintf(
"SELECT * FROM searchengine WHERE pagecontent LIKE '%s' LIMIT 0,%d",
'%'. mysql_real_escape_string($_GET['term']) .'%',
mysql_real_escape_string($_GET['results']))
);
while($ser = mysql_fetch_array($sql)) {
echo "<h2><a href='$ser[pageurl]'>$ser[pageurl]</a></h2>";
}
mysql_close();
推荐答案
<?php
$db = new mysqli('localhost','root', '', 'searchengine');
if($db->connect_errno) {
die('sorry we are having some problbems');
}
$sql = $db->query(sprintf(
"SELECT * FROM searchengine WHERE pagecontent LIKE '%s' LIMIT 0,%d",
'%'. $db->real_escape_string($_GET['term']) .'%',
$db->real_escape_string($_GET['results']))
);
while($ser = $sql->fetch_array()) {
echo "<h2><a href='" . $ser['pageurl'] . "'>" . $ser['pageurl'] . "</a></h2>";
}
$db->close();
这篇关于将mysql转换为mysqli?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文