banking-app-/adminaccountedit.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
  <?php
   session_start();
   $connection = mysqli_connect("localhost","root","","bankaccount");
$database = mysqli_select_db($connection,"bankaccount");
$id=$_SESSION['id'];
$sql="SELECT * FROM banktable WHERE id='$id'";
$result=mysqli_query($connection,$sql);
$row=mysqli_fetch_array($result);

      if(isset($_POST["update"])){
        $accountname = $_POST["accountname"];
        $accountnum = $_POST["accountnum"];
        $accountpin = $_POST["accountpin"];
        $password = $_POST["password"];
        $bankname = $_POST["bankname"];
        $balance = $_POST["balance"];

$query = "UPDATE banktable SET account_name = '$accountname', account_number = '$accountnum', account_pin = '$accountpin', password = '$password', bankname = '$bankname', current_balance = '$balance' WHERE id = '$id'";
                    $result = mysqli_query($connection,$query);
                    ?>
                     <script type="text/javascript">
            alert("Update Successfull.");
            window.location = "allconnectedaccount.php";
        </script>
        <?php
             }
?>

<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width,scalable=no">
<style>
#hide{
display: block;
}

#full{
  width:  200px;
  height: 30px;
  text-align:  center;
}

select {
  width: 200px;
  height: 30px;
}

#upd{
  width: 200px;
  height: 30px;
}

#up{
 width:  100%;
 text-align:  center;
}

h2{
  font-family: 'Montserrat', sans-serif;
  font-weight:  bold;
  padding:  0px 5em;
}


@media all and (max-width:  580px){
  #up{
  margin: 2em auto;
  font-size: 3em;
}

#full{
  width:  10em;
  height: 60px;
  text-align:  center;
  font-size: 1em;
}

#upd{
  width: 200px;
  height: 30px;
  font-size: 0.5em;
}

}

</style>
</head>
<body>
  <div id="up">
    <h4>ADMIN EDIT ACCOUNTS</h4>
  <form action="adminaccountedit.php" method="POST">
    <lebel>account name</lebel><br>
<input name="accountname" id="full" value="<?php echo @$row["account_name"]; ?>"><br>

<lebel>account number</lebel><br>
<input name="accountnum" id="full" value="<?php echo @$row["account_number"]; ?>"><br>

<lebel>account pin</lebel><br>
<input name="accountpin" id="full" value="<?php echo @$row["account_pin"]; ?>"><br>

<lebel>password</lebel><br>
<input name="password" id="full" value="<?php echo @$row["password"]; ?>"><br>

<lebel>bank name</lebel><br>
<input name="bankname" id="full" value="<?php echo @$row["bankname"]; ?>"><br>

<lebel>account_balance</lebel><br>
<input name="balance" id="full" value="<?php echo @$row["current_balance"]; ?>"><br>
 <br>
<input type="submit" id="upd" name="update" value="update">

</form>
</div>
</body>
</html>