Herbert
This user hasn't shared any biographical information
Homepage: http://www.shishuo.com/
Posts by Herbert
各种存储单位
Apr 16th
(bit).Byte (B)
KiloByte (KB)
MegaByte (MB)
GigaByte (GB)
TeraByte (TB)
PetaByte (PB)
ExaByte (EB)
ZetaByte (ZB)
YottaByte (YB)
NonaByte (NB)
DoggaByte (DB)
今天才知道还有这么多的存储单位,真是惭愧,不敢说自己是搞计算机的。
批量删除某个前缀的表[MySQL]
Apr 9th
由于本站点尝试过安装了BBS和其它一个博客,但又被我卸载了,现在想把这些有特殊前缀的表全部删掉。好像MySQL本身没有这个功能,所以找方法取而代之。
先运行下面的SQL语句:
select concat('drop table ', table_name, ';') from information_schema.tables where table_name like 'bbs_%';
然后得到一个drop table bbs_* 的列表,很简单了,到控制台跑一遍就可以了。
雅虎香港注册之保密问题
Apr 8th
由于某个人的博客注册了Flickr,以前注册了一个,不过忘记了。这次我想再注册一个吧。先是在Flickr页面上点了注册,结果跳到一个登录界面。好不容易跳到了注册界面,结果一个问题把我难住了。如图:
我的保密问题选择了“谁是我儿时的偶像?”我的保密答案写了“刘德华”,结果报错了,因为系统要求我写入4个字,我想了下,实在是想不出我有四个字的偶像。我在看下保密问题选项,里面有个“你最喜欢的老师姓什么?”,中国有4个字的姓吗?
唉~~,由于以前玩过了Flickr了,所以这次就放弃注册了。
我以前也碰到这样的问题,我的解决方案是在保密答案哪里写上“刘德华华”,不过我想如果我真的密码丢掉了,等我找密码的时候,肯定不记得自己答案是“刘德华华”。
我又去了下雅虎中国,又有类似的问题。
我去看了下网易有自定义保密问题,且最低字数为3个中文字,可以看出更加人性化,看来雅虎中国或雅虎香港不本地化。
[译]所有网站都应该使用的10个SEO方法
Apr 7th
原文:10 SEO elements all websites should have
说真的,你不需要为更好的搜索引擎排名而去请一个专家来优化你的网站。毕竟,搜索引擎优化(SEO)不是一件复杂的事情。只要花费一些阅读和努力就可以自己学习和做搜索引擎优化。
但是,在开始真正的SEO工作(整个SEO运动的方向)之前我们需要了解,我们尝试完成什么样的目标呢?我们的目标关键字是什么?谁是我们的竞争对手?在我们开始任何SEO之前,运动关键字搜索都是最重要的准备工作。
对你的网站或者博客来说,搜索关键字就像罗盘的角色一样起着决定性的作用。一个恰当的搜索关键字显示了你所在的行业所从事的和发展的方向,因此,你应该关注一些普遍的行业关键字。
简单来说,这就是告诉你怎么做一个关键字搜索呢?
- 使用Google Keyword Tool 得到一个关键字关系表。
- 检查每个关键字在搜索引擎结果页(SERP)有多少个页面被抓到,这将作为一个数据依据。
- SERP排前面的网站你的主要竞争对手,学习他们。
- 去学习什么是需要的,对每个关键字用关键字工具去检查他的所有字数。
- 一些好的关键字搜索工具:Word Tracker 和 Keyword Discovery(原文作者喜欢的)。
那么,你现在有了一个粗略的竞争思路。对于初学者来说,这最聪明的方法是在一个小的或中等的池塘里捕捉一条大鱼(The smart approach is to be a big fish in a small/average pond – for starters),你应该把你的工作重点放到有节制的需求和低竞争(moderate demands and low competition)的关键字上。
除了支持和需求,搜素关键字也应该主动提供一些有价值的信息给你的网页设计者。举个简单的例子,一个在线出售鞋子的网站,我能肯定你有如此的问题:什么品牌的鞋子将被搜索,鞋子应该怎样按品牌、季节还是尺寸分类?
随着你开展完你的关键字搜索工作这些问题将应刃而解。你将看见根据品牌查询的有“DC 鞋”、“jordan 鞋”、“nike 鞋”;同时,搜索者也根据不同的运动或季节查找鞋,比如:“芭蕾舞鞋”,“安全鞋”,“保龄球鞋”,“舞鞋”等等。
在你开展搜索引擎工作的最后,你应该能够生成一个目标关键字的列表。现在是关注你的SEO工作的时候了。为了更好的开展工作,这有10条建议帮助你马上提高你的博客或网站的SEO质量。
立刻提高你的网站的SEO质量的10条建议:
- 默认页(index.html,index.php等等)可用和多关键字的URL
- 可信赖的网页主机
- 多关键字的Title和标题标签
- 在图片上有Alt标签信息
- 适当结构化的内部链接
- 外部链接
- XML站点地图
- 有WWW和没有WWW的域名讨论
- Robots.txt
- 内容是关键
还没有翻译完,待续……
[转]Best of 2008 for designers
Apr 7th
转载:http://aytemir.com/best-of-2008-for-designers-2008-tips-tricks-resources-and-inspirations/
A compilation post with the best posts of 2008 was inevitable. Below you’ll find more than 2008 tips, tricks, icons, tutorials, inspirations and more design stuff. For beginners and advanced designers. Also make sure you check out the other posts on these great blogs.
So for your and my own reference here are the best posts for designers this year I’ve came across and which are worth (re)reading.
Tutorials (562)
30+ Exceptional GIMP Tutorials and Resources
25 Ways to Spice Up Blog Post Photos
50 Great Photoshop Tutorials for Clever Beginners
31 Practical (Web) Interface Design Tutorials
22 + 50+ Great Photoshop Text Effect Tutorials, Part II
41 + 30+ Nicest Photoshop Photo Tutorials, Part II
40 Cool Abstract and Background Photoshop Tutorials
100+ best sites to find tutorials!
80 of the Best Vector and Illustrator Free Resources
Icons (150)
110+ Free RSS Icons To Show Off Your RSS Feed
40+ Hand-picked Photoshop Icon Designs [Photoshop Tutorials]
Inspiration (638)
32 Invaluable Sites for Web Design Inspiration
40+ Beautiful Hand-Drawn Websites
Typographic Madness: 30 Brilliant Piece of Work
40 Creative + 50 Excellent + 100 funny and unusual + 36 cool + 49 Nice And Creative Error 404 Pages
33 New Design Blogs with Great Content & Resources
37 Ways to Design the Comments Form
30 Must See + 30 More Must See Comment Designs for Blog Designers
31 Creative Examples Of Mascots To Grab Your Attention
70 beautiful websites with a large background
30 creative custom wordpress logins
Resources (720)
20 Creative and Inspiring Free Design Magazines
20 Free & Open Source Image Galleries for Web Designers
30 Free Stock Photo Sites: Ultimate Collection
208 Retro Photoshop Patterns
52 Vector Landscapes, 53 Vector Characters
27 + 36 + 36 Beautiful Business Card designs
25+ Sites that Use Typography As The Only Design Element
Promote Your Blog Posts: 12 Nice Designs and Techniques
Top 25 Web Design Blogs
100 Nice and Beautiful Blog Design
40 most beautiful and inspirational website designs of 2008
11 Sites To Create Cartoon Characters of Yourself
25 Website Designs To Draw Inspiration From
Missing any great posts that should be added to this list? Leave a link with your comment and complete the list!
[转]Best of 2008 for bloggers
Apr 7th
转载:http://aytemir.com/best-of-2008-for-bloggers-1600-tips-tricks-advices-and-strategies/
Last in the series of Best post for Designers, Developers and Bloggers. A collection of more than 1600 useful tips, tricks and advices from (pro) bloggers for newbies and pro bloggers posted in 2008. From getting started to getting (more) traffic and from getting (more) subscribers to actually making money with your blog.
A huge reference if you need just that little push in the right direction.
General Blogging Tips (733)
30 Blogging Tips to Screw Up
10 Characteristics of a Successful Blogger
10 Ways to Brand Your Blog or Website Efficiently
18 Simple Tweaks To Get More Clicks From Your Organic Rankings
9 Things That Drive a Blogger Crazy
5 Blogging Goals Worth Chasing After
8 Addictive Habits of Bloggers
16 Important but Potentially Distracting Blogging Tasks
20 Types of Pages that Every Blogger Should Consider
Social media blog post ideas for desparate people (82)
22 Ultra Inspiring Blogs About Creativity and Idea Generation
40 Ways to Deliver Killer Blog Content
Stop Planning: 50 Ways to Improve Your Finances Today
22 Essential Habits Towards Blogging Success
Top 100 Blogging Tips for Bloggers – Bloggers Guide
Sensational List Of 25 The Best Design Worldwide Forums
100+ WordPress Video Tutorials, from Basic to Advanced
The Top 50 Marketing Blogs To Watch In 2008
30 Web Trends for 2009
50+ Must Read Web Design for ROI, Usability and SEO Articles
42+ Resources for Bloggers
Twenty-eight ways to be a better designer
10 Tips to avoid designer’s block
16 tips to improve as a graphic designer
Subscribers, Success and Failure (267)
Top 10 tips to make your own web app projects
How to Fail: 25 Secrets Learned through Failure
10 Innovative Blog Business Models
10 Signs That Your Blog Is On The Right Track
50 Ways to Take Your Blog to the Next Level
Top 100 Reasons Why Blogs Fail – Blogging Mistakes
12 Tips To Grow the Subscriber Base on Your Second Blog
50 Simple Ways to Gain RSS Subscribers
Money Making Tips (53)
28 Ways to Make Money with Your Website
25 Paths to an Insanely Popular Blog
16 Sponsored Review Programs Pay You For Your Blog Posts
Promotion and Traffic (572)
Promote your blog: 250+ links to get free backlinks
41 websites to promote your design articles and resources
14 Tips To Drive Traffic To Your Blog
11 Blog Directories and Communities to Boost Your Blog’s Traffic and Popularity
SEO Optimizing Tips: 30 + 30 + 25 + 30 + 33 + 30 + 78
[转]Best of 2008 for developers
Apr 7th
转载:http://aytemir.com/best-of-2008-for-developers-2008-tips-tricks-scripts-and-sources/
The second in series of best posts of 2008 for designers, developers and bloggers. This second post contains a collection of more than 2008 tips, tricks, scripts, examples and tools for developers.
Whether you’re a beginner or pro, you could use some of these posts for a reference someday.
Tools & Web Apps (463)
- 13 Most Essential Open Source Apps That You Probably Like To Say Thank You
- 14 free tools that reveal why people abandon your website
- 40+ CSS Generators, Creators, and Makers
- 74 Great Web Apps for Web Designers we have forgotten about
- 50-Plus Tips and Resources to Improve Your Site’s Speed and Performance
- 15 Tools for Monitoring a Website’s Popularity
- 11 Powerful Firefox 3 Add-ons That Can Replace Standalone Applications
- 10 Free Photo Managing Software You Should At Least Know
- 15 Things Every Web Developer Should Be Thankful For
- 15 Must-Have Bookmarklets For Web Designers And Developers
- 20 Great PHP frameworks for developers
- 66 Links To Learn The Webdesign Basics
- Web Development Toolbox: 120+ New Tools for Web Development
Scripts, Tweaks and Hacks (605)
- The Top 40 Free Ajax & Javascript Code for Web Designers
- 15 Key Elements All Top Web Sites Should Have
- Top 10 Tutorials for Converting PSDs to HTML/CSS
- 30+ Tooltips Scripts With JavaScript, Ajax & CSS
- 50+ Nice Clean CSS Tab-Based Navigation Scripts
- 40+ Most Wanted WordPress Tricks and Hacks and 30+ More
- 30+ Eye-Opening Web Development Screencasts
- 19 CSS Menu Tutorials to Spice Up Your Web Designs
- 34+ free HTML newsletter templates for startups
- 50 Excellent AJAX Tutorials
- 15 Helpful In-Browser Web Development Tools
- 75 (Really) Useful JavaScript Techniques
- 63 Essential WordPress Hacks, Tutorials, Help Files and Cheats
- The Best (19) Cheat Sheets for Web Designers and Developers (From CSS, Ajax, Perl, Vbscript…)
- 10 Useful RSS-Tricks and Hacks For WordPress
- 20 Amazing Javascript Prototype Scripts, Elements, Widgets, Classes..
- 10 Smart Javascript Techniques to Improve Your UI
- 20 Excellent AJAX Effects You Should Know
- 35 Easy to use Free Ajax/Javascript Navigation Solutions
- Top 10 CSS buttons tutorial list
- 10 Free Chart Scripts
Tips (208)
- 10 Principles of the PHP Masters
- 6 Easy Ways to Improve Your HTML Emails
- 7 Principles Of Clean And Optimized CSS Code
- 12 Principles For Keeping Your Code Clean
- 10 Advanced PHP Tips To Improve Your Programming
- 10 Optimization Tips
- 10 SEO elements all websites should have
- 10 Web App Tips From 8 Inspirational Speakers
- 7 ways to write beautiful code
- 10 Dirty Little Web Development Tricks
- 15 CSS Tricks That Must be Learned
- 101 CSS Techniques Of All Time- Part 1 and Part 2
Sources (441)
- 20 Websites to Help You Master User Interface Design
- 53 Steps to follow if you want to become Freelance Web Designer/Developer (60+ Resources)
- A study in Ajax Web trends. What are the best Free Ajax Resources? (70 of the Best Ajax Resources)
- 155 WordPress Resources, Tutorials, Plugins, Themes, AJAX, Podcasting…WP Monster List
- 41 of the Best MooTools Ajax Example Downloads
- 65 Excellent jQuery Resources (tutorials,cheat sheets,ebooks,demos,plugins…)
- 37+ Great Ajax, CSS Tab-Based Interfaces
Generators (63)
- 25 Color Palette Generating Resources for Web Designing!
- 13 Free Online Tools That Helps You To Create And Host Your Website
- 25 Web 2.0 Generators
Plugins and Themes (235)
- 10 Best Plugins To Get More Comments
- The top 20 plugins to transform WordPress in a CMS
- 10 plugins you should be using in your WordPress theme or blog
- 10 WordPress Plugins to Add Ratings and Polls to your blog
- Top 30 WordPress Plugins that are actually useful!
- 130 WordPress Plugins You Could Ever Need: The Best Of : Part 1 and Part 2
- 18 WordPress Plugins to add Professionalism to your Blog
- 7 WordPress Themes To Create Your Own CSS Gallery

