GuestBook

[Creative*php]

Hi im now making a simple guestbook. The problem is about displaying the number of comments . The maximum of commecnts to be display is 4. And i have a button. First, Previous, Next, Last. I have an idea but dont know how to start with it

[Jake Arkinstall]

What do you have so far?

I think it's just a case of some simple pagination.

[Creative*php]

Actually im not started to code yet. Im just planning and thinking of the problem that i may take. And the difficult one is the navigation of displaying the comments. The maximum number of comments to be displayed must be 4. About navigation i have 4 buttons like i said its First,Prev,Nxt,Lst.

[Kon-Tiki]

Yup, that's pagination. It's quite fun to figure out by yourself, although if you're new, it can be a bit frustrating as well. There's a similar question on that a bit earlier. Lemme fetch the link...

[Kon-Tiki]

http://www.sitepoint.com/forums/showthread.php?t=506852

[Jake Arkinstall]

What I would do is have a mysql table for the comments. Use this query to fetch the results. increasing $_GET['commentpage'] will change the page. If $_GET['commentpage'] is not set, then it defaults to 0.

$page = (isset($_GET['commentpage'])) ? $_GET['commentpage'] : 0;
$start = $page * 4;
$q = mysql_query("SELECT * FROM `comments` LIMIT $start,4"); 

Make the next button add 1 to $_GET['commentpage'] on the url, for example:

<?
$nextpage = $page + 1;
echo "<a href=\"?commentpage=".$nextpage."\">Next</a>";
?>

[Creative*php]

Ok let me try your code and also i try my own code even its too long using a for loop.

[Creative*php]

This is the code i use to display the comments, who post it, and the date posted it.

<?php

$getdata="SELECT * FROM comments ORDER BY com_id DESC";

$getdata2=mysql_query($getdata) or die("Could not get data");

while($getdata3=mysql_fetch_array($getdata2))

{

  $getdata3[com_name]=strip_tags($getdata3[com_name]);
  $getdata3[com_message]=strip_tags($getdata3[com_message]);
  $getdata3[com_date]=strip_tags($getdata3[com_date]);
  

?>
  

  
        <div class="headinglarge"> Title <img src="images/del.gif"></div><div class="adminbtn"><img src="images/admin.gif" width="65" height="52" border="0" ></div>
        <div class="headingsub"> <?php "$getdata3[com_date]"; ?> by <?php echo "$getdata3[com_name]"; ?></div>
        <div class="content"> <?php echo "$getdata3[com_message]"; ?>
                </div><hr>
<?php } ?>

But how im gonna limit that into 4 contents only and the other post must be in the other page when i click the button next or previous or last or first.

[Kon-Tiki]

Use limit in your SQL query.

[Creative*php]

I place the Limit 4. on my sql variable. but what if i press the next button or previous button should i place a limit 4 also. but how im gonna attain that if i meet the last record the next button is not enable

[Kon-Tiki]

You got to make a variable for the first and last number. It won't be LIMIT 0,4, but LIMIT $start, $stop. You change $start and $stop according to the button pressed (Next/Previous/Last/First)

[Creative*php]

Ok but before that how im gonna display an image inside the php code

<?php
for ($i=0; $i>"$getdata3[com_rating]"; $i++)
{
echo <img src="star.gif">
}
?>

This is not working

[Kon-Tiki]

It doesn't show star.gif any time, I bet. Read your for loop aloud:

i is 0. While i is bigger than getdata3[com_rating], draw star.gif, then increase i by one.

That would require get_data3 to be negative in value, and if that would be the case, it would loop endlessly.

[Creative*php]

oh ! i wrote a wrong for loop. It should be "<=" not ">". The reason the image doesn't show because i put a double quote of it

[Jake Arkinstall]

so, your fixed code there would be:

<?
for($i = 0; $i < $getdata3; $i++){
     ?><img src="star.gif" alt="star" /><?
}
?>

[Kon-Tiki]

Uhmmm, I see. Dunno how I didn't see this before.

<?php
for ($i=0; $i<$getdata3["com_rating"]; $i++)
{
echo '<img src="star.gif">';
}
?>

Try it like that. The quotes should be around the associative array key, not the entire variable.

[Creative*php]

Imstuck with the buttons

[Creative*php]

in the images i fixed it already but in the buttons im stuck.

[Kon-Tiki]

Can you show us the code that's giving trouble?

[Creative*php]

<?php 
for ($x=1; $x>"getdata3[com_id]"; $x++)
{
?>
        <table width="119" border="0" align="center" cellpadding="0" cellspacing="3">
          <tr>
            <td width="16" align="right"><?php $x; ?><img src="images/pfirst.gif" width="15" height="16"></td>
            <td width="16" align="right"><?php $x; ?><img src="images/pprev.gif" width="15" height="16"></td>
            <td width="7" align="center"><?php $x; ?>1</td>
            <td width="16" align="left"><?php $x; ?><img src="images/pnext.gif" width="15" height="16"></td>
            <td width="46" align="left"><?php $x; ?><img src="images/plast.gif" width="15" height="16"></td>
          </tr>
        </table>
        <?php } ?>

I know this is wrong but im still getting the idea of how to to that

[Jake Arkinstall]

don't put quotes around variables.
change

$x>"getdata3[com_id]"; 

to

$x>$getdata3["com_id"]; 

[Creative*php]

But is it my code do the displaying 4 by 4 . if i click it will go to the 4 comments again and if previous the vice versa. and so on

[Creative*php]

Im really stuck with it. Dont know what to do with my buttons

<?php

$getdata="SELECT * FROM comments ORDER BY com_id DESC LIMIT 0,4";

$getdata2=mysql_query($getdata) or die("Could not get data");

while($getdata3=mysql_fetch_array($getdata2))

{

  $getdata3[com_name]=strip_tags($getdata3[com_name]);
  $getdata3[com_rating]=strip_tags($getdata3[com_rating]);
  $getdata3[com_message]=strip_tags($getdata3[com_message]);
  $getdata3[com_date]=strip_tags($getdata3[com_date]);
  

?>
  

  
<div class="headinglarge"> Title <?php
for ($i=1; $i<="$getdata3[com_rating]"; $i++)
{
echo '<img src="images/star.gif">';
}
 ?><img src="images/del.gif"></div><div class="adminbtn"><img src="images/admin.gif" width="65" height="52" border="0" ></div>
<div class="headingsub"> <?php echo "$getdata3[com_date]"; ?> by <?php echo "$getdata3[com_name]"; ?></div>
<div class="content"> <?php echo "$getdata3[com_message]"; ?>
</div><hr>
<?php } ?>
        <table width="119" border="0" align="center" cellpadding="0" cellspacing="3">
          <tr>
            <td width="16" align="right"><img src="images/pfirst.gif" width="15" height="16"></td>
            <td width="16" align="right"><img src="images/pprev.gif" width="15" height="16"></td>
            <td width="7" align="center">1</td>
            <td width="16" align="left"><img src="images/pnext.gif" width="15" height="16"></td>
            <td width="46" align="left"><img src="images/plast.gif" width="15" height="16"></td>
          </tr>
        </table>

[Jake Arkinstall]

read post 6

[Creative*php]

what is this all about ?

(isset($_Get['commentpage']))