mysql database insert query
<?php
set_time_limit(0);
$dbconn = mysql_connect('localhost','username','password');
mysql_select_db('DBname',$dbconn);
$file = 'hospital.sql';
if($fp = file_get_contents($file)) {
$var_array = explode(';',$fp);
foreach($var_array as $value) {
mysql_query($value.';',$dbconn);
}
}
?>
<?php
set_time_limit(0);
$dbconn = mysql_connect('localhost','username','password');
mysql_select_db('DBname',$dbconn);
$file = 'hospital.sql';
if($fp = file_get_contents($file)) {
$var_array = explode(';',$fp);
foreach($var_array as $value) {
mysql_query($value.';',$dbconn);
}
}
?>