CODEWITHSUNDEEP
phppdo
SlaSerX
SlaSerX

Reputation: 27

PHP PDO update two tables

I want to update two tables, when I use submit form. I use this code, but update only one table. How to do to update both?

 $cryptpass = password_hash($password, PASSWORD_BCRYPT, array("cost" => 12));
 $db = DB();
 $query = $db->prepare("UPDATE passrecovery SET resComplete = 'Yes' WHERE email = :email");
 $query->closeCursor();
 $query = $db->prepare("UPDATE members SET password = :cryptpass WHERE email = :email");
 $query->execute(array(
  ':email' => $row['email'],
  ':cryptpass' => $cryptpass,
  ));
print_r("<div class='success'>Success</div>");

Upvotes: 0

Views: 1091

Answers (1)

Fran Cerezo
Fran Cerezo

Reputation: 948

$cryptpass = password_hash($password, PASSWORD_BCRYPT, array("cost" => 12));
 $db = DB();
 $query = $db->prepare("UPDATE passrecovery p, members m
SET p.resComplete = 'Yes', m.password = :cryptpass 
WHERE p.email = m.email and p.email = :email");
 $query->execute(array(
  ':email' => $row['email'],
  ':cryptpass' => $cryptpass,
  ));
print_r("<div class='success'>Success</div>");

Upvotes: 1

Related Questions