Simple-Banking-System/customer.php at main · JainPrema/Simple-Banking-System · 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
<!DOCTYPE html>
<html>

<head>
<meta charset="utf-8">
<meta http-equiv="x-ua-compatible" content="IE=edge, chrome=">
<title> Spark Bank</title>
<link rel="stylesheet" href="header.css">
<link rel="stylesheet" href="customer.css">

</head>


<body>

	<div id="wrapper">
		<?php
		    include "./header.html"
        ?>
	</div>


<div id="wrap">

<?php

$servername = "localhost";
$username = "root";
$password = "root123";
$dbname = "bank";

$conn = mysqli_connect($servername, $username, $password, $dbname);


if ($conn->connect_error)
die("Connection failed: " . $conn->connect_error);
$sql = "SELECT * FROM customer";

$result = $conn->query($sql);

echo "<table border='2'>";
echo "<caption>Customer List</caption>";
echo "<tr>";
echo "<th>ID</th><th>Name</th><th>Email ID</th><th>Current Balance</th><th>operations</th></tr>";
if ($result->num_rows> 0)
{
while($row = $result->fetch_assoc()){
?>

<tr>
    <td><?php echo $row["id"]; ?></td>
    <td><?php echo $row["Name"]; ?></td>
    <td><?php echo $row["Email_ID"]; ?></td>
       <td><?php echo $row["balance"]; ?></td>
    <td><a href="view.php?id=<?php echo $row['id']; ?>" class="view">View</a></td>
  </tr>

<?php
}
}
else
echo "Table is Empty";
echo "</table>";

echo "</form>";
$conn->close();
?>


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