Originally Posted by Fou-Lu
If this is for a fun project, then proceed ahead. If this is for a real production system, then you are in over your head; now would be the time to back out. If you cost someone their livelihood by incorrectly written software, there is a huge burden of responsibility that will come down right on you.
- That is all done with proper database design. You cannot be given suggestions without knowing the structure of the entire business rules and model that needs to be put in place.
- PHP can generate PDF files using pecl PDF extension. Mail can be set using PHPMailer, the simple mail() command or by writing your own. I would write my own or use PHPMailer.
- fgetcsv can read and parse at the same time. Just need to know the rules it was saved with for delimiting and quoting.
First, I want to tank you for replying and on trying to reply me with your suggestions.
Coming to the project this is like a fun & learn project for me but when it come for applicability it is a more like a real project (I am not charging anyone as i am still a beginner), This software I am planning to develop for some of NGO based schools.
I wanted to work on this project to just remove a legacy way of storing the data i.e., excel where by human error so many times we have missed/cor reputed most of these files, To just avoid this errors i am planning to create a DB which can store all these details.
I want a PHP code which can using CSV comma delimited file to upload in to the Mysql so that our accountants need not rely every time on me for uploading the data.
On the second I will create a page which will project data which i have uploaded using CSV.....and beside every row I want to have a edit option & generate options available.
Edit option is for updating/changing records in the Mysql.
Generate option is to generate a Mail using MS outlook that contain a PDF attachment and HTML body of the payslip page which will be sent to the user's email ID which is registered in the DB.
Coming to business rules: As our accountants do all the calculation related to the payroll in the Excel currently, I need not to worry or plan to write a script about the formulas that need a calculation of the figures.
Please suggest me if this is a good idea or any easy Idea available please suggest me.