Mysql database table column value increment not working

Question

So i made this database table called votes where i added 2 columns: likes and dislikes. In html i have 2 buttons: like button and dislike button. When i press the like button i want to increment the likes column value by 1, but i seem to be doing it wrong.

PHP:

 if(isset($_POST['like'])) {

    $sql = 'UPDATE votes';  
    $sql .= 'SET likes = likes + 1';    
    $sql .= 'WHERE id = 1';

    // prepare
    $stmt = $pdo->prepare($sql);

    // execute
    $result = $stmt->execute();
 }

HTML:

<form action="" method="post">
<input type="submit" value="Like" name="like">
<input type="submit" value="Dislike" name="dislike"">
</form>

No space between votes and SET, and +1, and WHERE. Your expression is basically UPDATE votesSET likes = likes + 1WHERE id = 1 - you can validate this by echoing $sql. Besides, such a short query can just be put in one line. — Qirel
– Qirel, Commented May 22, 2016 at 14:17

sagi · Accepted Answer · 2016-05-22 14:19:02Z

4

It's a typo, you are missing spaces between each row.

$sql = 'UPDATE votes ';  
$sql .= 'SET likes = likes + 1 ';    
$sql .= 'WHERE id = 1';

answered May 22, 2016 at 14:19

sagi

40.6k7 gold badges66 silver badges87 bronze badges

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

Collectives™ on Stack Overflow

Mysql database table column value increment not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related