从mysql转换为mysqli(mysql_fetch_array) [英] Converting from mysql to mysqli (mysql_fetch_array)

问题描述

我有一些像这样的php代码:

I have some php code that was like this:

$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 (示例#1面向对象样式)

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)

我不确定示例中"$ result"的含义.

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

到目前为止，这是我将代码转换为的内容:

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

<?php 
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.<br />" : "Nothing changed. <br />"; 
echo "<a href='list.php'>Back</a>";
} 
$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时，可能有很多错误，但是现在它在

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

致命错误:调用成员函数fetch_array()

Fatal error: Call to a member function fetch_array()

推荐答案

UPDATE查询不返回结果对象，而是返回TRUE(假设成功).然后，您尝试呼叫TRUE->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();

这篇关于从mysql转换为mysqli(mysql_fetch_array)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！