Pagination Help

artisticre

A couple of things, below is my pagination code that is working. I want to see if its possible to make this into two columns instead of one list per page. Also, I am looking to do alphabetical pagination so if anyone has any tutorials on it would help

thanks

$server = "xxx";
$userid = "xxx";
$pass = "xxx";
$database = "xxx";

$limit = 6;

$con = mysql_connect("$server","$userid","$pass") or die ("Huh? What Server");
$db = mysql_select_db("$database",$con) or die("I said WHAT database");

if (empty($offset) || $offset < 0) {
$offset=0;
}
if (empty($index)) $index=0;
$getrows = mysql_query("select * from directory", $con);
$numrows=mysql_num_rows($getrows);

$query = mysql_query("SELECT * from directory limit $offset,$limit", $con);

$num=1;
while ($result=mysql_fetch_array($query)){
$num = ($num < 15 ? $num : 1);
$index++; / Increment the line index by 1 /

echo "
<div align=left width=100>
$result[lname] 
$result[fname] 
$result[children]
$result[address]
$result[city]
$result[zip]
$result[phone]
</div>
<hr color=#000 width=200></hr>
";
if ($num==1 && $index!=$numrows)

$num++;
}

if ($numrows <= $limit) {
}
else {

if ($offset!=0) {
$prevoffset=$offset-$limit;
echo " <a onMouseOver=\"window.status='Previous $limit Results'; return true\"; href=\"$PHP_SELF?offset=$prevoffset&index=$prevoffset\">[Previous]</a> ";
}
else echo "[Previous] ";
$pages = intval($numrows/$limit);
if ($numrows%$limit) {
$pages++;
}
for ($i=1;$i<=$pages;$i++) {
if (($offset/$limit) == ($i-1)) {
echo " $i ";
} else {
$newoffset=$limit*($i-1);
echo " <a onMouseOver=\"window.status='Page $i Results'; return true\"; href=\"$PHP_SELF?offset=$newoffset&index=$newoffset\">$i</a> \n";
}

}
if (!((($offset/$limit)+1)==$pages) && $pages!=1) {
$newoffset=$offset+$limit;
echo " <a onMouseOver=\"window.status='Next $limit Results'; return true\"; href=\"$PHP_SELF?offset=$newoffset&index=$newoffset\">[Next]</a>\n";
} else echo " [Next]";
}

mysql_close($con);
?>

igbayilola

Pls is there anyone that can teach me the rudiment of php and mysql database design here i am a newbie

Thanks

future448

The alphabetical pagination part of your question is easiest to explain so I shall start with that.

You just need to change your $query to order the results by whichever field you choose.

So instead of:

$query = mysql_query("SELECT * from directory limit $offset,$limit", $con);

Use something like:

$query = mysql_query("SELECT * from directory ORDER BY fname limit $offset,$limit", $con);

So if you want to let the visitor choose what it is ordered by you will need to pass their selection through the url then retrieve it at the start of your script.

Something like:

if(isset($_REQUEST['order_by']))  {

$order_by = $_REQUEST['order_by'];
   }
   else {

$order_by = $_REQUEST['fname'];  // default 
}

Then change your query to:

$query = mysql_query("SELECT * from directory ORDER BY $order_by limit $offset,$limit", $con);

The displaying the results in two columns just needs a little bit of manipulation.

So when you are doing your while loop just keep track of how many you have displayed.

An example using tables for the layout because it is easier for you to see my point:

echo '<table>'; // start the table

$count = 0; //start a counter

while ($result=mysql_fetch_array($query)){  // start your loop

if($count == 0) {
echo '<tr><td>'.$result['fname'].'</td>';

// because $count = 0 we are doing the left hand side of the table
$count = 1; //increase the count
 }

elseif($count == 1) {

// because $count = 1 we are doing the right hand side of the table
echo '<td>' . $result['fname'] . '</td></tr>';

$count = 0;  //reset the count to 0
}

  } //finish the while loop

echo '</table>';  // finish the table

The above is just an example to get you started, you can of course use css for your layouts.

Hopefully you can expand upon that to fit it in with your results / layout.

future448

Just to add that you should also do some validation on the $order_by variable in your query otherwise someone could easily pass a value that is not one of your column names and throw up an error.