Mysql insertion failing in script

Question

I have been breaking my head against this and still I am unable to understand that why wouldn't this work

include ("db_conn.php");

//function for sanitizing the user input
function clean_input($data)
{
$data = stripslashes($data);
$data = trim($data);
$data = htmlspecialchars($data);
return $data;
}
//registration form data validation
if(!empty($_POST['s_register_submit']))
{
$Salutation= $F_Name= $L_Name= $email= $pass= $P_Number = "";

$Salutation= clean_input($_POST['Salutation']);
$F_Name= clean_input($_POST['F_Name']);
$L_Name= clean_input($_POST['L_Name']);
$email= clean_input($_POST['email']);
$pass= clean_input($_POST['pass']);
$P_Number= clean_input($_POST['P_Number']);
$query= "INSERT INTO STUDENT (Salutation, F_Name, L_Name, email, password, phone) 
         VALUES
         (`$Salutation`,`$F_Name`,`$L_Name`,`$email`,`$pass`,`$P_Number`)";

$query1= mysqli_query($dbhandle,$query) || die("Unable to insert"); 
echo "Saved";

And here are the contents for db_conn.php

$user="root";
$password="";
$host="localhost";
$dbname="Interns";

$dbhandle=mysqli_connect($host, $user, $password, $dbname);
if(!$dbhandle)
{
die("Unable to connect");
}
echo "Connected";

When running db_conn.php directly or through the script in which it is included, its echoing "Connected", still the query returns "Unable to Insert".

Try $query1= mysqli_query($dbhandle,$query) || die(mysqli_error($dbhandle)); to get the error message from mysql. EDIT: Thank you VolkerK. Adjusted the code acordingly. — Markus Müller
– Markus Müller, Commented Feb 2, 2015 at 14:32
@Markus Müller: mysqli_error($dbhandle). Unlike mysql_error() with the mysqli the handle is not optional. — VolkerK
– VolkerK, Commented Feb 2, 2015 at 14:33
Appears like @JohnConde spotted the bug. I had this impression that back ticks are used to avoid ambiguity between keywords and variables. — Chaitanya
– Chaitanya, Commented Feb 2, 2015 at 14:37

John Conde · Accepted Answer · 2015-02-02 14:31:36Z

3

You wrap strings in quotes, not ticks. Ticks are reserved for identifiers.

$query= "INSERT INTO STUDENT (Salutation, F_Name, L_Name, email, password, phone) 
     VALUES
     (`$Salutation`,`$F_Name`,`$L_Name`,`$email`,`$pass`,`$P_Number`)";

should be

$query= "INSERT INTO STUDENT (Salutation, F_Name, L_Name, email, password, phone) 
     VALUES
     ('$Salutation','$F_Name','$L_Name','$email','$pass','$P_Number')";

answered Feb 2, 2015 at 14:31

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mysql insertion failing in script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related