help stuck, new and running out of time

[dmason153]

Hi guys im new to this php mysql lark i have designed a database on my server and am uploading the website however i have not the foggierst how to link the website input boxes to my database, if anyone can help it would be much appreciated where can i get my hand son the code to do this, i would even be willing to pay anyone if they wanted to take up a small task, but in the mean time i would like to learn myself so any help is so appreciated

regards
david

[theeper]

You need to be a little more specific.

To link your site to the DB requires you to setup permissions on the DB, then make a connection to the DB, then issue queries from your script.

[Pig]

There are a couple things you have to do.

1) make the action of your form be a php page that processes the script. eg: action="form_process.php" or something like that.

2)Then, you have to build the query into the form_process.php page.

a) connect to your server and db.

b) validate the form to make sure they don't have garvage in there

c) Set up a query to add the information to the database
eg: mysql_query("INSERT INTO table_name (field1, field2, field3) VALUES ('$input_from_form1', '$input_from_form2', '$input_from_form3')");

if this doesn't make sense, then you'll need to read up on php and mysql. webmonkey and sitepoint have some good articles.

If you want, I can set this up for you (sorry, not for free, but at least for very cheap) if you can let me know the specifics.
[e-mail]

[dmason153]

i dont understand php and your explanations make it all unclear , i dont understand php at all so in plain language next time please.

[ihenman]

In resonable plain english what you need to do is:

As one of the previous reply's mentioned you need to make the action in your form = to a php page...

i.e. <form method="get" action="process_form.php">

Then when the form is submitted the info is sent to the page 'form_process.php". Once on this page all the info you entered into the form (i.e. all the input tags you used) is handed over to this page.

(for further info if your not sure of the variable names they are what ever you called them in you <input> tags ... i.e. <input type="text name="somthing_text"> somthing_text would be the variable)

In your PHP for the fictional process_form.php page you then need to open a connection to the database.... then choose the databes you want to use, then choose what table in that database this info has to inserted too.

Once you've connected to the correct place inside the DB you use a statement as the individual above my reply mentioned

insert into table_1 (field1, field2, field 3) (variable1, variable2, variable3)

this tells PHP to insert variable 1 thru 3 into fields 1 thru 3 in the table....

This may or may not shed some light on it... It's hard starting offand understandig how the query's work to connect to MySQL... If you need more help send me an email I may be able to shed a little more light on this for you with a sample file or something with the proper code in it.

[e-mail]

Good Luck!