Trying To Input Data Into Sql Table Using Php / Html From Registration Form

I've tried so many different things and did many searches with no solution. I am trying to use an html form to submit data to a sql table. Here is the code for my register.php fil

Solution 1:

mysqli_real_escape_string() need two parameter first one is your connection and other is your escapestring

mysqli_real_escape_string(connection,escapestring);

So add $con as first parameter into it

 mysqli_real_escape_string($con,$_POST['laz']);

Also wrap off quotes from table name. Use backtick like

INSERTINTO `database_name` . `table` 

To check error in your page use

ini_set('display_errors',1);
ini_set('display_startup_errors',1);
error_reporting(-1);

And Prevent you query by sql injection

Solution 2:

$con = mysqli_connect("localhost", "database_name", "password""database_user"); //open connection

if (mysqli_connect_errno()) { //if connection failed
    die("Connect failed: ", mysqli_connect_error());
    exit();
}

$lasty      = mysqli_real_escape_string($con, $_POST['laz']); //added $con needs two parameter (connection, input)
$namez      = mysqli_real_escape_string($con, $_POST['namer']);
$emailAddr  = mysqli_real_escape_string($con, $_POST['emaila']);
$UserName   = mysqli_real_escape_string($con, $_POST['usrn']);
$password   = mysqli_real_escape_string($con, $_POST['passw']);



$sqql = "INSERT INTO `table_name`(UserID, FirstName, LastName,   Email, UserName, Password) 
VALUES (NULL, '$namez', '$lasty', '$emailAddr', '$userName', '$passwo')";


if (mysqli_query($con, $sqql)) {
    echo "Row inserted";
}else{
    die("Error: ". mysqli_sqlstate($con));
}

mysqli_close($con);