|Sent on:||Thursday, November 20, 2008 4:35 PM|
|I'm wrestling my way into the world of mysqli, especially prepared queries. This is also my first foray into an Object Oriented approach/style.|
Here's my current roadblock that I seem to be stuck on: I am trying to create a simple, 'prepared statements'-type query (SELECT Name FROM organizations WHERE ID = ?). The only way I can get this to work is to not only use 'bind_param' (to bind a variable to the 'WHERE ID = ?' part of the query) but also use the 'bind_result' method. If I don't do this, I get no results.
I've been messing around with this so much that I no longer have a true sample to offer. But here's something close to what I've been doing (you'll notice a lot of book-type names of variables):
$mysqli = new mysqli("localhost", "me", "supersecret", "thedatabase");
// Prepare query
$stmt = $mysqli->prepare("SELECT Name FROM organizations WHERE ID=?");
$TheID = 15;
// Show results (or not!) -- why doesn't this work?
$row = $stmt->fetch_row();
// If I use bind_result, it works
print_r($NewRsult); // Yeah!
Why might this be?