Advertisement
Guest User

Untitled

a guest
Aug 28th, 2016
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.28 KB | None | 0 0
  1. INSERT INTO cart (product_id, quantityCart) VALUES (1, 10) ON DUPLICATE KEY UPDATE quantityCart = quantityCart + 10;
  2. UPDATE products SET quantity = quantity - 10 WHERE product_id = 1;
  3.  
  4. INSERT INTO cart (product_id, quantityCart) VALUES (2, 15) ON DUPLICATE KEY UPDATE quantityCart = quantityCart + 15;
  5. UPDATE products SET quantity = quantity - 15 WHERE product_id = 2;
  6.  
  7. INSERT INTO cart (product_id, quantityCart) VALUES (3, 20) ON DUPLICATE KEY UPDATE quantityCart = quantityCart + 20;
  8. UPDATE products SET quantity = quantity - 20 WHERE product_id = 3;
  9.  
  10. <?php
  11. if (isset($_POST['addCart']) && $_POST['addCart']=="Add Items to Cart") {
  12. foreach($_POST['qtyBuy'] as $index=>$value){
  13. if($value > 0){
  14. $cartProd_id = $_POST['product_id'][$index];
  15.  
  16. $addQuery = "INSERT INTO cart (product_id, quantityCart)
  17. VALUES ($cartProd_id, $value)
  18. ON DUPLICATE KEY UPDATE quantityCart = quantityCart + $value;";
  19. $addQuery .= "UPDATE products SET quantity = quantity - $value WHERE product_id = $cartProd_id;";
  20.  
  21. $execQuery = mysqli_multi_query($connection, $addQuery);
  22.  
  23. echo $addQuery;
  24. }
  25. }
  26.  
  27. }
  28. ?>
  29.  
  30. <form action="add_sales.php" method="POST">
  31. <table class="table table-striped table-bordered table-hover results table-fixed table-condensed">
  32. <thead>
  33. <tr>
  34. <th class="text-center">#</th>
  35. <th>Product Name</th>
  36. <th>Description</th>
  37. <th>Price</th>
  38. <th>In Stock</th>
  39. <th style="width: 20%">Quantity</th>
  40. </tr>
  41. <tr class="warning no-result">
  42. <td colspan="8"><i class="fa fa-warning"></i> No Product Found</td>
  43. </tr>
  44. </thead>
  45.  
  46.  
  47. <tbody>
  48. <?php
  49. $query = "SELECT * FROM products;";
  50. $exec = mysqli_query($connection, $query);
  51. $a = 1;
  52. $b = 1;
  53.  
  54. while ($row = mysqli_fetch_array($exec)) {
  55. $product_id = $row['product_id'];
  56. $product_name = $row['product_name'];
  57. $product_price = $row['sell_price'];
  58. $description = $row['description'];
  59. $product_quantity = $row['quantity'];
  60.  
  61. ?>
  62. <tr>
  63. <td class="text-center"><?php echo $product_id; ?>
  64. <input type="hidden" name="product_id[]" value="<?php echo $product_id; ?>">
  65. </td>
  66. <td><?php echo $product_name; ?></td>
  67. <td><?php echo $description; ?></td>
  68. <td><?php echo $product_price; ?></td>
  69. <td><input type="number" value="<?php echo $product_quantity; ?>" id="<?php echo "qtyResult" . $a++; ?>" disabled></td>
  70. <td><input type="number" name="qtyBuy[]" id="<?php echo "qtyBuy" . $b++; ?>" onkeyup="updateStock(this, event)"></td>
  71. </tr>
  72. <?php } ?>
  73. </tbody>
  74. </table>
  75.  
  76.  
  77. </div>
  78. <div class="form-group">
  79. <input type="submit" name="addCart" value="Add Items to Cart" class="btn btn-info pull-right">
  80.  
  81. </div>
  82. </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement