ZandarGlass Posted November 6, 2013 Share Posted November 6, 2013 I'm learning how to use PHP and prepared statements with mysqli/php and can't seem to get this code to output data. I get no error messages, just nothing output. This is the complete code, it's rather simple, created from an example I found online. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head> <title>Untitled</title></head><body><?phprequire_once('/includes/conn.inc.php');$conn = dbConnect('read');$stmt = $conn->stmt_init(); // Create a prepared statementif($stmt->prepare("SELECT 'name' FROM comments WHERE 'approved' = ?")) { // Bind your variable to replace the ? $stmt->bind_param('s', $approved); // Set your variable $approved = "Y"; // Execute query $stmt->execute(); // Bind your result columns to variables $stmt->bind_result($name); // Fetch the result of the query while($stmt->fetch()) { echo $name . ' - ' . "found"; // John Doe - Unknown... } // Close statement object $stmt->close();} ?></body></html> Quote Link to comment https://forums.phpfreaks.com/topic/283665-prepared-statement-not-providing-data/ Share on other sites More sharing options...
Barand Posted November 6, 2013 Share Posted November 6, 2013 Don't put column names in quotes, it treats them as a string value if you do Quote Link to comment https://forums.phpfreaks.com/topic/283665-prepared-statement-not-providing-data/#findComment-1457254 Share on other sites More sharing options...
ZandarGlass Posted November 6, 2013 Author Share Posted November 6, 2013 Thanks for the response Barand. I took them out, I still get nothing. New code below. <?phprequire_once('/includes/conn.inc.php');$conn = dbConnect('read');$stmt = $conn->stmt_init(); // Create a prepared statementif($stmt->prepare("SELECT name FROM comments WHERE approved = ?")) { // Bind your variable to replace the ? $stmt->bind_param('s', $approved); // Set your variable $approved = "Y"; // Execute query $stmt->execute(); // Bind your result columns to variables $stmt->bind_result($name); // Fetch the result of the query while($stmt->fetch()) { echo $name . ' - ' . "found"; // John Doe - Unknown... } // Close statement object $stmt->close();} ?> Quote Link to comment https://forums.phpfreaks.com/topic/283665-prepared-statement-not-providing-data/#findComment-1457261 Share on other sites More sharing options...
Barand Posted November 6, 2013 Share Posted November 6, 2013 Check the value of $conn->error after executing the query Quote Link to comment https://forums.phpfreaks.com/topic/283665-prepared-statement-not-providing-data/#findComment-1457270 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.