PHP 表单返回 Notice : Array to string conversion

Question

我有一个简单的表单，它到达以下要处理的代码。

include("connect.php");

$items = array_key_exists('equipment', $_POST) ? $_POST['equipment'] : '';

if(!empty($items))
{
    if ($_POST["equipment"] == "computer") {
        echo "checked computer!";
    } else if($_POST["equipment"] == "projector")
    {
        echo "checked projector!";

        $sql = "SELECT room_name, day_avail, from_time, to_time, equip_name
        FROM rooms
        JOIN equipment ON (equipment.room_id = rooms.room_id)
        JOIN room_availability ON (room_availability.room_id = rooms.room_id)
        WHERE equip_name='Projector'
        GROUP BY day_avail";

        $myData = mysql_query($sql, $conn) or die(mysql_error());

        $row = mysql_fetch_array($myData);
        echo $row;
        // echo mysql_num_rows($myData);

    } else if($_POST["equipment"] == "whiteboard")
    {
        echo "checked whiteboard!";
    } else if($_POST["equipment"] == "visualiser")
    {
        echo "checked visualiser!";
    } else if($_POST["equipment"] == "desk")
    {
        echo "checked desk!";
    }
} else {
    echo "> Sorry, You have not made a selection.";
}

表单通过 jQuery AJAX 调用调用，如下所示:

<script>
  $('form').submit(function(){
      var str = $(this).serialize();
      $.ajax({
        url: "userLogic.php",
        type: "post",
        data: str,
        cache: false
      }).done(function( html ) {
        $("#rooms_wrap").append(html);
      });
  });
</script>

选中 projector 复选框并提交表单后，我希望从数据库中获取房间列表，以便通过 PHP foreach 循环将它们打印出来。相反，我收到错误消息:

Notice: Array to string conversion

如何获取房间列表，并在 foreach 循环中打印出来？我知道返回了 5 行数据，因为 mysql_num_rows 在我回显时有效。

Answer 1

echo 将字符串作为参数，但 mysql_fetch_array 返回数组 - 您收到的消息表示数组已转换为要由 echo 打印的字符串.尝试使用 var_dump打印出数组:

var_dump($row);

要打印出查询返回的所有行，请使用如下内容:

while($row = mysql_fetch_array($myData)) {
    echo $row["room_name"]; // for example
}