How to display PDO statement query in PHP



https://stackoverflow.com/questions/2303972/how-can-i-view-the-contents-of-a-prepared-statement


First We need to Add this class in the project

https://github.com/noahheck/E_mysqli



$mysqli = new E_mysqli($dbHost, $dbUser, $dbPass, $dbName);

$query = "INSERT INTO registration SET name = ?, email = ?";

$stmt = $mysqli->prepare($query);

$stmt->bind_param("ss", $_POST['name'], $_POST['email']);

$stmt->execute();

echo $stmt->fullQuery;
would result in:

INSERT INTO registration SET name = 'John Doe', email = 'john.doe@example.com'






No comments:

Post a Comment

Pages