Select query in Mysqli

Admin

9 years ago

Nearly every site that you visit nowadays has some sort of database storage in place, many sites opt to use MySQL databases when using PHP. However, many people haven’t yet taken the step to interacting with databases properly in PHP. Here we guide you through what you should be doing – using PHP’s MySQLi class – with a hat-tip to the one way that you definitely shouldn’t be doing it.

Select db table & result in while loop

<?php
$res_view = mysqli_query($db,"SELECT * FROM home_slider ORDER BY position");
while($row_view = mysqli_fetch_array($res_view))
{
echo $row_view['banner']; 
}
?>

<?php

$res_view = mysqli_query($db,"SELECT * FROM home_slider ORDER BY position");

while($row_view = mysqli_fetch_array($res_view))

{

echo $row_view['banner'];

}

here ‘$db’ variable is db connection variable