Advertisement
Guest User

Untitled

a guest
Dec 24th, 2016
190
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. if(isset($_POST['order'])){
  2. $rows = [];
  3. $insertFields = [];
  4. $fields = ['item_num', 'brand', 'descrip', 'size', 'price', 'qty'];
  5. foreach($_POST['qty'] as $key => $value) {
  6. if($value!= '' && $value > 0){
  7. $rows[] = $key;
  8. }
  9.  
  10. }
  11.  
  12. foreach($rows as $key) {
  13. $row = [];
  14. foreach($fields as $field) {
  15. $row[$field] = $_POST[$field][$key];
  16. }
  17. $price = $row['price'];
  18. $qty = $row['qty'];
  19. $row['order_num'] = $CO;
  20. $row['cost'] = $price * $qty;
  21. $item = $row['item_num'];
  22. $checkQ = $db->query("SELECT * FROM myorder_outpost WHERE order_num = ? AND item_num = ?",array($CO,$item));
  23. $check = $checkQ->first();
  24. $checkC = $checkQ->count();
  25. if($checkC > 0) {
  26.  
  27. $db->update('myorder_outpost',$check->id,$row);
  28. }else{
  29. $db->insert('myorder_outpost',$row);
  30. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement