Happy Codings - Programming Code Examples
Html Css Web Design Sample Codes CPlusPlus Programming Sample Codes JavaScript Programming Sample Codes C Programming Sample Codes CSharp Programming Sample Codes Java Programming Sample Codes Php Programming Sample Codes Visual Basic Programming Sample Codes

Php Programming Code Examples

Php > Site Navigation Code Examples

Navigate through records

Navigate through records <?php // Variables for navigating between previous and next record id $previd = $id-1; $nextid = $id+1; // Your database connection code $dbcnx = mysql_connect('localhost:', 'mysql','yourpass') or die("Error Occurred"); mysql_selectdb("YourDB"); $query = "SELECT * FROM yourtable WHERE id='$id'"; $result = mysql_query($query, $dbcnx); $row = mysql_fetch_array($result); // Checking and displaying data If (($id > 0) && ($id <= sizeof($row))) { echo $row['your array']; echo "<a href=\"page.php?id=$previd\">Previous</a> <a href=\"page.php?id=$nextid\">Next</a>"; } else { if ($id < 1) { echo "Beginning of Record Set"." "; echo "<a href=\"page.php?id=$nextid\">Next</a>"; } else { echo "End of Record Set"." "; echo "<a href=\"page.php?id=$previd\">Previous</a>"; } } ?>