Management-System/insertDoctor.php at master · kratusharma/Management-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
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
106
<!-- Made By Bharat -->

<?php
	/*Create a connection with the data base*/
	$con = mysqli_connect("localhost","root","") or die ("Error Occures");
	mysqli_select_db($con, "hospital_management_system") or die ("Error Occures");

	error_reporting(0);

	$eid = $_POST["eid"];
	$ename = $_POST["ename"];
	$tnum = $_POST["tnum"];
	$gndr = $_POST["gender"];
	$dob = $_POST["dob"];
	$slr = $_POST["slr"];
	$isDoc = $_POST["isDoc"];
	$isCon = $_POST["isCon"];

	// Inserting the fetched data into the sql query
	if($_POST["submit"]) {
		$sql_1 = "INSERT INTO employee VALUES ('$eid','$ename','$tnum','$gndr','$dob','$slr','$eid')";
		$sql_2 = "INSERT INTO con_doc VALUES ('$eid','$isDoc','$isCon')";
		$sql_3 = "INSERT INTO elog VALUES('$eid','$eid')";

		if(mysqli_query($con, $sql_1)) {
			if(mysqli_query($con, $sql_2)) {
				if(mysqli_query($con, $sql_3)) {
						echo "Data Inserted Successfully!";
				}
			}
			else {
				echo "Something wrong with your flag insertion";
			}
		}
		else {
			echo "Oops ! Something went wrong.Try again";
		}
	}
	else {
		echo "Insert Data";
	}
?>

<html>

	<head>
		<title>Insert New Doctor/Consultant</title>
		<link rel="stylesheet" type="text/css" href="css/demo.css" />
        <link rel="stylesheet" type="text/css" href="css/style.css" />
		<link rel="stylesheet" type="text/css" href="css/animate-custom.css" />
	</head>

	<body>
		<div class="container">
			<header><h1>Insert Doctor/Consultant</h1></header>
			<section>
				<div id="container_demo" >
					<div id="wrapper">
						<div id="login" class="animate form">

							<form action="insertDoctor.php" method="POST">
								<h1>Insert Doctor/Consultant Details</h1>

								<p>
                                    <label data-icon="u">Employee ID :</label>
                                    <input id="eid" name="eid" required="required" type="text" placeholder="Insert employee ID" />
                                </p>
								<p>
                                    <label data-icon="u">Employee Name :</label>
                                    <input name="ename" required="required" type="text" placeholder="Insert employee name" />
                                </p>
								<p>
                                    <label data-icon="u">Phone Number :</label>
                                    <input name="tnum" required="required" type="number" placeholder="Insert employee phone number" />
                                </p>
								<p>
                                    <label data-icon="u">Gender :</label>
                                    <input name="gender" required="required" type="text" placeholder="Insert gender < M or F >" />
                                </p>
								<p>
                                    <label data-icon="u">Date of Birth :</label>
                                    <input name="dob" required="required" type="date" placeholder="Insert employee birth date" />
                                </p>
								<p>
                                    <label data-icon="u">is Doctor :</label>
                                    <input name="isDoc" required="required" type="text" placeholder="Is a Doctor < Y or N >" />
                                </p>
								<p>
                                    <label data-icon="u">is Consultant :</label>
                                    <input name="isCon" required="required" type="text" placeholder="Is a Consultant < Y or N>" />
                                </p>
								<p>
                                    <label data-icon="u">Salary :</label>
                                    <input name="slr" required="required" type="number" placeholder="Insert salary" />
                                </p>
								<p class="signin button">
									<input type="submit"  name="submit" value="Submit"/>
								</p>
							</form>
						</div>
					</div>
				</div>
			</section>
		</div>
	</body>
</html>