-
Notifications
You must be signed in to change notification settings - Fork 2
/
myprofile.php
99 lines (98 loc) · 4.27 KB
/
myprofile.php
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
<?php
require("login-check/logincheck_P.php");
include("config.php");
error_reporting(E_ALL & ~E_WARNING & ~E_NOTICE);
session_start();
?>
<head>
<title>My Profile</title>
<link rel="shortcut icon" type="image/jpg" href="images/favicon.ico"/>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css"
integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
<link rel="stylesheet" type="text/css" href="css/styles.css">
<script src='https://kit.fontawesome.com/a076d05399.js' crossorigin='anonymous'></script>
</head>
<body class="bg">
<?php include 'nav & footer/nav.php' ?>
<div class="container features" style="margin-bottom: 0px !important;">
<div class="row center">
<div class="col-lg-4 col-md-4 col-sm-6">
<h3 class="feature-title">My Profile</h3>
</div>
</div>
</div>
<div class="container features" style="margin-top: 0px !important;">
<div class="row center" style="margin-top: 50px">
<div class=" CardBgCol col-md-8">
<?php
try {
$num = $_SESSION["p_un"];
$conn = new PDO($db, $un, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$query = "SELECT `PID`, `Name`, `Bday`, `No`, `Email`, `Address`, `BG`, `Gender`,`NIC` FROM `Patients` WHERE PID= $num ";
$result = $conn->query($query);
echo '<table class="table">';
foreach ($result as $row) {
echo '<tbody>';
echo '<tr>';
echo '<td><b>Patient Number:</b></td>';
echo '<td>' . $row[0] . '</td>';
echo '</tr>';
echo '<tr>';
echo '<td><b>Name:</b></td>';
echo '<td>' . $row[1] . '</td>';
echo '</tr>';
echo '<tr>';
echo '<td><b>Birth Date:</b></td>';
echo '<td>' . $row[2] . '</td>';
echo '</tr>';
echo '<tr>';
echo '<td><b> Phone Number:</b></td>';
echo '<td>' . $row[3] . '</td>';
echo '</tr>';
echo '<tr>';
echo '<td><b>Email:</b></td>';
echo '<td>' . $row[4] . '</td>';
echo '</tr>';
echo '<tr>';
echo '<td><b>Address:</b></td>';
echo '<td>' . $row[5] . '</td>';
echo '</tr>';
echo '<tr>';
echo '<td><b>Blood Group:</b></td>';
echo '<td>' . $row[6] . '</td>';
echo '</tr>';
echo '<tr>';
echo '<td><b>Gender:</b></td>';
echo '<td>' . $row[7] . '</td>';
echo '</tr>';
echo '<tr>';
echo '<td><b>NIC:</b></td>';
echo '<td>' . $row[8] . '</td>';
echo '</tr>';
echo ' </tbody>';
}
echo '</table>';
} catch (PDOException $th) {
echo $th->getMessage();
}
error_reporting(E_ALL & ~E_WARNING & ~E_NOTICE);
?>
</div>
</div>
</div>
<img src="images/img.jpg" class="img-bg" style="margin-top: 10px">
<?php include 'nav & footer/footer.php' ?>
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"
integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo"
crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"
integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1"
crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"
integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM"
crossorigin="anonymous"></script>
</body>
</html>