Formbuilder Using a MySQL Database

Submitted Data

Here are the results of the User submitted data.

Required Code

Please Note: When you have created your page, save your page with the .PHP extension.

If your server supports the .htaccess file, and depending what version of PHP your server is running, you can add a line into the .htaccess file which will allow you to carry on using the .html file format and run php and 'include' from within your page.

For php 5 just add this line:- AddHandler application/x-httpd-php5 .html .htm
For previous version use:- AddHandler application/x-httpd-php .html and AddHandler application/x-httpd-php .htm

Some Apache servers are already configured to do this, so please check first.

Here is how to edit the code you will need to add to your page in order to display it on your page.
There are a few things you will have to change to match the code to your own database settings, start from the top of the code and where you see "yourinfo" (there are 3 of these) change this to your own info, next look for "tablename in this line:-
$result = mysql_query("SELECT * FROM tablename ORDER BY First",$dbcon); " change this to to name of your Table, next after "ORDER BY" change First with the Fieldname you would like the data sorting by.
Finally you will need to change the strings below to match your own Fieldnames:

// load to vairables
$field1 = $arow["yourfield"];
$field2 = $arow["yourfield"];
$field3 = $arow["yourfield"];
$field4 = $arow["yourfield"];
// -------------------------- display data
// output rows
echo "<tr><td>$field1</td><td>$field2</td><td>$field3</td><td>$field4</td>";

That is it, below is the full code to be edited.

Table CSS

If you want the CSS code for the table display, here it is, you can leave the scroll box section out if you want.