Display request created with stmt

I have the following code to insert a 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 request after bind_param is done? I know that I can use the echo to view and view variables:, echo "('isssss', $listID, $files, $filesize, $audio, $subtitles, $fansub)";I would like to view the request itself with the variables inside it. Is there any function that I can run on the stmt or mysqli object to display the query before it is executed, in addition to creating the echo statement itself?

+3
source share

Source: https://habr.com/ru/post/1715218/


All Articles