AdRock Posted July 3, 2006 Share Posted July 3, 2006 HelloI am thinking of creating a guestbook for a website which isn't a problem but I want to know how to set the number of messages per page.Say I wanted to display 10 messages per page and had 50 messages to be displayed, how would I include a link somewhere to move to the next set of messages and to display the number of pages?Any help would be appreciated Quote Link to comment https://forums.phpfreaks.com/topic/13594-creating-guestbook/ Share on other sites More sharing options...
redarrow Posted July 3, 2006 Share Posted July 3, 2006 an example only ok.<? session_start();$db=mysql_connect("xxxx" , "xxx" , "xxx");mysql_select_db("promotor",$db);?><html><head><title>Send Message</title><body bgcolor="#A0C0F0"><br><br><br><br><br><?if(!isset($_GET['page'])){ $page = 1; } else { $page = $_GET['page']; } $max_results = 1; $from = (($page * $max_results) - $max_results); $query="select * from xxxx 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>";}?> Quote Link to comment https://forums.phpfreaks.com/topic/13594-creating-guestbook/#findComment-52683 Share on other sites More sharing options...
Birdman203 Posted July 3, 2006 Share Posted July 3, 2006 I did this here look through it and learn![code]<?phprequire 'required.inc.php';$news = $config[news];$page = $_REQUEST['page'];$mul2 = bcmul($page, $news);$mul = bcsub($mul2, $news);if (isset($page)) { $result = mysql_db_query("typekill_$config[short]", "select * from cp_ftopics where cat_id = '$config[news_cat]' order by id desc limit $mul, $config[news]"); $smarty->assign("isset", "1");} else { $result = mysql_db_query("typekill_$config[short]", "select * from cp_ftopics where cat_id = '$config[news_cat]' order by id desc limit 0, $config[news]") or die(mysql_error()); $smarty->assign("isset", "0");}$count = mysql_num_rows($result);if ($count > $mul) { if (isset($page)) { $nextp = $page + 1; } else { $nextp = $page + 2; } $smarty->assign("nextp", $nextp);}if ($count < $mul) { $backp = $page - 1; $smarty->assign("backp", $backp);}?>[/code] Quote Link to comment https://forums.phpfreaks.com/topic/13594-creating-guestbook/#findComment-52686 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.