I work at a printing place, and we do lots of mailing, 10,000 to 20,000 pieces for 1 customer each month.
I want to assign a password and use their lastname for login
and once they login it will have their name here and there and other info about them which is in the original
excel file that we have.
Also from that I want them to fill out a form and that be sent to a database so I can then return to the client.
Where should I start...
Thanks
Paul
Database for mailing / to website
Moderator: General Moderators
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
If you have some php knowlege then this is easy just follow the steps below:
1) Create a database in mysql
2) Import your excel list, by converting it to CSV format and the column match up with the mysql table that you have created.
3) Write a php/html form for user to login, there should be tons of sample code to do this, once user login then you can write another page to display user's information
If you have no clue on any of this, then you can save alot of time by outsourcing it to some professional php developers. If you take this route, then make sure you get someone that you can talk to (locally) and make sure he/she understand completely what you want.
Good luck with your project.
Tri
1) Create a database in mysql
2) Import your excel list, by converting it to CSV format and the column match up with the mysql table that you have created.
3) Write a php/html form for user to login, there should be tons of sample code to do this, once user login then you can write another page to display user's information
If you have no clue on any of this, then you can save alot of time by outsourcing it to some professional php developers. If you take this route, then make sure you get someone that you can talk to (locally) and make sure he/she understand completely what you want.
Good luck with your project.
Tri
It's really difficult to answer your question without knowing what level of experience you have with programming, particularly database programming and web based applications. If you have little or no such experience, then you certainly should not try to develop an important business application on your own. If that is the case, I wholeheartedly agree with the first two responders. In case you are an experienced programmer and are looking for some hints about starting your project, please give us some idea of what your level of experience is.