richarro1234 Posted January 3, 2009 Share Posted January 3, 2009 Hey all, im having some problems with this code. basically i would like to set-up pagination for it as it is often updated and gets big pretty quick, all the sctipts i havelooked at dont seem to work i was wondering if someone could help me with the pagination please Thanks in advance Rich <?include("header.php");?> <? if ($_COOKIE["status"] == "online") { include("data.php"); mysql_connect($server,$username, $password); mysql_select_db($database); $query = mysql_query("SELECT * from users WHERE username = '".$_COOKIE["twusername"]."'"); while ($r = mysql_fetch_array($query)) { ?> <center> <?=$note?></center> <br> <? if ($r['username'] == 'richarro123') { ?> <div align="center"> <center> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#5D6765" width="95%" id="AutoNumber1" bgcolor="#131313"> <tr> <td width="17%" align="center" bgcolor="#000000"><b>Admin</b></td> <td width="17%" align="center" bgcolor="#000000"><b>User Edited</b></td> <td width="17%" align="center" bgcolor="#000000"><b>Value Edited</b></td> <td width="17%" align="center" bgcolor="#000000"><b>Original Value</b></td> <td width="16%" align="center" bgcolor="#000000"><b>New Value</b></td> <td width="16%" align="center" bgcolor="#000000"><b>Date</b></td> </tr> <tr> <td width="100%" align="center" colspan="6"> </td> </tr> <?php $results= mysql_query("SELECT * FROM adminactionlog Order by date desc"); $id = "id"; $adminname = "adminname"; $username = "username"; $action = "action"; $origvalue = "origvalue"; $newvalue = "newvalue"; $date = "date"; echo mysql_error(); if (mysql_Numrows($results)>0) //if there are records in the fields { $numrows=mysql_NumRows($results); //count them $x=0; while ($x<$numrows){ //loop through the records $theid=mysql_result($results,$x,$id); $theadminname=mysql_result($results,$x,$adminname); $theusername=mysql_result($results,$x,$username); $theaction=mysql_result($results,$x,$action); $theorigvalue=mysql_result($results,$x,$origvalue); $thenewvalue=mysql_result($results,$x,$newvalue); $thedate=mysql_result($results,$x,$date); $logdate = date("m/d/Y h:i a",$thedate); ?> <? $query = mysql_query("SELECT * from users WHERE username = '$theadminname'"); while ($adminlink = mysql_fetch_array($query)) { ?> <? $query = mysql_query("SELECT * from users WHERE username = '$theusername'"); while ($memlink = mysql_fetch_array($query)) { ?> <tr> <td width="17%" align="center"><a href="profile.php?id=<?=$adminlink['id'];?>"><?=$theadminname?></a> </td> <td width="17%" align="center"><a href="profile.php?id=<?=$memlink['id'];?>"><?=$theusername?></a> </td> <td width="17%" align="center"><?=$theaction?> </td> <td width="17%" align="center"><?=$theorigvalue?> </td> <td width="16%" align="center"><?=$thenewvalue?> </td> <td width="16%" align="center"><?=$logdate?> </td> </tr> <? $x++; } ?> <?}?> <?}?> <?}?> </table> </center> </div> <?} else {?> <center><b>!</b></center> <?}?> <br> <? } } else { require( 'notloggedin.php' ); }?> <?include("footer.php");?> Quote Link to comment Share on other sites More sharing options...
revraz Posted January 3, 2009 Share Posted January 3, 2009 Have you looked at the pagination tutorial? Quote Link to comment Share on other sites More sharing options...
richarro1234 Posted January 3, 2009 Author Share Posted January 3, 2009 yes but because of the way its coded it doesnt seem to work, or atleast i couldnt get it to work, so got rid of the code to post on here. Quote Link to comment Share on other sites More sharing options...
revraz Posted January 3, 2009 Share Posted January 3, 2009 Maybe you should post that so someone can see what you did wrong. Quote Link to comment Share on other sites More sharing options...
richarro1234 Posted January 3, 2009 Author Share Posted January 3, 2009 <?php if(isset($submit)) { $page = $_GET["page"]; $rowmax = 10; //Set this to the number of items you want returned per page if(!isset($page)) { $page = 1; } if($page == 1) { $pagein = 0; } if($page > 1) { $pagein = $page * $rowmax - $rowmax; } include("data.php"); mysql_connect($server,$anvandare, $losen); mysql_select_db($databas); //Below is where the total number of rows will be calculated //Below is where you would do the selected query to draw only paginated results. $results= mysql_query("SELECT * FROM adminactionlog Order by date desc LIMIT $pagein, $rowmax"); $id = "id"; $adminname = "adminname"; $username = "username"; $action = "action"; $origvalue = "origvalue"; $newvalue = "newvalue"; $date = "date"; echo mysql_error(); if (mysql_Numrows($results)>0) //if there are records in the fields { $numrows=mysql_NumRows($results); //count them $x=0; while ($x<$numrows){ //loop through the records $theid=mysql_result($results,$x,$id); $theadminname=mysql_result($results,$x,$adminname); $theusername=mysql_result($results,$x,$username); $theaction=mysql_result($results,$x,$action); $theorigvalue=mysql_result($results,$x,$origvalue); $thenewvalue=mysql_result($results,$x,$newvalue); $thedate=mysql_result($results,$x,$date); $logdate = date("m/d/Y h:i a",$thedate); ?> <? $query = mysql_query("SELECT * from users WHERE username = '$theadminname'"); while ($adminlink = mysql_fetch_array($query)) { ?> <? $query = mysql_query("SELECT * from users WHERE username = '$theusername'"); while ($memlink = mysql_fetch_array($query)) { ?> <tr> <td width="17%" align="center"><a href="profile.php?id=<?=$adminlink['id'];?>"><?=$theadminname?></a> </td> <td width="17%" align="center"><a href="profile.php?id=<?=$memlink['id'];?>"><?=$theusername?></a> </td> <td width="17%" align="center"><?=$theaction?> </td> <td width="17%" align="center"><?=$theorigvalue?> </td> <td width="16%" align="center"><?=$thenewvalue?> </td> <td width="16%" align="center"><?=$logdate?> </td> </tr> <? $x++; } ?> <?}?> <?}?> <?} $result1 = mysql_query($query1); while($row = mysql_fetch_array($result1)){ //This is the area where the paginated ruslts will be displayed by row results } //Below will only do calutaions if query was successful if($result1 != null) { $pagecount = ceil($num_rows / $rowmax); $resultinput = $pagein + 1; $resultsoutput = $pagein + $rowmax; if($resultsoutput > $num_rows) {$resultsoutput = $num_rows;}//Change $resultsoutput to $num_rows on last page here //Only displays pagination links if necessary below here if ($pagecount > 1) { echo "Page "; $x = 1; $y = $pagecount; for( $i = $x; $i <= $y; $i++ ) { print "<a href='adminlog1.php?page=$i'><b>[$i]</b></a> "; } } echo "<p align='center'>There were $num_rows results.<br />//Shows the total number of resutls on this line You are viewing results $resultinput through $resultsoutput.</p>";//shows which results you are viewing here } } ?> Thats what i got and all it shows is a blank white page. Quote Link to comment Share on other sites More sharing options...
richarro1234 Posted January 4, 2009 Author Share Posted January 4, 2009 bump Quote Link to comment Share on other sites More sharing options...
revraz Posted January 4, 2009 Share Posted January 4, 2009 Blank page is a good indication you have errors in your code. Enable error reporting and display errors to see if what it returns. Also, why do you stop and start PHP back to back so often? You may also want to substitute full <?php tags instead of <? short tags. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.