[RESOLVED] cut my page up into more than one page

**c_owl** · May 31st, 2010, 04:39 PM

hi
im wanting to cut my search page up to cut down on memory use. can anyone help

so instead of one page i have more than one page like google when a search is done

PHP Code:


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">



<html>

<head>

    <title>My Videos Site</title>

    <link rel="stylesheet" href="style.css" type="text/css" media="screen" />

</head>

<body>

<div id="mainwrap">

    <?php include("header.php"); ?>

    <?php include("leftnav.php"); ?>

    <div id="contentwrap">

        <div id="breadcrumb">

            <a href="#">Home</a> :: <a href="#">Category</a> :: This Page

        </div>

        <div id="content">

            <h2>



</style>

  </head>

 <table border="1" width="62%" height="126" BORDERCOLOR=white>



<?php

/* Change next two lines */

$db="vdidb";

$link = mysql_connect(server:port, 'user', 'login');

if (! $link)

die(mysql_error());

mysql_select_db($db , $link)

or die("Couldn't open $db: ".mysql_error());

 $id = "%".$_GET["search"]."%";



$result = mysql_query( "SELECT vidnumber, titleid, hd, year,starring1,videotitle,starring2, directedby, filmplot1,dirid,starrid1,starrid2, trilogy,age, Runningtime,WantToWatch FROM videolist WHERE WantToWatch LIKE '".mysql_real_escape_string("True")."'")



 or die(mysql_error());

while($row = mysql_fetch_array($result)){

//  echo $row['videotitle'];

               $num_rows = mysql_num_rows($result);



   //  <td><?php echo $row['vidnubmer']; ?></td>



 <td width="20%" rowspan="4" height="120" BORDERCOLOR=white><p align="center"><img border=0 src="/vidpics/<?php echo $row['videotitle'];?>web.jpg" <?php</p></td>

    <td width="20%" height="19" BORDERCOLOR=white><p align="center">ID:<?php echo $row['vidnumber']; ?></td>

    <td width="60%" colspan="3" height="19" BORDERCOLOR=white><p align="center"><b><?php echo $row['videotitle']; ?></b></td>

</tr>

<tr>

  <td width="20%" height="14" BORDERCOLOR=white><p align="center"><a href="http://imdb.com/title/<?php echo $row['titleid']; ?>" target="_top"><?php echo $row['titleid']; ?></a></td>

    <td width="20%" height="14" BORDERCOLOR=white><p align="center">Age <?php echo $row['age']; ?></td>

    <td width="20%" height="14" BORDERCOLOR=white><p align="center"><?php echo $row['year']; ?></td>

    <td width="20%" height="14" BORDERCOLOR=white><p align="center"><?php echo $row['Runningtime']; ?>mins</td>

</tr>

<tr>

  <td width="20%" height="25" BORDERCOLOR=white><p align="center"><a href="http://imdb.com/name/<?php echo $row['dirid']; ?>" target="_top"><?php echo $row['directedby']; ?></td>

    <td width="20%" height="25" BORDERCOLOR=white><p align="center"><a href="http://imdb.com/name/<?php echo $row['starrid1']; ?>" target="_top"><?php echo $row['starring1']; ?></td>

    <td width="20%" height="25" BORDERCOLOR=white><p align="center"><a href="http://imdb.com/name/<?php echo $row['starrid2']; ?>" target="_top"><?php echo $row['starring2']; ?></td>

    <td width="20%" height="25" BORDERCOLOR=white><p align="center"><?php echo $row['hd']; ?></td>

</tr>

<tr>

  <td width="80%" height="38" colspan="4" BORDERCOLOR=white><?php echo $row['filmplot1']; ?></td>

  </tr>

<tr>

  <td width="80%" height="38" colspan="5" BORDERCOLOR=white><p align="center">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p></td>



 </tr>

      <?php



  }

?>



</table>

       <p align="center">There are <?php echo $num_rows ?> videos from result.</p><P>

**kows** · May 31st, 2010, 07:28 PM

what you're thinking of is called pagination. you can take a look at a post made by visualAd about it here. and this is a search for pagination on this forum, if you want some more to read about.

**c_owl** · Jun 7th, 2010, 01:07 PM

hi all
i have had not internet access all week what fun

any ways i found a example to play around with and better understand pagination but now im stuck can someone please look at my code below as it dont create the page.. i think i may have missed somthing somewere

PHP Code:


<html>

<head><title>Display Records</title>

 <style type="text/css">

td {font-family: tahoma, arial, verdana; font-size: 10pt }

</style>





</head>

<body>

<? // database connection info

  $conn = mysql_connect('localhost','user','password') or trigger_error("SQL", E_USER_ERROR);

  $db = mysql_select_db('vdidb',$conn) or trigger_error("SQL", E_USER_ERROR);



  // find out how many rows are in the table

   $sql = "SELECT COUNT(*) FROM videolist";

   $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 = 200;

  // 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 VidNumber, videotitle FROM videolist LIMIT $offset, $rowsperpage";

     $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);



     // while there are rows to be fetched...

     while ($list = mysql_fetch_assoc($result)) {

        // echo data

         echo $list['vidnumber'] . " : " . $list['videotitle'] . "<br />";

     } // end while

   

   /******  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'><<</a> ";

       // get previous page num

       $prevpage = $currentpage - 1;

          // show < link to go back to 1 page

           echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";

           } // end if

   

          // loop to show links to range of pages around current page

          for ($x = ($currentpage - $range); $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'>$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'>></a> ";

              // echo forward link for lastpage

               echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";

               } // end if

/****** end build pagination links ******/

?>

   </body>

</html>

**kows** · Jun 7th, 2010, 06:41 PM

what do you mean, it doesn't create the page? do you get an error? does nothing show up at all?

**c_owl** · Jun 8th, 2010, 05:41 AM

when i try to run the page i get the below in the webpage and not the list of videos from mysql

PHP Code:


// 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 VidNumber, videotitle FROM videolist LIMIT $offset, $rowsperpage"; 

     $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR); 



     // while there are rows to be fetched... 

     while ($list = mysql_fetch_assoc($result)) { 

        // echo data 

         echo $list['vidnumber'] . " : " . $list['videotitle'] . "<br />"; 

     } // end while 

    

   /******  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'><<</a> "; 

       // get previous page num 

       $prevpage = $currentpage - 1; 

          // show < link to go back to 1 page 

           echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> "; 

           } // end if 

    

          // loop to show links to range of pages around current page 

          for ($x = ($currentpage - $range); $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'>$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'>></a> "; 

              // echo forward link for lastpage 

               echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> "; 

               } // end if 

/****** end build pagination links ******/ 

?> 

   </body> 

</html> 

__________________

**kows** · Jun 8th, 2010, 09:03 AM

don't use short tags. they are deprecated and usually disabled. use regular PHP tags:

PHP Code:


<?php

  //your PHP code

?>

**c_owl** · Jun 8th, 2010, 10:02 AM

hi i have now taken out all the tags but still having the same problem

PHP Code:


<html>

<head><title>Display Records</title>

 <style type="text/css">

td {font-family: tahoma, arial, verdana; font-size: 10pt }

</style>





</head>

<body>

<?

  $conn = mysql_connect('localhost','user','password') or trigger_error("SQL", E_USER_ERROR);

  $db = mysql_select_db('vdidb',$conn) or trigger_error("SQL", E_USER_ERROR);



   $sql = "SELECT COUNT(*) FROM videolist";

   $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

   $r = mysql_fetch_row($result);

   $numrows = $r[0];

   

$rowsperpage = 200;

  $totalpages = ceil($numrows / $rowsperpage);



  if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {

    $currentpage = (int) $_GET['currentpage'];

     } else {

        $currentpage = 1;

     }



     

  if ($currentpage > $totalpages){

     $currentpage = $totalpages

       }

      if ($currentpage < 1) {

          $currentpage = 1;

         }

      $offset = ($currentpage - 1) * $rowsperpage;

      

     $sql = "SELECT VidNumber, videotitle FROM videolist LIMIT $offset, $rowsperpage";

     $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);



    while ($list = mysql_fetch_assoc($result)) {

       echo $list['vidnumber'] . " : " . $list['videotitle'] . "<br />";

     }





 $range = 3;

   

   if ($currentpage > 1) {

    echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'><<</a> ";

      $prevpage = $currentpage - 1;

           echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";

           }

          for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {

            if (($x > 0) && ($x <= $totalpages)) {

                 if ($x == $currentpage) {

                         echo " [<b>$x</b>] ";

                              } else {

                      echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";

                       }

                  }



            }



   

  if ($currentpage != $totalpages) {

      $nextpage = $currentpage + 1;

         echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> ";

             echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";

               }



?>

   </body>

</html>

**kows** · Jun 8th, 2010, 10:04 AM

.. no, you haven't. this is a short tag:

PHP Code:

<?

you're using them. use the normal tags as I said in my last post.

**c_owl** · Jun 8th, 2010, 01:44 PM

changed it to below and got it working after playing around a little with other stuff on there

thanks kows

Code:

<?php

  //your PHP code

?>

**c_owl** · Jun 8th, 2010, 03:41 PM

finished code if anyone want to use it

PHP Code:


<html>

<head><title>Display Records</title>

 <style type="text/css">

td {font-family: tahoma, arial, verdana; font-size: 10pt }

</style>





</head>

<body>

     <?php

  $conn = mysql_connect('localhost','user','password') or trigger_error("SQL", E_USER_ERROR);

  $db = mysql_select_db('vdidb',$conn) or trigger_error("SQL", E_USER_ERROR);



   $sql = "SELECT COUNT(*) FROM videolist";

   $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

   $r = mysql_fetch_row($result);

   $numrows = $r[0];

   

$rowsperpage = 50;

  $totalpages = ceil($numrows / $rowsperpage);



  if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {

    $currentpage = (int) $_GET['currentpage'];

     } else {

        $currentpage = 1;

     }



     

  if ($currentpage > $totalpages){

     $currentpage = $totalpages;

     }

     

      if ($currentpage < 1) {

          $currentpage = 1;

         }

      $offset = ($currentpage - 1) * $rowsperpage;

      

     $sql = "SELECT vidnumber, videotitle FROM videolist LIMIT $offset, $rowsperpage";

     $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);



    while ($list = mysql_fetch_assoc($result)) {

       echo $list['vidnumber'] . " : " . $list['videotitle'] . "<br />";

     }





 $range = 3;

   

   if ($currentpage > 1) {

    echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'><<</a> ";

      $prevpage = $currentpage - 1;

           echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";

           }

          for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {

            if (($x > 0) && ($x <= $totalpages)) {

                 if ($x == $currentpage) {

                         echo " [<b>$x</b>] ";

                              } else {

                      echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";

                       }

                  }



            }



   

  if ($currentpage != $totalpages) {

      $nextpage = $currentpage + 1;

         echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> ";

             echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";

               }

    ?>



   </body>

</html>

**c_owl** · Jun 8th, 2010, 05:59 PM

hi
im wanting to add a search query to my page how can i do this please

below is my search query without page split i use on my site

PHP Code:


$id = "%".$_GET["search"]."%";





$result = mysql_query( "SELECT videotitle, vidnumber, titleid, hd, year,starring1,starring2, directedby, filmplot1,dirid,starrid1,starrid2, trilogy,age, Runningtime FROM videolist WHERE videotitle LIKE '".mysql_real_escape_string($id)."'")



 or die(mysql_error());

while($row = mysql_fetch_array($result)){

below is the query use for when splitting pages and adding links

PHP Code:


$sql = "SELECT vidnumber, titleid, hd, year,starring1,videotitle,starring2, directedby, filmplot1,dirid,starrid1,starrid2, trilogy,age, Runningtime,WantToWatch FROM videolist LIMIT $offset, $rowsperpage" ;

     $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

                     $num_rows = mysql_num_rows($result);

     // while there are rows to be fetched...

     while ($row = mysql_fetch_assoc($result)) {

i just need to merge these two together so i can have best of both worlds

**TheBigB** · Jun 8th, 2010, 06:07 PM

You can use the new one you're using and add "WHERE videotitle LIKE ..." before the LIMIT statement.

PHP Code:


$sql = "SELECT vidnumber, titleid, hd, year,starring1,videotitle,starring2, directedby, filmplot1,dirid,starrid1,starrid2, trilogy,age, Runningtime,WantToWatch FROM videolist WHERE videotitle LIKE '".mysql_real_escape_string($id)."' LIMIT $offset, $rowsperpage";

Also I don't know how many columns you have in the table but you might want to consider just using SELECT * FROM.
If you spare something like only 4 or 5 rows it's actually overhead for the database engine.

**c_owl** · Jun 9th, 2010, 05:51 AM

hi
thanks for that, i now have a problem with pagination part.
its not working with the search bit... im stuck

PHP Code:


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">



<html>

<head>

    <title>My Videos Site</title>

    <link rel="stylesheet" href="style.css" type="text/css" media="screen" />

</head>

<body>

<div id="mainwrap">

    <?php include("header.php"); ?>

    <?php include("leftnav.php"); ?>

    <div id="contentwrap">

        <div id="breadcrumb">

        <a href="#">Home</a> :: Main Title Page        </div>

        <div id="content">

            <h2>



</style>

  </head>

 <table border="1" width="62%" height="126" BORDERCOLOR=white>



<?php

$conn = mysql_connect('localhost','user','password') or trigger_error("SQL", E_USER_ERROR);

  $db = mysql_select_db('vdidb',$conn) or trigger_error("SQL", E_USER_ERROR);



  // find out how many rows are in the table

    $sql = "SELECT COUNT(*) FROM videolist";



   $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 = 5;

  // 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

     

     

     $id = "%".$_GET["search"]."%";



     $sql = "SELECT vidnumber, titleid, hd, year,starring1,videotitle,starring2, directedby, filmplot1,dirid,starrid1,starrid2, trilogy,age, Runningtime,WantToWatch FROM videolist WHERE videotitle LIKE '".mysql_real_escape_string($id)."' LIMIT $offset, $rowsperpage";

     $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);



     // while there are rows to be fetched...

     while ($row = mysql_fetch_assoc($result)) {



   //  <td><?php echo $row['vidnubmer']; ?></td>



 <td width="20%" rowspan="4" height="120" BORDERCOLOR=white><p align="center"><img border=0 src="/vidpics/<?php echo $row['videotitle'];?>web.jpg" <?php</p></td>

    <td width="20%" height="19" BORDERCOLOR=white><p align="center">ID:<?php echo $row['vidnumber']; ?></td>

    <td width="60%" colspan="3" height="19" BORDERCOLOR=white><p align="center"><b><?php echo $row['videotitle']; ?></b></td>

</tr>

<tr>

  <td width="20%" height="14" BORDERCOLOR=white><p align="center"><a href="http://imdb.com/title/<?php echo $row['titleid']; ?>" target="_top"><?php echo $row['titleid']; ?></a></td>

    <td width="20%" height="14" BORDERCOLOR=white><p align="center">Age <?php echo $row['age']; ?></td>

    <td width="20%" height="14" BORDERCOLOR=white><p align="center"><?php echo $row['year']; ?></td>

    <td width="20%" height="14" BORDERCOLOR=white><p align="center"><?php echo $row['Runningtime']; ?>mins</td>

</tr>

<tr>

  <td width="20%" height="25" BORDERCOLOR=white><p align="center"><a href="http://imdb.com/name/<?php echo $row['dirid']; ?>" target="_top"><?php echo $row['directedby']; ?></td>

    <td width="20%" height="25" BORDERCOLOR=white><p align="center"><a href="http://imdb.com/name/<?php echo $row['starrid1']; ?>" target="_top"><?php echo $row['starring1']; ?></td>

    <td width="20%" height="25" BORDERCOLOR=white><p align="center"><a href="http://imdb.com/name/<?php echo $row['starrid2']; ?>" target="_top"><?php echo $row['starring2']; ?></td>

    <td width="20%" height="25" BORDERCOLOR=white><p align="center"><?php echo $row['hd']; ?></td>

</tr>

<tr>

  <td width="80%" height="38" colspan="4" BORDERCOLOR=white><?php echo $row['filmplot1']; ?></td>

  </tr>

<tr>

  <td width="80%" height="38" colspan="5" BORDERCOLOR=white><p align="center">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p></td>



 </tr>

      <?php



  }

?>



</table>



  <?php

 /******  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'><<</a> ";

       // get previous page num

       $prevpage = $currentpage - 1;

          // show < link to go back to 1 page

           echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";

           }

           // end if



          // loop to show links to range of pages around current page

          for ($x = ($currentpage - $range); $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'>$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'>></a> ";

              // echo forward link for lastpage

               echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";

               }

                // end if

/****** end build pagination links ******/

?>

   </body>

</html>

**TheBigB** · Jun 9th, 2010, 07:54 AM

Although I can't spot any error in the query... Try this

PHP Code:


$id = (isset($_GET['search'])) ? "%" . $_GET["search"] . "%" : "%";
$sql = "SELECT vidnumber, titleid, hd, year,starring1,videotitle,starring2, directedby, filmplot1,dirid,starrid1,starrid2, trilogy,age, Runningtime,WantToWatch FROM videolist WHERE videotitle LIKE '".mysql_real_escape_string($id)."' LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

Alternatively you can try this:

PHP Code:


$id = (isset($_GET['search'])) ? "%" . $_GET["search"] . "%" : "%";
$sql = "SELECT * FROM `videolist` WHERE `videotitle` LIKE '".mysql_real_escape_string($id)."' LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

**c_owl** · Jun 9th, 2010, 11:27 AM

hi
still no look with the pagination part.
i did notice at the top of my page there is a total count below

PHP Code:


  $sql = "SELECT COUNT(*) FROM videolist";



   $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

   $r = mysql_fetch_row($result);

should this also include somthing like the select code below

PHP Code:


$id = (isset($_GET['search'])) ? "%" . $_GET["search"] . "%" : "%";

$sql = "SELECT vidnumber, titleid, hd, year,starring1,videotitle,starring2, directedby, filmplot1,dirid,starrid1,starrid2, trilogy,age, Runningtime,WantToWatch FROM videolist WHERE videotitle LIKE '".mysql_real_escape_string($id)."' LIMIT $offset, $rowsperpage";

$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

**kows** · Jun 9th, 2010, 11:32 AM

the COUNT(*) query should have the same WHERE clause as the other query. because you only define $id later on, move the declaration of $id more near the top of the script.

**c_owl** · Jun 9th, 2010, 12:03 PM

i have now moved it to the top so both searches use it but still having a problem with the page split

PHP Code:


    $sql = "SELECT COUNT(*) FROM videolist WHERE videotitle LIKE '".mysql_real_escape_string($id)."'";

 $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

   $r = mysql_fetch_row($result);

i dont think the above bit is working correctly, have i done it right

PHP Code:


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">



<html>

<head>

    <title>My Videos Site</title>

    <link rel="stylesheet" href="style.css" type="text/css" media="screen" />

</head>

<body>

<div id="mainwrap">

    <?php include("header.php"); ?>

    <?php include("leftnav.php"); ?>

    <div id="contentwrap">

        <div id="breadcrumb">

        <a href="#">Home</a> :: Main Title Page        </div>

        <div id="content">

            <h2>



</style>

  </head>

 <table border="1" width="62%" height="126" BORDERCOLOR=white>



<?php

$conn = mysql_connect('localhost','user','userpas') or trigger_error("SQL", E_USER_ERROR);

  $db = mysql_select_db('vdidb',$conn) or trigger_error("SQL", E_USER_ERROR);

    $id = "%".$_GET["search"]."%";

  // find out how many rows are in the table

    $sql = "SELECT COUNT(*) FROM videolist WHERE videotitle LIKE '".mysql_real_escape_string($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 = 5;

  // 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 vidnumber, titleid, hd, year,starring1,videotitle,starring2, directedby, filmplot1,dirid,starrid1,starrid2, trilogy,age, Runningtime,WantToWatch FROM videolist WHERE videotitle LIKE '".mysql_real_escape_string($id)."' LIMIT $offset, $rowsperpage";

     $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);



     // while there are rows to be fetched...

     while ($row = mysql_fetch_assoc($result)) {



   //  <td><?php echo $row['vidnubmer']; ?></td>



 <td width="20%" rowspan="4" height="120" BORDERCOLOR=white><p align="center"><img border=0 src="/vidpics/<?php echo $row['videotitle'];?>web.jpg" <?php</p></td>

    <td width="20%" height="19" BORDERCOLOR=white><p align="center">ID:<?php echo $row['vidnumber']; ?></td>

    <td width="60%" colspan="3" height="19" BORDERCOLOR=white><p align="center"><b><?php echo $row['videotitle']; ?></b></td>

</tr>

<tr>

  <td width="20%" height="14" BORDERCOLOR=white><p align="center"><a href="http://imdb.com/title/<?php echo $row['titleid']; ?>" target="_top"><?php echo $row['titleid']; ?></a></td>

    <td width="20%" height="14" BORDERCOLOR=white><p align="center">Age <?php echo $row['age']; ?></td>

    <td width="20%" height="14" BORDERCOLOR=white><p align="center"><?php echo $row['year']; ?></td>

    <td width="20%" height="14" BORDERCOLOR=white><p align="center"><?php echo $row['Runningtime']; ?>mins</td>

</tr>

<tr>

  <td width="20%" height="25" BORDERCOLOR=white><p align="center"><a href="http://imdb.com/name/<?php echo $row['dirid']; ?>" target="_top"><?php echo $row['directedby']; ?></td>

    <td width="20%" height="25" BORDERCOLOR=white><p align="center"><a href="http://imdb.com/name/<?php echo $row['starrid1']; ?>" target="_top"><?php echo $row['starring1']; ?></td>

    <td width="20%" height="25" BORDERCOLOR=white><p align="center"><a href="http://imdb.com/name/<?php echo $row['starrid2']; ?>" target="_top"><?php echo $row['starring2']; ?></td>

    <td width="20%" height="25" BORDERCOLOR=white><p align="center"><?php echo $row['hd']; ?></td>

</tr>

<tr>

  <td width="80%" height="38" colspan="4" BORDERCOLOR=white><?php echo $row['filmplot1']; ?></td>

  </tr>

<tr>

  <td width="80%" height="38" colspan="5" BORDERCOLOR=white><p align="center">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p></td>



 </tr>

      <?php



  }

?>



</table>



  <?php

 /******  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'><<</a> ";

       // get previous page num

       $prevpage = $currentpage - 1;

          // show < link to go back to 1 page

           echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";

           }

           // end if



          // loop to show links to range of pages around current page

          for ($x = ($currentpage - $range); $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'>$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'>></a> ";

              // echo forward link for lastpage

               echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";

               }

                // end if

/****** end build pagination links ******/

?>

   </body>

</html>

**kows** · Jun 9th, 2010, 12:24 PM

what is the actual problem? could you start being a little more descriptive than, "it doesn't work"? does the search function not work? do the page numbers not display correctly? do no records show up at all?

**c_owl** · Jun 9th, 2010, 01:46 PM

hi
sorry kows.
the pages comes up after search looks ok, everything is were it should be and pagination part is at the bottom were i want it. but when i select the next page i get a result from a previous search on the next page and not the result from the current search

for example
i have set pagination part to display 20 records on on each page the first page is ok but if i select the links at the bottom of the page for the next 20 records i get a totaly different result

**kows** · Jun 9th, 2010, 01:55 PM

oh, I understand now. your explanation was off, but I understand what's wrong. your page links are linking to script.php?currentpage=X, where X is the page number, but you're missing the search query after that. so, you'll need to add onto those URLs the search term. first, we should change the search term, though, so that it's URL-safe:

PHP Code:


$searchquery = urlencode($_GET['search']);

then we can insert this query into your pagination links:

PHP Code:


// here's one:
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage&search=$searchquery'><</a> "; 

// here's another:
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x&search=$searchquery'>$x</a> ";

I did two there, but you'll need to add &search=$searchquery to the rest of your links, too.

**c_owl** · Jun 9th, 2010, 03:06 PM

hi
thank you so much kows, i have finished the page to how i want it..

well two weeks ago i didnt know a thing about php, mysql, i have now setup mysql to store all my video collection and view it under a web page. im also working on a vb.net video adder so i can add videos to my collection. thats turnig out tobe interesting aswell.

thanks again kows

Thread: [RESOLVED] cut my page up into more than one page

Thread Tools

Display

[RESOLVED] cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Re: cut my page up into more than one page

Posting Permissions