转换MySQL中的MySQLi问题

Question

这是错误线125。其实，我是新来的MySQLi，所以我不能够理解如何将MySQL的转换为MySQLi的。

这是我的代码：

<?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']; 
} 

Answer 1

您需要在连接作为参数传递给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']; 
} 

仅供参考，请参阅：

• 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