Novie Question re: PHP and mySQL database

Hello,

I have a mysql database that resides on a folder on my domain called 'datab'. This database has fields that are identical in name to the fields that I created in an html form (firstname, lastname, address, etc.)
How can I add records from the html form to the database? Where does the PHP code that I create reside, in the root directory of my domain, or in the folder datab?

How can I retrieve the records from this database so that I can later export them to Excel?

any help would be most appreciated

thank you

I don't know about exporting to Excel, although I'm sure it could be done, I just wouldn't know where to start and don't feel like searching.

The PHP code would reside in whatever folder you want, although it would be at the very least in the root directory of your domain. It could be in the datab folder if you wanted.

I don't understand what you're saying though, what do you mean you have a MySQL database on your domain in a folder? you mean you installed it to the folder "datab" on a publicly accessible folder? If so, I recommend you take it offline! MySQL doesn't really exist as folders, persay (although they do exist as folders literally, you just can't access them like that).

You can add records using your HTML form by submitting it to the PHP file.