how to update multiple (5) tables using left join?

Question

I always use left join in drop select and I dont know yet how to use it on update. I've search a lot but I see only two tables. Im confuse when applying it in three or more table update.

Please check my query:

  public function updateUser($edit_id,$username)
  {
    $stmt=$this->conn->prepare("UPDATE tbl_login LEFT JOIN activity_logs ON tbl_login.username = activity_logs.activity_logs,
                                                 LEFT JOIN tbl_files ON tbl_login.username = tbl_files.file_uploader,
                                                 LEFT JOIN tbl_manfiles ON tbl_login.username = tbl_manfiles.file_uploader,
                                                 LEFT JOIN tbl_section ON tbl_login.username = tbl_section.creator,
                                                 LEFT JOIN tbl_adfiles ON tbl_login.username = tbl_adfiles.adfile_uploader
                                SET tbl_login.username=:username
                                WHERE id=:id");
    $stmt->execute(array(":id"=>$edit_id, ":username"=>$username));

    return $stmt;
  }

It seems fantastically unlikely that you would want to update outer joined tables. It's illogical. — Strawberry, Mar 19 '18 at 06:36
(Injection problems aside), you already have a satisfactory answer — Strawberry, Mar 19 '18 at 08:18
Ofcource I know It. What I mean is my code executable by sql injection? — , Mar 21 '18 at 10:08
I was referring to the injection vulnerabilities in Arvin's answer. Your code seems more robust in this respect. — Strawberry, Mar 21 '18 at 10:21

score 0 · Answer 1 · edited Mar 21 '18 at 10:21

0

$query = "UPDATE profiledata t1 JOIN profileprivacy t2 ON (t1.uid = t2.uid) 
          SET t1.aboutyou = '$aboutyou', t1.quotes = '$quotes', 
              t2.aboutyouPrivacy = '$aboutyouPrivacy', t2.quotesPrivacy = '$quotesPrivacy' 
          WHERE t1.uid = '$sess_uid'";

update two tables at once

edited Mar 21 '18 at 10:21

Strawberry

33,750
13
40
57

answered Mar 19 '18 at 03:17

how to update multiple (5) tables using left join?

1 Answers1