php - PHP 中的 SQL 查询仅在函数外有效

Question

我有以下 PHP 代码段:

function getFacilities($testName, $dbAdapter) {
  $sql1 = "SELECT * FROM facilities_db WHERE facility_name = '$testName'";
  $result1 = $dbAdapter->query($sql1);

  $facility_details = array();
  while ($row = mysqli_fetch_assoc($result1))
  {
    $facility_details[] = $row;
  }
  return $facility_details;
}

$testName = "Abraham Moss Leisure";
$facility_data = getFacilities($testName, $mysqli);

$testName 的值是任意的，仅用于测试目的。这是其中一个答案的函数，但我在初始定义中的唯一区别是没有将 $dbAdapter 作为参数。

Answer 1

您需要将 $testName 设置为参数，还需要设置您要用来连接 SGBD 的适配器(这里是 mysqli)。

function getFacilities($testName, $dbAdapter) {
    $sql1 = "SELECT * FROM facilities_db WHERE facility_name = '$testName'";
    $result1 = $dbAdapter->query($sql1);

    $facility_details = array();
    while ($row = mysqli_fetch_assoc($result1))
    {
      $facility_details[] = $row;
    }
    return $facility_details;
}

我们需要将 $testName 和 $mysqli 作为您的 dbAdapter 传递给该函数。因此，这就是我们调用该函数的方式:

$facility_data = getFacilities($testName, $dbAdapter);

希望对你有帮助，