I’ve learned building a guestbook script using Apache, PHP and Mysql... Please send me sample script?

Question

I’ve learned building a guestbook script using Apache, PHP and Mysql

I build a guestbook script and successfully… after submitting it will send the data to the mysql database.

Name: _________________
Location: ___________________
Email: ______________________
Message: ____________________

But how can I get from MYSQL Database and display it on HTML File.
If I browse the MYSQL Directory…. The format of the database is guest.myi and guest.frm inside the phpguest folder.

Sample format of desired html
Name Location Email Message
TonyPhilippines [e-mail] Hello
IlonahNew York [e-mail] Hi, How are You

Can someone give me the source code on the output getting from the a certain database with a format guest.myi and guest.frm

Thank you….

Answer 1

Well, I'll assume certain things:

1. You know how to connect to the database, as you can connect to it to save the data.
2. The data is stored in a table named "guestbook" and the fields are: "name", "location", "email" and "message".
3. You don't need pagination (show the results in more than one page). If you need to, post another question and I'll answer it.

$results = mysql_query("SELECT * FROM guestbook ORDER BY name"); //you can order by whatever you want
while ($result = mysql_fetch_array($results))
{
echo "Name: ".$result["name"]."
";
echo "Location: ".$result["location"]."
";
echo "Email: ".$result["email"]."
";
echo "Message: ".$result["message"]."

";
}

The way these results are shown can be different. That is something you can format with HTML (see http://www.htmlquick.com ). The values are stored in the $result["what"] variables.

Answer 2

HTML. it somewhat is it. pass to web pages, view the source from those web pages, and learn by potential of coping what persons do. in case you desire to construct dynamic pages that adjust finding on how people use the pages, you will would desire to earnings a language like Hypertext Preprocessor and MySQL. yet do no longer initiate studying that until eventually you have written some HTML pages.

Answer 3

$connection = mysql_connect($dbhost, $dbuser, $dbpass) ;
mysql_select_db($dbname) ;
$resultset=mysql_query("select name,emailid,msg from guestbook");
print "