2009

MySQL: Count the Number of Records and Update the Stats Field in Another Table

I wrote this before in 2 separate posts. Actually, here’s a much better idea: use a sub query. For example, you have 2 tables, Table poets – Columns: id, poet, nation Table nations – Columns: id, nation, count Basically, nations to poets has a mapping of one to many, naturally. For example, there are 1000 …

MySQL: Count the Number of Records and Update the Stats Field in Another Table Read More »

Use robots.txt Disallow directive to forbid spiders and search engine robots

Just like .htaccess, robots.txt resides at the document root of your domain. It’s a text configuration file containing directives or rules any well behaved web spiders or search engine robots should respect. While you can use .htaccess to forcibly prohibit any visits (including those of human visitors) to a certain part of your site, robots.txt …

Use robots.txt Disallow directive to forbid spiders and search engine robots Read More »

Bulk Domain Name Availability Checker Tool to Batch Search Available Domains

Someone asks me via contact form how to check potentially hundreds of domains for availability at once, as it’d be a huge waste of time to check them one by one. For example, when you need to check if these 50 domain names are still register-able: californiainsurance.com, newyorkinsurance.com, virginiainsurance.com, … and so forth, you need …

Bulk Domain Name Availability Checker Tool to Batch Search Available Domains Read More »

Instantly Boost SQL Query Efficiency of REGEXP or RLIKE by 2000%

Naturally, using regular expressions for SELECT queries to check if certain text strings or text patterns are residing somewhere in large chunks of data is the most resource-intensive option and thus your last option. However it’s somehow unavoidable to practice regular expressions in the SQL queries for complicated patterns. For example, word boundaries are a …

Instantly Boost SQL Query Efficiency of REGEXP or RLIKE by 2000% Read More »

WordPress blog goes blank after editing and updating the theme files

Really weird but not unexpected at all. After trying to edit and update a theme file functions.php to override a native function of WordPress, get_search_form, inserting these lines at the end of functions.php of my theme: function get_search_form() { ?>test<?php } To see if the native get_search_form() function can be overriden. Turns out it can’t. …

WordPress blog goes blank after editing and updating the theme files Read More »

mysql command line character set option for importing SQL files encoded in UTF8

For languages other than English, especially those in Asia such as Chinese, each character takes 2 bytes in storage and needs to be encoded in UTF8 or other encoding specifically designed for it. Normally, the command line mysql database importing command has no problem with English database SQL files that are encoded in ANSI or …

mysql command line character set option for importing SQL files encoded in UTF8 Read More »

Being simple as a bless for development cost

Usefulness is the king; and it doesn’t have to be complex. One of the premium rules of project management is to never add a feature without seeing any substantial demand for it. Whatever it is, any additional feature is a burden to the system and a cost of time, both growing exponentially. While many of …

Being simple as a bless for development cost Read More »

A few suggestions of good practices for accelerating PHP development

The slow and steady may win, but the fast and steady dominate. The old saying of faster not always being better may go well in other fields, but not in the IT world of today. Faster is absolutely better. You should by all means try to improve yours or your team’s programming proficiency and accelerate …

A few suggestions of good practices for accelerating PHP development Read More »

RackSpace Cloud Hosting Launched!

Dating back 1 or 2 years ago when RackSpace acquired Mosso, it has long been preparing to start its own cloud hosting business. Now here it is, Rackspace has officially launched the RackSpace Cloud from Mosso: http://www.rackspacecloud.com All hosting service packages remain fundamentally the same with those of Mosso: Cloud Sites, Cloud Servers and Cloud …

RackSpace Cloud Hosting Launched! Read More »

How to Recover or Reset MySQL root Password after You Forgot and Lost It

MySQL has come with a safe mode wherein access privileges are not checked, which essentially enables you to log in anonymously to change anything in any database. And we are going to get in this safe mode to reset the lost MySQL root password. First, you need to stop the current MySQL daemon by: /etc/init.d/mysql …

How to Recover or Reset MySQL root Password after You Forgot and Lost It Read More »

Work Around Zend Studio 5.5 PHP Class / Object / Method Auto-complete Problem

Don’t know if it’s a glitch of Zend itself but I frequently encounter this problem on Windows with Zend Studio when writing PHP. Function / object methods names auto-completion saves a lot of time by suggesting candidates and a quick flyover tooltip with the synopsis, however sometimes it doesn’t work with newly created functions and …

Work Around Zend Studio 5.5 PHP Class / Object / Method Auto-complete Problem Read More »

Best CSS Books to Learn CSS Web Design

While HTML is the concrete of all web pages and websites, CSS is the spirit. It specifies the aesthetic aspect of all the web pages by design through presentation, conveying the ideas and sensations by visual languages. The first class of all web designers start with CSS. These are some of the best CSS books …

Best CSS Books to Learn CSS Web Design Read More »

Best Books of HTML and XHTML to Learn How to Create Web Pages / Sites with HTML and CSS

HTML is the language of the Web and all websites are written in HTML (XHTML). To learn creating website, the first thing you will need to learn is HTML. Period. Some of the selected books below are for beginners and some are for intermediary coders to consolidate your knowledge of HTML and CSS and practice …

Best Books of HTML and XHTML to Learn How to Create Web Pages / Sites with HTML and CSS Read More »

Best JavaScript Books for Learning JavaScript Programming and Development

Thanks to the computer scientists who set the standards of JavaScript, in the arena of event programming and behavioral manipulations of windows and objects, it is the one programming script that is so powerful that you can virtually build any possible interactive applications with it. That said, learning JavaScript to the mastery of it takes …

Best JavaScript Books for Learning JavaScript Programming and Development Read More »

Best Books of Apache Web Server to Learn Apache and Use It

As the most popular web server for hosting websites, Apache is second to none. It thrives for a reason, that is, it’s versatile and adapts to all situations and answer to even the slightest demands of a website. Below are some books from Amazon about administering Apache that may give you a new perspective and …

Best Books of Apache Web Server to Learn Apache and Use It Read More »

Best MySQL Books to Learn MySQL Database Programming and Development (+ PHP Applications)

MySQL is by far the most popular and widespread database on the entire planet. It’s used in a wide array of industries and the Web is probably the most prominent scenario, websites database. Below are some hand selected books for you to learn MySQL: both database administration and database SQL programming, for both professionals and …

Best MySQL Books to Learn MySQL Database Programming and Development (+ PHP Applications) Read More »

Best PHP Books for Learning PHP Development and Programming (with MySQL)

PHP is by far the most popular and easiest to use web programming language in the world. If your goal is to enter PHP programming and development as a novice beginner and start from the very basics, these books are reviewed the best by actual readers. Some of the books contain chapters dealing with MySQL, …

Best PHP Books for Learning PHP Development and Programming (with MySQL) Read More »

JavaScript: Open or Redirect to Another Page / Site / Location

One of the most common uses of JavaScript is to redirect the user to or automatically open up another web page location. For example, when the user clicks a button, the JavaScript will redirect the user to the location selected in the drop down select menu. It’s just like the user has typed the web …

JavaScript: Open or Redirect to Another Page / Site / Location Read More »

JavaScript: Split and Divide Text String by A Delimiter

Spliting and dividing a string into several chunks is a rather basic need for text parsing. You can do it easily in PHP by the help of explode() function or preg_split(), in JavaScript, you can achieve this task by the split() string function. The following example illustrates the usage of javascript split() function to slice …

JavaScript: Split and Divide Text String by A Delimiter Read More »

Scroll to Top