-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathupdate.php
105 lines (105 loc) · 5.11 KB
/
update.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
99
100
101
102
103
104
105
<?php
require("login-check/logincheck_A&D.php");
include("config.php");
error_reporting(E_ALL & ~E_WARNING & ~E_NOTICE);
session_start();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Update Patient</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-md-8 CardBgCol">
<form method="post" enctype="multipart/form-data">
<h3 class="feature-title">Update patient profile</h3>
<?php
try {
$editP = $_SESSION["editNo"];
$conn = new PDO($db, $un, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$query = $query = "SELECT `PID`, `Name`, `BDay`, `No`, `Email`, `Address`,`Day` FROM `Patients` Where `PID`= $editP";
$result = $conn->query($query);
foreach ($result as $row) {
echo ' <div class="form-group"> Name:';
echo '<input type="text" class="form-control" name="pName" value="' . $row[1] . '" required >';
echo '</div>';
echo ' <div class="form-group"> Birth Date:';
echo '<input type="date" class="form-control" name="pAge" value="' . $row[2] . '" required >';
echo '</div>';
echo ' <div class="form-group"> Number:';
echo '<input type="number" class="form-control" name="pNo" value="' . $row[3] . '" required >';
echo '</div>';
echo ' <div class="form-group"> Email:';
echo '<input type="email" class="form-control" name="pEmail" value="' . $row[4] . '" required >';
echo '</div>';
echo ' <div class="form-group"> Address:';
echo '<input type="text" class="form-control" name="pAddress" value="' . $row[5] . '" required >';
echo '</div>';
echo ' <div class="form-group"> Modified Date:';
$date = date("Y-m-d");
echo $date;
echo '</div>';
echo '<input type="submit" class="btn btn-primary" value="Update" name="btnUpdate">';
echo '<input type="submit" style="margin-top: 10px;margin-bottom: 10px;" class="btn btn-primary" value="Cancel" name="btnCan">';
}
} catch (PDOException $th) {
echo $th->getMessage();
}
?>
</form>
</div>
</div>
</div>
<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
if (isset($_POST['btnUpdate'])) {
try {
$conn = new PDO($db, $un, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$query = "UPDATE `Patients` SET `Name`=?,`BDay`=?,`No`=?,`Email`=?,`Address`=?,`Day`=? WHERE `PID`=$editP";
$st = $conn->prepare($query);
$st->bindValue(1, $_POST["pName"], PDO::PARAM_STR);
$st->bindValue(2, $_POST["pAge"], PDO::PARAM_STR);
$st->bindValue(3, $_POST["pNo"], PDO::PARAM_STR);
$st->bindValue(4, $_POST["pEmail"], PDO::PARAM_STR);
$st->bindValue(5, $_POST["pAddress"], PDO::PARAM_STR);
$st->bindValue(6, $date, PDO::PARAM_STR);
$st->execute();
echo "<script> alert('Patient updated Successfully!');</script>";
} catch (PDOException $th) {
echo $th->getMessage();
}
}
}
?>
<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
if (isset($_POST['btnCan'])) {
echo '<script>window.location.href = "register.php";</script>';
}
}
?>
<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>