Advertisement
Guest User

Untitled

a guest
Feb 27th, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. // Мульти апдейт
  2. $updSQL_query = array();
  3. $updend_SQL = array();
  4. $updSQL = "UPDATE $allskins SET csmoney = CASE ";
  5. foreach ( $upd_items as $item){
  6. $updSQL_query[] = "WHEN skinname = '". $item['skinName'] ."' THEN '". $item['skinCost'] ."'";
  7. $updend_SQL[]="'".$item['skinName']."'";
  8.  
  9. }
  10. $updSQL .= implode(' ',$updSQL_query)." END WHERE skinname in (" . implode(',',$updend_SQL) . ")";
  11. R::exec($updSQL);
  12.  
  13.  
  14. // Мульти инсерт.
  15. $insSQL_query = array();
  16. $insSQL = "INSERT INTO $allskins ( skinname,csmoney,csmupd ) VALUES";
  17. foreach ($insert_items as $item){
  18. $insSQL_query[] = "('".$item['skinName']."', '" . $item['skinCost'] . "', '$date')";
  19. }
  20. $insSQL .= implode(',',$insSQL_query);
  21. R::exec($insSQL);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement