need advice for developing Leave tracking system
Posted: Wed Apr 04, 2007 8:32 am
Hello, I might be offered by a little company to build the web base leave tracking system which I never built before, the application have the following features :
- log in system for every employees in the company
- When an employee logged in, there are features like leave application form, cancellation leave, history, carried forward leave and staff on leave
- The leave application form contain the details for the employees(name, department,group, approved by, employee no., job description, start date) and also the form for the employee to fill in and apply the leave.
I am a 7 months PHP and MySQL learner, I am still a student, but I think I am able to build or learn to build these application. Please give me the advice and tips for building such application or answer these questions optionally by numbering your answers accordingly.
1. Is it ideal to use MySQL, because I saw most are using SQL Server ?
2. What are the securities that I need to take into account ?
3. What are the PHP function that I might need to use which I might not come across those function. (the function that is a little more than basic one)
4. I plan to host the application on my website, because I want to protect my PHP codes, should I do that ? so there will be other company can use my service.
5. Give me any resources, website, tips , advice or just anything else.
Thank you so much.
- log in system for every employees in the company
- When an employee logged in, there are features like leave application form, cancellation leave, history, carried forward leave and staff on leave
- The leave application form contain the details for the employees(name, department,group, approved by, employee no., job description, start date) and also the form for the employee to fill in and apply the leave.
I am a 7 months PHP and MySQL learner, I am still a student, but I think I am able to build or learn to build these application. Please give me the advice and tips for building such application or answer these questions optionally by numbering your answers accordingly.
1. Is it ideal to use MySQL, because I saw most are using SQL Server ?
2. What are the securities that I need to take into account ?
3. What are the PHP function that I might need to use which I might not come across those function. (the function that is a little more than basic one)
4. I plan to host the application on my website, because I want to protect my PHP codes, should I do that ? so there will be other company can use my service.
5. Give me any resources, website, tips , advice or just anything else.
Thank you so much.