如何解决Warning: mysqli_query() expects at least 2 parameters, 1 given in … on line？
如何解决Warning: mysqli_query() expects at least 2 parameters, 1 given in … on line？
提问于 2018-07-31 04:15:19
每次点击上载/提交都会遇到错误：
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";
}
}
?>回答 2
Stack Overflow用户
发布于 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 ] )
Stack Overflow用户
发布于 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')");页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/-100001783
复制相关文章
相似问题
腾讯云开发者
