0) { echo "
"; while($row = mysqli_fetch_assoc($result)) { echo ""; } echo "
EMP ID First Name Last Name Email Registration Date
" . $row['emp_id']." " . $row['firstname']." " . $row['lastname']." " . $row['email']." " . $row['reg_date']."
"; } else { echo "you have no records"; } } function getdb(){ $servername = "localhost"; $username = "root"; $password = "aee1024"; $dbname = "db_vts"; try { $conn = mysql_connect($servername, $username, $password, $dbname); //echo "Connected successfully"; } catch(exception $e) { echo "Connection failed: " . $e->getMessage(); } return $conn; } if(isset($_POST["Import"])){ $filename=$_FILES["file"]["tmp_name"]; if($_FILES["file"]["size"] > 0) { $file = fopen($filename, "r"); while (($getData = fgetcsv($file, 10000, ",")) !== FALSE) { $sql = "INSERT into login_history (log_id,u_name,date,time,remarks, branch_code) values ('','".$getData[1]."','".$getData[2]."','".$getData[3]."','".$getData[4].",'".$getData[5]."')"; $result = mysql_query($con, $sql); if(!isset($result)) { echo ""; } else { echo ""; } } fclose($file); } } ?>
Form Name