crudapp/view.php at master · sanderweb/crudapp · 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
62
<!DOCTYPE html>
<!--https://www.youtube.com/watch?v=bPZjuV4EdmE&index=1&list=PL6u82dzQtlfsV_n9w_wuhPulddNosaQru-->
<html lang="en">
<head>
    <meta charset="UTF-8">
        <meta name="description" content="Aqui vai uma descrição do website">
        <meta name="author" content="Sahil Kumar">
        <meta name="keywords" content="website, design">

        <!-- Bootstrap CSS -->
        <link rel="stylesheet" href="css/bootstrap.min.css">

        <!--    STYLE CSS-->
        <link rel="stylesheet" href="css/style.css">


        <link rel="icon" href="images/fav.png">
        <title>Sytle | Great Food and Wine</title>
    <title>Document</title>
</head>
<body class="bg-dark">
   <div class="container">
       <div class="row">
           <div class="collg-10 offset-lg-1 mt-3">
               <table class="table table-striped table-bordered bg-light">
                   <thead>
                       <tr class="bg-dark text-light text-cneter">
                           <th>ID</th>
                           <th>Name</th>
                           <th>Email</th>
                           <th>Phone</th>
                           <th>City</th>
                           <th>Edit</th>
                           <th>Delete</th>
                       </tr>
                   </thead>
                   <tbody>
                       <?php
                        include 'config.php';
                       $sql="SELECT * FROM users";
                       $result=mysqli_query($conn,$sql);
                       if(mysqli_num_rows($result)>0){
                           while($row=mysqli_fetch_assoc($result)){
                       ?>
                       <tr class="text-center">
                           <td><?= $row['id']; ?></td>
                           <td><?= $row['name']; ?></td>
                           <td><?= $row['email']; ?></td>
                           <td><?= $row['phone']; ?></td>
                           <td><?= $row['city']; ?></td>
                           <td><a class="btn btn-primary" href="edit.php?id=<?= $row['id']; ?>">Edit</a></td>
                           <td><a  class="btn btn-danger" href="del.php?id=<?= $row['id']; ?>">Delete</a></td>
                       </tr>
                       <?php } } ?>
                   </tbody>
               </table>
           </div>
       </div>
   </div>

</body>
</html>