getConnection(); $emp = new employee($db); if(isset($_POST['submit'])){ $c = 0; $foldername = $_POST['brachcode_xsl']; $folder_brname = preg_replace("/\s+/", "", $foldername); echo $filename=$_FILES["file"]["tmp_name"]; if($_FILES["file"]["size"] > 0) { $fileop = fopen($filename, 'r') or die('uncable to open file '); require_once("phpqrcode/qrlib.php"); while(($filesop = fgetcsv($fileop, 1000, ",")) !== false) //while ($getcsvdata = fgetcsv($fileop, '100', ',')) { $emp->empbranchcode = $filesop[0]; $emp->empname = $filesop[1]; $emp->empemail = $filesop[2]; $emp->empphone = $filesop[3]; $emp->empaddress = $filesop[4]; $emp->emppic = $filesop[5]; $emp->empstatus = $filesop[6]; $emp->emppass = $filesop[7]; if($emp->emp_create()){ //header('Location: dashboard.employee.qr.php'); //header('Location: dashboard.employee.qr.php?empid='.$emp->lastempid); $codeContents=$emp->lastempid; //echo "----------------------------------" . $codeContents . "
"; $filepath = 'qrcode/'.$folder_brname.'/' . $codeContents . '.png'; QRcode::png($codeContents,$filepath , QR_ECLEVEL_H, 5); // Start DRAWING LOGO IN QRCODE $QR = imagecreatefrompng($filepath); } $c = $c + 1; } } } ?>

All Record Imported Successfully

Total Records Inserted