邵珠庆の日记 生命只有一次,你可以用它来做很多伟大的事情–Make the world a little better and easier


29月/13

二十五个精美的后台管理界面模板和布局

发布在 邵珠庆

任何系统都会有一个管理后台,好看的管理后台看起来赏心悦目,管理的时候心情也舒畅,本文给大家推荐 25 个制作精美的后台管理界面的模板和布局,你值得拥有。

Free Admin Template

Web App Theme

Spring Time

Free Admin Template For Web Applications

Free Admin Template

INADMIN

Free admin skin

AdminPraise Lite

Premium Admin HTML Website Templates

MWS Admin – Full Featured Admin Template

Color life – Premium Admin Template

AdminCP

Spina – Premium Admin Template + Tablet Theme

Cupcake – Premium Admin Template + Mobile Theme

xSystem – HTML5 and CSS3 Admin Template

Mandy Lane Premium Admin Template

It’s Brain – premium admin theme

vPad – HTML5+CSS3 App Framework

Adminium – Modern Admin Panel Interface

Peach – Clean & Smooth Admin Template

Lagu Admin Premium Template

Ready Made Admin – Full Featured Admin Theme

Grape – Professional & Flexible Admin Template

Chameleon Circuit – Full Featured Admin Theme

Admin Control Panel v2

White Label – a full featured Admin Skin

 

29月/13

五十个挑花眼的 Twitter Bootstrap 模板(第二部分)

发布在 邵珠庆

Twitter Bootstrap Bootstrap 是一个基于 HTML,CSS,JAVASCRIPT 的简洁灵活的 网站前端框架及组件包。

BootAdmin – All-In-One Admin Responsive Template

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Online Shop
  • Site Pages/ Photo Gallery
  • Booking System
  • Finance

Supr – Responsive Admin Template

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Fully Responsive Layout
  • Build on Twitter Bootstrap
  • jQuery Plugins

Conquer – Responsive Admin Dashboard Template

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Clean and Responsive Design
  • Fixed Header Layouts
  • Friendly code & Template Pages
  • 42+ jQuery Plugins

Beoro Admin Responsive Template

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Responsive Layout (Bootstrap Framework)
  • HTML5/CSS3
  • custom pages, invoice,mailbox, blog, help/faq
  • Charts

Start – Metro UI Responsive Admin Template

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Responsive Layout (Bootstrap Framework)
  • Beautiful Clean Design
  • Plugins Everywhere
  • Easy to Adapt

Chromatron HTML5 Admin Backend

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • HTML5 syntax & CSS3 markup
  • Twitter Bootstrap compatible
  • Responsive design
  • Fluid grid system

WordPress Bootstrap Themes

Free Roots Theme for WordPress

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Roots WordPress Starter Theme
  • HTML5 Boilerplate & Bootstrap

AlYoum | Retina Magazine & Blog WordPress Theme

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • 19 Ready Widgets
  • 8 Ready HomePage Templates
  • Drag and Drop layout builder
  • Retina Display Ready

Point Business Responsive WP Theme

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Fully Responsive
  • HTML5 & CSS Code
  • Woocommerce 2.0.5 Ready
  • Drag & Drop GT3 Page Builder

Alterna – Retina Responsive Multi-Purpose WordPress Theme

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Retina-Ready
  • Visual Composer page builder
  • 5 Header Layout style
  • Bootstrap builder
  • Layer slider and Revolution Slider

Frenzy Responsive Multi-Purposes Theme

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Fully Responsive
  • WooCommerce Compatibility
  • Post Formats

Black Label – Fullscreen Video & Image Background

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Fullscreen Video Background Support
  • Fullscreen HTML5 Video Background Support
  • Fullscreen Images Background Support
  • Responsive HTML5 & CSS3
  • Retina Display ready
  • Audio Background while viewing images

SmartBox – Responsive WordPress Bootstrap Theme

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Responsive Design
  • Based on Bootstrap
  • Retina Display Ready
  • Custom Widgets

BUILDER – Responsive Multi-Purpose Theme

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • HTML5 & CSS3 & jQuery
  • JQuery Responsive Dropdown menu
  • Respinsive Design

One Touch – Multifunctional Metro Stylish Theme

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Fully Responsive WordPress Theme
  • Retina Ready
  • Google Fonts
  • Drag Drop page Builder

Fundraising/Charity Premium WordPress Theme

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Create Cause
  • Promote Causes with Landing Page Builder
  • Responsive Design

Studiofolio: A Versatile Portfolio and Blog Theme

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Infinite Portifolio and Galleries
  • Fluid or Fixed Width Layout
  • Custom backgrounds for pages

Blogbold – Responsive Metro Blogmagnews Theme

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Blogbold is Responsive WordPress theme
  • layout builder and module
  • Developed base on Bootstrap

Quartum Responsive Portfolio WP Theme

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • 45+ Custom Shortcodes
  • Shortcode Generator
  • Translation Ready
  • Built with Bootstrap

Knowledge Base – A WordPress Wiki Theme

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Modern Design
  • Responsive Layout
  • Ajax Based Live Search
  • Bult in Twitter Bootstrap

Metro Mobile Premium WordPress Mobile Template

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Metro Style Layout
  • Create your own Metro Style
  • Camera Slider
  • Mobile Detection

Valencia | Responsive WordPress Theme

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Responsive Layout
  • Powerful Admin Panel
  • Layout Builder

TrustMe – Responsive WordPress Magazine / Blog

50 个让你挑花眼的 Twitter Bootstrap 模板(第二部分)

Features

  • Builtin Review Posts
  • Fully Responsive Design
  • Ajax Rebuild Thumb
29月/13

五十个挑花眼的 Twitter Bootstrap 模板(第一部分)

发布在 邵珠庆

Twitter Bootstrap Bootstrap 是一个基于 HTML,CSS,JAVASCRIPT 的简洁灵活的 网站前端框架及组件包。

Free Bootbusiness

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Twitter Bootstrap version: 2.1.1
  • HTML5 & CSS3 with Responsive
  • Slider in Home page
  • Lightbox in Portfolio page

Free Responsive HTML Template Andia

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Responsive Layout
  • 5 Pages: Home, Portfolio, Services, About, Contact
  • Responsive Image Slider (Flexslider)
  • Filterable Portfolio (jQuery Quicksand and PrettyPhoto)
  • AJAX Contact Form with Form Validation

Readable (Free)

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Responsive Layout
  • Typography, navbar, buttons, forms and tables

Smashing Theme – Responsive HTML5 Theme

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Responsive
  • Retina support
  • 250 vector icons
  • Contact Form 7 support
  • Custom Portfolio

Myway – Onepage Bootstrap Parallax Retina Template

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Fully Responsive
  • Parallax Effect
  • Retina Ready
  • Google Fonts

VALOR – Responsive HTML Template

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • HTML5 & CSS3 & jQuery
  • Responsive Bootstrap grid
  • Filtered portfolio with css3 animations
  • Working js/php Contact Form

YellowProject Bootstrap Responsive Template

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Bootstrap Based
  • Valid HTML5 & CSS Code
  • Responsive Design
  • Retina Ready

OHMY! HTML5, CSS3, Bootstrap website template

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • HTML5 & CSS3 Bootstrap Based
  • 10 color schemes
  • 4 sliders and 3 functional widgets
  • Fully Responsive

Edge Corporate Web Template

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Fully Responsive
  • Incredible design
  • Twitter Bootstrap Framework

Xiara – Responsive Onepage Parallax HTML Template

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Contact Form Ready
  • Fully Responsive
  • Based on Bootstrap

Verendus – Responsive Business Template

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Two Premium Sliders worth $20
  • Unlimited Styles
  • 22 Layered PSD Files

Joiee – Multipurpose Responsive HTML5 Theme

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Clean, Blod, Responsive
  • Retina Ready HTML5 Theme
  • suitable for any business

Crafty – Responsive Retina-ready HTML Template

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Fully Responsive
  • Retina-Ready template with BootStrap

Viva – HTML5 Responsive Unique Theme

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Fully Responsive on bootstrap
  • CSS3 + Sorting Portfolio

oRESUME – Responsive Vcard & Portfolio

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Sortable Portfolio
  • Skin Maker

Roy – Responsive Vcard With Facebook Layout

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Twitter Bootstrap
  • HTML5 & CSS3
  • Unique Design
  • Fully Responsive

Night Life Bootstrap Responsive Dark Template

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Fully Responsive
  • Background Animation
  • Creative Gallery Montage
  • Bootstrap Enchanced

Plain Responsive Template

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Responsive HTML5 and CSS3 design
  • Based on latest Twitter bootstrap (v2.2.1)
  • jQuery 1.7.2
  • Support for touch gestures on mobile devices

Jday – Coming Soon page

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Responsive HTML5 and CSS3 design
  • Contact Form
  • PHP Scripts
  • 3D amazing Backgrounds

Greened – Bootstrap Coming Soon Page

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Bootstrap v2.2.1 and Responsive Layout
  • Optimized for Ipad and Iphone
  • 40 Pattern Background
  • FullScreen Slideshow Transition Effects

Caelus – Bootstrap Coming Soon Page

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Built with Bootstrap 2.2.2 and Responsive
  • jQuery countdown timer
  • CSS3 animated sign up

Charisma – free, responsive admin template

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • 9 different themes
  • Fully responsive
  • Based on Bootstrap
  • HTML5 valid and CSS3

MWS Admin – Full Featured Admin Template

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • Responsive Layout
  • unlimited Colors
  • Bootstrap Integration
  • jQuery-UI Integration

Boo Admin – Responsive Template

50 个让你挑花眼的 Twitter Bootstrap 模板

Features

  • HTML5/CSS3
  • iPad & iPhone Friendly
  • Integrated Bootstrap Plugins

Amsterdam – Premium Responsive Admin Template

50 个让你挑花眼的 Twitter Bootstrap 模板

29月/13

Mysql命令行技巧汇总

发布在 邵珠庆

1) pager

pager真是一个很神奇的东西,它可以控制mysql的输出。默认值是stdout,直接输出。
艾,貌似讲不清楚啊,还是看几个例子吧:

mysql> SELECT mobile FROM profile WHERE mobile!='';
+-------------+
| mobile      |
+-------------+
| 13719001986 |
| 123214234   |
+-------------+
2 ROWS IN SET (0.00 sec)
 
mysql> 
mysql> pager grep "137"
PAGER SET TO 'grep "137"'
mysql> 
mysql> SELECT mobile FROM profile WHERE mobile!='';
| 13719001986 |
2 ROWS IN SET (0.00 sec)
 
mysql> pager
DEFAULT pager wasn't set, using stdout

相当于在输出之后附加了 | grep “137″ ,是不是很震憾。
不止是grep, 所有linux上面的命令都可以的,自由发挥吧。
比如select很多行数据,就可以设置pager more,一页一页地看。
再比如要比较二次select的结果是否相同,可以设置pager md5sum,实在是太赞了。
再比如,只想看select语句运行需要多长时间,而不想看到select出来的结果集,可以使用

pager cat > /dev/null

再比如,看一下processlist里面Sleep的线程有多少,可以使用

pager grep Sleep | wc -l

2) edit

肯定有人会有这样的想法:在mysql命令行里面编辑一个复杂点的sql语句实在是太费神了,光标只能左右移动,要是有个vi就好多啦。
其实真的有….
mysql> edit
就这么简单,谁用谁知道。

3) tee

如果想记录下来您所有的操作及输出,除了屏幕录象软件之外,还有这么一个神奇的东西tee。

mysql> tee /tmp/h.log
Logging TO file '/tmp/h.log'
mysql> 
mysql> 
mysql> SHOW engine innodb STATUS;
.........
mysql> exit

所有的一切都被记录在 /tmp/h.log文件中了。

4) prompt

快要去吃午饭了, 这时如果你又想看一条UPDATE语句究竟会执行多久,怎么办?
等下去就要饿死啦。

修改一下mysql的prompt提示符,轻松解决这个问题:

mysql> prompt \r:\m:\s\P>\_
PROMPT SET TO '\r:\m:\s\P>\_'
11:30:10am> 
11:30:11am> 
11:30:11am> 
11:30:12am> 
11:30:12am> 
11:30:12am> 
11:30:12am>

输入UPDATE语句,回车走人。

吃完饭回来就可以看到执行结束的时间了。

5) ctrl+z

作为一个dba,每天都要在命令行中登陆mysql,运行完sql语句,随手就logout了,(快捷键是ctrl+d),
过一段时间又要login,又随手logout……
重复重复再重复,不仅浪费时间,而且输入mysql root的复杂密码也会烦死个人。

这个logout的坏习惯,一定要改掉。。。,哥已经改掉了。

mysql> 
mysql> 
mysql> SELECT now();
+---------------------+
| now()               |
+---------------------+
| 2012-12-25 15:33:16 |
+---------------------+
1 ROW IN SET (0.00 sec)
 
mysql> 
不要按ctrl+d了, 换成Ctrl+z , 暂停任务。
[1]+  Stopped                 /home/mysql/bin/mysql -uroot -p
[MODIFY@www 8p]$ 
[MODIFY@www 8p]$ 
[MODIFY@www 8p]$ 
需要用到mysql的时候,
输入fg回车:
[MODIFY@www 8p]$ fg
/home/mysql/bin/mysql -uroot -p
mysql> 
mysql>

是不是很爽。。。

6) html输出

-H

[root@www ~]# /home/mysql/bin/mysql -uroot -p -H -e "select host from mysql.user";
Enter password: 
<TABLE BORDER=1><TR><TH>host</TH></TR><TR><TD>localhost</TD></TR><TR><TD>localhost</TD></TR><TR><TD>localhost</TD></TR><TR><TD>localhost</TD></TR><TR><TD>localhost</TD></TR><TR><TD>localhost</TD></TR></TABLE>[root@www ~]#

7) 最简化输出

如果只想要结果,不要那些边框,字段名称之类的东西,可以使用 –skip-line-numbers –skip-column-names

[root@www ~]# /home/mysql/bin/mysql  -uroot -p -e "select count(*) from shipincon.share where add_time >= current_date()";                            
+----------+
| COUNT(*) |
+----------+
|      850 |
+----------+
 
[root@www ~]# /home/mysql/bin/mysql --silent --skip-line-numbers  --skip-column-names -uroot -p -e "select count(*) from shipincon.share where add_time >= current_date()";
850

8) help

在不方便上网查找mysql文档的情况下,help还是很靠谱的。

mysql> help string functions;
You asked FOR help about help category: "String Functions"
FOR more information, TYPE 'help <item>', WHERE <item> IS one OF the following
topics:
   ASCII
   BIN
   BINARY OPERATOR
   BIT_LENGTH
   CAST
   CHAR FUNCTION
   CHARACTER_LENGTH
   CHAR_LENGTH
   CONCAT
   CONCAT_WS
   CONVERT
   ELT
   EXPORT_SET
   EXTRACTVALUE
   FIELD
   FIND_IN_SET
   FORMAT
   HEX
........
 
mysql> help instr;
Name: 'INSTR'
Description:
Syntax:
INSTR(str,substr)
 
RETURNS the POSITION OF the FIRST occurrence OF SUBSTRING substr IN
string str. This IS the same AS the two-argument form OF LOCATE(),
EXCEPT that the ORDER OF the arguments IS reversed.
 
URL: http://dev.mysql.com/doc/refman/5.5/en/string-functions.html
 
Examples:
mysql> SELECT INSTR('foobarbar', 'bar');
        -> 4
mysql> SELECT INSTR('xbar', 'foobar');
        -> 0