Author name: Yang Yang

Hello, I'm Yang. I build online businesses that please people. Want to join in and post some useful articles on Kavoir.com? Shoot me a message.

The Rise of Web Bots

Just gave a read to this article: http://www.sitepoint.com/rise-web-bots-fall-human-traffic/ Very intriguing. The Internet is developing just like how the other industries are. Traditional industries try to make products out of the raw materials provided by nature, while Internet is trying to reach targeted information / answers by organizing raw data everywhere. That’s exactly what Google and …

The Rise of Web Bots Read More »

Optimize for Large Number of Columns in a Wide MySQL Table

In addition to necessary indexes and proper SELECT queries (only select needed columns), for wide tables, 2 basic tips apply well: Define your column as small as possible. Avoid using dynamic columns such as VARCHAR or TEXT as much as possible when you have large number of columns per table. Try using fixed length columns …

Optimize for Large Number of Columns in a Wide MySQL Table Read More »

You don’t need a Google Apps alternative for email hosting

Now that Google Apps closed sign-up for free plans, lots of people are looking for alternatives to Gmail for their own domains. Actually they don’t need to. You can simply add other domains to your existing Google Apps account as separate domains to set up emails such as [email protected] The separate domain emails perform exactly …

You don’t need a Google Apps alternative for email hosting Read More »

Sell on Taobao.com and Tmall.com – Market to China!

If you have solid products and wants to sell to China audience, let us know. We have a very capable team currently running 2 big brands on Taobao.com (for small merchants) and Tmall.com (for medium to large merchants), the largest online marketplaces in China thus far, with an annual sales volume over 1,000 billion CNY, or 200 billion …

Sell on Taobao.com and Tmall.com – Market to China! Read More »

Firefox redirecting localhost to www.localhost.com

To avoid this annoying behavior of Firefox that redirects http://localhost to http://www.localhost.com when you are developing on the localhost, try one or more of the following tips: Use other browsers such as IE or Chrome. Use “127.0.0.1” instead of “localhost”. Make sure http://localhost is correctly configured and responding. Make sure C:\Windows\System32\drivers\etc\hosts has and only has …

Firefox redirecting localhost to www.localhost.com Read More »

How to write page title for SEO?

I have several writers who write content for my websites. One of the things they constantly have is that they come up with page titles that are not good enough. Sometimes it’s trivial but sometimes it does pose a siginficant problem with regards to SEO. For example, in this article: http://www.bintley.com/blog/the-comprehensive-guide-to-choosing-the-right-short-range-airsoft-gun/ The title is so long …

How to write page title for SEO? Read More »

I’m just so happy

I don’t know why but I’m just so happy. I just returned from a hiking in the Qin Mountains. It’s gently snowing while we climb one of the mountains to an altitude of about 1000 meters above sea level. It’s been terrific in the outdoors! We have a good company of many friends and strange but …

I’m just so happy Read More »

Customize WordPress Admin Styles from Your Theme Directory

It’s better to style the /wp-admin of WordPress from your theme because it’s portable and upgrade-proof. Keeping all customizations  in ONE place is always a good idea in web development. How to style WordPress admin backend /wp-admin from your theme? Add this hook to the functions.php of your theme: function customAdmin() { ?><link rel="stylesheet" type="text/css" href="<?php bloginfo(‘stylesheet_directory’); ?>/wp-admin.css" …

Customize WordPress Admin Styles from Your Theme Directory Read More »

Super Cheap Cloud VPS: 1 Core, 1024MB, SSD, Managed – Just $21.25 / Month

Some of my sites such as ConvertHub has grown out of the 512MB box I have had for over 2 years at Linode. It’s been great but as I’m fed up with managing the server myself (I’ll come to that later), I went ahead looking for a solid VPS plan with WHM / cPanel that’s …

Super Cheap Cloud VPS: 1 Core, 1024MB, SSD, Managed – Just $21.25 / Month Read More »

Make WordPress Hooked Function to Run Only Once

Consider this hook to add something before your WordPress blog’s sidebar: function before_siderbar() { ?> <!– Something goes here, such as an AdSense links unit –> <?php } add_action( ‘get_sidebar’, ‘before_siderbar’ ); It’s usual to add an AdSense links unit there but the problem with some themes is that they run get_sidebar more than once, …

Make WordPress Hooked Function to Run Only Once Read More »

Remove Gmail via Field and Add mailed-by & signed-by with PHP mail()

PHP mail() is a great function to easily send emails from your website server. If you have ever used it before in action, or are currently using mail() to send out emails from your website or application, chances are you would find Gmail to be very persistent in attaching a ‘via’ field to the from …

Remove Gmail via Field and Add mailed-by & signed-by with PHP mail() Read More »

Disable Source > Format (Ctrl + Shift + F) in Zend Eclipse PDT

It became a total mess when I selected the entire root directory of my project and accidentally clicked Source > Format in Zend Eclipse PDT. All the files were instantly re-formatted and saved in a manner I wasn’t comfortable with and there didn’t seem any easy way to undo these changes that had been applied …

Disable Source > Format (Ctrl + Shift + F) in Zend Eclipse PDT Read More »

PHP: Round to the Nearest 0.5 (1.0, 1.5, 2.0, 2.5, etc.)

The common practice of rounding, namely the round() function in PHP, is to round to the nearest decimal point, that is, 1.0, 2.0, 3.0, etc. or, 10, 20, 30, etc. For example, echo round(4.25, 0); // 4 echo round(3.1415926, 2); // 3.14 echo round(299792, -3); // 300000 When I’m trying to aggregate all the customer …

PHP: Round to the Nearest 0.5 (1.0, 1.5, 2.0, 2.5, etc.) Read More »