c# - 错误:警告:mysqli_fetch_array()期望参数1为mysqli_result，在第15行的/var/www/html/data.php中给定的 bool 值

Question

This question already has answers here:

mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result
（32个答案）
三年前关闭。
我正试图从MySQL表中选择数据以显示c#datagridview中的数据，但收到以下错误消息之一：
警告：mysqli_fetch_array（）期望参数1是mysqli_result，
第15行/var/www/html/data.php中给出的布尔值
这是我的PHP代码：

<?php 

$servername = "********";
$username = "root";
$password = "pws";
$dbname = "dbs";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
$sql = "SELECT userid,password,first_name,last_name,role,active FROM aster_users";
$result = mysql_query($sql);
while($row = mysqli_fetch_array($result)) 
    {
        $userid=$row['userid'];
        $password=$row['password'];
        $first_name=$row['first_name'];
        $last_name=$row['last_name'];
        $role=$row['role'];
        $active=$row['active'];
    }
$conn->close();
?>

帮助我，

最佳答案

不能混合使用mysql和mysqli。对于数据库查询，请使用mysqli_query($conn,$query)。http://php.net/manual/en/mysqli.query.php

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
$sql = "SELECT userid,password,first_name,last_name,role,active FROM aster_users";
$result = mysqli_query($conn,$sql); // NOTICE HOW THIS IS MYSQLI QUERY. NOT MYSQL
while($row = mysqli_fetch_array($result)) 
    {
        $userid=$row['userid'];
        $password=$row['password'];
        $first_name=$row['first_name'];
        $last_name=$row['last_name'];
        $role=$row['role'];
        $active=$row['active'];
    }
mysqli_close($conn); //Use Procedural Code Here. not $conn->close();

关于c# - 错误:警告:mysqli_fetch_array()期望参数1为mysqli_result，在第15行的/var/www/html/data.php中给定的 bool 值，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/34448481/

上一篇：python - Django mysql 数据库凭据 read_default_file 给出错误

下一篇：php - 一起数一排的数字

Answer 1

不能混合使用mysql和mysqli。对于数据库查询，请使用mysqli_query($conn,$query)。http://php.net/manual/en/mysqli.query.php

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
$sql = "SELECT userid,password,first_name,last_name,role,active FROM aster_users";
$result = mysqli_query($conn,$sql); // NOTICE HOW THIS IS MYSQLI QUERY. NOT MYSQL
while($row = mysqli_fetch_array($result)) 
    {
        $userid=$row['userid'];
        $password=$row['password'];
        $first_name=$row['first_name'];
        $last_name=$row['last_name'];
        $role=$row['role'];
        $active=$row['active'];
    }
mysqli_close($conn); //Use Procedural Code Here. not $conn->close();