Recently I had to setup a self signed certificate for a Windows Apache setup. This of course requires the usage of openssl. However openssl returned the following error code when trying to use it:
Openssl not working in windows (SSLEAY32.dll error)
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.
Alternative Fast Android Emulator – Genymotion
There is no doubt that one of the most tedious parts of the Android development is the Android emulator that comes in the Android SDK. Its extremely slow and buggy. Fortunately the guys at Genymobile came up with a nice and easy alternative to the stock Android emulator that is much faster and responsive.
Galaxy S3 USB connect to Mac OS X
This is just a quick note to Galaxy S3 users who have the North American version i747 and have issues connecting it to a mac. If you want to transfer all kinds of files and not only your pictures you should download the Samsung Kies software.
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.