每次点击上载/提交都会遇到错误:
Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\FormsNetBeans\index.php on line 18
Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\FormsNetBeans\index.php on line 18
我的代码:
<?php
$con = mysqli_connect("localhost","root","") or die (mysql_error());
mysqli_select_db($con, 'studentform');
if(isset($_POST['submit']))
{
$file = $_FILES['file']['tmp_name'];
$handle = fopen($file,"r");
while(($fileop = fgetcsv($handle,1000,",")) !==false)
{
$gender = $fileop[0];
$track = $fileop[1];
$last = $fileop[2];
$first = $fileop[3];
$sql= mysqli_query("INSERT INTO student (gender,track,last,first) VALUES ('$gender','$track','$last','$first')");
}
if($sql)
{
echo "data uploaded successfully";
}
else{
echo "error";
}
}
?>
发布于 2018-07-31 12:55:15
需要传递$con到mysqli_query():
$sql = mysqli_query($con, "INSERT INTO student (gender,track,last,first) VALUES ('$gender','$track','$last','$first')");
//------------------^^^^^^
文档的语法是:
mixed mysqli_query ( mysqli $link , string $query [, int $resultmode = MYSQLI_STORE_RESULT ] )
发布于 2018-07-31 13:22:55
作出以下两项更改:
while(($fileop = fgetcsv($handle,1000,",")) !=false) //You have given two "=" signs
和
$sql= mysqli_query($con, "INSERT INTO student(gender,track,last,first) VALUES ('$gender','$track','$last','$first')");
https://stackoverflow.com/questions/-100001783
复制相似问题