Expand|Select|Wrap|Line Numbers
- <?php
- //where $rory is the variable that is passed via the form with the GET action
- $page = $_GET['page']
- $rory=$_GET['rory'];
- mysql_connect("localhost","<user>","<password>") or die(mysql_error());
- mysql_select_db("<db>") or die(mysql_error());
- $limit = 10; // Change to how many results you want per page
- $query_count = "SELECT * FROM bootlist WHERE venue LIKE '%$rory%' || location LIKE '%$rory%' || cd1 LIKE '%$rory%' || cd2 LIKE '%$rory%' || date LIKE '%$rory%' ORDER BY date";
- $result_count = mysql_query($query_count);
- $totalrows = mysql_num_rows($result_count);
- if(empty($page)){
- $page = 1;
- }
- $limitvalue = $page * $limit - ($limit);
- $query = ("SELECT * FROM bootlist WHERE venue LIKE '%$rory%' || location LIKE '%$rory%' || cd1 LIKE '%$rory%' || cd2 LIKE '%$rory%' || date LIKE '%$rory%' ORDER BY date LIMIT $limitvalue, $limit");
- $result = mysql_query($query);
- $num=mysql_num_rows($result);
- if(mysql_num_rows($result) == 0){
- echo("Nothing to Display!");
- }
- while ($row = mysql_fetch_array ($result) ) {
- echo "Date: ".$row['date'];
- echo "<br>Venue: ".$row['venue'];
- echo "<br>Location: ".$row['location'];
- echo "<br>CD 1: " .$row['cd1'];
- echo "<br>CD 2: " .$row['cd2'];
- echo "<hr>";
- }
- if($page != 1){
- $pageprev = $page-1;
- echo("<a href=\"$PHP_SELF?page=$pageprev\">PREV ".$limit."</a> ");
- }else{
- echo("PREV " .$limit." ");
- }
- $numofpages = $totalrows / $limit;
- for($i = 1; $i <= $numofpages; $i++){
- if($i == $page){
- echo($i." ");
- }else{
- echo("<a href=\"$PHP_SELF?page=$i\">$i</a> ");
- }
- }
- if(($totalrows % $limit) != 0){
- if($i == $page){
- echo($i." ");
- }else{
- echo("<a href=\"$PHP_SELF?page=$i\">$i</a> ");
- }
- }
- if(($totalrows - ($limit * $page)) >=0){
- $pagenext = $page+1;
- echo(" <a href=\"$PHP_SELF?page=$pagenext\">NEXT ".$limit."</a>");
- }else{
- echo(" NEXT " .$limit);
- }
- mysql_free_result($result);
- ?>