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 show 6 latest product reviews from Zen-Cart?

If you like to show 6 random product reviews, you can do like this: Configuration –> Maximum Values –> Random Product Reviews for SideBox and set “How many products do you want to display in this sidebox?” to 6. If you need to show 6 latest product reviews from all of your product,how to do […]

Read More

How to Change Magento Base Cart Domain Name?

For example, the old domain name is: http://www.glassespeople.com, and this shopping cart is based on magento. Now I need to remove the cart to my local computer, say under http://127.0.0.1/cart/glassespeople/. How to then? 1. Creat glassespeople, under http://127.0.0.1/cart/; 2. Copy all files under http://www.glassespeople.com, and paste them under http://127.0.0.1/cart/glassespeople; 3. Login phpmyadmin of www.glassespeople.com, and […]

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

Bulk register users for vbulletin.

Sometimes we need to register a lot of new users for our forum based on vbulletin. How to do then? Here, I will share my methods with you. 1. arrange the new user names in at .txt file, one line only display one user name; 2. create a .xml file and upload the .txt data; […]

Read More

How to install multi wordpress blog under one database?

Sometimes we only have one mysql database, and we have several domain names. How to install wordpress for each domain under one database then? Here is an example, say:   www.eyewearsaver.com, www.opticalsaver.com, www.eyeglassessaver.com, www.eyewearsave.com, and www.glassessaver.com.

Read More