Reply to thread

Message

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

[QUOTE="MaD-DoC, post: 4130205, member: 56284"] [B]Simple guestbook[/B] [B]Description[/B] 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. [B]The code[/B] [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] [/QUOTE]

Verification

Asuwa dahayen wadi kalama keeyada?

Search

Latest ads

Reply to thread