DarkPrince2005 Posted August 23, 2008 Share Posted August 23, 2008 Does anyone know how i can add a nice image/background to my pagination links? $sql = "SELECT COUNT(*) FROM tbl_product where product_manufacturer like '$_GET[product_manufacturer]' and category_id like '$_GET[category_id]'"; $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR); $r = mysql_fetch_row($result); $numrows = $r[0]; // number of rows to show per page $rowsperpage = 4; // find out total pages $totalpages = ceil($numrows / $rowsperpage); // get the current page or set a default if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) { // cast var as int $currentpage = (int) $_GET['currentpage']; } else { // default page num $currentpage = 1; } // end if // if current page is greater than total pages... if ($currentpage > $totalpages) { // set current page to last page $currentpage = $totalpages; } // end if // if current page is less than first page... if ($currentpage < 1) { // set current page to first page $currentpage = 1; } // end if // the offset of the list, based on current page $offset = ($currentpage - 1) * $rowsperpage; // get the info from the db $sql = "SELECT * FROM tbl_product where product_manufacturer like '$_GET[product_manufacturer]' and category_id like '$_GET[category_id]' LIMIT $offset, $rowsperpage"; $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR); $color1 = "#BAC6E3"; $color2 = "#FFFFFF"; $row_count = 0; // while there are rows to be fetched... while ($row = mysql_fetch_assoc($result)) { $row_color = ($row_count % 2) ? $color1 : $color2; // echo data echo "<tr bgcolor='$row_color'><td valign='center' align='center' width='250' height='90'><form action='' method='post' name='prod'><input type='hidden' name='product_id' value='$row[product_id]'><input type='image' src='$row[product_image]' border='0' alt='$row[product_name]' width='30%' onclick=\"this.form.action='product_details.php?product_id=$row[product_id]';\"></td> <td valign='top'><input type='hidden' name='product_name' value='$row[product_name]'><a href=\"product_details.php?product_id=$row[product_id]\">$row[product_name]</a><br><small><input type='hidden' name='product_price' value='$row[product_price]'>R $row[product_price]</small></td> <td> </td> <td> </td> <td valign='center'><input type='image' src='images/details.gif' value='View Details' alt='View Details' onclick=\"this.form.action='product_details.php?product_id=$row[product_id]';\"><br> <input type='image' src='images/placeorder.gif' value='Order' alt='Order' onclick=\"this.form.action='2.php';\"><br> <input type='hidden' name='qty' value='1'> <input type='image' src='images/addtocart.gif' value='Add To Cart' alt='Add To Cart' onclick=\"this.form.action='modcart.php?action=add';\"></td> </tr></form>"; $row_count++; } // end while echo " <tr> <td colspan='5' align='center' valign='bottom'>"; /****** build the pagination links ******/ // range of num links to show $range = 3; // if not on page 1, don't show back links if ($currentpage > 1) { // show << link to go back to page 1 echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1&product_manufacturer={$_GET['product_manufacturer']}&category_id={$_GET['category_id']}'><<</a> "; // get previous page num $prevpage = $currentpage - 1; // show < link to go back to 1 page echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage&product_manufacturer={$_GET['product_manufacturer']}&category_id={$_GET['category_id']}'><</a> "; } // end if // loop to show links to range of pages around current page for ($x = (($currentpage - $range) - 1); $x < (($currentpage + $range) + 1); $x++) { // if it's a valid page number... if (($x > 0) && ($x <= $totalpages)) { // if we're on current page... if ($x == $currentpage) { // 'highlight' it but don't make a link echo " [<b>$x</b>] "; // if not current page... } else { // make it a link echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x&product_manufacturer={$_GET['product_manufacturer']}&category_id={$_GET['category_id']}'>$x</a> "; } // end else } // end if } // end for // if not on last page, show forward and last page links if ($currentpage != $totalpages) { // get next page $nextpage = $currentpage + 1; // echo forward link for next page echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage&product_manufacturer={$_GET['product_manufacturer']}&category_id={$_GET['category_id']}'>></a> "; // echo forward link for lastpage echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages&product_manufacturer={$_GET['product_manufacturer']}&category_id={$_GET['category_id']}'>>></a> "; } // end if /****** end build pagination links ******/ Link to comment https://forums.phpfreaks.com/topic/120988-setting-an-imagebackground-to-pagination-links/ Share on other sites More sharing options...
s1yman Posted August 23, 2008 Share Posted August 23, 2008 Can't you just do; print '<body background="image.jpg">'; ? Link to comment https://forums.phpfreaks.com/topic/120988-setting-an-imagebackground-to-pagination-links/#findComment-623708 Share on other sites More sharing options...
DeanWhitehouse Posted August 23, 2008 Share Posted August 23, 2008 or add some CSS to it. Link to comment https://forums.phpfreaks.com/topic/120988-setting-an-imagebackground-to-pagination-links/#findComment-623805 Share on other sites More sharing options...
Minty Posted August 23, 2008 Share Posted August 23, 2008 You could use a dynamic stylesheet (i.e. a PHP page which outputs a valid CSS. Link to comment https://forums.phpfreaks.com/topic/120988-setting-an-imagebackground-to-pagination-links/#findComment-623881 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.