Howes-IT-Going - PHP MySQL Guestbook

By Running entry.html the Results should be:

Howes-IT-Going PHP MySQL Guestbook Application

The following example shows how to create your own simple PHP MySQL Guestbook Application. You will need to have PHP and MySQL BOTH Installed on a server And a Web Browser to View the Results. Use the Create_guest_book.txt file contents to create the needed table for this example. Copy the entry.html as the launch for your guest book application -- Then copy and save the two .php scripts.

Create_guest_book.txt || entry.html || add_entry.php || view_entry.php

Save As add_entry.php or Highlight Code and Save As *.php! <?php // // Howes-IT-Going.com Not Responsible for Usage or Reproduction // You Use This PHP Script and MySQL Database At Your Own Risk! // $dbservertype='mysql'; // PHP and MySQL Must Be Installed on a Server to Run .PHP Scripts with MySQL // You first need to Create a MySQL Database on a Server // Then enter 'Server Name', 'Database Name', 'User Name', 'Password' Below // Use Create_guest_book.txt file contents in MySQL to Create 'guest_book' Table $servername=''; // ='' <-- enter ='Server Name'; $dbname=''; // ='' <-- enter ='Database Name'; $dbusername=''; // ='' <-- enter ='User Name'; $dbpassword=''; // ='' <-- enter ='Password'; // Don't Change Any Other Code. connecttodb($servername,$dbname,$dbusername,$dbpassword); function connecttodb($servername,$dbname,$dbusername,$dbpassword) { global $link; $link=mysql_connect ("$servername","$dbusername","$dbpassword"); if(!$link){die("Could not connect to MySQL");} mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error()); } ?> <!doctype html public "-//w3c//dtd html 3.2//en"> <html>  <head> <title>Howes-IT-Going - PHP MySQL Guest Book Example</title> </head> <body> <? $email=$_POST['email']; $name=$_POST['name']; $country=$_POST['country']; $dtl=$_POST['dtl']; $status = "OK"; // set simple validation flag $msg=""; // error message string blank if (!stristr($email,"@") OR !stristr($email,".")) { $msg="<center>Your email address is not correct</center> "; $status="NOT OK"; } // check email address if(strlen($name) < 2 ){ // if name is less than two char length $msg .="<center>Please enter your name</center> "; $status="NOT OK"; } if($status<>"OK"){ echo " "; echo $msg. " <center><input type='button' value='Retry' onClick='history.go(-1)'></center> "; }else{ $tm=time(); // adding data to mysql database $rt=mysql_query("insert into guest_book(name,email,country,tm,dtl) values('$name','$email','$country','$tm','$dtl')"); echo mysql_error(); echo "<center>Entry added, Thank YOu. <a href=view_entry.php>Click here to view entries</a>. </center> "; } ?> <center><a href='http://www.howes-it-going.com'>Howes-IT-Going.com For I.T. Consulting and Coding Examples</a></center> </body> </html>

Save As view_entry.php or Highlight Code and Save As *.php! <?php // // Howes-IT-Going.com Not Responsible for Usage or Reproduction // You Use This PHP Script and MySQL Database At Your Own Risk! // $dbservertype='mysql'; // PHP and MySQL Must Be Installed on a Server to Run .PHP Scripts with MySQL // You first need to Create a MySQL Database on a Server // Then enter 'Server Name', 'Database Name', 'User Name', 'Password' Below // Use Create_guest_book.txt file contents in MySQL to Create 'guest_book' Table $servername=''; // ='' <-- enter ='Server Name'; $dbname=''; // ='' <-- enter ='Database Name'; $dbusername=''; // ='' <-- enter ='User Name'; $dbpassword=''; // ='' <-- enter ='Password'; // Don't Change Any Other Code. connecttodb($servername,$dbname,$dbusername,$dbpassword); function connecttodb($servername,$dbname,$dbusername,$dbpassword) { global $link; $link=mysql_connect ("$servername","$dbusername","$dbpassword"); if(!$link){die("Could not connect to MySQL");} mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error()); } ?> <!doctype html public "-//w3c//dtd html 3.2//en"> <html>  <head> <title>Howes-IT-Going - PHP MySQL Guest Book Example</title> </head> <body> <? $query=mysql_query("select * from guest_book order by tm desc"); echo "<table border='0' width='400' cellspacing='0' cellpadding='0' align=center>"; while($nt=mysql_fetch_array($query)){ $dt=date("m/d/y",$nt['tm']); // formating the date $dtl=nl2br($nt['dtl']); // this will change the line breaks to html line breaks echo "<tr><td>Name</td><td>$nt[name]</td>"; echo "<td>Email</td><td>$nt[email]</td></tr>"; echo "<tr bgcolor=#f1f1f1><td>Country</td><td>$nt[country]</td>"; echo "<td>Date:</td><td>$dt</td></tr>"; echo "<tr><td colspan=4>$dtl</td></tr>"; echo "<tr><td colspan=4><hr></td></tr>"; } echo "</table>"; echo "<center><a href='entry.html'>Add entry</a></center> "; ?> <center><a href='http://www.howes-it-going.com'>Howes-IT-Going.com For I.T. Consulting and Coding Examples</a></center> </body> </html>