donglv5269 2019-05-24 02:19
浏览 176
已采纳

致命错误:未捕获错误:调用未定义函数mysql_close()

I'm learning about MySQL prepare statement and when I run the following code, I get the PHP Fatal error: Uncaught Error: Call to undefined function mysql_close(). The output is correct and I just can't figure out why such an error occurs. Thanks for your time!

$conn3 = new mysqli(DB_HOST,DB_USERNAME,DB_PASSWORD,DB_NAME);

$event_type = $jarray['event_type'];
$key = "submission";

$search = $conn3->prepare("SELECT * FROM metadb USE INDEX(field_id) WHERE event_type = ? AND event_field = ?");
$search->bind_param('ss', $event_type, $key); 
$search->execute();
$search->store_result();

echo $search->num_rows;

mysql_close($conn3);
  • 写回答

1条回答 默认 最新

  • dryl34156 2019-05-24 02:22
    关注

    Use $conn3->close(); instead of mysql_close($conn3);

    You are using mysqli to open connection and then trying to close connection using mysql.

    Suggestion : You are mixing mysqliobject oriented and procedural in your code I will suggest you to stick with one(preferably Object Oriented). I will also suggest you to start using PDO instead of mysqli. reason explained here

    For more detailed information about mysqli you can refer this documentation.

    For more detailed information about PDO you can refer this documentation.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 计组这些题应该咋做呀
  • ¥60 更换迈创SOL6M4AE卡的时候,驱动要重新装才能使用,怎么解决?
  • ¥15 让node服务器有自动加载文件的功能
  • ¥15 jmeter脚本回放有的是对的有的是错的
  • ¥15 r语言蛋白组学相关问题
  • ¥15 Python时间序列如何拟合疏系数模型
  • ¥15 求学软件的前人们指明方向🥺
  • ¥50 如何增强飞上天的树莓派的热点信号强度,以使得笔记本可以在地面实现远程桌面连接
  • ¥20 双层网络上信息-疾病传播
  • ¥50 paddlepaddle pinn