" . "File ". $_FILES['filename']['name'] ." Uploaded successfully." . "";
// echo "Displaying contents:
";
// readfile($_FILES['filename']['tmp_name']);
// }
//Import uploaded file to Database
$handle = fopen($_FILES['filename']['tmp_name'], "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
mysqli_query($conn,"INSERT into user (school_number, firstname ,middlename, lastname, contact, gender, address, type, level, section, status, user_added)
values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]',NOW())");
}
fclose($handle);
//print "Import done";
echo "";
echo "";
//view upload form
}
?>