| Server IP : 108.163.255.210 / Your IP : 18.224.60.132 Web Server : Apache System : Linux blossom.urlnameserver.com 3.10.0-1160.80.1.el7.x86_64 #1 SMP Tue Nov 8 15:48:59 UTC 2022 x86_64 User : ( 1172) PHP Version : 7.2.34 Disable Function : eval,escapeshellarg,proc_close,proc_get_status,proc_nice,proc_open,symlink,system,pcntl_exec,getrusage,chown,chgp,closelog,openlog,syslog,define_syslog_variables,php_ini_loaded_file,getservbyname,getservbyport,posix_getgid,posix_getgrgid,proc_terminate,pfsockopen,apache_child_terminate,posix_mkfifo,posix_setpgid,posix_setuid,hypot,pg_host,pos,posix_access,posix_getcwd,posix_getservbyname,myshellexec,getpid,posix_getsid,posix_isatty,posix_kill,posix_mknod,posix_setgid,posix_setsid,posix_setuid,posix_times,posix_uname,ps_fill,posix_getpwuid,global,ini_restore,zip_open,zip_read,rar_open,bzopen,bzread,bzwrite,apache_get_modules,apache_get_version,phpversionphpinfo,php_ini_scanned_files,get_current_user,disk_total_space,diskfreespace,leak,imap_list,hypo,filedump,safe_mode,getmygid,apache_getenv,apache_setenv,bzread,bzwrite,bzopen,phpini,higlight_file,dos_conv,get_cwd,er_log,cmd,e_name,vdir,get_dir,only_read,ftok,ftpexec,posix_getpwnam,mysql_list_dbs,disk_free_space,session_save_path,confirm_phpdoc_compiled,zip_entry_rea,php_u,psockopen,crack_opendict,crack_getlastmessage,crack_closedict,crack_check,fpassthru,posix_get_last_error,posix_getlogin,posix_getgroups,posix_strerror,posix_getrlimit,posix_getpgrp,posix_getgrnam,pos,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/unilinki/www/payroll/admin/ |
Upload File : |
<html>
<body>
<form action="" method="POST" enctype="multipart/form-data">
<input type="file" name="file" />
<input type="submit" name="submit_cl_pl_csv" value="upload"/>
</form>
</body>
</html>
<?php
if (isset($_POST['submit_cl_pl_csv'])) {
include ("../include/db.php");
//Import uploaded file to Database
$handle = fopen($_FILES['file']['tmp_name'], "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$import="INSERT INTO `cl-pl_data`( `pf`, `year`, `month`, `cl`, `pl`) VALUES ('$data[0]','2016','08','$data[1]','$data[2]')";
/* $import="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','CL','$data[1]','2011')";
$import1="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','CL','$data[2]','2012')";
$import2="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','CL','$data[3]','2013')";
$import3="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','CL','$data[4]','2014')";
$import4="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','CL','$data[5]','2015')";
$import5="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','CL','$data[6]','01/2016')";
$import6="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','CL','$data[7]','02/2016')";
$import7="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','CL','$data[8]','03/2016')";
$import8="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','CL','$data[9]','04/2016')";
$import9="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','CL','$data[10]','05/2016')";
$import10="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','CL','$data[11]','06/2016')";
$import="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','CL','$data[12]','07/2016')";
$import11="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','CL','$data[13]','08/2016')";
$import12="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','PL','$data[14]','01/2016')";
$import13="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','PL','$data[15]','02/2016')";
$import14="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','PL','$data[16]','03/2016')";
$import15="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','PL','$data[17]','04/2016')";
$import16="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','PL','$data[18]','05/2016')";
$import17="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','PL','$data[19]','06/2016')";
$import18="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','PL','$data[20]','07/2016')";
$import19="INSERT INTO `fix_cl_pl_data`( `uid`, `type`, `number`, `month`) VALUES ('$data[0]','PL','$data[21]','08/2016')";*/
mysql_query($import);
/*mysql_query($import1);
mysql_query($import2);
mysql_query($import3);
mysql_query($import4);
mysql_query($import5);
mysql_query($import6);
mysql_query($import7);
mysql_query($import8);
mysql_query($import9);
mysql_query($import10);
mysql_query($import11);
mysql_query($import12);
mysql_query($import13);
mysql_query($import14);
mysql_query($import15);
mysql_query($import16);
mysql_query($import17);
mysql_query($import18);
mysql_query($import19);*/
}
fclose($handle);
header("location:manage_employee.php");
}
?>