警告：mysqli_fetch_array（）要求参数1为mysqli_result，在第7行的C：\ xampp \ htdocs \ auction \ index.php中给出字符串[复制]

Question

This question already has an answer here:

• mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result 32 answers

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, string given in C:\xampp\htdocs\auction\index.php on line 7

How can I fix this error? This is my code:

<?php
    session_start();
    $_SESSION['logged'] = 'guest';
    require("functions.php");
    require("htmls.php");
    $query = "SELECT * FROM products WHERE status = 0" or die (mysql_error());
   while ($row = mysqli_fetch_array($query))
    {
        $datenow = date("Y-m-d");
        $duedate = $row['duedate'];
        $prodid = $row['productid'];
        if($datenow >= $duedate){
            $query = "UPDATE products SET status = 1 WHERE productid = '$prodid'" or die (mysqli_error());
        }
    }
    $date = date("Y-m-d");
    headhtml();
?>

</div>

Answer 1

You forgot to do the query.

$query = "SELECT * FROM products WHERE status = 0" or die (mysqli_error());

should be

$query = mysqli_query("SELECT * FROM products WHERE status = 0") or die (mysqli_error());

And don't forget to first connect to mysqli using mysqli_connect function.

WHen you have your query, use mysqli_fetch_array to read actual data.