php - 在网页上显示 PHP/SQL 查询以进行调试

Question

我正在开发基于 PHP/MYSQL 的数据库。当查询不工作时，通常在调试期间我认为如果我能看到处理过的查询会很有帮助。因为可能有问题的处理查询与我编码的查询不同。如何查看已处理的查询？这是我简化的 php Controller 代码:

<?php
$patientid = "3";
$patientname = "Khan";
$patientcity = "Osaka";
$Result = mysqli_query($link, 'SELECT id, name, city FROM patient-table WHERE id= '".$patientid."' ');
If(!$Result){
   echo 'An error was encountered during fetching patient's data, error details: '. mysqli_error($link);
}
//Code for displaying results of query
?>

任何帮助将不胜感激。谢谢。

Answer 1

为什么不将其分配为简单变量？

<?php
$patientid = "3";
$patientname = "Khan";
$patientcity = "Osaka";
$query = 'SELECT id, name, city FROM patient-table WHERE id= '".$patientid."' ';
$Result = mysqli_query($link, $query);
If(!$Result){
   echo 'An error was encountered during fetching patients data using query, '.$query.' , error details: '. mysqli_error($link);
}
//Code for displaying results of query
?>