Guest User

Untitled

a guest
Sep 21st, 2018
189
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. $query_tmp=mysqli_query($con,"select * from product_tmp where product_id='$product_id' and user_id='$user_id' and branch_id='$id_sucursal'");
  2. $count=mysqli_num_rows($query_tmp);
  3. if ($count==0){
  4. $sql=mysqli_query($con,"INSERT into product_tmp
  5. ( product_id, qty, unit_price, user_id, discount, branch_id, cventa)
  6. values ('$product_id','$qty','$unit_price', '$user_id','$descuento','$id_sucursal','$cventa')");
  7. } else {
  8. $rw=mysqli_fetch_array($query_tmp);
  9. $actual_qty=$rw['qty'];
  10. $new_qty=$actual_qty+$qty;
  11. $update=mysqli_query($con,"update product_tmp set qty='$new_qty' where product_id='$product_id' and user_id='$user_id' and branch_id='$id_sucursal'");
  12. }
  13.  
  14. <?php
  15. $servername = "localhost";
  16. $username = "username";
  17. $password = "password";
  18. $dbname = "myDB";
  19.  
  20. // Create connection
  21. $conn = new mysqli($servername, $username, $password, $dbname);
  22. // Check connection
  23. if ($conn->connect_error) {
  24. die("Connection failed: " . $conn->connect_error);
  25. }
  26.  
  27. $sql = "select * from product_tmp where product_id='$product_id' and user_id='$user_id' and branch_id='$id_sucursal'";
  28.  
  29. $result = $conn->query($sql);
  30.  
  31. if ($result->num_rows > 0)
  32. {
  33. $sql = "INSERT into product_tmp
  34. ( product_id, qty, unit_price, user_id, discount, branch_id, cventa)
  35. values ('$product_id','$qty','$unit_price', '$user_id','$descuento','$id_sucursal','$cventa')";
  36.  
  37. } else {
  38.  
  39. $actual_qty = 0;
  40.  
  41. while($row = $result->fetch_assoc())
  42. {
  43. $actual_qty += $row['qty'];
  44. }
  45.  
  46. $sql = "update product_tmp set qty='$actual_qty' where product_id='$product_id' and user_id='$user_id' and branch_id='$id_sucursal'";
  47. }
  48. ?>
Add Comment
Please, Sign In to add comment