insert_user.php

<?php
include("includes/connection.php");

	if (isset($_POST['sign_up'])) {
		$first_name = htmlentities(mysqli_real_escape_string($con,$_POST['first_name']));
		$last_name = htmlentities(mysqli_real_escape_string($con,$_POST['last_name']));
		$pass = htmlentities(mysqli_real_escape_string($con,$_POST['u_pass']));
		$email = htmlentities(mysqli_real_escape_string($con,$_POST['u_email']));
		$dis = htmlentities(mysqli_real_escape_string($con,$_POST['u_district']));
		$gender = htmlentities(mysqli_real_escape_string($con,$_POST['u_gender']));
		$birthday = htmlentities(mysqli_real_escape_string($con,$_POST['u_birthday']));	
		$status = "verified";
		$posts = "no";
		$newgid = sprintf('%05d', rand(0, 999999));
		$username = strtolower($first_name . "_" . $last_name . "_" . $newgid);
		$check_username_query = "select user_name from users where user_email='$email'";
		$run_username = mysqli_query($con,$check_username_query);

		if(strlen($pass) <9 ){
			echo "<script>alert('Password should be minimum 9 characters!')</script>";
			exit();
		}
		$check_email = "select * from users where user_email='$email'";
		$run_email = mysqli_query($check_email);
		$check = mysqli_num_rows($run_email);

		if ($check == 1) {
			echo "<script>alert('Email already exist, Please try using another email')</script>";
			echo "<script>window.open('signup.php', '_self')</script>";
			exit();
		}
		
				$profile_pic = "images.png";

			

			$insert = "insert into users (f_name,l_name,user_name,describe_user,user_pass,user_email,user_dis,user_gender,user_birthday,user_image,user_cover,user_reg_date,status,posts,recovery_account) 
				values('$first_name','$last_name','$username','USER','$pass','$email','$dis','$gender','$birthday','$profile_pic','download.jpg',NOW(),'status','$posts','DCMA.')";
			$query = mysqli_query($con, $insert);

			if ($query) {
				
				echo "<script>window.open('signin.php', '_self')</script>";
			}
			else{
				echo "<script>alert('Registration failed,please try again!')</script>";
				echo "<script>window.open('signup.php', '_self')</script>";
			}



	}
?>