为什么“数量”值不显示任何值？

debugcn 发表于 Dev

神奇骑士

我正在尝试显示数据库表中的“数量”值，但未$quantity在浏览器中显示该值。为什么？

在此处输入图片说明

<?php

include('connection.php');

# cartexe.php will perform all actions on cart.php

// add Item to Cart
if(isset($_POST['addItemToCart']))
{
    // initialize index.php variables
    $productName = $_POST['productName'];
    $price = $_POST['price'];
    $description = $_POST['description'];
    $quantity = 0;

    // check the cart table to see if the product has been previously added
    $smtp = $conn->prepare('SELECT * FROM cart WHERE Product_Name = :product'); // prepare a statement to fetch the quanity for a particular pprodut... the statement is not executed but merely prepared to do so. 
    $smtp->bindParam(':product', $productName, PDO::PARAM_STR); //bind the productNAme with whatever data supplied hence the statement after : above will be replaced with the actually data.. In additional the statement is set as string hence PDO::PRAM_STR
    $smtp->execute();//finally run the statment

    //var_dump($smtp);
    //find the number of rows affected
    $result = $smtp->fetch(PDO::FETCH_NUM);
    // var_dump($smtp);


    //the data does existed
    if($result > 0)
    {
        $row = $smtp->fetch(PDO::FETCH_ASSOC);
        echo " DATA FOUND";
        echo $row['Quantity'];

        //$quantity++; // increment the quanity if data found
     }
     //no match found
     else
     {
         echo ' No data found';
     }

 }

 ?>

博扬

似乎您不需要先尝试获取

$smtp = $conn->prepare('SELECT * FROM cart WHERE Product_Name = :product'); // prepare a statement to fetch the quanity for a particular pprodut... the statement is not executed but merely prepared to do so. 
    $smtp->bindParam(':product', $productName, PDO::PARAM_STR); //bind the productNAme with whatever data supplied hence the statement after : above will be replaced with the actually data.. In additional the statement is set as string hence PDO::PRAM_STR
   ;//finally run the statment



    //the data does existed
    if( $smtp->execute() )
    {
        $row = $smtp->fetch(PDO::FETCH_ASSOC);
        echo " DATA FOUND";
        echo $row['Quantity'];

        //$quantity++; // increment the quanity if data found
     }

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。