A web developer's blog. PHP, MySQL, CakePHP, Zend Framework, Wordpress, Code Igniter, Django, Python, CSS, Javascript, jQuery, Knockout.js, and other web development topics.

Tag Archives: csv

CakePHP 2.x: CSV File download from a database query

Here is a quick way to output/stream/download a CSV file from your database using CakePHP. For simplicity, I have placed everything in the controller. Not good practice but it quickly does the job. <?php class UsersController extends AppController {   … Continue reading

Posted in Uncategorized | Tagged , , | 3 Comments

Importing from Huge CSV Files to MySQL Database and more…

The scenario: I am given a huge CSV File dumped thru FTP from some big JDE-ish system everyday. The CSV File is about 15MB or so. The file has around 60,000 lines in it. What I needed to do is … Continue reading

Posted in General | Tagged , , , , | 6 Comments