0) { $file = fopen($fileName, "r"); while (($column = fgetcsv($file, 10000, ",")) !== FALSE) { $sqlInsert = "INSERT into tbtransact (userId,userName,password,firstName,lastName) values ('" . $column[0] . "','" . $column[1] . "','" . $column[2] . "','" . $column[3] . "','" . $column[4] . "')"; $result = mysqli_query($con, $sqlInsert); if (! empty($result)) { $type = "success"; $message = "CSV Data Imported into the Database"; } else { $type = "error"; $message = "Problem in Importing CSV Data"; } } } } ?>