Updating database using dropdown without using a submit button

Question

I'm trying to update the table status value whenever I make a selection from the dropdown list.

The problem is I'm having a syntax error on my update query. I've read stuff about syntax error and I can't quite understand it. I think I'm gonna need a more specific help. Here's what I've done:

<?php

    $hostname = "localhost";
    $username = "root";
    $password = "";
    $databasename = "companydb";

    try
    {
        $conn = new PDO("mysql:host=$hostname;dbname=$databasename",$username, $password);
        $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        if(isset($_POST["status"]))
        {
            $query = "UPDATE tickets SET status = '$status' WHERE id = $id";
            $statement = $conn->prepare($query);
            $statement->execute(array('status' => $_POST["status"]));

            $count = $statement->rowCount();
            if($count > 0)
            {
                echo "Data Inserted Successfully..!";
            }
                else
            {
                echo "Data Insertion Failed";
            }
        }
            else
        {
            echo "unknown index: 'status'";
        }
    }

    catch(PDOException $error)
    {
        echo $error->getMessage();
    }
?>

And here's my table schema:

@BitsPlease Syntax error or access violation: 1064 You have an error in your SQL syntax — user9236271
– user9236271, Commented Feb 17, 2018 at 5:51

Rotimi · Accepted Answer · 2018-02-17 05:56:03Z

1

You are not performing prepared statements properly. You need to add the placeholder in the query and not the variables. The variables should be added in the execute() line.

$query = "UPDATE tickets SET `status` = :status WHERE `id` = :id";
$statement = $conn->prepare($query);
$statement->execute(array(':status' => $_POST["status"],':id' => $id));

Also FYI, $id is undefined.

answered Feb 17, 2018 at 5:56

Rotimi

4,7804 gold badges21 silver badges28 bronze badges

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

1 Comment

user9236271 Over a year ago

Yes I know that, for now I was just trying to figure out the update query. Thank you!

Bits Please · Accepted Answer · 2018-02-17 05:51:42Z

0

Try Changing this:

$query = "UPDATE tickets SET status = $status WHERE id = $id";

answered Feb 17, 2018 at 5:51

Bits Please

9071 gold badge7 silver badges23 bronze badges

2 Comments

user9236271 Over a year ago

I still get the same error, thanks for the suggestion tho.

Bits Please Over a year ago

Can you please try to post and check does static values gets updated? SET status = '1' and check?

Collectives™ on Stack Overflow

Updating database using dropdown without using a submit button

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related