Database for mailing / to website

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
humpfrezz
Forum Newbie
Posts: 2
Joined: Fri Sep 07, 2007 1:09 am

Database for mailing / to website

Post by humpfrezz »

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
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Post by Christopher »

You would usually start by hiring a programmer and repeating all that the them. ;)

You can search for Authentication for the sign-in page, ACL or Access Control for protecting the pages, and CRUD or Form Manager for adding the data to a database.
(#10850)
trivo
Forum Newbie
Posts: 1
Joined: Sun Sep 09, 2007 12:23 pm
Location: New York, USA

Post by trivo »

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
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Post by califdon »

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.
Post Reply