crud_based_php_admin_role/add_role.php at master · dsaam94/crud_based_php_admin_role · 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
<html>
<head>
	<title>Add Course</title>
</head>

<body>
<?php
//including the database connection file
include_once("config.php");

if(isset($_POST['Submit_Role'])) {
	//$id = mysqli_real_escape_string($con, $_POST['id']);
	//$department_name = mysqli_real_escape_string($con, $_POST['department_name']);
	$role_name = mysqli_real_escape_string($con, $_POST['role_name']);
	// checking empty fields
	if(empty($role_name)) {
			echo "<font color='red'>Add Course Name</font><br/>";
		    echo "<br/><a href='index.php'>Go Back</a>";
	} else {
		// if all the fields are filled (not empty)

		//insert data to database
		$role_name =  mysqli_real_escape_string($con, $_POST['role_name']);
        $insert_role_table = mysqli_query($con, "INSERT INTO role(role_name) VALUES('$role_name')");

		//echo $result;
		//display success message
		echo "<font color='green'>Data added successfully.";
		echo "<br/><a href='index.php'>View Result</a>";
	}
}
?>

</body>
</html>