hi guys. im new here, i came here to seek help from u guys here. actually im working on some project, an event management.. ive done 80% of it now.. now im stuck with this timesheet. the requirement >user can add/update/delete data just like in excel. thats all. ive attached the pic of my page. i hope someone can help me on this. or provide any link to tutorial on this. p.s im still newbie on this php, my major is c++.. anyway thanks in advance. warmest regards, shdin271
I never understood why people want the web to behave like a fat client app like Excel. If they want to use Excel, they should use Excel. I know this doesn't help you, but I just had to vent. You will basically need to put an "onChange" event handler on each text field of your form to make an AJAX call to instantly write newly inputted data out to the database as soon as its value is populated by the user and tabs away from that field. The AJAX call will send the field name and value to a separate PHP script to run the query to the database. I hope you don't need to code in formula capabilities for totals and other "Excel" features for instant, real-time calculations. Wouldn't want to be you if it came to that - then you will have to concern yourself with syntax filtering and other mind-numbing nastiness. If not, and the calculation/totals fields are pre-determined, then that's much easier, and you can run the calculations in the JavaScript code when you do your AJAX calls. Good luck.