Most sites these days are dynamic, and whilst some use off the shelf software, such as Wordpress, MovableType or Drupal, there are many custom developed sites.

Most of these custom developed websites have a admin section that very few people see, which plays a vital role in the website operation, but because few people see the admin section, sometimes little attention is paid to it.

Below you’ll find some HTML/CSS templates specifically built for admin sections of custom sites which can help make sure the admin section as beautiful and usable as the public face of the website.

Free Templates

Web Resources Depot Free Admin Template For Web Applications

I have created this admin template for a project of mine and pleased to share with WebResourcesDepot readers.

It is a 3 column design with a tabbed menu. The idea is having the standard categories in the tab menu for an easy reach and have all the detailed ones in the left menu. And there is an info box at the right to inform users what’s going on at that page.

Demo Link
Download Link

Gooey Templates Proton

A plain and simple template, Proton provides the basics of what you’ll need in your Admin. See below for other Paid templates from Gooey.

Download Link

Bloganje Free Admin Template

I needed a simple admin template for a project I’m doing but I couldn’t find any so I created my own and decided to share it. It’s nothing fancy and I didn’t paid much attention to cross browser compatibility but I think it should work. It works for me and hopefully it will spare you few hours of work. You can see index demo and users demo. This template is free for personal use /non commercial. I would’t mind if you keep the link in the footer. All icons are form famfamfam.com

Demo Link
Download Link

Transdmin Light

A clean template which can be easily modified released by Perspectived.

Demo Link
Download Link

Paid Templates

Gooey Atom

Available in Green, Blue and Brown, or a bundle of all three priced at $99 each or $199 for the bundle.

Gooey Carbon

Available in Blue, Red, Green and bundle of all three priced at $99 each or $199 for the bundle.

Theme Forest

The recently launched Theme Forest provides a category for Admin Skins, which includes a number of great templates a selection is shown below.

Quik v1 Admin Skin

Developed by Collis Ta’eed one of the founders of Envato that created Theme Forest, this theme was available for just $1 when Theme Forest launched, now priced at $10, and still well worth the price.

CSS Admin

Priced at just $10.00 this is a simple and clean template by mip-design

Demo Link

LiteAdmin

LiteAdmin is a backend admin template. This web application template was built with Web 2.0 in mind and will give you all of the elements to jumpstart your backend web application skin. LiteAdmin includes heading styles, tables styles, error and success message styles and much more. This admin theme will easily integrate into existing web applications or be a great start as a theme for your upcoming application.

Price is $12

这里还有大量收费的模板：

http://themeforest.net/category/site-templates/admin-skins

http://news.163.com/09/0627/09/5CQAJ72Q0001124J.html

http://news.sina.com.cn/c/p/2009-06-27/113018105661.shtml

1. cfImageCropper - This script is written in Coldfusion. The Demo of this script works very well and the code is very simple to implement.
2. jsCropper - This javascript image cropping script is based on the Prototype JavaScript framework and script.aculo.us. jsCropper is one of my favorite copping script. It is very easy to use and its a great unobtrusive script. jsCropper has tons of great features you should check it out.
3. mooImageCrop - mooImageCrop is based on the mootools framework and php. It is very easy to implement.
4. Image Crop - This is a great script written in Javascript and PHP. It requires the install of ImageMagick server component.
5. Ajax Image Editor - Is a very powerful image editor script that allows you to crop, resize, and rotate the image. It is fairly easy to implement and it isn’t written with any frameworks.
6. Flash Image Crop - Is a very nice flash image crop tool written in Actionscript and PHP. The only problem I have with this script is that you have to use the space bar to accept the cropped area and not the enter key. But overall it works very well.
7. Flash Based Cropping tool - This tool is also written in Actionscript and PHP is a very nice script. You can also resize the image with this script.
8. MooCrop -MooCrop is an Image Cropping utility that uses mootools javascript framework.  MooCrop works very fast and you can even edit the color of the mask.

1. jqac - Is jQuery plugin for autocomplete. jqac is very easy to implement and has a scrollable suggests list. It also allows for multiple suggests support and is tested in all major browsers.
2. AutoComplete (for Prototype) - This is a script built for the prototype framework and it allows multiple column support. It also is a very nice style built with it.
3. YUI Autocomplete - This script is built with the Yahoo! UI Library. The AutoComplete features navigation of the suggestion box via up/down arrow keys. It is very easy to configure with the Yahoo! UI Library.
4. AJAX autocomplete - Is built with Easy Ajax framework by Jim Roos. It features the the up and down navigation and is fairly easy to implement.
5. Another AutoComplete (prototype) - This prototype framework autocomplete also uses scriptaculous. It has a nice fade in effect when the suggest box appears. It is easy to implement and works with XML data.
6. AutoComplete (mootools) - A MooTools Autocomplete widget that creates a unobtrusive and customizable suggestion box from variable data sources. It also has nice fade in effect.
7. dhtmlxCombo - Is a different from the rest of these. dhtmlxCombo can be used in four modes: an editable select box, a read-only select box, a filter drop down box, and an autocomplete. It also allows for you to add icons to your drop down boxes.
8. AutoSuggest - This AutoSuggest script uses no frameworks. The script allows you to navigate either with the up or down arrows or just click. The script size is under 10k, it even has a fade in effect, and a great 2.0 style.
9. Spry Auto Suggest - This Auto Suggest script is written with Adobe’s spry framework. It has works with all sorts of data formats and languages. It supports keyboard navigation and also allows for multiple suggestions.
10. ASP.Net AutoComplete - This script allows you to add AutoComplete to ASP.Net without using a webservice. This is a great way to add Autocomplete feature to ASP.net

1. LightBox 2: In Lightbox 2 you are able to group images together to form a slideshow and it has some fancy transitions. Lightbox 2 only allows the use of Images. Lightbox 2 uses the Prototype Framework and Scriptaculous Effects Library.
2. ThickBox 3.1: ThickBox is very similar to Lightbox but it allows the use Text content in the box, inline frames, and a login module. ThickBox was built using the super lightweight jQuery library. ThickBox doesn’t have Transitions.
3. MultiBox: Is like lightbox but it supports flash, video, mp3s, and html. MultiBox is built with MooTools.
4. GreyBox: GreyBox can be used to display websites, images and other content. Since this script is written without the use of frameworks it is very lightweight. It’s only 22 KB! This is my favorite script because I don’t like using frameworks in my sites.
5. SexyBox: SexyBox is also written without a framework and what I’ve seen it allows the use of text. I’m not sure if SexyBox can work with images since I have not used it.
6. ShadowBox.js: Shadowbox supports all of the most popular web media formats including images, QuickTime, Windows Media Player, Flash, Flash video, HTML, and even external web pages. Shadowbox supports a host of options that make it highly configurable. I highly recommend this script. It is one of the best.
7. LightView: LightView also supports all of the most popular web media formats including images, QuickTime, Windows Media Player, Flash, Flash video, and HTML. The Difference is LightView uses Prototype and Scriptaculous.
8. GMapsOverlay: GMapsOverlay is very unique from the rest of these. It only works with Google maps but it allows you to set the location on the map. It is built on MooTools.

男人的视野像一条“隧道”，只有30度的视野范围

女人的视野有180度，是男人视野范围的六倍

科学家们近日研究发现男女视野有别，女性的视野是男性的六倍，所以女性往往能看到男性看不到的物体。

男人往往找不到小东西，并且喜欢责怪女人在他们背后藏东西。钥匙，内衣，袜子，鞋子等等他们一般都很难找到。这样的结果是有历史渊源的。在很久以前，人类的祖先住在山洞里，在篝火边取暖，男人不得不每天外出狩猎，养家糊口。为了盯住并跟踪远处的猎物，男人必须将眼光放得长远，并将其他事情置于一边不理会。从古时候起，上天就已经赋予男人这样的能力了，所以对大多数男人来说，他们的视野就像一个隧道——狭小但长远，正是这种能力使他们能够看到距离很远的物体。

女人从远古时候起就留在家里照顾孩子和家庭，这种工作需要眼观四路，耳听八方，以防有危险靠近她们的孩子。所以上天赋予她们视野宽广的能力，这就是为什么女人在看东西时能看到180度视野范围内的所有物体，她们能比男人更容易在冰箱或衣柜里找到一件东西，而男人的视野范围只有30度。

男人在寻找东西时需要上下左右移动头部才能找到一样小物件，而女人只需要扫一眼打开的冰箱，就能将冰箱里的东西尽收眼底，在几秒钟内找到想要的东西。

男人都有盯着漂亮女人看的习惯，但却看不到这一行为已激怒了身旁的妻子或女朋友。在现实中这并不意味着女人就不喜欢看长得英俊的男人，她们同样也会这样做，只是她们不需要把头移过去才看得到，用余光就能看到。

说说为什么。

假如这个人是你的亲人，你救谁？

A cross tab query is a transformation of rows of data to columns. It usually involves aggregation of data e.g. totals broken down by months, products etc., where the months are represented by columns. It's very hard to visualize without an example, so we will provide one below.

Lets say you have a table of transactions that looks like this

customer_id	amount	purchase_date
123	41.50	2004-10-01
12	30.50	2004-09-01
12	40.50	2004-08-15

One example of a cross-tab is to take the above data and show how much you earned in each month across. This allows for easy comparison of profits from quarter to quarter. You want your resulting data to look like the below.

m2004_08	m2004_09	m2004_10	Total
40.50	30.50	41.50	112.50

How you get to the above representation varies from Database to Database. In the first example, we'll show you how to get there with standard ANSI-SQL tricks.

Standard ANSI-SQL Crosstab

Select
SUM(CASE WHEN purchase_date BETWEEN '2004-08-01' and   '2004-08-31' THEN amount ELSE 0 END) As m2004_08,
SUM(CASE WHEN purchase_date BETWEEN '2004-09-01' and   '2004-09-30'  THEN amount ELSE 0 END) As m2004_09,
SUM(CASE WHEN purchase_date BETWEEN '2004-10-01' and   '2004-10-31' THEN amount ELSE 0 END) As m2004_10,
SUM(amount) As Total
FROM purchases Where purchase_date BETWEEN '2004-08-01' AND '2004-10-31'

DBMS specific approaches

Microsoft Access

Microsoft Access has supported cross-tab queries natively for as far back as I can remember which would be Access 2.0. Access 1.0 may have supported it as well, but my memory doesn't go that far back.

Access supported via a predicate called TRANSFORM. If you are using the Access wizard, you can use the cross-tab wizard to automatically write the SQL statement for you.

The above query would look like

TRANSFORM Sum(purchases.amount) AS SumOfamount
Select Sum(purchases.amount) AS Total
FROM purchases
Where purchase_date between #8/1/2004# and #10/31/2004#
PIVOT "m" & Format([purchase_date],"yyyy_mm") In ("m2004_08","m2004_09","m2004_10")

Microsoft SQL Server 2005

In SQL Server 2005, the PIVOT and UNPIVOT predicates were introduced. The PIVOT predicate is a new way of doing crosstab queries that is very similar to MS Access Transform PIVOT approach. The code looks like the below

Select *
FROM
(Select  'm' + CAST(DATEPART(year,[purchase_date]) As varchar(4)) + '_' + RIGHT('0' + CAST(DATEPART(month,[purchase_date]) As varchar(2)), 2) as themonth, amount
FROM purchases
Where purchase_date between '8/1/2004' and '10/31/2004' ) p
PIVOT (SUM(p.amount) FOR themonth  In ([m2004_08],[m2004_09],[m2004_10])) as pvt