Untitled

<?php
$host = "localhost";
$user = "root";
$password = "";
$database="database";

$user_id=$_POST['user_id'];
$user_name=$_POST['user_name'];
$user_email=$_POST['user_email'];
$user_password=$_POST['user_password'];
$department=$_POST['department'];
$user_type=$_POST['user_type'];


$conn = mysqli_connect($host, $user, $password, $database);
if (!$conn) {die("Connection failed: " . mysqli_connect_error());
}

 $sql = "INSERT INTO user_information
(user_id,user_name,user_email,user_password,
department, user_type)VALUES  ('$user_id','$user_name','$user_email',
'$user_password','$department','$user_email')");


if (mysqli_query($conn, $sql)) {echo "New User Added successfully";
} else { echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

?>

<html>
<head></head>
<body bgcolor="purple"  text="lightpink"    link = "gold"  vlink= "lime"alink= "lightgreen"  align ="center">
<p align ="left"><img src = "../OES/images/keep calm.gif"  width ="120"  hight ="100"  border ="0"/><p/>
<form method="post" action="registration.php">
<b><font size="6">Registration form</font></b></br></br>
User ID:<input type="text" name="id" ></br></br>
User Name:<input type="text" name="name" ></br></br>
User E-mail:<input type="text" name="email" ></br></br>
User Password:<input type="text" name="password" ></br></br>

<b><font size="4">Department:</font></b>&nbsp;&nbsp;
<select name="department">
<option>Information Technology</option>
<option>Engineering</option>
<option>Pharmacy</option>
<option>Photography</option>
<option>Business Studies</option>
<option>Fashion Design</option>
<option>Applied Science</option>
</select></br></br>
<b><font size="4">Select Your User Type:</font></b>&nbsp;&nbsp;
<input type="radio" name="teacher">Teacher
<input type="radio" name="student">Student</br></br>


<input type="submit" name="ok" value="Register">
<input type="reset" name="clear" value="Reset">


</table>
</form>
</body>
</html>