Management-System/updateDoctor.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
<!-- Made By Ankita -->

<?php
	$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"];
	$column = $_POST["column"];
	$data = $_POST["data"];

	if($_POST["update"]) {
		$sql = "UPDATE employee SET $column = '$data' WHERE eID='$eid'";

		if(mysqli_query($con, $sql)) {
			echo "Update Successfully";
		}
		else {
			echo "Insert Data";
		}
	}
	else {
	}
?>

<html>

	<head>
		<title>Update Doctor Details</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>Update Doctor/Consultant</h1></header>
			<section>
				<div id="container_demo" >
					<div id="wrapper">
						<div id="login" class="animate form">

							<form action="updateDoctor.php" method="POST">
								<h1>Update Doctor/Consultant Details</h1>
								<p>
                                    <label data-icon="u">Employee ID :</label>
                                    <input name="eid" required="required" type="text" placeholder="Insert employee ID" />
                                </p>
								<p>
                                    <label data-icon="u">What detail to be updated :</label>
                                    <input name="column" required="required" type="text" placeholder="Insert colunm name to update" />
                                </p>
								<p>
                                    <label data-icon="u">New Data :</label>
                                    <input name="data" required="required" type="text" placeholder="Insert new data" />
                                </p>
								<p class="signin button">
									<input type="submit"  name="update" value="Update"/>
								</p>
							</form>
						</div>
					</div>
				</div>
			</section>
		</div>
	</body>

</html>