Author Archives: Manigandan Arjunan

About Manigandan Arjunan

I'm Manigandan Arjunan an Electrical and Electronics Engineer by Education and a Software Engineer by profession. A web application developer based in Coimbatore, India. And the author of WWW.PHPKNOWLEDGEBASE.COM

Format number with leading zero

Format number with leading zero You are having some number which should contain eight digits in it as the registration number. So for the first registration, the number should be 00000001 and for the next 00000002, similarly 00012456, 00002158, 01234568, 25634897 and so on till 99999999. To achieve this we need to format a number… Read More »

How to Move WordPress From Local Server to Live Site

How to Move WordPress From Local Server to Live Site Nowadays many websites and blogs are powered by WordPress. Because any person who doesn’t know how to code get WordPress to build a website, also its free and priceless. WordPress.org states that currently 60 million people chooses WordPress to power their blog and website. So, in… Read More »

GROUP_CONCAT with JOIN in MySQL

GROUP_CONCAT with JOIN in MySQL The GROUP_CONCAT function concatenates strings from a group into one string with various options. Usage of GROUP_CONCAT with JOIN Product Table product_id name 1 abc 2 adc product_to_category table: product_id category_id 1 1 2 1 2 2 2 3 1 3 category_description table: category_id name 1 A 2 B 3… Read More »

Modify OpenCart upload image size limits

Modify OpenCart upload image size limits Opencart is a popularly used ecommerce framework. When adding product images or category images to a product or to a category sometimes we get  upload image size is large. This is because Opencart by default sets the maximum image size limit to 300kb with 1000x1000px resolution. Unfortunately we can… Read More »