MySQL login details in WordPress

If you have decided to move a copy of your wordpress to other host propably you will have problem with your mysql login details. Even if mysql database name, login and password are same - propably you will have to change login host (until it is not localhost :) ). It is very easy to do. All you … Continue reading →

URL Shortening Script

Here is a demo of my url shortening script. It let your visitors to make short redirections of their very long url's (for example it is useful for twitter users where they are limited to 140 characters). Script is made to be as simple as possible. HTML is separated from PHP so it may be customized … Continue reading →

Web hosting review website

My last project have just been launched. It is Web Hosting Reviews website based on customized Wordpress and K2 theme. Below you may see front page screenshot. Click it to visit working site. There is a lot of customization in PHP, the design and a few customized free plugins just to make it … Continue reading →

Form element name change with JavaScript and radio button

Today I have had to modify very complex script to change look of html form. It is quite easy to make changes in the form. But sometimes it is a problem to modify not to well written PHP script to receive data from new form. … Continue reading →

Sort VARCHAR as INT in MySQL query

If you need to sort varchar data as int, there is one very nice function in MySQL. Problem I had to solve was to sort values as below in a human logical way. Values were similar to this (and I wanted it to be sorted like below): 1; 2; 2a; 3; 4; 5; 5a; 5b; 5c; 6; 7; 11; 14; 14a; 16; The … Continue reading →