Listing Articles for a PEAR Content Management System - After the Query is Run
(Page 4 of 4 )
The query is run and the results are stored in the $res variable as shown below.
$res = $db->query($sql);
The $res variable is tested to see if it contains any records. If it does, the while loop is called to iterate through the results array and retrieve the data:
if($res){
while ($row = $res->fetchRow(DB_FETCHMODE_OBJECT)) {
?>
The while loop then iterates through the result set and builds the dynamic table with all the data that it retrieves from the result set:
<tr>
<td class="title"><a href="view.php?sid=<?php print $row->sid?>" class="title"><?php print $row->title ?></a></td>
</tr>
It's worth noting that the title listing also provides a hyperlink that links the authart page with the view.php page. The link has a query string attached that makes a sid or story_ID available to it:
<td class="title"><a href="view.php?sid=<?php print $row->sid?>" class="title"><?php print $row->title ?></a></td>
If the $res variable does not contain any records, then the code displays a message stating exactly that:
<?php }
}else{
?>
<tr>
<td colspan="2" class="auth"><p class="auth">No articles found</p></td>
</tr>
<?php } ?>
</table>
The HTML table is then closed and the HTML for the page is also closed.
<!-- InstanceEndEditable --></td>
</tr>
<tr class="copy">
<td colspan="2">©2008</td>
</tr>
</table>
</body>
<!-- InstanceEnd --></html>
In the next article we will look at the index and delete scripts. See you next week!
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
