Jump to content

Archived

This topic is now archived and is closed to further replies.

techiefreak05

how to paginate this??

Recommended Posts

i have this little script to view all user friends.. and i want to limit it to about 5 per-page so my page doesnt scroll down a long way.. how would i add pagination??

[code]<?php
$user = $_SESSION[username];
$query = mysql_query("SELECT * FROM friends WHERE `username` = '$user' AND `accepted` = 'yes'");
while ($array = mysql_fetch_array($query)){
$to=$array['friend'];
echo "<br><center><b>" .$to. "</b></center>";
echo "<a href='sendMessage.php?to=" .$to. "'>-Message " .$to. "-</a> |<a href='getInfo.php?user=" .$to."'> -Get Info-</a> | <a href='http://zycoworld.com/" .$to. "'>-View zPage-</a><br><form action=\"\" method=\"post\">
      <table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\">
<tr><td colspan=\"2\" align=\"right\"><input type=\"submit\" name=\"delete\" value=\"-Remove-\"></td></tr><input type=\"hidden\" name=\"friend\" value=\"$to\">
</table>
</form>";
}
?>[/code]

Share this post


Link to post
Share on other sites
just set this
$max_results = 1;

example only not tested ok.

good luck.
[code]
<?php session_start();

$user = $_SESSION[username];

if(!isset($_GET['page'])){
    $page = 1;
} else {
    $page = $_GET['page'];
}

$max_results = 1;


$from = (($page * $max_results) - $max_results);

$query="SELECT * FROM friends WHERE `username` = '$user' AND `accepted` = 'yes LIMIT $from, $max_results";


while ($array = mysql_fetch_assoc($query)){
$to=$array['friend'];


echo "<br><center><b>" .$to. "</b></center>";
echo "<a href='sendMessage.php?to=" .$to. "'>-Message " .$to. "-</a> |<a href='getInfo.php?user=" .$to."'> -Get Info-</a> | <a href='http://zycoworld.com/" .$to. "'>-View zPage-</a><br><form action=\"\" method=\"post\">
      <table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\">
<tr><td colspan=\"2\" align=\"right\"><input type=\"submit\" name=\"delete\" value=\"-Remove-\"></td></tr><input type=\"hidden\" name=\"friend\" value=\"$to\">
</table>
</form>";

$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM friends where `username` = '$user'"),0);

$total_pages = ceil($total_results / $max_results);

if($page > 1){
    $prev = ($page - 1);
    echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"></a>";
}
for($i = 1; $i <= $total_pages; $i++){
    if(($page) == $i){
        echo "$i ";
        } else {
            echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> ";
    }
}

if($page < $total_pages){
    $next = ($page + 1);
    echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\"></a>";

}

}
?>

[/code]

Share this post


Link to post
Share on other sites
i got this :

"Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/zycoworld.flamelicker.com/newlayout/index.php on line 104"


Share this post


Link to post
Share on other sites
this
[code]
$query="SELECT * FROM friends WHERE `username` = '$user' AND `accepted` = 'yes LIMIT $from, $max_results";
[/code]

to this

[code]
$query="SELECT * FROM friends WHERE `username` = '$user' AND `accepted` = 'yes' LIMIT $from, $max_results";
[/code]

Share this post


Link to post
Share on other sites
from
[code]
while ($array = mysql_fetch_assoc($query)){
[/code]
to
[code]
while ($array = mysql_fetch_array($query)){

[/code]

Share this post


Link to post
Share on other sites
i got the same error again.. heres line 93 - 117

[code]
if(!isset($_GET['page'])){
    $page = 1;
} else {
    $page = $_GET['page'];
}

$max_results = 1;


$from = (($page * $max_results) - $max_results);

(LINE 104) $query="SELECT * FROM friends WHERE `username` = '$user' AND `accepted` = 'yes LIMIT $from, $max_results";


while ($array = mysql_fetch_array($query)){
$to=$array['friend'];


echo "<br><center><b>" .$to. "</b></center>";
echo "<a href='sendMessage.php?to=" .$to. "'>-Message " .$to. "-</a> |<a href='getInfo.php?user=" .$to."'> -Get Info-</a> | <a href='http://zycoworld.com/" .$to. "'>-View zPage-</a><br><form action=\"\" method=\"post\">
      <table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\">
<tr><td colspan=\"2\" align=\"right\"><input type=\"submit\" name=\"delete\" value=\"-Remove-\"></td></tr><input type=\"hidden\" name=\"friend\" value=\"$to\">
</table>
</form>";[/code]

line 104 is the line mysql said was giving me probs ...

Share this post


Link to post
Share on other sites
try this for one min
[code]
$query="SELECT * FROM friends WHERE `username` = '$user' LIMIT $from, $max_results";
[/code]

Share this post


Link to post
Share on other sites
trie this ok.
[code]
<?php session_start();

$user = $_SESSION[username];

if(!isset($_GET['page'])){
   $page = 1;
} else {
   $page = $_GET['page'];
}

$max_results = 1;


$from = (($page * $max_results) - $max_results);

$query="SELECT * FROM friends WHERE `username` = '$user' AND `accepted` = 'yes' LIMIT $from, $max_results";

$result=mysql_query($query);

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

$to=$array['friend'];


echo "<br><center><b>" .$to. "</b></center>";
echo "<a href='sendMessage.php?to=" .$to. "'>-Message " .$to. "-</a> |<a href='getInfo.php?user=" .$to."'> -Get Info-</a> | <a href='http://zycoworld.com/" .$to. "'>-View zPage-</a><br><form action=\"\" method=\"post\">
     <table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\">
<tr><td colspan=\"2\" align=\"right\"><input type=\"submit\" name=\"delete\" value=\"-Remove-\"></td></tr><input type=\"hidden\" name=\"friend\" value=\"$to\">
</table>
</form>";

$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM friends where `username` = '$user'and `accepted` = 'yes'"),0);

$total_pages = ceil($total_results / $max_results);

if($page > 1){
   $prev = ($page - 1);
   echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"></a>";
}
for($i = 1; $i <= $total_pages; $i++){
   if(($page) == $i){
       echo "$i ";
       } else {
           echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> ";
   }
}

if($page < $total_pages){
   $next = ($page + 1);
   echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\"></a>";

}

}
?>
[/code]

Share this post


Link to post
Share on other sites
"Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/zycoworld.flamelicker.com/newlayout/index.php on line 104"

same error.. on the same line... again

Share this post


Link to post
Share on other sites
$query="SELECT * FROM friends WHERE `username` = '$user' AND `accepted` = 'yes' LIMIT $from, $max_results";

$result=mysql_query($query);

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

Share this post


Link to post
Share on other sites
heres one i just made and works fine.

[code]
<?php session_start();

$db=mysql_connect("localhost" , "xxx" , "xxxx");
mysql_select_db("promotor",$db);

?>


<html>
<head>
<title>Send Message</title>
<body bgcolor="#A0C0F0">
<br><br><br><br><br>



<?php



if(!isset($_GET['page'])){
    $page = 1;
} else {
    $page = $_GET['page'];
}

$max_results = 1;


$from = (($page * $max_results) - $max_results);

$query="select * from member_messages where id='$id' LIMIT $from, $max_results";


$result=mysql_query($query);
while($record=mysql_fetch_assoc($result)){


echo"<table align='center' width='300'border='4' bordercolor='black'><td align='left'><b>Members Id:<font color='red'><br>".$record["sent_id"]."</font><br> User Name: <font color='red'><br>".$record["members_name"]."</font><br>
Sent Time: <font color='red'><br>".$record["time"]."</font> <br> Sent Date <font color='red'><br>".$record["date"]."</font> </b></td><td align='center' valign='top'><b>Members Message <font color='red'>$page</font><b>
<br><br><b><div align='left'><textarea col='7' rows='7'style='color: white; background-color: #A0C0F0'>".$record["message"]."</textarea></td></b></div><table>";





echo "<table align='center' width='300'border='4' bordercolor='black'><td align='center'><b>";


$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM member_messages where id='$id'"),0);


$total_pages = ceil($total_results / $max_results);


echo "<center><b>Select A Message!</b><br>";


if($page > 1){
    $prev = ($page - 1);
    echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"></a>";
}

for($i = 1; $i <= $total_pages; $i++){
    if(($page) == $i){
        echo "$i ";
        } else {
            echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> ";
    }
}


if($page < $total_pages){
    $next = ($page + 1);
    echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\"></a>";

}


echo "</center>";
echo'</td></table>';

echo "<table align='center' width='300'border='4' bordercolor='black'><td align='center'><b>Send A Reply    <font color='red'><a href='reply_message.php?&id=".$record['sent_id']."'>Reply</a></b></font>
<font color='red'><a href='delete_message.php?&cmd=delete&time=".$record['time']."&id=".$record['sent_id']."'>Delete</a></b></font>
</td></table><br>";
}

?>

[/code]

Share this post


Link to post
Share on other sites
redarrow - it's [code=php:0]$_SESSION['username'][/code] not [code=php:0]$_SESSION[username][/code]

Share this post


Link to post
Share on other sites
i didnt write that code so tell the designer ok sorry i only inplemented the rest.

if you look at the first post your notice that and i totaly agree, i can not sit here doing all the work for the user can i.

dont no why your pointing this out as all i do is help others but thank you i pm the user and tell them ok.

Share this post


Link to post
Share on other sites
still experiencing problems?

echo all your queries to see if they are 'correct'

Share this post


Link to post
Share on other sites
have you still got problams you told me that it all ok now my friend not iam not mad i love helping all.

i like jenk but he likes a good row i can tell lol

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.