Parse error: syntax error, unexpected T_VARIABLE in bindValue

Question

if (isset($_SESSION['logged_in'])) {
if (isset($_POST['title'], $_POST['content'])) {
    $title = $_POST['title'];
    $content = $_POST['content'];

    if (empty($title) or empty($content)) {
        $error = 'All fields are required!';
    } else {
        $query = $pdo->prepare("INSERT INTO articles (atricle_title, atricle_text, atricle_timestamp) VALUES (?, ?, ?)")

        $query->bindValue(1, $title); //error is here
        $query->bindValue(2, $content);
        $query->bindValue(3, time());

        $query->execute();

        header(Location: index.php);
}

Someone knows what's the problem here?. The code itself is more then that, but this is to only relevent part.

Thanks.

Jan · Accepted Answer · 2013-09-15 17:52:57Z

1

$query = $pdo->prepare("INSERT INTO articles (atricle_title, atricle_text, atricle_timestamp) VALUES (?, ?, ?)")

in this line, the ; is missing

This line is wrong too:

header(Location: index.php);

It has to look like this:

header("location: index.php");

answered Sep 15, 2013 at 17:52

Jan

262 bronze badges

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

Comments

user2681150 · Accepted Answer · 2013-09-15 18:04:04Z

1

Missed ; at the end of below line,that's why it's showing error on next line when you are trying to bind value. $query = $pdo->prepare("INSERT INTO articles (atricle_title, atricle_text, atricle_timestamp) VALUES (?, ?, ?)");

and also header(Location: index.php); needs to make parameter as string into header function.

Please try it and me know if any issue.

answered Sep 15, 2013 at 18:04

user2681150

Comments

Chibuzo · Accepted Answer · 2013-09-15 17:52:00Z

0

The error occurs because PHP assumes that the line containing the query hasn't ended, and the next character then violates the syntax rule. Add semi colon ; to the query line.

$query = $pdo->prepare("INSERT INTO articles (atricle_title, atricle_text, atricle_timestamp) VALUES (?, ?, ?)");

answered Sep 15, 2013 at 17:52

Chibuzo

6,1133 gold badges33 silver badges54 bronze badges

Comments

Shankar Narayana Damodaran · Accepted Answer · 2013-09-15 17:53:01Z

0

You missed a ; in the PDO statement and quotes on the header().

<?php

if (isset($_SESSION['logged_in'])) {
if (isset($_POST['title'], $_POST['content'])) {
    $title = $_POST['title'];
    $content = $_POST['content'];

    if (empty($title) or empty($content)) {
        $error = 'All fields are required!';
    } else {
        $query = $pdo->prepare("INSERT INTO articles (atricle_title, atricle_text, atricle_timestamp) VALUES (?, ?, ?)");

        $query->bindValue(1, $title); //error is here
        $query->bindValue(2, $content);
        $query->bindValue(3, time());

        $query->execute();

        header("Location: index.php");
}

answered Sep 15, 2013 at 17:53

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

Collectives™ on Stack Overflow

Parse error: syntax error, unexpected T_VARIABLE in bindValue

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related