Below is a snippet that involves retrieving an Article...
// Execute query.
// Store results.
// Check # of Records Returned.
// Article was Found.
$articleExists = TRUE;
// Bind result-set to variables.
mysqli_stmt_bind_result($stmt, $articleID, $title, $description, $keywords,
$heading, $subHeading, $publishedOn, $author,
$body, $referenceListing, $endnoteListing);
// Fetch record.
// Close prepared statement.
mysqli_stmt_close($stmt); // ????
If the Article was found, can I safely assume that there will be data in all required fields in the Results-Set above?
In other words, if something fails, can I assume that the entire process of "Bind result-set to variables" would fail?
The context of my question is really whether I need to INITIALIZE variables like "$articleID" or "$body" for fear that if the query didn't return these required fields that I would get an undefined variable error?!
I did initialize these variables since they are optional...
$subHeading = $referenceListing = $endnoteListing = '';
Hope this thread makes sense?!
Have a read thru the online php manual. In it you will see that mysqli_stmt_bind_result returns true or false. It's probably a good idea to have some "plan b code" in your code in case it returns false and execute subsequent code only if it returns true.