Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Aug 12th, 2012  |  syntax: None  |  size: 0.93 KB  |  hits: 8  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. PHP - loop through array and insert values to SQL
  2. $pushFinal = $_POST["pushFinal"];
  3. $lines = array();
  4. $lines = explode("|",$pushFinal);
  5. $lineItems = array();
  6.  
  7.  
  8. foreach ($lines as $val){
  9.     $lineItems = explode("$",$val);
  10.     $temp = "";
  11.     foreach($lineItems as $val2){
  12.         $temp = $temp."'".$val2."',";  
  13.     }
  14.     $sql="insert into OPS_SCHEDULE values($temp)";
  15.     $stmt = sqlsrv_query($conn,$sql);
  16. }
  17.        
  18. foreach($array as $val){
  19.     $sqlVals[]="'".$val."'";
  20. }
  21. $sqlValsStr = implode(",",$sqlVals);
  22. $sql = "insert into table values(".$sqlValsStr.")";
  23.        
  24. $pushFinal = $_POST["pushFinal"];
  25. $lines = array();
  26. $lines = explode("|",$pushFinal);
  27. $lineItems = array();
  28.  
  29. foreach ($lines as $val){
  30.     $lineItems = explode("$",$val);
  31.     $temp = "";
  32.     foreach($lineItems as $val2){
  33.         $temp = $temp."'".$val2."',";  
  34.     }
  35.     $temp = substr($temp, 0, -1);
  36.     $sql ="insert into table values($temp)";
  37.     $stmt = sqlsrv_query($conn,$sql);
  38. }