Updating a play count in SQLite

[Gandalf]

I have a script that updates a play count whenever a video has been played. It works but I’m wondering if there’s a simpler way to do it.

  $db = new PDO('sqlite:'.$dba);
  $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

  $query = 'SELECT played FROM videos WHERE id = :id;';
  $stmt = $db->prepare($query);
  $stmt->bindParam(':id', $id);
  $stmt->execute();
  $row = $stmt->fetch();

  $played = $row['played'] + 1;
  $query = 'UPDATE videos SET played = :played WHERE id = :id;';
  $stmt = $db->prepare($query);
  $stmt->bindParam(':id', $id);
  $stmt->bindParam(':played', $played);
  $stmt->execute();

  $db = null;

[igor_g]

UPDATE videos SET played = played + 1 WHERE id = :id;

[Gandalf]

Ah, thanks @igor_g. It is that simple after all!

[benanamen]

Additionally, the whole SELECT block of code is not needed. This should be all you need.

    $db = new PDO('sqlite:'.$dba);
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $query = 'UPDATE videos SET played = played + 1 WHERE id = ?';
    $stmt = $db->prepare($query);
    $stmt->execute[$id];

[Gandalf]

@benanamen

the whole SELECT block of code is not needed

Yeah, thanks. That’s what I took it to mean.