Content Management Code
  Home arrow Content Management Code arrow Guestbook
Codewalker Forums 
  Tutorials  
Database Articles  
Miscellaneous  
Navigation Usability  
PEAR Articles  
Programming Basics  
Server Administration  
XML Tutorials  
  Reviews  
Database Book Reviews  
Linux Book Reviews  
Miscellaneous Reviews  
PHP Book Reviews  
PHP Software Reviews  
Server Admin Reviews  
SQL Tool Reviews  
  Code Gallery  
Content Management Code  
Contest Code  
Counters Code  
Database Code  
Date Time Code  
Discussion Board Code  
Email Code  
File Manipulation Code  
GUI Code  
Link Farm Code  
Miscellaneous Code  
Search Code  
Site Navigation Code  
User Management Code  
Mobile Linux 
App Generation ROI 
IBM® developerWorks 
Download TestComplete 
Forums Sitemap 
Weekly Newsletter 
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
CONTENT MANAGEMENT CODE

Guestbook
By: Codewalkers
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 3 stars3 stars3 stars3 stars3 stars / 11
    2002-01-18

    Table of Contents:

    Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    This is a guestbook script, that stores all records in a MYSQL database. Displays records by pages. Highly configurable interface. For more information contact me at: nerd@kic.kmtn.ru See demo of the script at: http://php.inc.ru

    By : lyonchik

    <?
    /********************************************************************************
    Guestbook by lyonchik: nerd@kic.kmtn.ru
    Contact me to report bugs, give your comments or
    to develop your own personalized Web applications.

    This is a simple guestbook. It consists only of one file.
    All you need to do is create a MYSQL database table and set the variables below
    to conform to your settings and that's it.
    The sample query to create a table should be:

    "CREATE TABLE guestbook (id int(5) NOT NULL auto_increment, name varchar(20),
    email varchar(20), message text, date datetime, PRIMARY KEY (id))"

    And the guestbook is ready to go. Enjoy!

    You can freely distribute this code. For any suggestions and comments write to:
    'nerd@kic.kmtn.ru'. Feel free to email me URLs where this guestbook works,
    I would love to hear that my work is appreciated.
    *********************************************************************************/

    // Define MYSQL server information
    $server = 'localhost'; // MYSQL server;
    $user = ''; // User to connect to MYSQL server;
    $password = ''; // Password;
    $database = 'database name'; // The name of the database;
    $table = 'guestbook'; // The name of your database table;

    // Define page layout variables
    $guestbook_name = "My guestbook page"; // Guestbook page name;
    $titlecolor = 'black'; // Title font color;
    $tablewidth = "90%"; // Table width in pixels or percentage;
    $bgcolor = '#AAAAAA'; // Table background color value (name of hex equivalent);
    $bordercolor = '#000000'; // Table border color value (name of hex equivalent);
    $bordersize = 5; // Table border size;
    $cellspacing = 0; // Table cellspacing value;
    $cellpadding = 5; // Table cellpadding value;
    $messagecellcolor = '#BBAAAA'; // message cell color;
    $namecolor = '#0000EE'; // name font color;
    $messagecolor = '#000099'; // message font color;
    $mainfont = '#000033'; // main text font color;
    $maxshow = 10; // Number of messages to display per page;
    ?>
    <HTML>
    <META http-equiv=Content-Type content="text/html; charset=windows-1251">
    <HEAD>
    <TITLE>
    <?
    echo $guestbook_name;
    ?>
    </TITLE>
    <script language="javascript">
    function checkForm()
    {
    if ((document.forms.myGB.name.value == '') || (document.forms.myGB.message.value == ''))
    {
    alert('Fill in required fields!');
    }
    else {
    document.forms.myGB.submit();
    }
    }
    </script>
    </HEAD>
    <?


    echo "<BODY bgcolor=" . $bgcolor . ">";
    echo "<div align=center><h1><font color=" . $titlecolor . ">" . $guestbook_name . "</font></h1>";




    if (isset($message))
    {
    if ($email == "")
    {
    $email = "no_email";
    }
    mysql_connect ($server, $user, $password) or die ("Can't connect!");
    mysql_select_db ($database) or die ("Can't open database!");
    $sql = "INSERT INTO $table (name, email, message, date) VALUES ('$name', '$email', '$message', NOW())";
    $result = mysql_db_query($database, $sql);
    if ($result)
    echo "<meta http-equiv='Refresh' content='0; URL=" . $PHP_SELF . "'>";
    else
    echo "Error! Check the form!";
    mysql_close();
    }


    if (!isset($show))
    {
    $show = 0;
    }
    mysql_connect($server, $user, $password) or die ("Can't connect!");
    mysql_select_db($database) or die ("Can't open database!");
    $sql = "SELECT * FROM $table ORDER BY id DESC";
    $result = mysql_db_query($database, $sql);
    if ($result)
    {
    $count = mysql_num_rows($result);

    $sqlshow = "SELECT * FROM $table ORDER BY id DESC LIMIT $show, $maxshow";
    $result = mysql_db_query($database, $sqlshow);
    ?>
    <table width=<? echo $tablewidth ?> cellspacing=<? echo $cellspacing ?> cellpadding=<? echo $cellpadding ?> border=<? echo $bordersize ?> bordercolor=<? echo $bordercolor ?>>
    <?
    while (($myrow = mysql_fetch_array($result)))
    {
    echo "<tr><td colspan=2 valign=top bgcolor=" . $messagecellcolor . "><font color=" . $messagecolor . ">Sent by <b>" . htmlspecialchars($myrow["name"]) . "</b><i>, " . $myrow["date"] . "</i><br>Email: <a href=mailto:" . htmlspecialchars($myrow["email"]) . ">" . htmlspecialchars($myrow["email"]) . "</a><br><br>" . htmlspecialchars($myrow["message"]) . "</font></td></tr>";
    }
    ?>
    </table>
    <?
    }
    else
    echo "Error!";
    mysql_close();

    echo "<font color=" . $mainfont . ">";
    echo "<br>";
    $pages = $count / $maxshow;
    if ($pages < 1)
    {
    $pages = 1;
    }
    if ($pages / (int) $pages <> 1)
    {
    $pages = (int) $pages + 1;
    }
    else
    {
    $pages = $pages;
    }
    $pagenow = ($show/$maxshow + 1);
    echo "Page " . $pagenow . " of " . $pages . "<br>";
    $next = $show + $maxshow;
    $previous = $show - $maxshow;
    if ($pages <> 1)
    {
    if ($previous < 0)
    {
    echo "<a href=" . $PHP_SELF . "?show=" . "$next" . ">";
    echo "<acronym title='Next " . $maxshow . " records'>>>></acronym></a> ||";
    }
    elseif ($next >= $count)
    {
    echo "<a href=" . $PHP_SELF . "?show=" . "$previous" . ">";
    echo "<acronym title='Previous " . $maxshow . " records'><<<</acronym></a> ||";
    }
    else
    {
    echo "<a href=" . $PHP_SELF . "?show=" . "$previous" . ">";
    echo "<acronym title='Previous " . $maxshow . " records'><<<</acronym></a>";
    echo " | ";
    echo "<a href=" . $PHP_SELF . "?show=" . "$next" . ">";
    echo "<acronym title='Next " . $maxshow . " records'>>>></acronym></a> ||";
    }
    }
    echo " Pages: ";
    $i = 0;
    while ($i < $pages)
    {
    $ri = $i + 1;
    $showpage = $i * $maxshow;
    echo "<a href=" . $PHP_SELF . "?show=" . $showpage . ">" . $ri . "</a> ";
    $i++;
    }
    ?>

    <p>
    (*) Required fields
    <form name='myGB' action=<? echo $PHP_SELF ?> method='post'>
    * Name:<br><input type='text' name='name' maxlength=20><br>
    Email:<br><input type='text' name='email' maxlength=20><br>
    * Message:<br><textarea name='message' rows=5 cols=30></textarea><br>
    <a href="javascript:checkForm()">Send</a>
    </form>
    </font>
    </div>
    </BODY>
    </HTML>
    DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

    More Content Management Code Articles
    More By Codewalkers

     

    IBM® developerWorks developerWorks - FREE Tools!


    NEW! A Layered approach to delivering security-rich Web applications

    As businesses grow increasingly dependent upon Web applications to provide services to customers, employees and partners, these complex applications become more difficult to secure. Although traditional security solutions protect Internet infrastructure layers, they do not guard against HTTP and HTML attacks. Many organizations that conduct security testing still deploy applications that allow attackers to manipulate their logic and wreak havoc on their business. To mitigate this risk, development and delivery teams must address Web application security throughout the lifecycle, addressing the many layers detailed in this paper.
    FREE! Go There Now!


    NEW! Hello World: Monitor a simple business process using WebSphere Business Monitor V6.0.2

    This tutorial shows new users of IBM WebSphere Business Monitor Version 6.0.2 how to perform the "Hello World" equivalent for monitoring business process applications. It is intended to help you get familiar with the capabilities of the product.
    FREE! Go There Now!


    NEW! Rational Build Forge Express eKit

    Rational Build Forge Express Edition is an automation framework that packages the latest enterprise-grade technologies into a reliable, flexible and robust configuration designed and priced specifically for small to midsize businesses. The new Rational Build Forge Express eKit provides you with valuable resources – including a case study, podcast, demo, and articles – to help you increase staff productivity, compress development cycles and deliver better software, fast.
    FREE! Go There Now!


    NEW! Rational Talks to You:Per Kroll on Rational Method Composer Plug-in customization

    Join this Rational Talks to You teleconference on December 11 at 1:00 pm ET to get tips on building your own plugins with Rational Method Composer. Get your questions answered!
    FREE! Go There Now!


    NEW! Rational Talks to You: Scott Ambler on being agile in a global development environment

    Join this Rational Talks to You teleconference on December 6 at 1:00 pm ET to participate in an agile application development discussion and get your questions answered on using IBM Rational Method Composer in a distributed environment.Get your questions answered!
    FREE! Go There Now!


    NEW! Try the IBM SOA Sandbox for Connectivity

    Visit IBM developerWorks to try the IBM SOA Sandbox for connectivity. The SOA Sandbox for connectivity provides a trial environment with the tooling and components to help you explore how to effectively connect your infrastructure and integrate all of the people, processes and information in your company. Use the hosted sandbox to explore SOA techniques that streamline connecting existing IT assets together, as well as learn how to connect them to new business logic.
    FREE! Go There Now!


    NEW! Try the IBM SOA Sandbox for Process

    Visit IBM developerWorks to try the IBM SOA Sandbox for process. The SOA Sandbox for process focuses on providing a trial environment with the necessary tooling and components required to gain a better understanding of business processes and how to best improve existing business processes to derive value quickly.
    FREE! Go There Now!


    NEW! Understanding Web application security challenges

    As businesses grow increasingly dependent upon Web applications, these complex entities grow more difficult to secure. Most companies equip their Web sites with firewalls, Secure Sockets Layer (SSL), and network and host security, but the majority of attacks are on applications themselves – and these technologies cannot prevent them. This paper explains what you can do to help protect your organization, and it discusses an approach for improving your organization’s Web application security.
    FREE! Go There Now!


    NEW! Webcast: Extreme transaction processing with WebSphere Extended Deployment

    In this webcast, you'll get an introduction to the eXtreme Transaction Processing (XTP) features of WebSphere Extended Deployment and the common architectural traits required by XTP applications. See how WebSphere Extended Deployment's ObjectGrid feature provides a state-of-the-art infrastructure for hosting XTP applications.
    FREE! Go There Now!


    NEW! Whitepaper: Delivering SOA solutions: service lifecycle management

    The unprecedented scope of a service-oriented architecture (SOA) initiative brings to the forefront a number of management and governance issues that were sidestepped in the past. The key to a successful SOA implementation is managing and governing activities throughout the entire SOA delivery lifecycle by ensuring that services conform to the needs of all of the business’s stakeholders. Learn how service lifecycle management allows the business to ensure that the process by which services are defined, created, tested, deployed, optimized and retired is manageable, repeatable and auditable.
    FREE! Go There Now!



    All FREE IBM® developerWorks Tools!

    CONTENT MANAGEMENT CODE ARTICLES

    - V2 CMS - Content Management System
    - VSNS Lemon
    - Country List For Forms Using SQL
    - eggblog
    - Table generation class
    - STP Simple Template Parser
    - class Vision_To_Form_Elements
    - Cascade Drop Down
    - Cura - CMS
    - Syntax Desktop
    - 216 color table
    - Simple Mini Poll class library (SimPoll)
    - Regex Generator
    - Siteseed
    - Company WebSite Builder PRO





    © 2003-2009 by Developer Shed. All rights reserved. DS Cluster 4 Hosted by Hostway
    For more Enterprise Application Development news, visit eWeek