Exporting your MySQL table data with PHPExcel + CodeIgniter

Posted by on Mar 8, 2011 in CodeIgniter, PHP | 12 Comments

Most of the time my clients need to download data from their database tables. Exporting to CSV is a pain in the rear for users and it leads to confusion (you know the colon and semicolon stuff). Today, I decided to make a very small controller that is portable and efficient for exporting full MySQL […]

Fixing UTF-8 encoding problems on MySQL queries with PHP

Posted by on Aug 24, 2010 in MySQL, PHP | 4 Comments

It happened to me a lot of times, I had my connection set to UTF-8, my database was UTF-8, even my tables and every single field, however, for some reason, the information I updated in phpMyAdmin wasn’t being displayed correctly on my website and the information edited on my website wasn’t being displayed correctly in […]