#1064(42000) MySQL Error in INSERT INTO query PHP MySQL

Question

I'm getting the same error some some people got here. But still my problem was not solved. In my University project for my all modules Im getting the same error.

When I'm running the following query in PHP

$username = $_SESSION['username'];
$query = "SELECT id FROM user WHERE username = '$username'";
$qpost = mysqli_query($connection,$query);
$post_user = mysqli_fetch_assoc($qpost);
$forum_size = strlen($forum);
$dt = time();
$datetime = strftime("%Y-%m-%d %H:%M:%S", $dt);
$enteruser = $post_user['id'];
$Query = "INSERT INTO posts('id','user_id','post','date_added') VALUES(NULL,'$enteruser','$forum','$datetime')";`

I'm getting the following error,

#1064 - 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 ''id','user_id','post','date_added') VALUES (NULL,'3','erye yeyeyeyetyery ery ery '' at line 1

And when I was run it in mysql shell I'm getting the same error. When I run that query in phpmyadmin as following,

INSERT INTO posts('id','user_id','post','date_added') VALUES (NULL,3,'erye yeyeyeyetyery ery ery ','2015-07-24 18:53:48');

I'm getting the same error. Can you please help me to solve this.I checked the query in every way I can adn error remains. I cant go forward withour solving this! Thank you for your help!

GrumpyCrouton · Accepted Answer · 2015-07-24 18:12:44Z

1

You don't need apostrophes on your table headers.

        $username = $_SESSION['username'];
        $query = "SELECT id FROM user WHERE username = '$username'";
        $qpost = mysqli_query($connection,$query);
        $post_user = mysqli_fetch_assoc($qpost);
        $forum_size = strlen($forum);
        $dt = time();
        $datetime = strftime("%Y-%m-%d %H:%M:%S", $dt);
        $enteruser = $post_user['id'];
        $Query = "INSERT INTO `posts` (id, user_id, post, date_added) VALUES (NULL,'$enteruser','$forum','$datetime')";

answered Jul 24, 2015 at 18:12

GrumpyCrouton

8,6367 gold badges37 silver badges81 bronze badges

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

2 Comments

thilanka1989 Over a year ago

The code worked perfectly when I removed apostrophes, . (I entered same mysql queries shown in phpmyadmin.) Thank you for the help

GrumpyCrouton Over a year ago

@thilanka1989 of course. Thank you for your question.

pinkal vansia · Accepted Answer · 2015-07-24 18:14:31Z

0

Given id is primary-key and auto-increment, you can exclude it. You can also use native Mysql function now() for date_added

$Query = "INSERT INTO `posts` (user_id, post, date_added) VALUES ('$enteruser','$forum',now())";

answered Jul 24, 2015 at 18:14

pinkal vansia

10.4k7 gold badges52 silver badges63 bronze badges

2 Comments

thilanka1989 Over a year ago

when I removed apostrophes of table headers problem is solved and I didnt know about now() its saves my time and some lines of coding. Thank you!

pinkal vansia Over a year ago

Glad I could help. Than you can accept this as an answer so it may be helpful for user In future.

Sachitha Dilshan · Accepted Answer · 2016-04-18 09:33:09Z

0

Try this...

$username = $_SESSION['username'];
$query = "SELECT id FROM user WHERE username = '$username'";
$qpost = mysqli_query($connection,$query);
$post_user = mysqli_fetch_assoc($qpost);
$forum_size = strlen($forum);
$dt = time();
$datetime = strftime("%Y-%m-%d %H:%M:%S", $dt);
$enteruser = $post_user['id'];
$Query = "INSERT INTO posts ('user_id','post','date_added') VALUES('$enteruser','$forum','$datetime')";`

answered Apr 18, 2016 at 9:33

Sachitha Dilshan

3432 silver badges7 bronze badges

Collectives™ on Stack Overflow

#1064(42000) MySQL Error in INSERT INTO query PHP MySQL

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related