Hello can you help me to connect my registration PHP which I don't know how to insert those registration data on my database and table which is the admin table and the regular table. Can you help me for the right code for the table admin and regular to connect to my database I would appreciate if you would put the right code and SQL query for the connection.
Hello can you help me to connect my registration PHP which I don't know how to insert those registration data on my
Here is my PHP code
<?php
session_start();
include 'database_connection.php';
if($_POST['uname'] && $_POST['password'])
{
$name=$_POST['name'];
$lname = $_POST['lname'];
$fname = $_POST['fname'];
$mname = $_POST['mname'];
$gen = $_POST['gender'];
$birth = $_POST['birth'];
$type = $_POST['utype'];
$email = $_POST['email'];
$pass=$_POST['password'];
if($type=='Admin')
admin($name,$lname,$fname,$mname,$gen,$birth,$email,$pass,$con);
else
regular($name,$lname,$fname,$mname,$gen,$birth,$email,$pass,$con);
}
function admin($name,$lname,$fname,$mname,$gen,$birth,$email,$pass,$con)
{
$query="INSERT INTO admin VALUES('$id','$name','$lname','$fname','$mname','$gen','$birth','$email','$pass')";
$result=mysqli_query($con,$query);
if(!$result)
{
die("<br>Can't Insert Data : " .mysqli_error());
}
echo "<script>alert('Admin Record Inserted..!!');window.location='index.php'</script>";
}
function regular($name,$lname,$fname,$mname,$gen,$birth,$email,$pass,$con)
{
$query="INSERT INTO parent VALUES('$name','$lname','$fname','$mname''$gen','$city','$birth','$email','$pass')";
$result=mysqli_query($con,$query);
if(!$result)
{
die("<br>Can't Insert Data : " .mysqli_error());
}
echo "<script>alert('Parent Record Inserted..!!');window.location='index.php'</script>";
}
?>
why thecode does not show
Step by step
Solved in 2 steps with 2 images