php pdo execute multiple query in loop

Question

At first select query if id exists just update quantity else execute insert(id, quantity) query in my case just update query executed

$fodid = $data->orfid;
$quantity = $data->orqnt; 

include('db.php');     

try{                              
    $sqlchk="SELECT `orfoodid` AS  FROM `orders` where `orfoodid`=':chkfoodid';";
    $sqlupdate="UPDATE `resturant`.`orders` SET `orfoodqnt` = ':chcount' WHERE `orders`.`orfoodid` = ':chfodid';";
    $sql="INSERT INTO `resturant`.`orders` (`orfoodid`, `orfoodqnt`) VALUES (:foodid,:count);";  

    for($i=0;$i<sizeof($fodid);$i++){

        $rs = $conn->prepare($sqlchk);
        $rs->execute(array(':chkfoodid'=>$fodid[$i]));       
        $result=$rs->fetch(PDO::FETCH_ASSOC);     

        if(!$result)
        {
            $rs = $conn->prepare($sqlupdate);
            $rs->execute(array(':chfodid'=>$fodid[$i],
                           ':chcount'=>$quantity[$i]));
            echo 'Order updated';                      
        } else {         
            $rs = $conn->prepare($sql);
            $rs->execute(array(':foodid'=>$fodid[$i],
                           ':count'=>$quantity[$i])); 
            echo 'Order Saved';
        }           

    }                          
    $conn=null;
}catch (PDOException $e) {
    print "Error!: " . $e->getMessage() . "<br/>";
    die();
}

Just a note: An statement must only once prepared. So prepare once and give all stmts and readable name like `$selectStmt` — JustOnUnderMillions, Apr 27 '17 at 11:30
another note, use [`insert on duplicate update`](https://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html) statement instead — hassan, Apr 27 '17 at 11:33

score 0 · Answer 1 · answered Apr 27 '17 at 14:52

0

i solved my problem it was syntax error ':chkfoodid' just remove single quotations :chkfoodid

answered Apr 27 '17 at 14:52

user3188243

1
3

php pdo execute multiple query in loop

1 Answers1