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

Does anybody know that it’s a perfect wave of how the month names would look like if aligned left vertically? December January February March April May June July August September November December January Creepy, huh! (wink wink) 😀

HTML DocType Text: World’s Tiniest and Shortest HTML DocType Declaration

Dustin Diaz made an interesting discovery to trigger “standards mode” with just a tiny little declaration instead of the regular lengthy one we see everywhere. As opposed to “standard mode“, there’s this “quirks mode” in IE that accommodates legacy HTML code of no standards at all — rendering them in many different ways compared with …

HTML DocType Text: World’s Tiniest and Shortest HTML DocType Declaration Read More »

How to Do Keyword Research – From Keyword Seed List to a Profitable Niche

This tiny little tutorial is meant for SEO beginners. Just for instance, if you never heard of what a seed list is or how to do keyword research, you are one. Keyword seed list is a list of keywords you gather for further keyword research which may very well contain thousands of related keywords about …

How to Do Keyword Research – From Keyword Seed List to a Profitable Niche Read More »

Elements with display:block and height gains 100% width and don’t float in IE6

As we all know that with a style rule of width or height, an element gains hasLayout in Internet Explorer and it triggers the IE proprietary rendering algorithm. Though this trick solves many weird problems in IE, especially IE6, it does come with a few issues as well. For example, when you need a top …

Elements with display:block and height gains 100% width and don’t float in IE6 Read More »

What are the Mandarin Chinese web safe fonts?

As I’m a mainlander Chinese, I can only speak for those computers and browsers who live in central P.R.China. If you are making a design for or in Mandarin Chinese, especially Simplified Chinese, beside those common English web safe fonts such as Arial and Verdana shipped in MS Windows by default that 95% mainlander Chinese …

What are the Mandarin Chinese web safe fonts? Read More »

How to pass variable values in URL from page to page with PHP?

You can see dynamic URLs everywhere on the web with busy interactive sites. Variables and their values are passed from one page to another in this way. Or more precisely, a page served in PHP (a single file php script) can accept external input in the form of a dynamic URL such as http://www.asite.com/[email protected]&subject=hi&body=bye. In …

How to pass variable values in URL from page to page with PHP? Read More »

Using JavaScript to Open Excel and Word Files in HTML

One of the main reasons that you might need this is that Microsoft Excel and Word documents pervade. They are perfect media to store, display and distribute information and ideas. A rather straightforward approach is to simply link that document up. <a href=”bank/sheet.xls” >some excel file</a> Another approach is via JavaScript. <script type=”text/javascript”> function openExcel(strFilePath) …

Using JavaScript to Open Excel and Word Files in HTML Read More »

SQL: INSERT INTO … SELECT … to generate or combine records from existing ones and insert into an existing table

Update: Here is a more advanced use of INSERT INTO … SELECT … to combine multiple tables into one. While CREATE TABLE … SELECT … mix and mingle records by column from other tables into a table that’s created on the fly, INSERT INTO … SELECT … insert those generated or combined records into an …

SQL: INSERT INTO … SELECT … to generate or combine records from existing ones and insert into an existing table Read More »

SQL: CREATE TABLE … SELECT … to generate new table from existing tables

CREATE TABLE … SELECT comes rather useful when you need to generate reports from existing tables or do a mixture. The title just shows the basic usage of it, for instance, to create a new table xxx from 2 columns in yyy, namely col1, col2. After executing SQL: CREATE TABLE xxx SELECT col1, col2 FROM …

SQL: CREATE TABLE … SELECT … to generate new table from existing tables Read More »

How to build a php query string without question mark

As a result of the spreading SEO awareness and how Google works, it is always recommended to use as less dynamic URLs as possible for your site. If one must, try using as less variables in the dynamic URL as possible. A dynamic URL is one with a question mark that passes dynamic variables to …

How to build a php query string without question mark Read More »

Using JavaScript to refresh and reload an iframe on main page

<iframe></iframe> is useful in many aspects. There are times when you want to refresh the content of an iframe and reload the page in it, without refreshing that of the main page, and it can be achieved with a tiny property of iframe, src. Let’s say you have an iframe of captcha that enables the …

Using JavaScript to refresh and reload an iframe on main page Read More »

Check for file size with JavaScript before uploading

File uploading is a rather common feature of interactive sites. As all servers come with a limit on the size of the file being uploaded, it would be a usability blessing for users if web developers can implement a logic to check for the file size before uploading, informing the user if the size of …

Check for file size with JavaScript before uploading Read More »

Use twitter in Windows active desktop to post anytime!

Windows active desktop is a feature that allows you to embed a browser window (viewport) on your actual desktop. Instead of a window form, it’s accessible anytime on the desktop yet never takes up any task bar spaces. Windows XP users can activate active desktop following these procedures. Basically you just right click on the …

Use twitter in Windows active desktop to post anytime! Read More »

Pretend your scraper script as a browser when scraping in PHP

It’s easy to make a simple scraper script in PHP but it’s also easy for data-centric sites to detect and keep out suspiciously continued page accesses done in large amounts and a small period of time. There are usually 2 ways for a site to detect possible scraping activities. One is to make sure the …

Pretend your scraper script as a browser when scraping in PHP Read More »

Scroll to Top