Hi,
I would like some help adding the javascript below to the php code below, where it's marked as <!-- Insert Javascript Here !--> scroll to the bottom of the php code, and it will be right near the bottom.
Javascript Code to be added to the php code below (don't forget where it needs to go) see above:
Code:
<script type="text/javascript"><!--
zone = "21";
url = "http://www.reunitemysite.com/scripts/amp";
//--></script>
<script type="text/javascript" src="http://www.reunitemysite.com/scripts/amp/show.js"></script>
PHP Code:
<html>
<head><title> Shopping Index - 1024 x 768 Pixel Banner Ads</title>
<link rel="stylesheet" type="text/css" href="/css/default.css" media="screen" />
<link rel="stylesheet" type="text/css" href="/css/pagination.css" media="screen" />
</head>
<body>
<style>
/* Body of Website */
body {
width: 97%;
background-color: #b2d2e3;
border-style: solid;
border-width: 1px;
border-color: black;
text-align: center;
margin-left: auto;
margin-right: auto;
font-family:Tahoma, Geneva, sans-serif;
}
/* Gradient Background */
.gradient {
width: 100%;
background: #c5deea; /* old browsers */
background: -moz-linear-gradient(top, #c5deea 0%, #8abbd7 31%, #066dab 100%); /* firefox */
background: -webkit-gradient(linear, left top, left bottom, color-stop(0%,#c5deea), color-stop(31%,#8abbd7), color-stop(100%,#066dab)); /* webkit */
filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#c5deea', endColorstr='#066dab',GradientType=0 ); /* ie */
margin: 0px auto;
}
</style>
<div class="gradient">
<table width="100%">
<td>
<div><a href="http://www.reunitemysite.com/advertisements/premium/banners/">Return to Category Index</div></td>
<td align="right">
<div><a href="http://www.reunitemysite.com/advertisements/premium/banners/shopping.php">Return to 468 x 60 pixel Shopping Banners</div></td>
</table>
<div class="pagination white">
<!-- The Following Php Code is the pagination script, which will create pages based on the number of banners in the database. Ex: 2 columns (across) x 5 Rows (down) the page -->
<?php
/* Include your code to connect to DB. */
include('config.php');
/* Your DB table name */
$tbl_name="amp_ads";
// How many adjacent pages should be shown on each side?
$adjacents = 1;
/*
First get total number of rows in data table.
If you have a WHERE clause in your query, make sure you mirror it here.
*/
$query = "SELECT COUNT(*) as num FROM $tbl_name WHERE ad_type = '1' LIMIT 1";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];
/* Setup vars for query. */
$targetpage = "1024x768.php"; //your file name (the name of this file)
$limit = 1; //how many items to show per page
$page = $_GET['page'];
if($page)
$st = ($page - 1) * $limit; //first item to display on this page
else
$st = 0; //if no page var is given, set st to 0
/* Get data. */
$sql = "SELECT remote_banner FROM $tbl_name LIMIT $st, $limit";
$result = mysql_query($sql);
/* Setup page vars for display. */
if ($page == 0) $page = 1; //if no page var is given, default to 1.
$prev = $page - 1; //previous page is page - 1
$next = $page + 1; //next page is page + 1
$lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up.
$lpm1 = $lastpage - 1; //last page minus 1
/*
Now we apply our rules and draw the pagination object.
We're actually saving the code to a variable in case we want to draw it more than once.
*/
$pagination = "";
if($lastpage > 1)
{
$pagination .= "";
//previous button
if ($page > 1)
$pagination.= "<a href=\"$targetpage?page=$prev\" class=\"current\"> previous </a>";
else
$pagination.= "<span class=\"disabled\"> previous </span>";
//pages
if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"number\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\" class=\"number current\">$counter</a>";
}
}
elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some
{
//close to beginning; only hide later pages
if($page < 1 + ($adjacents * 2))
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"number\">$counter </span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\" class=\"number current\">$counter</a>";
}
$pagination.= "<span class=\"dots\">...</span>";
$pagination.= "<a href=\"$targetpage?page=$lpm1\" class=\"number\">$lpm1</a>";
$pagination.= "<a href=\"$targetpage?page=$lastpage\" class=\"number current\">$lastpage</a>";
}
//in middle; hide some front and some back
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
$pagination.= "<a href=\"$targetpage?page=1\" class=\"number\">1</a>";
$pagination.= "<a href=\"$targetpage?page=2\" class=\"number\">2</a>";
$pagination.= "<span class=\"dots\">...</span>";
for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"number\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\" class=\"number current\">$counter</ a>";
}
$pagination.= "<span class=\"dots\">...</span>";
$pagination.= "<a href=\"$targetpage?page=$lpm1\" class=\"number\">$lpm1</a>";
$pagination.= "<a href=\"$targetpage?page=$lastpage\" class=\"number current\">$lastpage</a>";
}
//close to end; only hide early pages
else
{
$pagination.= "<a href=\"$targetpage?page=1\" class=\"number\">1</a>";
$pagination.= "<a href=\"$targetpage?page=2\" class=\"number\">2</a>";
$pagination.= "<span class=\"dots\">...</span>";
for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"number\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\" class=\"number current\">$counter</a>";
}
}
}
//next button
if ($page < $counter - 1)
$pagination.= "<a href=\"$targetpage?page=$next\" class=\"number current\"> next </a>";
else
$pagination.= "<span class=\"disabled\"> next </span>";
$pagination.= "</div>\n";
}
// End of Pagination Script //
?>
<!-- Table Output Code -->
<?php
$result = mysql_query("SELECT * FROM amp_ads WHERE ad_type = '1' LIMIT 1") or die(mysql_error());
$numCols = 2;
$numPerCol = ceil(mysql_num_rows($result) / $numCols);
echo "<table valign=\"top\"><tr>";
for($col = 1; $col <= $numCols; $col++) {
echo "<td valign=\"top\">";
for($row = 0; $row < $numPerCol; $row++) {
$resultRow = mysql_fetch_assoc($result);
if($resultRow == false) {
break;
}
<!-- Insert Javascript Here !-->
}
echo "</td>";
}
echo "</tr></table>";
?>
<?=$pagination?>
</div>
</body>
</html>
__________________
Made2Own
Last edited by Brian07002; 04-12-2011 at 02:48 PM..
|
