What is the best way to display all SQL queries in a PHP script?

When working with PHP scripts that interact with a database using SQL queries, it can be helpful to display all the SQL queries being executed for debugging or troubleshooting purposes. One way to achieve this is by using a function like `mysqli_error()` to capture and display any errors that occur during query execution. Another approach is to use a logging tool or function to store all queries in a log file for later review. Additionally, you can manually echo or print out each query before executing it to see the exact SQL statement being sent to the database. 

// Enable error reporting and display errors
error_reporting(E_ALL);
ini_set('display_errors', 1);

// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Example SQL query
$sql = "SELECT * FROM table_name WHERE column = 'value'";

// Display SQL query
echo "SQL Query: " . $sql . "<br>";

// Execute SQL query
$result = $conn->query($sql);

// Check for errors
if (!$result) {
    echo "Error: " . $conn->error;
}

// Display results or do something with the data

// Close the connection
$conn->close();

Keywords

PHP SQL queries debugging display logging

Related Questions