Egovernance/admin_verify_road_updates.php at main · bindushahi/Egovernance · 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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
<!--connect file-->
<?php
  include('dbconnect.php');
?>
<h3 class="text-center text-primary">User Road Condition Updates</h3>
<table class="table table-bordered mt-5">
    <thead >
    <tr>
        <th class="text-primary text-center">SNo.</th>
        <th class="text-primary text-center">Location</th>
        <th class="text-primary text-center">Image</th>
        <th class="text-primary text-center">Image</th>
        <th class="text-primary text-center">Image</th>
        <th class="text-primary text-center">Description</th>
        <th class="text-primary text-center">Date</th>
        <th class="text-primary text-center">Source</th>
        <th class="text-primary text-center">Source Contact</th>
        <th class="text-primary text-center">Accept</th>
        <th class="text-primary text-center">Delete</th>
    </tr>
    </thead>
    <tbody>
        <?php
        $get_user_updates="SELECT * from `roadreport` ORDER BY created_at DESC";
        $rresult=mysqli_query($conn,$get_user_updates);
        $rnumber=0;
        while($row=mysqli_fetch_assoc($rresult)){
            $reportid=$row['reportid'];
            $updatelocation=$row['updatelocation'];
            $roadimage1=$row['roadimage1'];
            $roadimage2=$row['roadimage2'];
            $roadimage3=$row['roadimage3'];
            $roadcondition=$row['roadcondition'];
            $created_at=$row['created_at'];
            $updatereporter=$row['updaterepoter'];
            $updatereportercontact=$row['updaterepotercontact'];
            $rnumber++;
            ?>
            <tr class='text-center' >
            <td class=''><?php echo $rnumber?></td>
            <td> <?php echo $updatelocation?></td>
            <td> <img src='user_road_update_images/<?php echo $roadimage1;?>' class='product_img'/></td>
            <td> <img src='user_road_update_images/<?php echo $roadimage2;?>' class='product_img'/></td>
            <td> <img src='user_road_update_images/<?php echo $roadimage3;?>' class='product_img'/></td>

            <td><?php echo $roadcondition?></td>
            <td> <?php echo $created_at?></td>
            <td> <?php echo $updatereporter?></td>
            <td> <?php echo $updatereportercontact?></td>

            <td><a href='admin_index.php?accept_road_updates=<?php echo $reportid ?>' class=''>
            <i class="fa-solid fa-check"></i></a></td>
            <td><a href='admin_index.php?delete_user_road_update=<?php echo $reportid ?>' class=''>
            <i class='fa-solid fa-trash'></a></td>
        </tr>
        <?php
        }
        ?>

    </tbody>
</table>