mysql 改为mysqli_php – 如何将这个mysql更改为mysqli?

基于下面的代码我使用正常的mysql,我怎么可以转换为使用mysqli?

是简单的改变** mysql _query($ sql); mysqli _query($ sql); ?**

//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("

An Internal Error has Occured. Please report following error to the webmaster.
".mysql_error()."'
");

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 = '

An Internal Error has Occured.
The error has been recorded for review

';

if ($_SESSION['auto_id'] == 1) {

$sql_formatted = highlight_string(stripslashes($sql), true);

$error .= 'The MySQL Syntax Used
' . $sql_formatted . 'The MySQL Error Returned
' . 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;

}

?>

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值