将MySQL转换为MySQLi问题[重复]

Question

This question already has an answer here:

• mysqli_query expects at least 2 parameters 5 answers

This is error line 125. Actually, I am new to MySQLi, so I am not able to understand how to convert MySQL to MySQLi.

This is my code:

<?php 

$query = mysql_query("select * from upload ORDER BY id DESC") or die(mysql_error());

while ($row = mysql_fetch_array($query)) {
    $id = $row['id'];
    $name = $row['name'];
    $date=$row['date'];
}

</div>

Answer 1

You need to pass in the connection as a parameter to mysqli_query():

$connection = mysqli_connect(
    "your_host",
    "your_user",
    "your_password",
    "your_db"
);

$result = mysqli_query(
    $connection, 
    "select * from upload ORDER BY id DESC"
);

if (false === $result) {
    die(mysqli_error($connection));
}

while ($row = mysqli_fetch_array($result)) {
    $id = $row['id'];
    $name = $row['name'];
    $date = $row['date'];
}

For reference, see:

• http://php.net/manual/en/function.mysqli-connect.php
• http://php.net/manual/en/mysqli.query.php
• http://php.net/manual/en/mysqli.error.php
• http://php.net/manual/en/mysqli-result.fetch-assoc.php