Ja i må da godt se lidt kode (ikke færdig syet!)
<?
mysql_pconnect(\"adresse\",\"db-navn\",\"password\") or die(\"Can\'t connect to the SQL-server\");
mysql_select_db(\"tabellen\");
if($action == \"view\") {
/* function for showing the data */
function search_it($name) {
/* some vars */
global $offset,$total,$lpp,$dir;
global $table,$html_mail,$admin_name,$admin_mail;
/* select the data to get out of the database */
$query = \"select * from gaestebogen order by dato desc\";
$result = mysql_query($query);
$total= mysql_numrows($result);
print \"<CENTER><FONT FACE=\\\"Verdana\\\" SIZE=\\\"-2\\\"><A HREF=\\\"$PHP_SELF.php?action=add\\\" onMouseOver=\\\"window.status=\'Add your name\';return true\\\" onMouseOut=\\\"window.status=\'\';return true\\\" TITLE=\\\"Add your name\\\">(Add your name)</A></FONT></CENTER><br><br>\";
if ($total== 0) {
print \"<CENTER>At the moment there are no persons in the guestbook.</CENTER><br><br>\"; }
elseif ($total> 0) {
/* default */
$counter=0;
if ($dir==\"\") $dir=\"Next\";
/* Her bestemmes hvor mange indlæg der vises af gangen */
$lpp=5;
/* ---------------------------------------------------------------------------------*/
if ($offset==0) $offset=0;
if ($dir==\"Next\") {
if ($total > $lpp) {
$counter=$offset;
$offset+=$lpp;
$num=$offset;
if ($num > $total) {
$num=$total; } }
else {
$num=$total; } }
elseif ($dir==\"Previous\") {
if ($total > $lpp) {
$offset-=$lpp;
if ($offset < 0) {
$offset=0; }
$counter=$offset-$lpp;
if ($counter < 0)
$counter=0;
$num=$counter+$lpp; }
else {
$num=$total; } }
while ($counter < $num) {
$j=0;
$j=$counter + 1;
/* now really grab the data */
$i1=mysql_result($result,$counter,\"navn\");
$i2=mysql_result($result,$counter,\"mail\");
$i3=mysql_result($result,$counter,\"site\");
$i4=mysql_result($result,$counter,\"text\");
$i4 = stripslashes (\"$i4\");
/* print it in a nice layout */
print \"<CENTER>\\n\";
print \"<TABLE WIDTH=400 BORDER=0 ALIGN=CENTER VALIGN=TOP><TR><TD><FONT FACE=\\\"Verdana\\\" SIZE=\\\"-2\\\">\\n\";
print \"<HR>\\n\";
print \"<B>Navn:</B> <A HREF=\\\"mailto:$i2\\\" onMouseOver=\\\"window.status=\'Email $i1\';return true\\\" onMouseOut=\\\"window.status=\'\';return true\\\" TITLE=\\\"Email $i1\\\">$i1</A>\\n\";
print \"<BR><B>Site:</B> $i3\\n\";
print \"<BR><B>Besked:</B>\\n\";
print \"<BR>$i4\\n\";
print \"</FONT></TD></TR></TABLE>\\n\";
print \"</CENTER>\\n\";
$counter++;
}
}
mysql_close();
}
/* execute the function */
search_it($name);
/* See if we need to put on the NEXT or PREVIOUS buttons */
if ($total > $lpp) {
echo(\"<form action=\\\"$PHP_SCRIPT\\\" method=\\\"POST\\\">\\n\");
/* See if we need a PREVIOUS button */
if ($offset > $lpp) {
echo(\"<input type=\\\"submit\\\" value=\\\"Previous\\\" name=dir>\\n\"); }
/* See if we need a NEXT button */
if ($offset < $total) {
echo(\"<input type=\\\"submit\\\" value=\\\"Next\\\" name=dir>\\n\"); }
echo(\"<input type=hidden name=\\\"offset\\\" value=\\\"$offset\\\">\\n\");
echo(\"<input type=hidden name=\\\"name\\\" value=\\\"$name\\\">\\n\");
echo(\"</form>\");
}
}
?>
Den er noget forkortet og har kun \'Next\' og \'Prev\' men den virker.
/Reflex
Ny bruger
Nybegynder
Opret
Preview
