[How do I take input and put it into a table.]

Hi PFMaBiSmAd.

 

Thanks for your input.  Yes the current "form to e-mail" is a joomla extension. 

 

It is mad4joomla http://extensions.joomla.org/extensions/contacts-and-feedback/forms/5597

 

Do you think I could modify this form?  It would be handy because it does look like it "fits" on the website.

[How do I take input and put it into a table.]

Thanks guys.

 

I now have a database

 

I have found elsewhere how to connect to the DB and have the following code.

 

 

<?php

 

// open connection to mysql server

// dbc is a variable

$dbc = mysql_connect ('localhost','airfield_data','mypassword');

 

if (!dbc){

die("not connected :" . mysql_error());

}

// select the database

 

$db_selected = mysql_select_db ("airfield_data",$dbc);

 

if (!db_selected)

{

die ("cant connect :" . mysql_error());

 

}

 

// test

 

$query="UPDATE ";

 

?>

 

So my question is now how to write the submission script?  If someone could please give me the code to add my data to the database (only one I'll do the rest obviously)

[How do I take input and put it into a table.]

Brilliant, thanks for that.

 

I've started to build the DB and I've got an error message like so.  Any ideas what I should do?

 

 

[attachment deleted by admin]

[How do I take input and put it into a table.]

At the moment the user puts it in via this form.http://www.microlight.co/index.php/New-Airfield

 

I then take the information (from an e-mail that the form sends to me) and edit the card (HTML table) like in this page http://www.microlight.co/index.php/billaricay

[How do I take input and put it into a table.]

Hi Litebearer.

 

Thank you for your input.

 

The new database is bare at the moment.  There are no tables whatsoever in there.

 

This is the data I get back from the current form...

 

***************************** start quoted form returns **************************

Your Name : trevor

Airfield Name : Billericay / Napps Field

Height Above Sea Level : 200 ft

General Location : 2 miles North of Billericay

Co-Ordinates : N 51.29.25 E 0.25.10

Prior Permission Required : Yes

Alternative Airfield : Laindon

Air Ground Radio : No

Radio Frequency : use safety comm

Runways : 08 / 26 600m

Circuits : To the South of the airstrip

Remarks : runway dips to the western end no faciliies and no fuel etc. Airfiled used to be known as Brocks Farm and now appears on CAA maps as Napps field

Warnings : 08 departure please turn right 26 landing angled approach in to avoid houses.

Operating Hours : sr to ss

Airfield Operator and Contact Details : Bob Napp 01277-840287 07968-861592

Landing Fee : see bob

**************************** end quoted form returns **************************

 

So from that I guess that my table should be "named" and the number of fields should be 16?

 

I won't do anything with that until someone says that it's right.

 

[attachment deleted by admin]

[How do I take input and put it into a table.]

Hi Nomadsoul.

 

Thank you for your offer of help. 

 

I have set up a new database and have phpMyAdmin 3.3.3 installed on my system.  Please be gentle with me, I've not used it before ever.

[How do I take input and put it into a table.]

Hello people.

 

I am very new to PHP and have a website for microlight pilots where you can add an airfield.

 

It is a Joomla based site and the input form can be seen here. http://microlight.co/index.php/New-Airfield

 

I am quite prepared to re-write the whole input form again if I have to.

 

Now here's my question.  I would like the output of the form to be in an HTML table like it is on this page http://microlight.co/index.php/billaricay

 

This is because at the moment people fill out the form, I get an e-mail with the info, and then have to put it into the airfield card manually myself.

 

Sorry, If my explanation isn't very clear.  But basically want users input into a table.