如何在for循环php中显示图像？

Question

i had 5 images path and name in mysql database.

now i want to display that in a slider in for loop

include ('conn.php');

$select_path="select * from image_table";

$var=mysqli_query($conn,$select_path);

while($row=mysqli_fetch_array($var))
{
 $image_name=$row["name"];
 $image_path=$row["path"];
 $url=$image_path.$image_name;
}



echo' <div id="ninja-slider">
    <div class="slider-inner">
        <ul>';
            for($i=0;$i < $url;$i++){
               echo'<li>';
               echo'  <a class="ns-img" href="'.$url[$i].'"></a>
                <div class="caption">image 1</div>
               </li>';}

        </ul>
        <div class="fs-icon" title="Expand/Close"></div>
    </div>
</div>

for loop can display a list from database?

Answer 1

can you tri this

$servername = 'localhost';
$username = 'root';
$password = '';
$dbname = 'image';
$conn = new mysqli($servername,$username,$password,$dbname);
if($conn->connect_error){
    die.("Connection failed : " .$conn->connect_error);
}
$select_path = 'select * from images';
$var = mysqli_query($conn,$select_path);
while ($row=mysqli_fetch_array($var))
{
    $image_name = $row['image_name'];
    $image_path = 'images';
    $url = "$image_path".'/'."$image_name";
    echo'<div id="ninja-slider">
      <div class="slider-inner">
      <ul>';
    echo'  <a class="ns-img" href="'.$url.'"></a>
           <div class="caption">'.$url.'</div>
    </li>';
}
?>
</ul>
        <div class="fs-icon" title="Expand/Close"></div>
    </div>
</div>