I'm building a system using FuelPHP in which users can download a CSV template, populate it, then upload it to mass import records into a database. I feel like I'm reinventing the wheel with this one, although I don't see any implementations.
What is the best/standard/right/slick way to allow users who are generally non-technical to upload bulk data?
Non-technical end users loading their own data + mass import into database = very bad idea
Seriously, Build into your template clear instructions and limit the options/data types the user can add. Then, double dog check the data and be prepared to fail gracefully.
If data passes inspection (is sanitized) - use standard PHP techniques to guard against injection - How can I prevent SQL injection in PHP?
