Keep getting this same error message
Warning: mysqli_error() expects exactly 1 parameter, 0 given in C:\xampp\htdocs\demetriusdesign777.com\includes\functions.php on line 29 Query FAILED
<?php
if(isset($_POST['submit'])) {
$db['db_host'] = "localhost";
$db['db_user'] = "root";
$db['db_pass'] = "";
$db['db_name'] = "dd777";
foreach($db as $key => $value) {
define(strtoupper($key), $value);
}
$connection = mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
$username = $_POST['username'];
$email = $_POST['e-mail'];
$phone = $_POST['phone'];
$info = $_POST['info'];
$budget = $_POST['budget'];
$website = $_POST['website'];
$query = "INSERT INTO userinfo(name, email, phone, website, info, budget) ";
$query .= "VALUES ('$username', '$email' '$phone', '$info', '$budget', '$website')";
$result = mysqli_query($connection, $query);
if(!$result) {
die('Query FAILED' . mysqli_error());
} else {
echo "Record Create";
}
}
?>
The mysqli_error()
call requires a parameter. The parameter should be the connection handle.
if(!$result) {
die('Query FAILED' . mysqli_error($connection));
This would have told you about the actual error in your query which is the missing comma between '$email' '$phone',
in your parameter list section.
$query = "INSERT INTO userinfo
(name, email, phone, website, info, budget)
VALUES
('$username', '$email', '$phone', '$info', '$budget', '$website')";
'$email'
and '$phone'
mysqli_error($connection)
. Require parameter.Use This edited code.
<?php
if(isset($_POST['submit']))
{
$DB_HOST = "localhost";
$DB_USER = "root";
$DB_PASS = "";
$DB_NAME = "dd777";
$connection = mysqli_connect($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME);
$username = $_POST['username'];
$email = $_POST['e-mail'];
$phone = $_POST['phone'];
$info = $_POST['info'];
$budget = $_POST['budget'];
$website = $_POST['website'];
$query = "INSERT INTO userinfo(name, email, phone, website, info, budget) ";
$query .= "VALUES ('$username', '$email','$phone', '$info', '$budget', '$website')";
$result = mysqli_query($connection, $query);
if(!$result) {
die('Query FAILED' . mysqli_error($connection));
} else {
echo "Record Create";
}
}
}