<td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> --> <tr> <td colspan="5" align="center" valign="middle"><?php if($maxPage>1) { ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="35%" style="border-right:none;"> </td> <td width="40%" align="center" valign="middle" style="border-right:none;"><?php echo $pager->renderFirst('First');?> <?php echo $pager->renderPrev('Previous');?> <?php echo $pager->renderNav('<span>', '</span>');?> <?php echo $pager->renderNext('Next'); ?> <?php echo $pager->renderLast('Last'); ?></td> <td width="25%" style="border-right:none;"> </td> </tr> </table> <?php } ?> </td> <td> </td> </tr> </table> </div><p> </p> </div> </body>
*/ $rs = $pager->paginate(); if (!$rs) { die(mysql_error()); } while ($row = mysql_fetch_assoc($rs)) { echo $row['image'], "<br />\n"; } //Display the full navigation in one go echo $pager->renderFullNav(); echo "<br />\n"; /* * Or you can display the individual links for more * control over HTML rendering. * */ //Display the link to first page: First echo $pager->renderFirst(); //Display the link to previous page: << echo $pager->renderPrev(); /* * Display page links: 1 2 3 * $prefix = Will be prepended to the page link (optional) * $suffix = Will be appended to the page link (optional) * */ echo $pager->renderNav('<span>', '</span>'); //Display the link to next page: >> echo $pager->renderNext(); //Display the link to last page: Last echo $pager->renderLast();
<form action="rfqdetails.php" method="post" name="rfqdetails" id="rfqdetails"> <table border="0" width="100%" class="display" cellpadding="5" cellspacing="1" > <tr> <td colspan="5" align="right"> <?php include 'ps_pagination.php'; $conn = mysql_connect('localhost', 'root', ''); mysql_select_db('hawthorne_nittany', $conn); $currdate = date("m/d/Y"); $sql = "SELECT * FROM `admin_rfq` WHERE isvalid=1"; $result = mysql_query($sql); $pager = new PS_Pagination($conn, $sql, 20, 5); //The paginate() function returns a mysql result set $rs = $pager->paginate(); if (mysql_num_rows($result) > 20) { echo " " . $pager->renderFirst('First') . " "; //Display the link to previous page: << echo $pager->renderPrev('<<'); //Display page links: 1 2 3 echo $pager->renderNav(); //Display the link to next page: >> echo $pager->renderNext(' >>'); //Display the link to last page: Last echo " " . $pager->renderLast('Last'); } ?> </td> </tr> <tr valign="top">
<td colspan="6"><font color="#FF0000">Citation List Not Available Please Modify Your Search</font></td> </tr> <?php } ?> <tr> <td colspan="5" align="center" valign="middle"> <?php if ($maxPage > 1) { ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="35%" style="border-right:none;"> </td> <td width="40%" align="center" valign="middle" style="border-right:none;"> <?php echo $pager->renderFirst('First'); ?> <?php echo $pager->renderPrev('Previous'); ?> <?php echo $pager->renderNav('<span>', '</span>'); ?> <?php echo $pager->renderNext('Next'); ?> <?php