Please help me with the solution to this problem:
mysqli_query() expects at least 2 parameters 1 given.......on line 24
mysqli_query() expects at least 2 parameters 1 given.......on line 24
mysqli_query() expects at least 2 parameters 1 given.......on line 24
<?php
if (isset($_POST['submit']))
{
$db_server = "localhost";
$db_user = "root";
$db_pass = "";
$db_name = "rms_db";
$db = new mysqli($db_server, $db_user, $db_pass, $db_name);
if($db->connect_errno){
echo "Could not connect to database";
}
//Import uploaded file to Database
$file_CSV = fopen($_FILES['filename']['tmp_name'], "r");
while (($data = fgetcsv($file_CSV, 1000, ",")) !== FALSE) {
mysqli_query("INSERT into stinfo (ibsn, name, ftname,mtname, sex, birth,religion, nationality, phone,email, bio, address, joined)
values('$data[0], '$data[1]', '$data[2]','$data[3]','$data[4]', '$data[5]', '$data[6]','$data[7]', '$data[8]', '$data[9]','$data[10]', '$data[11]', NOW())");
}
fclose($file_CSV);
//print "Import done";
echo "<script type='text/javascript'>alert('Successfully Imported a CSV File for User!');</script>";
echo "<script>document.location='index.php'</script>";
//view upload form
}
?>
