PHP PDO

[razorsese]

How I can increment a value into database ?!

When I try whit my code it's replacing the data from mysql database not summing up

 

$conn = new PDO( DBN, DB_USER, DB_PASS );
      $sql = "UPDATE articles SET rating =:rating+1, totalv=:totalv+1 WHERE id = :id";
  $st = $conn->prepare ( $sql );
  $st->bindValue( ":rating", $this->rating, PDO::PARAM_INT );
  $st->bindValue( ":id", $this->id, PDO::PARAM_INT );
  $st->bindValue( ":totalv", $this->totalv, PDO::PARAM_INT );
  $st->execute();
      $conn = null;

[Jessica]

You can simplify it a lot by removing the variables for rating and total. you can increment a column by the column name.

UPDATE bar SET foo = foo+1

 

[razorsese]

Thank you very much

[Jessica]

you're welcome! Mark as solved!