Display query created with stmt

Question

I have the following code for inserting new row into the database:

$query = "INSERT INTO files_requests VALUES (NULL, ?, ?, ?, ?, ?, ?, {$userinfo['id']}, 0, ". time() .", 0)";
    $stmt = $mysqli->prepare($query);
    $stmt->bind_param('isssss', $listID, $files, $filesize, $audio, $subtitles, $fansub);
    $stmt->execute();

Is there a way to see the query after the bind_param is done? I know I can use echo to view and see the variables: echo "('isssss', $listID, $files, $filesize, $audio, $subtitles, $fansub)"; , I would like to view the query itself with the variables inside it. Is there any function I can run on the stmt object or mysqli, to display the query before it is executed, beside create an echo statement myself?

Answer 1

Sorry, it's not possible, and this has been discussed here before a few times, check it out:

• http://stackoverflow.com/questions/1047155/how-can-i-display-the-full-text-of-a-query-created-by-pdo
• http://stackoverflow.com/questions/305179/is-there-a-way-to-see-a-prepared-query-as-it-will-be-executed-on-the-database
• http://stackoverflow.com/questions/210564/pdo-prepared-statements