0

I am trying to update a column but it is not working and displays no error. It works if on INSERT.

  • var_dump($data); contains the correct elements
  • var_dump($req); contains the correct elments
  • Anything after $req->execute($data); is not displayed unless execute() is commented out.
  • var_dump($req->execute($data)); doesn't return anything.

$this->dbLog is my PDO connection.

  public function updateNotification($id, $user)
  {
    $data = array(
        'id'   => intval($id),
        'user' => $user,
    );

    $sql = "UPDATE db.user_alerts
            SET `clicked` = 1
            WHERE TRUE
            AND id = :id
            AND user_name = :user
            ";

    $req = $this->dbLog->prepare($sql);

    $req->execute($data);
  }

I also have a column with a default value of CURRENT_TIMESTAMP, do you think it can be the cause of the problem ?

Thank you in advance for your help.

Bon Coin
  • 1
  • 2

0 Answers0