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?
How can this be done?
Moderator: General Moderators
Re: How can this be done?
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.
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?
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.
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.
-
internet-solution
- Forum Contributor
- Posts: 220
- Joined: Thu May 27, 2010 6:27 am
- Location: UK
Re: How can this be done?
can you please define "elegant"?