Jump to content

Obodo

New Members
  • Posts

    6
  • Joined

  • Last visited

Obodo's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. ok sir. how can that be done with the above mentioned?
  2. thanks all. i got it up and running now. but Mr Barand, is there a way i could have stored the items into the database without the use of form? meanwhile like i tried explaining, the values are derived from session so the page i had problem is the checkout page. thanks again
  3. I really want to update the record. I mean to subtract the quantity of items bought to that in stock. that is if a customer buys 12 coke and 15 milk, they will be deducted from the total in stock. hope you get it. thanks
  4. Sorry but i don't quite get you. the files are read only cos user is not expected to do any form of input on the page. the values are from another page which is the front end. this page is the checkout page.
  5. Hahahahahahaha. Users don't get to input their own price. this page is actually to send the order to the database and print. meanwhile its for online, I'm developing it for my wife to use in her shop. so everything is ran on localhost.
  6. hello all i am building a shopping system, but i am stuck. i want to update items in the database but it is affecting only the last row. thanks for the help <input type="hidden" class="form-control" name="prod_id" value="'.$values["product_ids"].'" /> <td><input type="text" class="form-control" readonly name="prod_name" value="'.$values["product_name"].'" /></td> <td><input type="text" class="form-control" readonly name="prod_type" value="'.$values["product_type"].'" /></td> <td><input type="text" class="form-control" readonly name="prod_size" value="'.$values["product_size"].'" /></td> <td><input type="text" class="form-control" readonly name="prod_qty" value="'.$values["product_quantity"].'" /></td> <td><input type="text" class="form-control" readonly name="prod_price" value="'.$values["product_price"].'" /></td> <td><input type="text" class="form-control" readonly name="total_price" value="'.number_format($values["product_quantity"] * $values["product_price"], 2).'" /></td> if(isset($_POST['enter'])) { require_once 'database_connection.php'; $prod_name = $_POST['prod_name']; $prod_id = $_POST['prod_id']; $prod_type = $_POST['prod_type']; $prod_size = $_POST['prod_size']; $prod_qty = $_POST['prod_qty']; $prod_price = $_POST['prod_price']; $total_price = $_POST['total_price']; $trans_ref = mt_rand(10000, 99999); $sql = "INSERT INTO test_sales ( trans_ref, prod_id, prod_name, prod_type, prod_size, prod_qty, prod_price, total_price, trans_date ) VALUES ( :trans_ref, :prod_id, :prod_name, :prod_type, :prod_size, :prod_qty, :prod_price, :total_price, NOW() )"; $stmt = $connect->prepare($sql); $stmt->execute(array( ':trans_ref' => $trans_ref, ':prod_id' => $prod_id, ':prod_name' => $prod_name, ':prod_type' => $prod_type, ':prod_size' => $prod_size, ':prod_qty' => $prod_qty, ':prod_price' => $prod_price, ':total_price' => $total_price )); $num_rows = $stmt->rowCount(); if($num_rows){ $sql = " UPDATE products SET qty = qty - '$prod_qty' WHERE prod_name = '$prod_name' AND prod_id = '$prod_id' "; $stmt = $connect->prepare($sql); //$stmt->bindValue(':qty', $prod_qty, PDO::PARAM_STR); $stmt->bindValue(':prod_name', $prod_name, PDO::PARAM_STR); $stmt->bindValue(':prod_id', $prod_id, PDO::PARAM_STR); $stmt->execute(); echo '<div class="alert bg-success text-center">ITEMS ADDED</div>'; unset($_SESSION["shopping_cart"]); }else{ echo '<div class="alert bg-danger text-center">A PROBLEM OCCURRED</div>'; } }
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.