PHP/MySQLi - Trouble running while loop [duplicate

问题:

This question already has answers here:

Can I mix MySQL APIs in PHP? (4 answers)

Closed 3 years ago.

Here is my code:

$v = $conn->query("SELECT * FROM `categories` WHERE `Link`!=''");


while($vrowi = mysql_fetch_array($v, MYSQLI_ASSOC))

{

$url = $vrowi['Link'];  
$Cat = $vrowi['id'];
}

The while loop isn't working. Can you please tell me where the mistake is? Thanks in advance!

回答1:

You're mixing object-oriented MySQLi code with a functional approach, and need to choose either one or the other. In your exact, the solution is this:

$v = $conn->query("SELECT * FROM `categories` WHERE `Link` != '';");

while ($vrowi = $v->fetch_assoc()) {
    $url = $vrowi['Link'];
    $Cat = $vrowi['id'];
}