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> 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 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();} ?> 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 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
Archived
This topic is now archived and is closed to further replies.