Edit Question - KnowledgeHub

Title Body

I'm currently updating my app by switching to PDO. I have the following code: $stmt = $db->prepare("select * from `product` where productid in (:productidLst)"); $stmt->bindParam(":productidLst",$productidLst, PDO::PARAM_INT); $stmt->execute(); The var $productidLst is 1,2 after the above code I would like to use the PDO equivalent of this: while($rs=mysql_fetch_assoc($res)){ $rs['qty']=$_SESSION['basket'][$rs['productid']]; $rs['total'] += $rs['qty']*$rs['price']; $total += $rs['total']; $a[] = $rs; } I have tried numerous combinations but not been successful so any help with this would be appreciated (in the 2nd code block $res was the sql). Secondly I have set the Parameter $productidLst to INT is this correct or should it be a string? --------------------UPDATE 1---------------------------------------------------- I have tried the following code: $stmt = $db->prepare("select * from `product` where productid in (:productidLst)"); foreach ($stmt->execute(array(':productidLst' => $productidLst)) as $row) { $total += $row['total']; } Which returns: Invalid argument supplied for foreach() error

Tags (comma-separated) Cancel