How to read Excel files with PHP

Reading Excel files with PHP can be tricky, but fortunately there is a great library that makes this task a lot easier: PHPExcel. In the following article I will show you how to use it to convert the excel sheets into PHP arrays and use the data in PHP.

Continue reading

Setting up a new CentOS 6 web server with nginx and php-fpm

Sometimes as developers we have to perform some simple sysadmin tasks, such as installing a basic LAMP or LEMP stack, basic securing of the server and so on. So what I decided to do is to just gather links to various helpful resources on how to setup Nginx + PHP 5.4 + MySQL + memcached on CentOS 6. I chose this installation since its the one I happen to use the most and I personally believe the optimal one. An alternative might be Apache + mod_php + Varnish + memcached.

Continue reading

Why you should never use opencart

Recently I had the opportunity to work on a decent sized e-commerce project based on OpenCart. I haven’t used it before but I had heard its a very simple and easy to use. So the following is just a quick overview of all the fundamental flaws and issues with OpenCart and why you should NEVER use it as a platform of choice for your projects, unless you want constant headaches, ugly code and incredible amount of code repetition.

Continue reading