Some good, cost effective web hosting providers we rarely know

web-hosting-banner

I always think of good and secured web hosting with all control to me. There are thousands of service providers are available in the market and all of have some pros and cons. My main concern is the price too. If you need a personal or business website or blog, simple or bit complex web applications and you do not expect thousands of visitors daily then there are some good choices .

Here are such few web hosting providers I am currently working or worked with.

Continue Reading

Websites to find free high resolution stock-images

public-domain-stock-images

Completely free stock-images for personal and commercial purposes?

We always prefer good, high quality stock-images for our websites, blogs, print designs and may be for some other graphical work. Getting good images always cost a lot. Alternatively there are some websites which offer free images called ‘Public Domain Images’.

Public domain images are not covered by intellectual property (Creative Commons license) or copyrights which mean these can be used anywhere without any copyright issues.

Here are the few websites to get public domain stock-images.

Continue Reading

5 Websites to get icons completely free

icon-banner

As a web and application developer I need icons on my every project. Icons are copyrighted assets like images. I prefer to use kind of public domain graphics which are completely free for commercial purposes.

From where we can get completely free icons for web and graphic design?

Here are the 5 best websites to get icons for your graphic design projects.

Continue Reading

5 Free online infographic maker which are easy to use

infographic-banner

Infographic is the best way to represent your idea in proper way. It attracts all the visitors on your topic. You can use infographic on your blog, website, school project and business proposals.

How to design this infographic?

Common answer will be Photoshop or Gimp. But all these need designing skill and lots of time.

There are several online applications available now from where you can easily design your infographic with no graphical skill. Here are some of those websites listed below.

Continue Reading

How to convert MySQL collation from utf8mb4 to utf8

Recently I faced a tough situation with one of my WordPress site at the time of exporting MySQL database. My development MySQL server supports utf8mb4 collation but the production MySQL server does not support that. So, I had to convert all the tables of the MySQL database from  utf8mb4 to utf8.  The actual task was conversion from utf8mb4_unicode_ci to utf8_general_ci

I tried to convert manually several times but it did not work. My question was what is the difference between utf8mb4 and utf8?

utf8mb4 (as well as standard UTF-8) can directly store any character specified by Unicode; the former is fixed size at 4 bytes per character whereas the latter is between 1 and 4 bytes per character.

utf8 can only store the first 65,536 codepoints, which will cover CJVK (Chinese, Japanese, Vietnam, Korean), and use 1 to 3 bytes per character.

So, the real process will be ALTER the database as well as each database table to change the CHARACTER SET.  Using a PHP script I made the conversion and it worked perfectly. This is the PHP script which will convert your MySQL database collation from utf8mb4_unicode_ci to utf8_general_ci instantly. 

  1. Copy the above PHP script and paste in a file say, ‘dbconversion.php’.
  2. Now put this file in your server (development/production).
  3. Run this script from ‘yourdomain.com/dbconversion.php’.
  4. It’s all. It will convert everything and you will get a success message.

Note: If you are using WordPress website and you need to convert your database any time, make sure ‘utf8’ Charset will be defined in your ‘wp-config.php’ file as
define(‘DB_CHARSET’, ‘utf8’);

Continue Reading

The smartest umbrella ever

Rainy seasons and you always need an umbrella keeping with you always. We struggle always to open or close our umbrella. What if the umbrella will have too much smart to do everything automatically! Yes, it is true to come.

This smart umbrella has the following features.

  1. Automatic open and close with one button push.
  2. Synced with our smart phones.
  3. Bluetooth connectivity so you can not loose it. It will send you notification in your smart phone if you keep it any place and forget to take.
  4. Weather forecasting.

This smart umbrella is a project of Indiegogo and you can purchase this lovely umbrella from their Indiegogo or support them.

Continue Reading