How Do I See The Final Text Of A Query Resulting From A Call To mysqli->prepare?
- by Joshua
After code like this:
$stmt = $mysqli->prepare("SELECT District FROM City WHERE Name=?")) {
$stmt->bind_param("s", $city);
$stmt->execute();
$stmt->bind_result($district);
$stmt->fetch();
printf("%s is in district %s\n", $city, $district);
How Do I See The Actual SQL Statement That Was Executed?
(It Should Look Something Like "SELECT District FROM City WHERE Name='Simi Valley';")
I already realize that in this simplistic case it would be very easy to simply reconstruct the query... but how can I access it in a general way that will work for very complicated prepared statements, and cases where I don't necessarily already understand the intended structure of the query, etc. Isn't there some function or method that can be called on the statement object that will return the actual text of the SQL query, after binding?
