-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathaddRecords.php
89 lines (85 loc) · 5.12 KB
/
addRecords.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
<!DOCTYPE html>
<!--
Project by Tanmoy Sen Gupta | tanmoysps@gmail.com | www.tanmoysg.com
-->
<?php
include 'connection.php';
session_start();
if (isset($_SESSION['logged_in'])) {
$email = $_SESSION['email'];
$query = "SELECT * FROM users WHERE email ='$email'";
$result = mysqli_query($db, $query);
$row = mysqli_fetch_assoc($result);
$mln = $row['mln'];
if (isset($_POST['submit'])) {
$sypmtoms = mysqli_real_escape_string($db, $_POST['symptoms']);
$diagnosis = mysqli_real_escape_string($db, $_POST['diagnosis']);
$date = mysqli_real_escape_string($db, $_POST['date']);
$dr = mysqli_real_escape_string($db, $_POST['dr']);
$trtmnt = mysqli_real_escape_string($db, $_POST['trtmnt']);
$medicines = mysqli_real_escape_string($db, $_POST['medicines']);
$query = "INSERT INTO $mln (`symptoms`, `diagnosis`, `date`, `dr`, `trtmnt`, `medicines`)
VALUES('$sypmtoms' , '$diagnosis', '$date', '$dr', '$trtmnt', '$medicines')";
mysqli_query($db, $query);
$message = 'Successfully Added for ';
}
?>
<html>
<head>
<meta charset="UTF-8">
<title>Add Records</title>
<link rel="icon" href="favicon.ico" sizes="20x20" type="image/png">
<link rel="stylesheet" type="text/css" href="styling/dashboard.css">
<link rel="stylesheet" type="text/css" href="styling/flexboxgrid.css">
<link rel="stylesheet" type="text/css" href="styling/forms.css">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.6.0/css/all.css" crossorigin="anonymous">
<link rel="stylesheet" href="https://use.typekit.net/sgr8dvc.css">
<link href="https://fonts.googleapis.com/css?family=Lato|Montserrat|Open+Sans|Oswald|Raleway|Roboto" rel="stylesheet">
<link href="https://fonts.googleapis.com/css?family=Varela+Round" rel="stylesheet">
</head>
<body style=" height: 100%; background-color: #f5f5f5; padding-bottom: 10px;">
<div class="dashboard-navbar-light">
<div class="dashboard-navbar-options-light nav-title" style="width: 100%;">
<center>
<span>
<a href="index.php" style="float: left; padding-left: 50px; color: black">Medical Legacy Directory</a>
</span>
<span style="float: right;">
<a href="userHome.php" style="color:#252525"><i class="fas fa-home"></i></a>
<a href="logout.php" style="color:#252525"><i class="fas fa-sign-out-alt" ></i></a>
</span>
</center>
</div>
</div>
<div class="col-lg-offset-1 col-lg-10 box" style="vertical-align: middle; padding: 20px">
<form action="addRecords.php" class="content-section" method="POST">
<h1 style="font-size: 50px; "><i class="fas fa-clipboard"></i> ADD RECORDS</h1>
<?php
if (isset($message)) {
echo "<p><small><i>".$message."<b>".$mln."</b> !</p></small></i>";
}
?>
<div class="row form-input-group">
<label style="float: left; vertical-align: middle;" class="col-lg-2">Symptoms</label>
<textarea name="symptoms" class="input-box col-lg-4"></textarea>
<label style="float: left; vertical-align: middle;" class="col-lg-2">Diagnosis</label>
<textarea name="diagnosis" class="input-box col-lg-4"></textarea>
</div>
<div class="row form-input-group">
<label style="float: left; vertical-align: middle;" class="col-lg-2">Date of Diagnosis</label><input name="date" type="date" class="input-box col-lg-4">
<label style="" class="col-lg-2">Specialist Consulted</label><input name="dr" type="text" class="input-box col-lg-4">
</div>
<div class="row form-input-group">
<label style="float: left; vertical-align: middle;" class="col-lg-2">Treatment Process</label>
<textarea name="trtmnt" class="input-box col-lg-4"></textarea>
<label style="float: left; vertical-align: middle;" class="col-lg-2">Medicines Prescribed</label>
<textarea name="medicines" class="input-box col-lg-4"></textarea>
</div>
<p><small><i><i class="fas fa-exclamation-circle"></i> Please make sure all inputs are filled correctly.</i></small></p>
<button type="submit" name="submit" class="form-button-one" style="background-color: #00cf7a; border-color:#00cf7a; color: white">Add Record</button>
</form>
</div>
</body>
</html>
<?php } ?>