Welcome to WebmasterWorld Guest from 184.108.40.206
I need a script that does the following:
1. Has a few form fields (Full Name, Address, City... etc) and a few drop boxes.
2. When the form is submitted it writes the data into a xls file.
3. Every time the script is run a unique id (number) should be generated and written into the xls file together with the rest of the data.
4. Verifies that the telephone number matches the state when the form is submitted, otherwise it will return a error message.
5. Every time the form is submitted, it overwrites the existing xls file and combines the data in one file.
6. It saves the ip, date, time, and URL.
The alternative would be to use a database, not to store the xls file but to store the data which you could export to an xls file. I'm not 100% whether or not this is natively possible with MySQL but you can definitely export to HTML or XML quite easily.
Once you set up the file, you can just refresh it when you want to load whatever new data might be there.
It's also a quick and dirty way to keep backup copies of your raw data for small tables (less than 65,536 rows or so)