PHP mysql connection error : You have an error in your SQL syntax

Question

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1

I got this above error while running super easy code that any idiot can build it, so I don't know what and where or is my machine needs to be turned on and off or my luck is not working. Please help me or I'll start crying.

<?php
$con=mysqli_connect("localhost","root","some password","test");
// Check connection
if (mysqli_connect_errno())
{
   echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$sql=mysqli_query($con,"INSERT INTO users(first_name, last_name, username,password,email)
                        VALUES('$_POST[fname]', '$_POST[lname]', '$_POST[username]', '$_POST[password]','$_POST[email]')");
if (!mysqli_query($con,$sql))
{
   die('Error: ' . mysqli_error($con));
}
header("Location:reg.php?remarks=success");
echo " record added";
mysqli_close($con);
?>

Isnt it once? I learned from here http://www.w3schools.com/php/php_mysql_insert.asp — simpleProgrammer, Mar 31 '14 at 06:27
Just put `$sql="INSERT INTO users(first_name, last_name, username,password,email) VALUES('$_POST[fname]', '$_POST[lname]', '$_POST[username]', '$_POST[password]','$_POST[email]')";` — Shankar Narayana Damodaran, Mar 31 '14 at 06:30
http://en.wikipedia.org/wiki/SQL --- http://stackoverflow.com/q/60174/ (*as will these*) "life". — Funk Forty Niner, Mar 31 '14 at 06:31
@ProgrammingQueen Dont use this horrible horrible horrible page ... please. Do yourself that favor. — Realitätsverlust, Mar 31 '14 at 06:35
One more quick question, if anyone can help it would be great, I am getting query failed error for this query, I think this look good, Is there anything else wrong? $qry="SELECT * FROM member WHERE username='$username' AND password='$password'"; $result=mysqli_query($qry); — simpleProgrammer, Mar 31 '14 at 08:13

score 1 · Answer 1 · edited Mar 31 '14 at 06:34

1

Try wthout the database in con and select db separately.

$con=mysqli_connect("localhost","root","some password");
mysqli_select_db("dbname here",$con);

edited Mar 31 '14 at 06:34

Sahil Mittal

20,697
12
65
90

answered Mar 31 '14 at 06:33

TAS

331
3
10

score -1 · Answer 2 · answered Mar 31 '14 at 06:27

-1

This $_POST value are wrong. Try with:

$sql=mysqli_query($con,"INSERT INTO users(first_name, last_name, username,password,email)VALUES('{$_POST['fname']}', '{$_POST['lname']}'...

answered Mar 31 '14 at 06:27

Christian

484
3
15

$_POST is array, to call him need quotes '', this cleary is one of errors that they have in his code – Christian Mar 31 '14 at 06:50

PHP mysql connection error : You have an error in your SQL syntax

2 Answers2