Thread: need php script

Greetings
I am not a programmer but need a relatively simple (or at least i think so) php script.
I need a script that would allow a visitor to input information like:Name,Surname,City,zip code etc. to a web form and then save that information into a database or even better something like excel spreadsheet located on the ftp server.After the user clicks the "submit" button the script should send him and one of our administrators a email
The text in the email of the user should be something like "Thank you for submitting your information to us,we have received it and will contact you after we have reviewed it"
and the email for the administrator should contain something like
"A new user has submitted his information to us"
I hope you can help me with this and tell me where i can find such a script ?

Breifly searching I found one that looks to fit your needs you would need to edit to fit your exact needs but allows a sign up with a courtesy email..

Might be a good start for you Contact PHP Email Form Script with free contact php code

But not sure i saves the info or not. Might be others on that site though

This is easy to code for a PHP programmer, especially when your preference is to save to a spread sheet format.

Here are some tips for specifying your requirements:

For this I would save as .csv (comma-separated values) to the server. This file would be appended with newly submitted form data.

The post vars Keys, would be the column headings and the post values, the data.

If the file doesn't yet exist, the new CSV file would be created with the Keys as the column headings. Then data is appended as new lines of comma-separated values.

The format of the CSV file is very simple such as:

Name,Email
Fred,fred@site.com

You can then download this and import into Excel or any other spreadsheet.

For the web form, the submitted data needs to be sanitized i.e. run through filters that check for valid data.

Also, I would throttle the submission rate from the same IP address and also include the IP address in the table (so you can block it if need be).

These measures are to cut down on spam.

And, ensure that the file on the server is not readable by the public by setting the file permissions appropriately.

Use of a captcha would be useful too.

Originally Posted by Andy101

This is easy to code for a PHP programmer, especially when your preference is to save to a spread sheet format.

Here are some tips for specifying your requirements:

For this I would save as .csv (comma-separated values) to the server. This file would be appended with newly submitted form data.

The post vars Keys, would be the column headings and the post values, the data.

If the file doesn't yet exist, the new CSV file would be created with the Keys as the column headings. Then data is appended as new lines of comma-separated values.

The format of the CSV file is very simple such as:

Name,Email
Fred,fred@site.com

You can then download this and import into Excel or any other spreadsheet.

For the web form, the submitted data needs to be sanitized i.e. run through filters that check for valid data.

Also, I would throttle the submission rate from the same IP address and also include the IP address in the table (so you can block it if need be).

These measures are to cut down on spam.

And, ensure that the file on the server is not readable by the public by setting the file permissions appropriately.

Use of a captcha would be useful too.

Well for me it would be hard because i am not a programmer,do you know where i could find a finished script or someone who can write one for me ?

I would try and ask dtkguy he does very good work and is very patient. He is a member here so just search his name.