query($sql) === TRUE) { // echo "Record deleted successfully"; $fileName = $_FILES["file"]["tmp_name"]; if ($_FILES["file"]["size"] > 0) { $file = fopen($fileName, "r"); while (($column = fgetcsv($file, 10000, ",")) !== FALSE) { $sqlInsert = "INSERT into users (id,Subject,Level,Date,Time,Fee,Registration) values ('" . $column[0] . "','" . $column[1] . "','" . $column[2] . "','" . $column[3] . "','" . $column[4] . "','" . $column[5] . "','" . $column[6] . "')"; $result = mysqli_query($conn, $sqlInsert); if (! empty($result)) { $type = "success"; $message = "CSV Data Imported into the Database"; } else { $type = "error"; $message = "Problem in Importing CSV Data"; } } } } else { echo "Error deleting record: " . $conn->error; } } ?>