Today find an interesting thing from google service.
Google trends is a service that tell you the search trends of some keywords you inputed, I find that it is useful on SEO that you can use it to analysis which keyword has better search trends.
．．．．．．．．．．．Today find an easy way to embed an pdf file in a website, the service provided by google docs.
By use of iframe and just replace the url of your pdf file to the following
https://docs.google.com/viewer?embedded=true&url=your_pdf_url
You can also go to https://docs.google.com/viewer to do so
With the growth of web 2.0, we got to use ajax much more than the past. To make ajax content loading, we always need to use loading img to cache the interval while loading, we mostly use image display the loading message, but nowaday, you have another choice.
By use of the animation and transform attribute, we can easily make a loading display with CSS3, below is the example
Today learn a new method on MySQL. On programing, we always need to judge a record is exists or not, update when exists else insert. I'm always using PHP to do that before, but today I find the that MySQL already have a method to do so. For example, if a table contain three colum a,b,c and a is the unique key or primary key, you can use the following statment to do an update exists else insert.
INSERT INTO table (a,b,c) VALUES (1,2,3) ON DUPLICATE KEY UPDATE c=c+1;
This will insert a new record when the table hasn't a record a=1 else the record will update c=c+1
