Database-Management-System/add.php at master · afzafri/Database-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
<?php
	require_once('auth.php');
?>
<html>
<head>
<link rel="shortcut icon" href="./images/dblogo.ico" />
<link href='http://fonts.googleapis.com/css?family=Montserrat:400,700' rel='stylesheet' type='text/css'>
<link rel="stylesheet" type="text/css" href="./css/design.css">
<title>Add Data</title>
</head>
<body>
<div class="logo"></div>
<div class="design-block">
<center>
<h1>Add Data</h1>
<form action="add.php" method="post" enctype="multipart/form-data" >
<input type="text" value="" placeholder="ID" name="id">
<input type="text" value="" placeholder="Name" name="name">
<input type="text" value="" placeholder="Date of Birth (YYYY-MM-DD)" name="dob">
<input type="text" value="" placeholder="Phone Number" name="phone">
<input type="text" value="" placeholder="IC" name="ic">
<input type="text" value="" placeholder="Course" name="course">
Choose an image to upload : <input type="file" name="fileToUpload" id="fileToUpload">
 <button>Submit</button>
</form>


<?php

include 'config.php';

//declare variable. use 'isset' to determine if variable is set and not null. if null, not execute
if(isset($_POST["id"]) && isset($_POST["name"]) && isset($_POST["dob"]) && isset($_POST["phone"]) && isset($_POST["ic"]) && isset($_POST["course"]))
{
	$id = (isset($_POST["id"]) ? $_POST["id"] : null);
	$name = (isset($_POST["name"]) ? $_POST["name"] : null);
	$dob = (isset($_POST["dob"]) ? $_POST["dob"] : null);
	$phone = (isset($_POST["phone"]) ? $_POST["phone"] : null);
	$ic = (isset($_POST["ic"]) ? $_POST["ic"] : null);
	$course = (isset($_POST["course"]) ? $_POST["course"] : null);


	try
	{
		//connect to database
		$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
		$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

		//insert data into db
		$stmt = $conn->prepare("INSERT INTO STUDENTS VALUES(? , ? , ?, ? , ? , ? );");

		//execute sql query
		$stmt->execute(array($id,$name,$dob,$phone,$ic,$course));


		echo "<script>alert('Success! Data Inserted.')</script>";


	}
	catch(PDOException $e)
	{
		echo "Connection failed: " . $e->getMessage();
	}

	//close conection
	$conn = null;

	//use image upload script
	include 'imgup.php';

}


?>

<br><br>

<div class="back-but">
<a href="home.php"><button type="button">Back</button></a><br>
</div>
</center>
</div>
</body>
</html>