问题描述

我正在尝试通过 php 连接到 sql 数据库，并不断收到我无法弄清楚的错误.我可以连接另一个调试脚本而没有错误.我获得了连接并提取了我的数据，但最后却出现了错误.

I am attempting a connection to a sql db via php and keep getting an error I can't figure out. I can connect with another debug scripts with no errors. I get my connection and pull my data but pulls an error at the end.

$con=mysqli_connect("localhost","username","password","dbname");
 
// Check connection
if (mysqli_connect_errno())
{
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
 
// This SQL statement selects ALL from the table 'Locations'
$sql = "SELECT * FROM Locations";
 
// Check if there are results
if ($result = mysqli_query($con, $sql))
{
    // If so, then create a results array and a temporary one
    // to hold the data
    $resultArray = array();
    $tempArray = array();
 
    // Loop through each row in the result set
    while($row = $result->fetch_object())
    {
        // Add each row into our results array
        $tempArray = $row;
        array_push($resultArray, $tempArray);
    }
 
    // Finally, encode the array to JSON and output the results
    echo json_encode($resultArray);
}
 
// Close connections
mysqli_close($result);
mysqli_close($con);
?>

把这个拿出来

[{名称":苹果"，地址":1 Infinity Loop Cupertino，CA"，纬度":37.331741"，经度":-122.0303333""},{"Name":"Googleplex","Address":"1600 Amphitheatre Pkwy, Mountain View, CA","Latitude":"37.421999","Longitude":"-122.083954"}]

[{"Name":"Apple","Address":"1 Infinity Loop Cupertino, CA","Latitude":"37.331741","Longitude":"-122.030333"},{"Name":"Googleplex","Address":"1600 Amphitheatre Pkwy, Mountain View, CA","Latitude":"37.421999","Longitude":"-122.083954"}]

警告:mysqli_close() 期望参数 1 是 mysqli，对象在/home/jfletch/public_html/appone/connect.php 第 36 行

Warning: mysqli_close() expects parameter 1 to be mysqli, object given in /home/jfletch/public_html/appone/connect.php on line 36

推荐答案

mysqli_close($result);

上面的行是不正确的.您只需要调用 mysqli_close() 一次(如果有的话，正如评论中指出的那样，连接在脚本执行结束时关闭)并且参数应该是您的链接标识符，而不是您的查询资源.

The line above is incorrect. You only need to call mysqli_close() once (if at all since, as pointed out in the comments, the connection is closed at the end of the execution of your script) and the parameter should be your link identifier, not your query resource.

删除它.

这篇关于php 警告:mysqli_close() 期望参数 1 是 mysqli的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！