
Untitled
By: a guest on
Aug 12th, 2012 | syntax:
None | size: 0.93 KB | hits: 8 | expires: Never
PHP - loop through array and insert values to SQL
$pushFinal = $_POST["pushFinal"];
$lines = array();
$lines = explode("|",$pushFinal);
$lineItems = array();
foreach ($lines as $val){
$lineItems = explode("$",$val);
$temp = "";
foreach($lineItems as $val2){
$temp = $temp."'".$val2."',";
}
$sql="insert into OPS_SCHEDULE values($temp)";
$stmt = sqlsrv_query($conn,$sql);
}
foreach($array as $val){
$sqlVals[]="'".$val."'";
}
$sqlValsStr = implode(",",$sqlVals);
$sql = "insert into table values(".$sqlValsStr.")";
$pushFinal = $_POST["pushFinal"];
$lines = array();
$lines = explode("|",$pushFinal);
$lineItems = array();
foreach ($lines as $val){
$lineItems = explode("$",$val);
$temp = "";
foreach($lineItems as $val2){
$temp = $temp."'".$val2."',";
}
$temp = substr($temp, 0, -1);
$sql ="insert into table values($temp)";
$stmt = sqlsrv_query($conn,$sql);
}