INSERT Query in PHP Parse Error

Question

I have a simple PHP code to insert data into MySQL database but it's giving me a parse error.

Error:

Parse error: parse error in /Users/Navs13/Desktop/RS/code.php on line 17 what might be the problem. find the code below.

<?php
$servername = "localhost";
$username = "admin";
$password = "pwd";
$dbname = "testdb";

// Create connection
$conn = mysql_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysql_error());
} 

$x=10;
//VALUES ('$_POST[x]')";
//echo $_POST[x];

$sql = "INSERT INTO test (disliked)"
    ."VALUES ($x)";
if (mysql_query($sql, $conn) === TRUE) {
    echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . mysql_error();
}

mysql_close($conn);
?>

score 2 · Answer 1 · answered Apr 10 '16 at 06:34

2

Try this:

$sql = "INSERT INTO test (disliked) VALUES ('".$x."')" or die(mysql_error());

answered Apr 10 '16 at 06:34

Object Manipulator

8,644
2
10
31

score 1 · Answer 2 · edited May 23 '17 at 12:07

In your case, you can try this

$query = "INSERT INTO test (disliked) values('$x');";
    if (!mysql_query($query, $conn)) {
        die('Error: ' . mysql_error());
    }

My project works well with the following codes :

$q1 = "INSERT INTO users (username,email,password,state) values('$username','$email','$password',1);";
if (!mysql_query($q1, $conn)) {
    die('Error: ' . mysql_error());
}

PS: mysql_connect and mysql_query are deprecated. It is better to use mysqli_connect and mysqli_query.

Panda · Accepted Answer · 2016-04-10T06:53:42.103

You'll need single-quotes around PHP variables and back ticks for SQL-related names:

$sql = "INSERT INTO `test` (`disliked`) VALUES ('$x')";

Note: mysql_* functions are already deprecated, use mysqli_* instead:

$conn = mysqli_connect($servername, $username, $password, $dbname);

if (!$conn) {
    die("Connection failed: " . mysqli_error($conn));
} 

$x=10;

$sql = "INSERT INTO `test` (`disliked`) VALUES ('$x')";

if (mysqli_query($conn, $sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);

INSERT Query in PHP Parse Error

3 Answers3