当满足条件时，我需要一段代码来增加表中的列 - I need a code to incremeny a column in my table when condition is satisfied

I need a code to incremeny a column in my table when condition is satisfied

下面是我用于递增的代码，它没有显示错误，但"like"列没有递增。

   <?php
      $id=$_GET['id'];
     echo $id;
     $dsn = 'mysql:host=127.0.0.1;dbname=as1';
     $user = 'root';
     $password = '';
    try{
                // Connect and create the PDO object
                $pdo = new PDO($dsn, $user, $password);
                $pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
            }
         catch(PDOException $e){
                                    echo 'Database connection failed - ';
                                    echo $e->getMessage();
                                    exit;
                                }
        $sql="UPDATE photo SET likes = likes + 1 WHERE imagename=:id";
        $q=$pdo->prepare($sql);
        $q->execute(array($id));
        header("Location:upload.php");
}

$sql="UPDATE photo SET likes = likes + 1 WHERE imagename=':id'";

$sql="UPDATE photo SET likes = likes + 1 WHERE imagename=:id";
$q=$pdo->prepare($sql);
$q->bindParam(':id', $id, PDO::PARAM_INT);
$q->execute();

从编程语言中知道++不适用于正常的SQL语法。