 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| PHP Web Logs (BLogs) | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Submit Site | ||
| Forex Trading Online forex trading platform | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | |||||
<? // // Give me comment if I there is a bug on it. // // // //CREATE DATABASE guest; //USE guest; //CREATE TABLE guestbook ( // id mediumint(8) DEFAULT '0' NOT NULL auto_increment, // name varchar(30) DEFAULT '' NOT NULL, // email varchar(30) DEFAULT '' NOT NULL, // comments text DEFAULT '' NOT NULL, // mdate TIMESTAMP, // PRIMARY KEY (id) //); echo "<HTML><HEAD><TITLE>Guestbook</TITLE></HEAD><BODY>"; mysql_connect( "localhost", "USERNAME", "PASSWORD"); mysql_select_db("guestbook") or die("Error opening database"); $$EXTEND =""; $ROW_PER_PAGE = 10; $rel = mysql_query("select * from guestbook order by mdate DESC"); $MAX_ROW = mysql_num_rows($rel); if (isset($BUTTON)) { $EXTEND = "limit $LOWER_ROW, $UPPER_ROW"; } else { $BUTTON = Begin; $TMP_NUM = 0 ; } switch ($BUTTON) { case Begin: $TMP_NUM = 0 ; $EXTEND = "limit $ROW_PER_PAGE "; break; case End: $TMP_NUM = $MAX_ROW - $MAX_ROW % $ROW_PER_PAGE; $LOWER_ROW = $TMP_NUM ; if ($LOWER_ROW == $MAX_ROW && $LOWER_ROW != 0) { $LOWER_ROW = $MAX_ROW - $ROW_PER_PAGE; $TMP_NUM = $TMP_NUM - $ROW_PER_PAGE; } $EXTEND = "limit $LOWER_ROW, $ROW_PER_PAGE"; break; case Prev: $TMP_NUM = $CURVALUE - $ROW_PER_PAGE; if ($TMP_NUM < 0) { $TMP_NUM = 0; $LOWER_ROW = 0; } else { $LOWER_ROW = $TMP_NUM; } $EXTEND = "limit $LOWER_ROW, $ROW_PER_PAGE"; break; case Next: if (($CURVALUE + $ROW_PER_PAGE) < $MAX_ROW ) { $LOWER_ROW = $CURVALUE + $ROW_PER_PAGE; }else{ $LOWER_ROW = $CURVALUE; } $TMP_NUM = $LOWER_ROW; $EXTEND = "limit $LOWER_ROW, $ROW_PER_PAGE"; break; } if ($argv[0] == "add"): ?> <P><FORM NAME="guestbook" ACTION="<?echo $PHP_SELF?>" METHOD=POST><BR> <TABLE WIDTH=340 BGCOLOR="#66CCFF" VALIGN="CENTER" BORDER="0" CELLSPACING="1" CELLPADDING="1"> <INPUT TYPE=hidden NAME=cmd VALUE=send> <TR><TD ALIGN="RIGHT">Your Name:</TD> <TD><INPUT TYPE=text NAME=name></TD></TR> <TR><TD ALIGN="RIGHT">Your E-mail: </TD> <TD><INPUT TYPE=text NAME=email></TD></TR> <TR><TD COLSPAN="3">Comments:</TD></TR> <TR><TD COLSPAN="100%" ALIGN="CENTER"><TEXTAREA NAME=comments COLS=34 ROWS=6></TEXTAREA><BR> <CENTER><INPUT TYPE=submit VALUE=Submit><INPUT TYPE=reset VALUE=Clear></CENTER></TD></TR> </TABLE> </FORM> <? include("./tpl/footer.txt"); // if the query string is view, the fetch the guestbook entries else: if (isset($cmd) && $cmd == "send" && $name != '' && $comments != '' ) { $comments = nl2br(htmlspecialchars(addslashes($comments))); $abc = mysql_query("select * from guestbook where name = '$name' and comments = '$comments'"); if (mysql_num_rows($abc)== 0) { mysql_query("insert into guestbook (name, email, comments) values ('$name', '$email', '$comments')"); } } include("./tpl/header.txt"); echo "<H2>Guestbook Entries</H2>"; echo "<H4><A HREF=\"$PHP_SELF?add\">My Comments</A></H4>"; $result = mysql_query("select * from guestbook"); $row = mysql_num_rows($result); echo "<P>There are <I>$row[0]</I> entries in the guestbook.<P>"; $result = mysql_query( "select UNIX_TIMESTAMP(mdate), name, email, comments from guestbook order by mdate DESC $EXTEND"); while ($row = mysql_fetch_row($result)) { echo "<TABLE WIDTH=340 BGCOLOR=\"#99CCFF\" VALIGN=\"LEFT\" BORDER=\"0\" CELLSPACING=\"0\" CELLPADDING=\"5\">"; echo "<TR>"; echo "<TD COLSPAN=\"50%\" ><I><FONT SIZE=\"-2\"><B>".date("d-M-Y H:i:s",$row [0])."</FONT></I></B></TD>"; echo "<TD COLSPAN=\"50%\" ALIGN=\"RIGHT\"><FONT SIZE=\"-1\"><A HREF=\"mailto:$row [2]\">$row[1]</A>"; echo "</TD>"; echo "</TR>"; echo "<TR BORDER=\"1\">"; echo "<TD COLSPAN=\"100%\"BGCOLOR=\"#FFFFCC\">".stripslashes($row[3]); echo "</TD>"; echo "</TR>"; echo "</TABLE>"; echo "<BR>"; } ?> <FORM NAME="test" ACTION="<?echo $PHP_SELF?>" METHOD=POST> <INPUT TYPE=hidden NAME=CURVALUE VALUE=<? echo $TMP_NUM;?>> <INPUT TYPE=submit NAME="BUTTON" VALUE=Begin> <INPUT TYPE=submit NAME="BUTTON" VALUE=Prev> <INPUT TYPE=submit NAME="BUTTON" VALUE=Next> <INPUT TYPE=submit NAME="BUTTON" VALUE=End> </FORM> <? endif; ?> | |||||
| Related Code Examples | |||||
