php - 我需要保留 mysqli_query() 和 mysqli_close() 吗？

Question

我还需要使用 mysqli_query($connection, $results);和 mysqli_close($connection); ？

$sql = $connection->prepare("INSERT INTO pawnshop ".
    "(Pawnshop_Name, Street, Barangay, City, DTI_Permit_No, Mayor_Permit_No, Firstname, Middlename, Lastname, Contact_Number, Email_Address, Password) ".
    "VALUES ".
    "(?,?,?,?,?,?,?,?,?,?,?,?)");
    $sql->bind_param("ssssiissssss", $pawnshopName, $street, $barangay, $city, $dtiPermitNo, $mayorPermitNo, $firstName, $lastName, $middleName, $contactNumber, $email, $password);
    $sql->execute();
    $results = $sql->get_results();   
    mysqli_query($connection, $results);// Do I still need this?
    mysqli_close($connection); //Do I still need this

Answer 1

这么多的代码足以让您完成查询数据库。

$sql = $connection->prepare("INSERT INTO pawnshop ".
    "(Pawnshop_Name, Street, Barangay, City, DTI_Permit_No, Mayor_Permit_No, Firstname, Middlename, Lastname, Contact_Number, Email_Address, Password) ".
    "VALUES ".
    "(?,?,?,?,?,?,?,?,?,?,?,?)");
    $sql->bind_param("ssssiissssss", $pawnshopName, $street, $barangay, $city, $dtiPermitNo, $mayorPermitNo, $firstName, $lastName, $middleName, $contactNumber, $email, $password);
    $sql->execute();
    $results = $sql->get_results(); 

我看到您通过使用 mysqli_close($connection) 将 OOP 和过程编程方法混合在一起，这不是一个好的做法，即使您可以这样做。而是使用 $connection 对象中的方法，例如 $connection->close();