<?php
\n\/\/ Load the database configuration file
\ninclude_once ‘config.php’;<\/p>\n
if(isset($_POST[‘importSubmit’])){<\/p>\n
\/\/ Allowed mime types
\n$csvMimes = array(‘text\/x-comma-separated-values’, ‘text\/comma-separated-values’, ‘application\/octet-stream’, ‘application\/vnd.ms-excel’, ‘application\/x-csv’, ‘text\/x-csv’, ‘text\/csv’, ‘application\/csv’, ‘application\/excel’, ‘application\/vnd.msexcel’, ‘text\/plain’);<\/p>\n
\/\/ Validate whether selected file is a CSV file
\nif(!empty($_FILES[‘file’][‘name’]) && in_array($_FILES[‘file’][‘type’], $csvMimes)){<\/p>\n
\/\/ If the file is uploaded
\nif(is_uploaded_file($_FILES[‘file’][‘tmp_name’])){<\/p>\n
\/\/ Open uploaded CSV file with read-only mode
\n$csvFile = fopen($_FILES[‘file’][‘tmp_name’], ‘r’);<\/p>\n
\/\/ Skip the first line
\nfgetcsv($csvFile);<\/p>\n
\/\/ Parse data from CSV file line by line
\nwhile(($line = fgetcsv($csvFile)) !== FALSE){
\n\/\/ Get row data
\n$employee_code = $line[0];
\n$name = $line[1];
\n$dept = strtoupper($line[2]);
\n$position = $line[3];
\n$email = $line[4];
\n$phone = $line[5];
\n$isHod = $line[6];<\/p>\n
$password = md5(‘1234567’);<\/p>\n
$deptNo = mysqli_fetch_assoc(mysqli_query($conn,”SELECT * FROM `department` where UPPER(name)=’$dept'”))[‘id’];<\/p>\n
if(mysqli_num_rows(mysqli_query($conn,”SELECT * FROM `employees` WHERE `employee_code`=’$employee_code'”))>0)
\n{
\necho $employee_code.” already inserted!<br>”;
\n}
\nelse
\n{
\nif(mysqli_query($conn,”INSERT INTO `employees`(`employee_code`, `name`, `employee_pos`, `email`, `password`, `contact`, `ishod`, `dept`, `status`) VALUES (‘$employee_code’,’$name’,’$position’,’$email’,’$password’,’$phone’,’$isHod’,’$deptNo’,’1′)”))
\n{
\necho $employee_code.” inserted——-!<br>”;
\n}
\nelse
\n{
\necho “Something went wrong——-<br>”;
\n}
\n}<\/p>\n
}<\/p>\n
\/\/ Close opened CSV file
\nfclose($csvFile);<\/p>\n
$qstring = ‘?status=succ’;
\n}else{
\n$qstring = ‘?status=err’;
\n}
\n}else{
\n$qstring = ‘?status=invalid_file’;
\n}
\n}
\n?><\/p>\n
<html>
\n<head><\/p>\n
<\/head>
\n<body>
\n<form method=”POST” enctype=’multipart\/form-data’>
\n<input type=”file” name=”file”>
\n<button type=”submit” name=”importSubmit”>Upload data<\/button>
\n<\/form>
\n<\/body>
\n<\/html><\/p>\n","protected":false},"excerpt":{"rendered":"
<?php \/\/ Load the database configuration file include_once ‘config.php’; if(isset($_POST[‘importSubmit’])){ \/\/ Allowed mime types $csvMimes = array(‘text\/x-comma-separated-values’, ‘text\/comma-separated-values’, ‘application\/octet-stream’, ‘application\/vnd.ms-excel’, ‘application\/x-csv’, ‘text\/x-csv’, ‘text\/csv’, ‘application\/csv’, ‘application\/excel’, ‘application\/vnd.msexcel’, ‘text\/plain’); \/\/ Validate whether selected file is a CSV file if(!empty($_FILES[‘file’][‘name’]) && in_array($_FILES[‘file’][‘type’], $csvMimes)){ \/\/ If the file is uploaded if(is_uploaded_file($_FILES[‘file’][‘tmp_name’])){ \/\/ Open uploaded CSV file with read-only mode …<\/p>\n