kindoman Posted January 14, 2009 Share Posted January 14, 2009 Hi, I am new here. I am a graphic designer and web designer for a group of companies. I have to do business cards for people that are located in branches all around the country. This gets very confusing. Everyone sends me an email and I have to print it, put it in a file and try to keep track of who has got and who has not. This is why I want to design a simple request form that will handle this for me. It will be located on a PHP/MySQL server located in my office that can only be seen by people within the company. The problem that I am having is how to stop people doubling up entries. Let’s say that I am doing some business cards, cost factors require me to send as many as possible to the printers. I will then send out an email that contains a link to the request form. People will fill it in and a request will be logged. But next time I will send out the same email and people will without a doubt fill in the same form again. This is unnecessary as I have already got their card designed; it just has to be reprinted. What I need is a form that asks for your first and last name. Once they have filled this in and they have not had business cards before it will take them to a page that will ask them for more details (cell, email etc). If a person enters a name that is on record it needs to take them to a page that will confirm their details. From there they can update and log a request. How would I create a form that will display an entry based on a first and last name????? Point me in the right direction please. Quote Link to comment Share on other sites More sharing options...
xtopolis Posted January 14, 2009 Share Posted January 14, 2009 People can have the same first and last names; you need a unique method of tracking: such as their email. You can use their email as their login and whatever password they choose. You will store the data in MYSQL in the normal way... Firstname, Lastname, email, one-way-hash-of-password, and perhaps other things. You might also wish to create a table for requests so that you can see previous requests by the same user and list them, or perhaps use it as a "status" thing for "sent to printer", or "shipping to you now". You should read up on php forms: http://www.tizag.com/phpT/examples/formex.php That is a good site for learning. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.