title: Undefined variable $page in canned pagination script
body: <p>i've got this pagiantion from "Stranger Studios Web Design" i have problem with page = $_GET['page'];
  the error is page undefined variable page
  , and i don't know where the 'page' come from?  please any help?</p>
  
  <pre><code>&lt;?php
  //php code for making pagination in  the gallery page
      /*
          Place code to connect to your DB here.
      */
      // code to connect to DB.
  
  //    $page = $_REQUEST['page'];
      $connection = @mysql_connect(localhost, 'root', '');
      if (!$connection){
      echo 'not connect';
      }
      mysql_select_db('bena'); // select db
  
      $tbl_name="gallery";        //your table name
      // How many adjacent pages should be shown on each side?
      $adjacents = 3;
  
      /*
         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";
      $total_pages = mysql_fetch_array(mysql_query($query));
      $total_pages = $total_pages['num'];
  
      /* Setup vars for query. */
      $targetpage = "galleryContent.php";     //your file name  (the name of this file)
      $limit = 3;                                 //how many items to show per page
      $page = $_GET['page'];
  
      if((!$page) || (is_numeric($page) == false) || ($page &lt; 0) || ($page &gt; $total_items)) {
            $page = 1; //default
  
   }
  
  
  if(isset($_REQUEST['page']))
      $page = $_REQUEST['page'];
  else
      $page = 1;
   // if
  
      if($page)
      {   $start = ($page - 1) * $limit;  }       //first item to display on this page
      else
      {   $start = 0; }                           //if no page var is given, set start to 0
  
      /* Get data. */
      $sql = "SELECT name FROM $tbl_name LIMIT $start, $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 are actually saving the code to a variable in case we want to draw it more than once.
      */
      $pagination = "";
      if($lastpage &gt; 1)
      {
          $pagination .= "&lt;div class=\"pagination\"&gt;";
          //previous button
          if ($page &gt; 1)
              $pagination.= "&lt;a href=\"$targetpage?page=$prev\"&gt;« previous&lt;/a&gt;";
          else
              $pagination.= "&lt;span class=\"disabled\"&gt;« previous&lt;/span&gt;";
  
          //pages
          if ($lastpage &lt; 7 + ($adjacents * 2))   //not enough pages to bother breaking it up
          {
              for ($counter = 1; $counter &lt;= $lastpage; $counter++)
              {
                  if ($counter == $page)
                      $pagination.= "&lt;span class=\"current\"&gt;$counter&lt;/span&gt;";
                  else
                      $pagination.= "&lt;a href=\"$targetpage?page=$counter\"&gt;$counter&lt;/a&gt;";
              }
          }
          elseif($lastpage &gt; 5 + ($adjacents * 2))    //enough pages to hide some
          {
              //close to beginning; only hide later pages
              if($page &lt; 1 + ($adjacents * 2))
              {
                  for ($counter = 1; $counter &lt; 4 + ($adjacents * 2); $counter++)
                  {
                      if ($counter == $page)
                          $pagination.= "&lt;span class=\"current\"&gt;$counter&lt;/span&gt;";
                      else
                          $pagination.= "&lt;a href=\"$targetpage?page=$counter\"&gt;$counter&lt;/a&gt;";
                  }
                  $pagination.= "...";
                  $pagination.= "&lt;a href=\"$targetpage?page=$lpm1\"&gt;$lpm1&lt;/a&gt;";
                  $pagination.= "&lt;a href=\"$targetpage?page=$lastpage\"&gt;$lastpage&lt;/a&gt;";
              }
              //in middle; hide some front and some back
              elseif($lastpage - ($adjacents * 2) &gt; $page &amp;&amp; $page &gt; ($adjacents * 2))
              {
                  $pagination.= "&lt;a href=\"$targetpage?page=1\"&gt;1&lt;/a&gt;";
                  $pagination.= "&lt;a href=\"$targetpage?page=2\"&gt;2&lt;/a&gt;";
                  $pagination.= "...";
                  for ($counter = $page - $adjacents; $counter &lt;= $page + $adjacents; $counter++)
                  {
                      if ($counter == $page)
                          $pagination.= "&lt;span class=\"current\"&gt;$counter&lt;/span&gt;";
                      else
                          $pagination.= "&lt;a href=\"$targetpage?page=$counter\"&gt;$counter&lt;/a&gt;";
                  }
                  $pagination.= "...";
                  $pagination.= "&lt;a href=\"$targetpage?page=$lpm1\"&gt;$lpm1&lt;/a&gt;";
                  $pagination.= "&lt;a href=\"$targetpage?page=$lastpage\"&gt;$lastpage&lt;/a&gt;";
              }
              //close to end; only hide early pages
              else
              {
                  $pagination.= "&lt;a href=\"$targetpage?page=1\"&gt;1&lt;/a&gt;";
                  $pagination.= "&lt;a href=\"$targetpage?page=2\"&gt;2&lt;/a&gt;";
                  $pagination.= "...";
                  for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter &lt;= $lastpage; $counter++)
                  {
                      if ($counter == $page)
                          $pagination.= "&lt;span class=\"current\"&gt;$counter&lt;/span&gt;";
                      else
                          $pagination.= "&lt;a href=\"$targetpage?page=$counter\"&gt;$counter&lt;/a&gt;";
                  }
              }
          }
  
          //next button
          if ($page &lt; $counter - 1)
              $pagination.= "&lt;a href=\"$targetpage?page=$next\"&gt;next »&lt;/a&gt;";
          else
              $pagination.= "&lt;span class=\"disabled\"&gt;next »&lt;/span&gt;";
          $pagination.= "&lt;/div&gt;\n";
      }
  ?&gt;
      &lt;?php
          while($row = mysql_fetch_array($result))
          {
  
          // Your while loop here
          echo '&lt;table&gt;&lt;tr&gt;&lt;td&gt;&lt;img src='.$row["name"].'/&gt;&lt;/td&gt;&lt;/tr&gt;';
          //echo '&lt;tr&gt;&lt;td&gt;'.$row["image"].'&lt;/td&gt;&lt;/tr&gt;';
          echo '&lt;/table&gt;';
          }
      ?&gt;
  &lt;?php=$pagination?&gt;
  </code></pre>