college-management-php/mediauser_view.php at main · PawanCodeCrafts/college-management-php · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
<?php
include("connect.php")
?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=, initial-scale=1.0">
    <title> user gallery view</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-9ndCyUaIbzAi2FUVXJi0CjmCapSmO7SnpJef0486qhLnuZ2cdeRhO02iuK6FUUVM" crossorigin="anonymous">
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js" integrity="sha384-geWF76RCwLtnZ8qwWowPQNguL3RmwHVBC9FhGdlKrxdiJJigb/j/68SIy3Te4Bkz" crossorigin="anonymous"></script>

    <link href="fontawesome-free-6.4.0-web/css/all.css" rel="stylesheet">

</head>

<body>
              <?php
            $sel_query = "Select * from media  ORDER BY media_id desc;";
            $result = mysqli_query($con, $sel_query);
            while ($row = mysqli_fetch_assoc($result)) { ?>
               <div class="row">
                  <div class="col-3"><img src="image/<?php echo $row["photo1"]; ?>" height="150" width="200"></div>
                  <div class="col-3"><img src="image/<?php echo $row["photo2"]; ?>" height="150" width="200"></div>
                  <div class="col-3"><img src="image/<?php echo $row["photo3"]; ?>" height="150" width="200"></div>
                  <div class="col-3"><img src="image/<?php echo $row["photo4"]; ?>" height="150" width="200"></div>
            </div>
<br>

            <?php
            } ?>

</body>

</html>