This question already has an answer here:
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>
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: