PHP and SQLi connection problems: mysqli_query() expects at least 2 parameters
Hi Guys as some of you are aware, I'm creating my own website and I want users to register
// Check connection
echo "Failed to connect to MySQL: " . mysqli_connect_error();
and this is now the error I'm getting can anyone help me out with it?
//select your database
//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
die("The following SQL Failed $query");
echo 'Registred successfully..!!</div>';
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', 'email@example.com' , 'firstname.lastname@example.org')
No password in connect string. Also try include "Config.php" Ensure the path for config.php is correct.
there is no password to the database as the last time i did this i buggerd up xampp and phpmyadmin
This would probably be the password you use to log in to PHP MyAdmin
there should be but I haven't got one to be honest. I dont want to put on in there as last time it took me nearly 2 weeks to get xampp working again and i accidentally lost all of the work that i did for my website
So when you log on to PHP MyAdmin, what password do you use? How do you log in since it required username and password?
If you are using a hosting service, it might be your username and password to get to your cpanel
Users Browsing this Thread
There are currently 2 users browsing this thread. (0 members and 2 guests)