Blog entries  |  Home » Archives by category » Work

Very high Mysql CPU usage and low memory usage with Nginx+php-fpm solution

Just a very short post here as I wanted to share some finding on a problem I recently encountered.
On one of my websites I was implementing a Jcart Shopping cart instead of just the previous ‘buy now’ button to do some A/B testing to see what does better. When the implementation was done everything was […]

SEOProject

SEOProject

2012 was a big year for SEO with a lot of changes which are being continued in 2013. Google is doing a better job getting rid of low quality websites and some businesses got hit pretty hard because of that.
I believe there are 2 sides to the sword, on one hand I think it is […]

Inno Setup – creating an installer as downloader

For the Simlock Remote Server software I needed to create a good installer that downloaded files based on installer components selected by the user and then installed the downloaded files. There are some commercial solutions for creating installers however there is also a very good and free one called ‘Inno Setup‘.
I was completely new to […]

AwayDaddy debacle

In case you haven’t heard this yet (I was a bit late also) in the US of ridiculous they are trying to push a new act called ‘SOPA’, basically this means no more privacy, no more right for all internet users. Many many people and also companies are against it and support petitions and actions […]

Mysql 2 Search PHP class made public

Mysql 2 Search PHP class made public

I decided to release a search class which I use for several of my website to the public to use. The collection of 2 classes use 3 techniques to search a mysql database which are:

Full text search (for MyISAM or InnoDB with Mysql version 5.6)
Like search (simplest method, not recommended)
Sphinx search (needs Sphinx installation, recommended)

The […]

PHP: Mysql to Excel and Excel to Mysql

For the back-end of all my websites I use a self made CMS¬† / eCommerce system (called ICS), in this system I have build a module for website translations using Mysql for all site content. With that I created a Excel import and export function to be able to send all the text files to […]

[PHP] Recursive array search with multiple results

Ok, so for UnlockSamsungOnline.com I needed a function to search in a multidimensional array with an unknown dept for values and returning the base keys. So first I started at php.net and I searched google. It was easy to find such a function when it just presented one result or just a ‘yes, the value […]

Google +1 good for SEO good for customers

Google +1 good for SEO good for customers

For one of my websites I just added the Google +1 button. As you probably already know it is very similar to the Facebook ‘Like’ or ‘Recommend’ button and it can help your SEO for organic search and of course also the social aspect of people vouching for your website helps you get more visitors.

So […]