如何將MySQL轉換為mysqli?基于下面的代碼,我如何將其轉換為mysqli?是否就像更改*mysql_query($sql)一樣簡單?;到mysqli_query($SQL); ?**<?PHP//in my header file that is included on every page I have this$DB["dbName"] = "emails";$DB["host"] = "localhost";$DB["user"] = "root";$DB["pass"] = "";$link = mysql_connect($DB['host'], $DB['user'], $DB['pass']) or die("<center>An Internal Error has Occured. Please report following error to the webmaster.<br><br>".mysql_error()."'</center>");mysql_select_db($DB['dbName']);// end header connection part// function from a functions file that I run a mysql query through in any page.function executeQuery($sql) { $result = mysql_query($sql); if (mysql_error()) { $error = '<BR><center><font size="+1" face="arial" color="red">An Internal Error has Occured.<BR> The error has been recorded for review</font></center><br>'; if ($_SESSION['auto_id'] == 1) { $sql_formatted = highlight_string(stripslashes($sql), true); $error .= '<b>The MySQL Syntax Used</b><br>' . $sql_formatted . '<br><br><b>The MySQL Error Returned</b><br>' . mysql_error(); } die($error); } return $result;}// example query ran on anypage of the site using executeQuery function$sql='SELECT auto_id FROM friend_reg_user WHERE auto_id=' .$info['auto_id'];$result_member=executequery($sql);if($line_member=mysql_fetch_array($result_member)){ extract($line_member);} else { header("location: index.php"); exit;}?>
3 回答

繁華開滿天機
TA貢獻1816條經驗 獲得超4個贊
mysql_*
mysqli_*
mysql_connect
將由 mysql_error
將由 和/或 ,取決于上下文 mysql_query
將由 諸若此類
對于MySQL,您必須使用 連接后,指示要在哪個數據庫上執行查詢。 另一方面,mysqli允許您將數據庫名指定為第四個參數 盡管如此,也有一個 函數,如果您愿意的話,可以使用。

手掌心
TA貢獻1942條經驗 獲得超3個贊
mysql_*
mysqli_*
mysqli_*
mysql_query($query)
mysqli_query($link, $query)

MMTTMM
TA貢獻1869條經驗 獲得超4個贊
$con = mysqli_connect($serverName,$dbusername,$dbpassword);
所有“ MySQL_SELECT_db(
“有” mysqli_select_db($con)"
所有“ MySQL查詢(
“有” mysqli_query($con)
“和 所有“ MySQL
“有” mysqli".
添加回答
舉報
0/150
提交
取消