mysql转mysqli,从mysql转换为mysqli（mysql_fetch_array）

最新推荐文章于 2021-02-09 22:41:54 发布

mtrip我的旅行我做主

最新推荐文章于 2021-02-09 22:41:54 发布

阅读量160

点赞数

文章标签： mysql转mysqli

这篇博客讨论了将PHP代码从使用mysql_函数转换到mysqli_函数的过程中遇到的问题。作者尝试更新查询以使用面向对象的mysqli风格，但在调用fetch_array()时遇到了错误。解决方案指出，UPDATE查询不返回结果集，因此不能直接调用fetch_array()。修正后的代码应直接使用mysqli_query()的结果来获取数组。

摘要由CSDN通过智能技术生成

I have some php code that was like this:

$row = mysql_fetch_array ( mysql_query("SELECT * FROM `tblFacilityHrs` WHERE `uid` = '$uid'"));

I'm now trying to convert it to mysqli_fetch_array as shown here http://php.net/manual/en/mysqli-result.fetch-array.php (Example #1 Object oriented style)

I'm not sure what the example means by "$result".

This is what I've converted my code to so far:

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'"));

There is probably a lot wrong with as I am learning mysqli, but right now it errors on

Fatal error: Call to a member function fetch_array()

解决方案

UPDATE queries do not return result objects, it returns TRUE (assuming success). You're then trying to call TRUE->fetch_array(), which obviously won't work.

Now, for doing what you actually want to do, try this:

$row = $mysqli->query("SELECT.....")->fetch_array();