banking-app-/editconnectedusers.php at main · errorcodegh/banking-app- · 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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
<?php
include 'adminadminindex.php';
$connection = mysqli_connect("localhost","root","","bankaccount");
$database = mysqli_select_db($connection,"bankaccount");

?>


<!DOCTYPE html>
<html>
<head><title>admin logging</title>
<meta name="viewport" content="width=device-width,  scalable=no">
<style>

table {
  font-family: arial, sans-serif;
  border-collapse: collapse;
  width: 100vw;
  height: 5em;

}


       td, th {
  border: 1px solid #dddddd;
  text-align: left;
  padding: 1em;
}

h1 {
  color: gold;
  display: block;
}

#add{
  margin-top:  5em;
}

h2{
  text-align:  center;
  font-family: 'Montserrat', sans-serif;
}

@media all and (max-width:  580px){


table {
  font-family: arial, sans-serif;
  border-collapse: collapse;
  width: 100vw;
  height: 5em;
  font-size: 3em;

}


}

</style>
</head>

<body>
  <div id="add">
  <table>
    <h2>Edit all connected users!!!</h2>
    <tr>

            <th>USER_ID</th>
            <th>FULLNAME</th>
            <th>EMAIL</th>
            <th>PHONE</th>
            <th>CITY</th>
            <th>COUNTRY</th>
            <th>ZIPCODE</th>
            <th>ADDRESS</th>
            <th>IMAGE</th>
          </tr>

    </tr>

   <?php

     $sql = "SELECT * FROM banktable;";
     $result = mysqli_query($connection,$sql);
     $resultcheck = mysqli_num_rows($result);

        if($resultcheck > 0){
          while ($row=mysqli_fetch_assoc($result)){


 echo "<tr>";

                   echo "<td>".$row["id"]. "</td>";
                   echo "<td>".$row["fullname"]."</td>";
                   echo "<td>".$row["email"]."</td>";
                   echo "<td>".$row["phone"]."</td>";
                   echo "<td>" .$row["city"]. "</td>";
                   echo "<td>" .$row["country"]. "</td>";
                   echo "<td>" .$row["zipcode"]. "</td>";
                   echo "<td>" .$row["address"]. "</td>";
                   echo "<td>" .$row["image"]. "</td>";
                  echo "</tr>";

     }

        }


  ?>

    </table>
  </div>
  </body>
  </html>