5d8a1e7654 Add ReviewClose Rated 1.74 out of 5 0 Member Reviews Views: 4,963 Price: Free Simple Posting System MORE DETAILS Simple Posting System (SPS) is a PHP program that can be used as a simple guestbook, a news system, etc. Code : A Simple Guestbook in PHP & MYSQL "; echo " Click here to Leave us a message "; echo " Comments from Visitors "; // Fetch and Display the Results from the Database $result = mysqlquery("select name, email, country, vcomment from guestbook ORDER BY id",$dbi); while ($myrow = mysqlfetcharray($result)) { echo " name: $myrow[0] email: $myrow[1] Country: $myrow[2] message: $myrow[3] "; } echo(" This guest book is coded in PHP and uses MySQL to store data "); ?> Make the same changes to the variables $host, $name, $pass and $dbname, as you have done in storecomment.php, and upload the file. Hope that helps! Reply Leave a Reply Cancel reply Your email address will not be published. Online Demos. Template can be easily modified. You can subscribe via RSS Feeds, Liking our Facebook Page or by Following us on Twitter. We'll need to create some PHP and MySQL code to capture the visitor's input and save it to the database.
The field "Comment" is mandatory and the will not be posted until that field has been filled out. This is done using the mysqlselectdb() function, and the syntax for this function is Code : mysqlselectdb(databasename, databaseconnector); Now let's get to coding the actual data insertion process. If the script has been purchased more than a year ago, an update fee is required. That is saved for an upcoming tutorial. Consider leaving a review and let others know more about your experience. It has a very user friendly control panel from where administrator can control all functionalities of this script. Create a new HTML page, and in the body tag of the page, add the following code. If you want the code which I used to create the look of the form above, you can use the following code: Code : Your Name Your Email ID Country Comments You can save this HTML code as comments.php The Database Table Before we can capture and store this data into the database, we'll need to create a table to store the data (I'm assuming that you already have a database created and ready to use).
Melodelf replied
414 weeks ago