表单处理器调用bind_param()出现致命错误，请求排查原因

调用$stmt->bind_param或$stmt->execute时总是遇到致命错误，怀疑数据库连接失败但无法定位问题，相关代码及错误信息如下：

formhandler.php代码 #

<?php

ini_set('display_errors', '1');
ini_set('display_startup_errors', '1');
error_reporting(E_ALL);

if ($_SERVER["REQUEST_METHOD"] == "POST") {

  $nameSurname = htmlspecialchars($_POST["nameSurname"]);
  $zipcodeLocation = htmlspecialchars($_POST["zipcodeLocation"]);
  $streetAddress = htmlspecialchars($_POST["streetAddress"]);
  $phoneNumber = htmlspecialchars($_POST["phoneNumber"]);
  $email = htmlspecialchars($_POST["email"]);

  if (empty($nameSurname) || empty($phoneNumber)) {
    header("Location: ../index.php");
    exit();
  }

  try {
    require_once $_SERVER['DOCUMENT_ROOT'] . '/adressbuch/pages/adodbcon.php';

    $query = "INSERT INTO addressbuch (nameSurname, zipcodeLocation, streetAddress, phoneNumber, email) VALUES (?, ?, ?, ?, ?);";

    $stmt = $db->prepare($query);

    $stmt->bind_param("sssss", $nameSurname, $zipcodeLocation, $streetAddress, $phoneNumber, $email);
    $stmt->execute();

    $db = null;
    $stmt = null;

  } catch (mysqli_sql_exception $e) {
    die("MySQLi Error: " . $e->getMessage());
  }

  header("Location: ../index.php");
} else {
  header("Location: ../index.php");
}

ADODB连接代码 #

<?php

ini_set('display_errors', '1');
ini_set('display_startup_errors', '1');
error_reporting(E_ALL);

require_once $_SERVER['DOCUMENT_ROOT'] . '/adressbuch/lib/adodb/adodb.inc.php';


$dbhost = 'localhost';
$dbusername = '***';
$dbpassword = '***';
$dbname='***';

$db = adoNewConnection('mysqli'); 
$db->debug = true;
$db->connect($dbhost, $dbusername, $dbpassword, $dbname);

错误信息 #

Fatal error: Uncaught Error: Call to a member function bind_param() on string in /var/www/ch/kxa/ygy/adressbuch/pages/formhandler.php:31 Stack trace: #0 {main} thrown in pages/formhandler.php on line 31

• 核心问题：混用了ADODB库和原生mysqli API。ADODB的prepare()方法返回的是ADODB专属语句对象，而非原生mysqli_stmt，因此无法调用原生的bind_param()方法。

• 修正步骤：

  1. 使用ADODB提供的参数绑定与执行逻辑，无需依赖原生mysqli方法。
  2. 调整错误检查逻辑，适配ADODB的错误处理机制。

修正后的formhandler.php示例：

<?php

ini_set('display_errors', '1');
ini_set('display_startup_errors', '1');
error_reporting(E_ALL);

if ($_SERVER["REQUEST_METHOD"] == "POST") {

  $nameSurname = htmlspecialchars($_POST["nameSurname"]);
  $zipcodeLocation = htmlspecialchars($_POST["zipcodeLocation"]);
  $streetAddress = htmlspecialchars($_POST["streetAddress"]);
  $phoneNumber = htmlspecialchars($_POST["phoneNumber"]);
  $email = htmlspecialchars($_POST["email"]);

  if (empty($nameSurname) || empty($phoneNumber)) {
    header("Location: ../index.php");
    exit();
  }

  try {
    require_once $_SERVER['DOCUMENT_ROOT'] . '/adressbuch/pages/adodbcon.php';

    // 检查数据库连接状态
    if (!$db->IsConnected()) {
      throw new Exception("数据库连接失败: " . $db->ErrorMsg());
    }

    $query = "INSERT INTO addressbuch (nameSurname, zipcodeLocation, streetAddress, phoneNumber, email) VALUES (?, ?, ?, ?, ?);";

    // 用ADODB的Execute方法直接传递参数数组，自动处理绑定
    $result = $db->Execute($query, array($nameSurname, $zipcodeLocation, $streetAddress, $phoneNumber, $email));

    if (!$result) {
      throw new Exception("SQL执行失败: " . $db->ErrorMsg());
    }

    $db->Close(); // 关闭ADODB连接

  } catch (Exception $e) {
    die("错误: " . $e->getMessage());
  }

  header("Location: ../index.php");
} else {
  header("Location: ../index.php");
}

• 额外说明：
  • ADODB的Execute()方法可直接接收SQL语句和参数数组，自动完成参数绑定，无需手动调用bind_param。
  • 用IsConnected()验证连接状态，ErrorMsg()获取ADODB的错误详情，替代原生mysqli的异常捕获逻辑。
  • 使用Close()方法关闭ADODB连接，而非直接赋值为null。

内容的提问来源于stack exchange，提问作者Yoshi