Study PHP Skills, Share PHP Code
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 log in to our admin… Read moreHow to Calculate Certain Period Net Sale for Zen-Cart?
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… Read moreHow to Change Magento Base Cart Domain Name?
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… Read moreHow to show 6 latest product reviews from Zen-Cart?
Listen, if you have 10,000 companies’ URLs at your MySQL, now you need to add about-us.html just after each URL, for example, one of your company URLs is absorking-desiccat, how to let it become to absorking-desiccant/company_profile.html?
I have a MySQL database, about 8 GB, and I have tried several types to import it to MySQL databases, such as bigdump, PHPMyAdmin…, all fails. Finally, I found a way successfully. I am very glad to share this with… Read moreHow to import extra big data to MySQL databases?
Sometimes we need to convert upper case to lower case, for example, x-cart, by default, its category and product URL shows as a category or product name. if a category or product name has an upper case, then its related… Read moreSimple way to convert Upper Case to Lower Case via MySQL
If anyone else wants to accomplish something similar, I just figured it out. The extra field number needed to be used in “if” statement as well. Go to cart442\skin\common_files\modules\Extra_Fields, and open product.tpl.
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… Read moreBulk register users for vbulletin.
Question 1: Can’t overwrite or delete settings.php It’s a smart security setting of drupal You need to add permissions to write not only the settings file but also the folder where it is. Don’t forget to put the permissions back… Read moreDrupal 7 Skills
If you get this error, you do not have privileges on user_* to use Create. HostGator needs to correct this issue for you. If you open your database which you plan to import to your HostGator web hosting, you can… Read moreERROR 1044 (42000): Access denied for user ‘username1’@’localhost’ to database ‘006’