Make the connect php login php and register php work with these table instead

Connect.php (connect it with the database table)

define('DB_SERVER', 'localhost:3306');

define('DB_USERNAME', 'root');

define('DB_PASSWORD', '');

define('DB_DATABASE', 'db_registration');

$con = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);

?>

That is the login php file. When I use connect to connect the login and registration php file to my php admin data base

login php:

session_start();

include ("connect.php");

if($_SESSION['counter']==null)

{

$_SESSION['counter']=1;

}

$msg = "";

if(isset($_POST["check"]))

{

if($_POST["username1"]=='')

{

$msg = "Enter User Name...";

//return false;

}

else if($_POST["ddlsecurity"]=="0")

{

$msg = "Select Security Question...";

//return false;

}

else if(empty($_POST["answer"]))

{

$msg = "Enter Answer...";

//return false;

}

else{

$username1 = $_POST["username1"];

$ddlsecurity = $_POST["ddlsecurity"];

$answer = $_POST["answer"];

$username1 = mysqli_real_escape_string($con, $username1);

$ddlsecurity = mysqli_real_escape_string($con, $ddlsecurity);

$answer = mysqli_real_escape_string($con, $answer);

$sql="SELECT Password FROM `tbl_user_registration` WHERE User_Name='$username1' and Security_Question_Id='$ddlsecurity' and Security_Answer='$answer'";

$result=mysqli_query($con,$sql);

$row=mysqli_fetch_array($result,MYSQLI_ASSOC);

if(mysqli_num_rows($result) == 1)

{

//$_SESSION['User_Id'] = $row['Password'];

$msg = "Your Password is:".$row['Password']; /* Redirect browser */

//exit();

}

else

{

$msg = "Sorry..! Invalid Answer";

}

}

}

if(isset($_POST["submit"]))

{

if($_POST["username"]=='')

{

$msg = "Enter User Name...";

//return false;

}

else if($_POST["password"]=='')

{

$msg = "Enter Password...";

//return false;

}

else

{

$username = $_POST["username"];

$password = $_POST["password"];

$username = mysqli_real_escape_string($con, $username);

$password = mysqli_real_escape_string($con, $password);

//$password = md5($password);

$sql="SELECT User_Id FROM `tbl_user_registration` WHERE User_Name='$username' and Password='$password'";

$result=mysqli_query($con,$sql);

$row=mysqli_fetch_array($result,MYSQLI_ASSOC);

if(mysqli_num_rows($result) == 1)

{

$_SESSION['User_Id'] = $row['User_Id'];

$msg = "Successfully Log in"; /* Redirect browser */

//exit();

}

else

{

$msg = "Sorry..! Invalid UserName and Password".$_SESSION['counter'];

$_SESSION['counter']=$_SESSION['counter']+1;

if($_SESSION['counter']==3)

{

?>

$_SESSION['counter']=1;

}

}

}

}

?>

.txtcontrol{

height: 40px;

font-size: 22px;

border: single;

border-color:black;

width: 100%;

margin-bottom:10px;

text-align:center;

}

.mcontainer {

max-width: 600px;

margin: 0 auto;

padding: 80px 0;

height: 400px;

text-align: center;

}

.mcontainer {

width: 100%;

padding-right: 10px;

padding-left: 10px;

margin-right: auto;

margin-left: auto;

}

.sbutton

{

width: 42%;

height: 42px;

background-color: #75d4b6;

border: none;

color: #f9f5ee;

font-size: 17px;

}

Welcome

if($msg!='')

{

echo "

Message

$msg

";

}

?>

New User? Register Here

Select Security Question

$sql="SELECT * FROM `tbl_Security_Question`";

$qury=mysqli_query($con,$sql);

if(!$qury){

echo "No Records Found";

}

else

{

while($row=mysqli_fetch_array($qury))

{

echo "".$row["Security_Question"]."";

}

}

?>

this is the registration php that needs to have the same username, password, and security question as these tables below. When I did it i did not use the tables from the data base.

include ("connect.php");

$msg = "";

if(isset($_POST["submit"]))

{

if($_POST["User_Name"]=='')

{

$msg = "Enter User Name...";

//return false;

}

else if($_POST["password"]=='')

{

$msg = "Enter Password...";

//return false;

}

else if($_POST["ddlsecurity"]=="0")

{

$msg = "Select Security Question...";

//return false;

}

else if($_POST["answer"]=='')

{

$msg = "Enter Answer...";

//return false;

}

else

{

$User_Name = $_POST["User_Name"];

$password = $_POST["password"];

$ddlsecurity = $_POST["ddlsecurity"];

$answer = $_POST["answer"];

$User_Name = mysqli_real_escape_string($con, $User_Name);

$ddlsecurity = mysqli_real_escape_string($con, $ddlsecurity);

$answer = mysqli_real_escape_string($con, $answer);

$password = mysqli_real_escape_string($con, $password);

//$password = md5($password);

$sql="SELECT * FROM `tbl_user_registration` WHERE User_Name='".$User_Name."'";

$result=mysqli_query($con,$sql);

if(!$result)

{

$msg = "Sorry...This email already exist...";

}

else

{

$query = mysqli_query($con, "INSERT INTO `tbl_user_registration`(`User_Name`, `Password`, `Security_Question_Id`, `Security_Answer`) VALUES ('".$User_Name."','".$password."','".$ddlsecurity."','".$answer."')");

if($query)

{

$msg = "Thank You! you are now registered.";

header("Location: login.php"); /* Redirect browser */

exit();

}

}

}

}

?>

.txtcontrol{

height: 40px;

font-size: 22px;

border: single;

border-color:black;

width: 100%;

margin-bottom:10px;

text-align:center;

}

.mcontainer {

max-width: 600px;

margin: 0 auto;

padding: 80px 0;

height: 400px;

text-align: center;

}

.mcontainer {

width: 100%;

padding-right: 10px;

padding-left: 10px;

margin-right: auto;

margin-left: auto;

}

.sbutton

{

width: 42%;

height: 42px;

background-color: #75d4b6;

border: none;

color: #f9f5ee;

font-size: 17px;

}

Welcome

if($msg!='')

{

echo "

Message

$msg

";

}

?>

Select Security Question

$sql="SELECT * FROM `tbl_Security_Question`";

$qury=mysqli_query($con,$sql);

if(!$qury){

echo "No Records Found";

}

else

{

while($row=mysqli_fetch_array($qury))

{

echo "".$row["Security_Question"]."";

}

}

?>

Already a User? Login Here

Now I need the login/registration, connect. php file to work with the tables from the database below.