PAGNATION and RANDOM help

[phil101]

I have a DB of models.
I want when you do a search for say a male in the state of florida the results come back in random order each time. The problem I am having is in my pagnation when you go to page 2 you get some of page 1 results. Is there anyway to alter my script below to give back random results in a set and hold them so the pagnation will work correctly, So basically it will not scramble the results until the person does another search. Can anyone help me get through this from start to finish. Below is my script if you could alter it to do this please post.

---

<?php

$conn=mysql_connect("localhost","","");
$rs=mysql_select_db("mymodelfinder",$conn);

/ The str_replace function replaces the string accordingly, for example 10,11,12,13 to 10','11','12','13. Later in query its formated as '10','11','12','13' Which is the standard format to use in WHERE IN Query. /

$mysex = str_replace(",", "','", $POST['sex']);
$myage = str_replace(",", "','", $POST['age']);
$myweight = str_replace(",", "','", $POST['weight']);
$myheight = str_replace(",", "','", $POST['height']);
$myhaircolor = str_replace(",", "','", $POST['haircolor']);
$myeyecolor = str_replace(",", "','", $POST['eyecolor']);
$mystate = str_replace(",", "','", $POST['state']);
// get the pager input values
$mypage = "";
$mypage = $POST['page'];

$limit = 5; // 5 records per page...you can change it according to your wish.

$result = mysql_query("SELECT count(*) FROM models WHERE sex IN ('$mysex') AND age IN ('$myage') AND weight IN ('$myweight') AND height IN ('$myheight') AND haircolor IN ('$myhaircolor') AND eyecolor IN ('$myeyecolor') AND state IN ('$mystate')", $conn);

$total = mysql_result($result, 0, 0);

// work out the pager values
$pager = Pager::getPagerData($total, $limit, $mypage);
$offset = $pager->offset;

$limit = $pager->limit;

$mypage = $pager->page;

$answer = "SELECT * FROM models WHERE sex IN ('$mysex') AND age IN ('$myage') AND weight IN ('$myweight') AND height IN ('$myheight') AND haircolor IN ('$myhaircolor') AND eyecolor IN ('$myeyecolor') AND state IN ('$mystate') ORDER BY RAND() LIMIT $offset, $limit ";

$rs=mysql_query($answer,$conn) or die("Error occured in SQL -> ".mysql_error());

if (mysql_num_rows($rs) == 0)
{

     echo("No models with these Parameters where found!...please try again!    "); 

}
echo("MYMODELFINDER.com SEARCH RESULTS ");

while ($row =mysql_fetch_array($rs) )
{ print"<table width = 551 border=0>";

  echo ("<tr><td><b> ID:</b>  " .$row ["id"]."&nbsp; &nbsp;");
  echo ("<b> Name:</b>  " .$row ["name"]."&nbsp; &nbsp;");
  echo ("<b> Age:</b>   ".$row["age"]."&nbsp; &nbsp;");
  echo ("<b> Weight:</b> ".$row["weight"]."&nbsp; lbs &nbsp;");
  echo ("<b> Height:</b> ".$row["height"]."<br>");
  echo ("<b> Hair Color:</b> ".$row["haircolor"]."&nbsp; &nbsp;");
  echo ("<b> Eye Color:</b> ".$row["eyecolor"]."&nbsp; &nbsp;");
  $mylink= $row["link"]; 
  $go ="More from this model";
  echo "<a href=\"$mylink\" target='_blank'>$go</a></tr></td><br>";  
  $filepath = $row["filepath"];
  echo "<td><img src='$filepath'></td><hr></tr>";

   print"</table>";

}

?>
<?php

class Pager

{

function getPagerData($numHits, $limit, $page)

{

$numHits = (int) $numHits;

$limit = max((int) $limit, 1);

$page = (int) $page;

$numPages = ceil($numHits / $limit);

        $page = max($page, 1);  
        $page = min($page, $numPages);  

        $offset = ($page - 1) * $limit;  

        $ret = new stdClass;  

        $ret->offset   = $offset;  
        $ret->limit    = $limit;  
        $ret->numPages = $numPages;  
        $ret->page     = $page;  

        return $ret;  
    }  
}  

?>
<form action="mmf_result.php" method="POST" target="self">
<input name="state" type="hidden" id="state" value="<?php echo $POST['state']; ?>">
<input type="hidden" name="sex" value="<?php echo $POST['sex']; ?>">
<input type="hidden" name="age" value="<?php echo $POST['age']; ?>">
<input type="hidden" name="weight" value="<?php echo $POST['weight']; ?>">
<input type="hidden" name="height" value="<?php echo $POST['height']; ?>">
<input type="hidden" name="haircolor" value="<?php echo $POST['haircolor']; ?>">
<input type="hidden" name="eyecolor" value="<?php echo $POST['eyecolor']; ?>">
<select name="page">
<?php

// output paging system
for ($i = 1; $i <= $pager->numPages; $i++)
{
if ($i == $mypage)

echo "<option value='$i' SELECTED> $i </option>";
else

echo "<option value='$i'> $i </option>";
}

?>
</select>
<input type="submit" name="submit" value="GO">
</form>

[drawmack]

First call session_start

When a search is performed you'll have to get all of the mertinate ids from the database into an array. I simulate this with this code:

<?php
//get all the matching ids into an array
$numbers = array();
for($i=0;$i<100;$i++) {
    $numbers[$i] = $i;
} //end for
?>

Once you have that done you'll want to randomize the array. Like this

<?php
//randomize the array
shuffle($numbers);
?>

Then you'll have to paginate the randomized list of ids. I wrote a function for this which returns an array of arrays. Each page is a top level array entry and each id on that page is a secondary entry. The function looks like this:

<?php
function paginate($entries,$per_page) {
    $retval = array();
    for($i=0;$i<(ceil(count($entries)/$per_page));$i++) {
        $retval[$i] = array();
        for($j=0;$j<$per_page;$j++) {
            if(array_key_exists(($i*$per_page+$j),$entries)) {
                $retval[$i][$j] = $entries[$i*$per_page+$j];
            } //end if
        } //end for
    }//end for
    return $retval;
} //end function
?>

I call the function like this:

<?php
//paginate the randomized array
$pages = paginate($numbers,10);
?>

Then I write the total number of pages and the list of ids to the SESSION array like this:

<?php
//save the paginated randomized array to a series of session variables.
for($i=0;$i<count($pages);$i++) {
    for($j=0;$j<count($pages[$i]);$j++) {
        $cur_key = 'p_' . $i . '_e_' . $j;
        $_SESSION[$cur_key] = $pages[$i][$j];
    } //end for
} //end for
?>

Then I can build a list of the current page's ids from the session array like this:

<?php
//set the current page
if(array_key_exists('page',$_GET)) $page = $_GET['page'] - 1;
else $page = 0;

//build the current page's array
$page_ids = array();
for($i=0;$i<10;$i++) {
    $cur_key = 'p_' . $page . '_e_' . $i;
    if(array_key_exists($cur_key,$_SESSION)) {
        $page_ids[] = $_SESSION[$cur_key];
    }
} //end for
?>

Since this method only actually queries the database and retrieves the ids once there is no duplication of records between pages.

[phil101]

Wow thanks nobody could tell me how to do it I new I needed to get a container (array) to hold the data in then ramdomize it but had no good knowledge on how to get started I'm just having a real problem intergrating your method into my script could you help further with a bit of cut and paste? If possible with my script above>>>>
Thanks so much Phil
if you ever have a flash problem look no further I am a flash master and I'm there for ya !

[drawmack]

<?php
//HERE CALL session_start

$conn=mysql_connect("localhost","","");
$rs=mysql_select_db("mymodelfinder",$conn);

/* The str_replace function replaces the string accordingly, for example 10,11,12,13 to 10','11','12','13. Later in query its formated  as '10','11','12','13' Which is the standard format to use in WHERE IN Query. */

$mysex = str_replace(",", "','", $_POST['sex']); 
$myage = str_replace(",", "','", $_POST['age']);
$myweight = str_replace(",", "','", $_POST['weight']);
$myheight = str_replace(",", "','", $_POST['height']);
$myhaircolor = str_replace(",", "','", $_POST['haircolor']);
$myeyecolor = str_replace(",", "','", $_POST['eyecolor']);
$mystate = str_replace(",", "','", $_POST['state']);
// get the pager input values 
$mypage = ""; 
$mypage = $_POST['page'];   

$limit = 5;     // 5 records per page...you can change it according to your wish.

//change this query so instead of retrieving the count of *
//it retrieves the id field from the database.
$result = mysql_query("SELECT count(*) FROM models WHERE sex IN ('$mysex') AND age IN ('$myage') AND weight IN ('$myweight') AND height IN ('$myheight') AND haircolor IN ('$myhaircolor') AND eyecolor IN ('$myeyecolor') AND state IN ('$mystate')", $conn);

//change this line to use the mysql_num_rows function
$total = mysql_result($result, 0, 0);  

//HERE INSERT THE CODE TO PUT THE IDS INTO AN ARRAY,
//RANDOMIZE THEM, DO THE PAGINATION AND WRITE THEM
//TO THE SEEION VARIABLES

// work out the pager values 
$pager  = Pager::getPagerData($total, $limit, $mypage); 
$offset = $pager->offset;  

$limit  = $pager->limit;  

$mypage  = $pager->page;  

//HERE PULL THE CURRENT PAGE'S ARRAY FROM THE
//SESSION VARIABLES.


//change this so it loops the the array created above 
//and pulls out the people in that array.
$answer = "SELECT * FROM models WHERE sex IN ('$mysex') AND age IN ('$myage') AND weight IN ('$myweight') AND height IN ('$myheight') AND haircolor IN ('$myhaircolor') AND eyecolor IN ('$myeyecolor') AND state IN ('$mystate') ORDER BY RAND() LIMIT $offset, $limit ";

$rs=mysql_query($answer,$conn) or die("Error occured in SQL -> ".mysql_error());

if (mysql_num_rows($rs) == 0) 
   { 

     echo("No models with these Parameters where found!...please try again!    "); 
   } 
         echo("MYMODELFINDER.com SEARCH RESULTS ");

while ($row =mysql_fetch_array($rs) )
   {      print"<table width = 551 border=0>";

  echo ("<tr><td><b> ID:</b>  " .$row ["id"]."&nbsp; &nbsp;");
  echo ("<b> Name:</b>  " .$row ["name"]."&nbsp; &nbsp;");
  echo ("<b> Age:</b>   ".$row["age"]."&nbsp; &nbsp;");
  echo ("<b> Weight:</b> ".$row["weight"]."&nbsp; lbs &nbsp;");
  echo ("<b> Height:</b> ".$row["height"]."<br>");
  echo ("<b> Hair Color:</b> ".$row["haircolor"]."&nbsp; &nbsp;");
  echo ("<b> Eye Color:</b> ".$row["eyecolor"]."&nbsp; &nbsp;");
  $mylink= $row["link"]; 
  $go ="More from this model";
  echo "<a href=\"$mylink\" target='_blank'>$go</a></tr></td><br>";  
  $filepath = $row["filepath"];
  echo "<td><img src='$filepath'></td><hr></tr>";

   print"</table>";
   }

?>
                <?php  

class Pager  

   {  

      function getPagerData($numHits, $limit, $page)  

         {  

            $numHits  = (int) $numHits;  

            $limit    = max((int) $limit, 1);  

            $page     = (int) $page;  

            $numPages = ceil($numHits / $limit);  

        $page = max($page, 1);  
        $page = min($page, $numPages);  

        $offset = ($page - 1) * $limit;  

        $ret = new stdClass;  

        $ret->offset   = $offset;  
        $ret->limit    = $limit;  
        $ret->numPages = $numPages;  
        $ret->page     = $page;  

        return $ret;  
    }  
}  

?>
                <form action="mmf_result.php" method="POST" target="_self">
                  <input name="state" type="hidden" id="state" value="<?php echo $_POST['state']; ?>">
                  <input type="hidden" name="sex" value="<?php echo $_POST['sex']; ?>">
                  <input type="hidden" name="age" value="<?php echo $_POST['age']; ?>">
                  <input type="hidden" name="weight" value="<?php echo $_POST['weight']; ?>">
                  <input type="hidden" name="height" value="<?php echo $_POST['height']; ?>">
                  <input type="hidden" name="haircolor" value="<?php echo $_POST['haircolor']; ?>">
                  <input type="hidden" name="eyecolor" value="<?php echo $_POST['eyecolor']; ?>">
                  <select name="page">
                    <?php

// output paging system
for ($i = 1; $i <= $pager->numPages; $i++) 
   {
      if ($i == $mypage)  

         echo "<option value='$i' SELECTED> $i </option>";
       else  

          echo "<option value='$i'> $i </option>";
   } 

?>
                  </select>
                  <input type="submit" name="submit" value="GO">
                </form>

[phil101]

Im allmost complete on the intergration can you just show me how to rewrite this part

//change this query so instead of retrieving the count of *
//it retrieves the id field from the database.

[drawmack]

<?php
$sql  = "SELECT id FROM models WHERE \n";
$sql .= "sex IN ('$mysex') AND \n";
$sql .= "age IN ('$myage') AND \n";
$sql .= "weight IN ('$myweight') AND \n";
$sql .= "height IN ('$myheight') AND \n";
$sql .= "haircolor IN ('$myhaircolor') AND \n";
$sql .= "eyecolor IN ('$myeyecolor') AND \n";
$sql .= "state IN ('$mystate')"
$result = mysql_query($sql, $conn);
?>