mysql_fetch_array mysqli_从mysql转换为mysqli(mysql_fetch_array)

66 阅读 0 评论 44 点赞

我是靠谱客的博主懵懂蛋挞，最近开发中收集的这篇文章主要介绍mysql_fetch_array mysqli_从mysql转换为mysqli(mysql_fetch_array)，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

我有一些这样的PHP代码：

$row = mysql_fetch_array ( mysql_query("SELECT * FROM `tblFacilityHrs` WHERE `uid` = '$uid'"));我现在试图将它转换为mysqli_fetch_array，如下所示http://php.net/manual/en/mysqli-result.fetch-array.php(Example#1面向对象的样式)

我不确定“$ result”是什么意思。

这就是我已经将代码转换为目前为止的内容：

include('../config.php');

if (isset($_GET['uid']) ) {

$uid = $_GET['uid'];

$id = $_GET['id'];

if (isset($_POST['submitted'])) {

foreach($_POST AS $key => $value) { $_POST[$key] = mysqli_real_escape_string($value); }

//Query for tblFacilityHrs

$sql = " UPDATE tblFacilityHrs SET `title`='{$_POST['title']}',`description`='{$_POST['description']}' WHERE `uid` = '$uid' ";

$result = $mysqli->query($sql) or die($mysqli->error);

//Query for tblFacilityHrsDateTimes

$sql2 = "UPDATE tblFacilityHrsDateTimes SET `startEventDate`='{$_POST['startEventDate']}',`endEventDate`='{$_POST['endEventDate']}', `startTime`='{$_POST['startTime']}',`endTime`='{$_POST['endTime']}',`days`='{$_POST['days']}',`recurrence`='{$_POST['recurrence']},`finalDate`='{$_POST['finalDate']}' WHERE `id` = '$id' "; print $sql2;

$result2 = $mysqli->query($sql2) or die($mysqli->error);

echo ($mysqli->affected_rows) ? "Edited row.
" : "Nothing changed.
";

echo "Back";

}

$row = $result->fetch_array($mysqli->query("SELECT * FROM `tblFacilityHrs` WHERE `uid` = '$uid'"));

$row2 = $result2->fetch_array($mysqli->query("SELECT * FROM `tblFacilityHrsDateTimes` WHERE `id` = '$id'"));

?>因为我正在学习mysqli，可能有很多错误，但现在它出错了

Fatal error: Call to a member function fetch_array()