Page 1 of 1

How can this be done?

Posted: Wed Dec 28, 2011 6:20 am
by powr
I`m brand new to PHP coding and have only read a few newbie books about PHP/MySQL.
But I`m hoping to learn as I go along, and the first thing I want to make is this:

When my company gets a new customer, one of our employees has to do a lot of tasks to get them implemented into our system.
For example:

- Register the customers company name
- Register the customers company number
- Register the customers contact details
- Register the customers insurance info

The thing I want to create is a page where I register a new customer with it`s customer number and name. And then the script should automatically get all the tasks listed above and sets them as "unfinished" for this customer. From there I can change the status from "unfinished" to "finished" as we get all the information needed from the customer.

Can anyone please give me a clue on how I can get the script to get the standard tasks and link them to the customer?

Re: How can this be done?

Posted: Wed Dec 28, 2011 6:58 am
by phpHappy
Put all those items in your form but have an additional item in database for finished/not finished.
If all form fields are not filled out have it set the customer row to unfinished in database.
When you call for a customer from database have 2 pages - one that shows them in finished state and one that has form to finish - have which page shows by the finished/not finished item.
The unfinished page can also be an edit page to call finished customers to edit for changes - so useful anyway.

Re: How can this be done?

Posted: Wed Dec 28, 2011 7:16 am
by powr
Thank you so much for your reply!

So there is not a more "elegant" way to do this?
I was hoping to also make a settings page where the user can add/edit/delete the standard tasks.

Re: How can this be done?

Posted: Thu Dec 29, 2011 2:47 am
by internet-solution
can you please define "elegant"?