php - Want to run multiple document upload and insert query at same time
one text
Solution:
In previous code two loops are used that's why it runs 2 time. below code work well to upload file as well as inserting a query. Updated code :
$countfiles = count($_FILES['uploadDoc']['name']);
for($j=0;$j<$countfiles;$j++)
{
$filename = $_FILES['uploadDoc']['name'][$j];
$o1=$_POST['V_Till'][$j];
$o2=$_POST['D_Type'][$j];
move_uploaded_file($_FILES['uploadDoc']['tmp_name'][$j],'../uploadNot/'.$filename);
$sql="INSERT INTO `doc` VALUES ('','".addslashes($i)."','".addslashes($o1)."','".addslashes($o2)."','".addslashes($filename)."','','')";
if ($con->query($sql) == TRUE)
{
}
else
{
echo "Error:".$sql."<br>".$con->error;
}
}
Source