I have a pagination script linked to a MySQL query that I can filter. When the results are not filtered and all rows are being shown I have a next link that says "?pg=2" and so on(depending on how many results and such). Once I filter what I want shown my URL contains other parameters like ?certifications=VALUE&state=VALUE.
These lines handle my pagination links.
echo "<a href='?pg=".($pg-1)."' class='paginationButton'>PREVIOUS</a>
";
echo "<a href='?pg=".($pg+1)."' class='paginationButton'>NEXT</a>
";
I added $_SERVER['QUERY_STRING'] to each to try to add the url parameters to the links. It works BUT it also adds the ?pg parameter each time it is clicked(basically if next is clicked twice it does this ?certifications=VALUE&state=VALUE&pg=3&pg=2.
How can I make it to where if &pg is already set it does not duplicate it in the URL?
==============================================================================
FULL CODE HERE
$start=0;
$limit=3;
if(isset($_GET['pg']))
{
$pg=$_GET['pg'];
$start=($pg-1)*$limit;
}
else {
$pg = 1;
}
$sql = mysql_query($query);
$conditions = "SELECT * FROM pilotOperators WHERE 1=1";
# append condition for signage (if required)
if(isset($_GET['signage'])) {
$conditions .= " AND signage='1'";
}
# append condition for certifications (if required)
if(isset($_GET['certifications'])) {
$certifications = mysqli_real_escape_string($conn,$_GET['certifications']);
$conditions .= " AND certifications='$certifications'";
}
# append condition for state (if required)
if(isset($_GET['state'])) {
if($_GET['state'] != "Select State") {
$state = mysqli_real_escape_string($conn,$_GET['state']);
$conditions .= " AND state='$state'";
}
}
$conditions .= " Limit $start, $limit";
$result = mysqli_query($conn, $conditions);
while($row = mysqli_fetch_array($result))
{
echo "
<table border='0' class='resultTable' width='75%'>
";
echo "<tr>
";
echo "<td width='120px'>ID: </td>
";
echo "<td>" . $row['id'] . "</td>
";
echo "</tr>
";
echo "<tr>
";
echo "<td>Name: </td>
";
echo "<td>" . $row['name'] . "</td>
";
echo "</tr>
";
echo "<tr>
";
echo "<td>Phone: </td>
";
echo "<td>" . $row['phone'] . "</td>
";
echo "</tr>
";
echo "<tr>
";
echo "<td>Alt. Phone: </td>
";
echo "<td>" . $row['alt_phone'] . "</td>
";
echo "</tr>
";
echo "<tr>
";
echo "<td>Fax: </td>
";
echo "<td>" . $row['fax'] . "</td>
";
echo "</tr>
";
echo "<tr>
";
echo "<td>Email: </td>
";
echo "<td>" . $row['email'] . "</td>
";
echo "</tr>
";
echo "<tr>
";
echo "<td>Website: </td>
";
echo "<td><a href='" . $row['website'] . "' target='_blank'>" . $row['website'] . "</a></td>
";
echo "</tr>
";
echo "<tr>
";
echo "<td>City: </td>
";
echo "<td>" . $row['city'] . "</td>
";
echo "</tr>
";
echo "<tr>
";
echo "<td>State: </td>
";
echo "<td>" . $row['state'] . "</td>
";
echo "</tr>
";
echo "<tr>
";
echo "<td>Certifications: </td>
";
echo "<td>" . $row['certifications'] . "</td>
";
echo "</tr>
";
echo "<tr>
";
echo "<td>Top Sign: </td>
";
echo "<td>";
if($row['signage'] = 1) {
echo "Has Top Sign";
}
else {
echo "Top Sign Not Listed";
}
echo "</td>
";
echo "</tr>
";
echo "</table>
";
}
$countconditions = "SELECT * FROM pilotOperators WHERE 1=1";
# append condition for signage (if required)
if(isset($_GET['signage'])) {
$countconditions .= " AND signage='1'";
}
# append condition for certifications (if required)
if(isset($_GET['certifications'])) {
$certifications = mysqli_real_escape_string($conn,$_GET['certifications']);
$countconditions .= " AND certifications='$certifications'";
}
# append condition for state (if required)
if(isset($_GET['state'])) {
if($_GET['state'] != "Select State") {
$state = mysqli_real_escape_string($conn,$_GET['state']);
$countconditions .= " AND state='$state'";
}
}
$rows = mysqli_num_rows(mysqli_query($conn, $countconditions));
$total=ceil($rows/$limit);
echo "<div id='paginationLinks'>
";
if($pg>1)
{
echo "<a href='?pg=".($pg-1)."&".$_SERVER['QUERY_STRING']."' class='paginationButton'>PREVIOUS</a>
";
}
if($pg!=$total)
{
echo "<a href='?pg=".($pg+1)."&".$_SERVER['QUERY_STRING']."' class='paginationButton'>NEXT</a>
";
}
echo "<ul class='page'>
";
for($i=1;$i<=$total;$i++)
{
if($i==$pg) { echo "<li class='current'>".$i."</li>
"; }
else { echo "<li><a href='?id=".$i."'>".$i."</a></li>
"; }
}
echo "</ul>
";
echo "</div>
";
mysqli_close($con);
