Output to MySQL DB

[The Voivod]

I have the requirements of getting a simple form to output to a db
file. Currently I am using a form called ennyform and it outputs to a
flat file. The person who want this wants it to be searchable and we
expect to get anywhere from 50 - 300 forms submitted per day. I was
reading that using php to MySQL was the correct way to get output into
a MySQL database. I know this is not the only way but I am on a Linux
platform and it is free. Is this overkill to set this up for a simple
form? Should I continue using the flat file and import it into
something. I am basically fishing for the most efficient way. I am
only assuming PHP to MySQL is the best way. I would just like to know
before I dive into the unknown. My next step would be to figure out
how to set up a page to use PHP to output form fields. And of course I
will have to create the DB.

I hate to say this but yes I am clueless but I was hoping that this
would be a short quik answer from somebody who done these things
already. I just want to pointed in the right direction before I spend
a lot of time with the wrong stuff. Currently I just read the text
file, actually I don't even do that I just read the emails as they are
sent. I rarely go in and look at the text file the form outputs to. I
am going to have to though, very soon.

Thanks A lot

[Jean-Baptiste Nizet]

The Voivod wrote:

I have the requirements of getting a simple form to output to a db
file. Currently I am using a form called ennyform and it outputs to a
flat file.
What server-side technology/language do you use to output the form
values to the flat file? Couldn't you use the same technology/language
to output them to MySQL?

The person who want this wants it to be searchable and we expect to get anywhere from 50 - 300 forms submitted per day.
Just FYI: this won't cause any problem, whatever technology you use. 300
hits per day is a really small charge.

I was reading that using php to MySQL was the correct way to get output into
a MySQL database. I know this is not the only way but I am on a Linux
platform and it is free. Is this overkill to set this up for a simple
form?
php is very quick and easy to install, as well as MySQL. You shouldn't
have too many problems if you read the manuals at www.php.net.
Should I continue using the flat file and import it into
something.
No. This would make things slower, and more difficult to implement.
I am basically fishing for the most efficient way.
For such a small charge, use what you know best, i.e. the easiest
solution for you.

HTH.
JB.
I am
only assuming PHP to MySQL is the best way. I would just like to know
before I dive into the unknown. My next step would be to figure out
how to set up a page to use PHP to output form fields. And of course I
will have to create the DB.

I hate to say this but yes I am clueless but I was hoping that this
would be a short quik answer from somebody who done these things
already. I just want to pointed in the right direction before I spend
a lot of time with the wrong stuff. Currently I just read the text
file, actually I don't even do that I just read the emails as they are
sent. I rarely go in and look at the text file the form outputs to. I
am going to have to though, very soon.

Thanks A lot