Reply to thread

Message: <blockquote data-quote="MaD-DoC" data-source="post: 4130205" data-attributes="member: 56284">Simple guestbook       Description       Allows visitors to your site to read your guestbook entries and post a message of their own. Very simple setup, only requires you to change 4 settings. Uses MySQL to store the entries.       The code       [PHP]<?php/** * Create the table in your MySQL database: *  * CREATE TABLE guests ( *   id int(10) NOT NULL auto_increment, *   name varchar(50) NOT NULL, *   message varchar(255) NOT NULL, *   date timestamp(14) NOT NULL, *   PRIMARY KEY (id) * ) *  * Change the database login settings to your own *  * The script is now ready to run */// Change these to your own database settings$host = "localhost";$user = "username";$pass = "password";$db = "database";mysql_connect($host, $user, $pass) OR die ("Could not connect to the server.");mysql_select_db($db) OR die("Could not connect to the database.");      $name = stripslashes($_POST['txtName']);$message = stripslashes($_POST['txtMessage']);if (!isset($_POST['txtName'])) {    $query = "SELECT id, name, message, DATE_FORMAT(date, '%D %M, %Y @ %H:%i') as newdate FROM guests ORDER BY id DESC";    $result = mysql_query($query);        while ($row = mysql_fetch_object($result)) {?><?php echo $row->message; ?> Posted by <?php echo $row->name; ?> on <?php echo $row->newdate; ?><?php            }    ?>Post a message<form method="post" action="<?php echo $_SERVER['REQUEST_URI']; ?>">    <label for="txtName">Name:</label>     <input type="text" title="Enter your name" name="txtName" />    <label for="txtMessage">Your message:</label>     <textarea title="Enter your message" name="txtMessage"></textarea>        <label title="Send your message">    <input type="submit" value="Send" /></label>    </form><?php}else {    // Adds the new entry to the database    $query = "INSERT INTO guests SET message='$message', name='$name', date=NOW()";    $result = mysql_query($query);    // Takes us back to the entries    $ref = $_SERVER['HTTP_REFERER'];    header ("Location: $ref");}?> [/PHP]</blockquote>

Verification: Dawasata paya keeyak thibeda?

Top Bottom

Search

Latest ads

Reply to thread