Question on PHP programm?

[Blago86]

Hi all,

I'm trying to create a PHP programm that does the following:

Acts as a tracker in a call-center environment, where each agent has to log in to his account and can enter basic data about each case he has (e.g. serial number, calling party etc.). Afterwards, the programm has to check if the serial is in a database (Excel file as of now) and give it's category listing. Then, we have to count them by category/agent/calling party?

How do you suggest this should be done best?

Kind regards,

[bradgrafelman]

First step I would suggest is to import the "Excel file" (whatever that might mean) into a SQL database.

Second step would then be to start writing the code necessary to do what you've described above, asking specific questions when you get stuck on something.

[NogDog]

You can always start out by searching to see if there is already some (preferably open-source) software out there that does all or most of what you need.

If not, then it's "divide and conquer" time: break down your requirements into individual components, functions, whatever; then start deciding how to design and implement that component (possibly again looking for open-source classes, functions, packages, etc. that already do what you need to do for that component).