mysqli_query() expects at least 2 parameters

[pathfinder]

When I run this command mysqli_query it is given results in the error below

mysqli_query("INSERT INTO `username`.`email` (`userinfo`) VALUES ('".$email."')");

"Warning: mysqli_query() expects at least 2 parameters, 1 given in"

Why am I getting this error above? what does it mean and how to fix it?

 

[energizedit]

You may need to declare the table again with your variables like

mysqli_query("INSERT INTO `username`.`email` (`username`.`userinfo`) VALUES ('".$email."')");

I would say the problem has something to do with your table selection `username`.`email` that just doesn't look right.

 

[Rob Whisonant]

You are not telling it what mysql connection to use.

$con=mysqli_connect("localhost","my_user","my_password","my_db");
mysqli_query($con, "INSERT INTO Persons (FirstName,LastName,Age) VALUES ('Glenn','Quagmire',33)");

 

[Steve32]

Steve32

Does this affect to the query of The OP asking?

If we use a normal MySQL connection like

<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

or open a Connection with MySQLi

<?php
$servername = "localhost";
$username = "username";
$password = "password";

// Create connection
$conn = mysqli_connect($servername, $username, $password);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
?>

then this command

mysqli_query("INSERT INTO `username`.`email` (`userinfo`) VALUES ('".$email."')");

could have errors or didn't work?

 

[Rob Whisonant]

Rob Whisonant

Since it is not being connected to any mysql connection it will never work. You have to tell it what database to query.

Also it is looking for a table named usernameemail as it is written. It is then looking for a field named userinfo to insert the value of $email.

Also, never try to mix mysql and mysqli syntax. They are not compatible.