run multiple sql queries at once in php code example

Example: php execute 2 queries

while (($emapData = fgetcsv($file, 10000, ",")) !== FALSE)
		 {

           $sql_tableone =  "INSERT into inverterlog (`id`,`timestamp`,`irradiance`,`ambienttemp`,`photovoltaictemp`,`pv1voltage`,`pv2voltage`,`pv3voltage`,`pv1current`,`pv2current`,`pv3current`,`pv1power`,`pv2power`,`pv3power`,`pv1energy`,`pv2energy`,`pv3energy`,`gridvoltagegv1`,`gridvoltagegv2`,`gridvoltagegv3`,`gridcurrentgc1`,`gridcurrentgc2`,`gridcurrentgc3`,`gridpowergp1`,`gridpowergp2`,`gridpowergp3`,`sumofapparentpower`,`gridpowertotal`,`gridenergyge1`,`gridenergyge2`,`gridenergyge3`,`socounter`,`gridcurrentdcgc1`,`gridcurrentdcgc2`,`gridcurrentdcgc3`,`gridresidualcurrent`,`gridfrequencymean`,`dcbusupper`,`dcbuslower`,`temppower`,`tempaux`,`tempctrl`,`temppower1`,`temppowerboost`,`apparentpowerap1`,`apparentpowerap2`,`apparentpowerap3`,`sovalue`,`reactivepowerrp1`,`reactivepowerrp2`,`reactivepowerrp3`,`opmode`,`latestevent`,`pla`,`reactivepowermode`,`overexcitedunderexcited`,`reactivepowerabs`,`inverter`)
						                                  values('','$newDate','$emapData[1]','$emapData[2]','$emapData[3]','$emapData[4]','$emapData[5]','$emapData[6]','$emapData[7]','$emapData[8]','$emapData[9]','$emapData[10]','$emapData[11]','$emapData[12]','$emapData[13]','$emapData[14]','$emapData[15]','$emapData[16]','$emapData[17]','$emapData[18]','$emapData[19]','$emapData[20]','$emapData[21]','$emapData[22]','$emapData[23]','$emapData[24]','$emapData[25]','$emapData[26]','$emapData[27]','$emapData[28]','$emapData[29]','$emapData[30]','$emapData[31]','$emapData[32]','$emapData[33]','$emapData[34]','$emapData[35]','$emapData[36]','$emapData[37]','$emapData[38]','$emapData[39]','$emapData[40]','$emapData[41]','$emapData[42]','$emapData[43]','$emapData[44]','$emapData[45]','$emapData[46]','$emapData[47]','$emapData[48]','$emapData[49]','$emapData[50]','$emapData[51]','$emapData[52]','$emapData[53]','$emapData[54]','$emapData[55]','$inverter')";
        
		   $sql_tabletwo = "INSERT into data (`id`,`timestamp`,`gridpowertotal`,`inverter`) values ('','$newDate','$emapData[26]','$inverter')";
         //we// are using mysql_query function. it returns a resource on true else False on error
          
		  $sql= $sql_tableone.";".$sql_tabletwo;
		  
		  $result = mysqli_multi_query( $con,$sql);
		  
		 if(! $result )
			{
				echo "<script type=\"text/javascript\">
					alert(\"Record Insertion Failed.\");
					</script>";
			
			}

	
			}

         }
         fclose($file);
		 }
	 
	
         //throws a message if data successfully imported to mysql database from excel file
       echo "<script type=\"text/javascript\">
					alert(\"CSV File has been successfully Imported.\");
				window.location = \"four.php\"
				/</script>";
        	 
		 

		 //close of connection
		mysqli_close($con); 
	}
	}
    $result = mysqli_multi_query( $con,$sql);
	  
	 if(! $result )
		{
			echo "<script type=\"text/javascript\">
				alert(\"multi query Record Insertion Failed.\");
				</script>";
		
		}


		}

     }
     fclose($file);
	 }
 

     //throws a message if data successfully imported to mysql database from excel file
   echo "<script type=\"text/javascript\">
				alert(\"CSV File has been successfully Imported.\");
			window.location = \"four.php\"
			/</script>";
    	 
	 

	 //close of connection
	mysqli_close($con); 
}
}

Tags:

Php Example