Hi Guys as some of you are aware, I'm creating my own website and I want users to register
Config.php
<?php
$con=mysqli_connect("localhost","root","","registration");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
mysqli_close($con);
?>
submit_form.php
<?php
//select your database
//$b=mysql_select_db("database_name",$a);
$firstname=$_POST['firstname'];
$lastname=$_POST['lastname'];
$username=$_POST['username'];
//$confirmusername=$_POST['confirmusername'];
$password=$_POST['password'];
$confirmpassword=$_POST['confirmpassword'];
$email=$_POST['email'];
$confirmemail=$_POST['confirmemail'];
//Database connection
require_once("config.php");
//mysql query to insert value to database
$query="INSERT INTO registration (`firstname`, `lastname`, `username`, `confirmusername`, `password`, `confirmpassword`, `email` ,`confirmemail`) VALUES ('$firstname', '$lastname', '$username', '$password', '$confirmpassword', '$email' , '$confirmemail')";
$result = mysqli_query($query);
//if value inserted successyully disply success message
if(!$result) {
die("The following SQL Failed $query");
}
echo 'Registred successfully..!!</div>';
?>
and this is now the error I'm getting can anyone help me out with it?
Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\submit-form.php on line 17
The following SQL Failed INSERT INTO registration (firstname, lastname, username, confirmusername, password, confirmpassword, email ,confirmemail) VALUES ('richard', 'Hemmings', 'hemmo001', 'password', 'password', 'richardgwhemmings@msn.com' , 'richardgwhemmings@msn.com')
