Total Newbie

flouric

Greetings all,

I'm a near total newbie trying to learn PHP and MySQL. The script I'm working on needs to:

Accept input from an external form.
Submit the input into a MySQL DB.
Redirect the user back to the page with the form on it.

I'm at a loss as to where to get started. I've got the form in place (I've used them plenty before) but I'm not sure how to get PHP to collect the variables or how to Insert them into the MySQL.

If anyone could offer tips or direct me to a tutorial that would help I'd appreciate it.

Traduim

Usually it works with just the field name.

You would usually retrieve the value of <input name="kid"> by just using $kid.

To make a MySQL insert, you need to do a mysql_query() using the basic insert syntax: INSERT INTO table (fields) VALUES (values).

You cold have more information in:
[man]mysql[/man]
http://www.mysql.com/doc

klansman

there are tons of tutorials on how to do that...

first of all, you can go to www.php.net and look for the mysql functions. There is an example on how to connect to a mysql database to select/insert data.

then you have devshed:
http://www.devshed.com/Server_Side/MySQL/Speak
http://www.devshed.com/Server_Side/Administration/Database/page1.html

i don't know if you are aware of this one:
http://www.phpbuilder.com/columns/jesus19990308.php3

from databasejournal.com:
http://www.databasejournal.com/features/php/article.php/1485971
http://www.databasejournal.com/features/php/article.php/10898_1485971_2

just to mention a few starting points...

[]