-
Notifications
You must be signed in to change notification settings - Fork 2
/
myrecords.php
76 lines (75 loc) · 3.28 KB
/
myrecords.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
<?php
require("login-check/logincheck_P.php");
include("config.php");
error_reporting(E_ALL & ~E_WARNING & ~E_NOTICE);
session_start();
?>
<head>
<title>My Records</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">
<div class="row center">
<div class="col-lg-4 col-md-4 col-sm-6">
<h3 class="feature-title">My Records</h3>
</div>
</div>
</div>
<?php
try {
$num = $_SESSION["p_un"];
$conn = new PDO($db, $un, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$query = "SELECT `Patient`,Name, `Diagnosis`, `Medications`, `Date`,`doc` FROM `Diagnosis`
JOIN Patients on Diagnosis.Patient= Patients.PID WHERE PID = $num ORDER BY `Date` DESC";
$result = $conn->query($query);
echo '<div class="container">';
foreach ($result as $row) {
$docName = $row[5];
try {
$conn = new PDO($db, $un, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$query = $query = "SELECT `Name`, `No`, `Email`, `Gender`, `NIC`, `Password`, `Day`, `Address`, `Status` FROM `doctors` WHERE `DID`=$docName";
$result = $conn->query($query);
foreach ($result as $docRow) {
$name = $docRow[0];
}
} catch (PDOException $th) {
echo $th->getMessage();
}
echo '<div class="datacard features CardBgCol">';
echo '<h5 class="dataCard-header">' . $row[4] . '</h5>';
echo '<div class="dataCard-body">';
echo '<h5 class="card-title">' . $row[2] . '</h5>';
echo '<p class="card-text">' . $row[3] . '</p>';
echo '<p class="card-text" style="color: #4b4a4a; text-align: end;"> Diagnosed by Dr.' . $name . '</p>';
echo '</div>';
echo '</div>';
}
echo '</div>';
} catch (PDOException $th) {
echo $th->getMessage();
}
error_reporting(E_ALL & ~E_WARNING & ~E_NOTICE);
?>
<img src="images/img.jpg" class="img-bg" >
<?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>