0
 try{

   $stmt = $conn->prepare("UPDATE products SET products.stock=:products.stock Where products.id=:product_id");
        $stmt->execute(['products.stock'=>$newstock,'products.id'=>$productid]);

'''

= When I try to execute it it stated that SQLSTATE[HY093]: Invalid parameter number: parameter was not defined i dont know what is wrong

and here are the code for getting row ''' if(isset($_POST['id'])){ $id = $_POST['id'];

    $conn = $pdo->open();

    $stmt = $conn->prepare("SELECT *, orderlist.id AS orderlistid FROM orderlist LEFT JOIN usersc ON orderlist.user_id=usersc.id WHERE orderlist.id=:id");
    $stmt->execute(['id'=>$id]);
    $row = $stmt->fetch();
    
    $pdo->close();

'''

0 Answers0