Simple way to convert Upper Case to Lower Case via MySQL

Sometimes we need to convert upper case to lower case, for example, x-cart, by default, its category and product url shows as category or product name. if a category or product name has upper case, the its related url also show upper case. Can we conver url with upper case to lower case? The anser […]

Read More

How to import extra big data to mysql databases?

I have a mysql database, about 8 GB, and i have tried several types to import it to mysql databases, such as bigdump, phpmyamdin…, all faile. Finally I found a way successfully. I am very glad to share this with all phper. 1. Run DOS command; 2. Go to the folder that contains mysql.exe. Mine […]

Read More

How to add certain string to a url via mysql?

Listen, if you have 10,000 companies url at your mysql, now you need to add about-us.html just after each url, for example, one of your company url is absorking-desiccat, how to let it become to absorking-desiccant/company_profile.html?

Read More

How to Calculate Certain Period Net Sale for Zen-Cart

At the end of every month we need to know how much we have earned, or how much we have sold every day, in a year for our Zen-Cart based shop cart. Usually we have to login our admin panel, and check the total orders we have sold at the certain time. We have to […]

Read More