Below is a snippet that involves retrieving an Article…
// Execute query.
mysqli_stmt_execute($stmt);
// Store results.
mysqli_stmt_store_result($stmt);
// Check # of Records Returned.
if (mysqli_stmt_num_rows($stmt)==1){
// 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.
mysqli_stmt_fetch($stmt);
// 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?!
Debbie