Study PHP Skills, Share PHP Code – Page 4 – Study PHP Skills, Share PHP Code

How to Set height of the categories meta box in post dashboard of WordPress?

Say we are trying to modify the height of the categories meta box of www.glassescanada.com, edit functions.php, which is under: https://www.glassescanada.com/wp-includes/, add the following code at the end of functions.php function change_cat_meta_postbox_css(){ ?> <style type=”text/css”> .wp-tab-panel, .categorydiv div.tabs-panel, .customlinkdiv div.tabs-panel,… Read moreHow to Set height of the categories meta box in post dashboard of WordPress?

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 log in to our admin… Read moreHow to Calculate Certain Period Net Sale for Zen-Cart?

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… Read moreHow to Change Magento Base Cart Domain Name?

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

How to add certain string to a URL via MySQL?

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?

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, 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?

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 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

Displaying Extra Fields using “if” statements

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.

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… Read moreBulk register users for vbulletin.

Drupal 7 Skills

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