Archive for September, 2009

The difference between utf8_general_ci and utf8_unicode_ci in MySQL

The utf8_general_ci and utf8_unicode_ci are most popular collations for utf8 charset in MySQL database. But a lot of peoples do not know the different between utf8_general_ci and utf8_unicode_ci.
Read the rest of this entry »

 

[PHP] PHPExcel – The Powerful Excel Library

PHPExcel is an powerful class for read & write excel files, it is very useful in the report generation. You can easily to use PHPExcel to create the true and new version excel files, not are outdated excel formats.

PHPExcel providing a set of classes for the PHP programming language, which allow you to write to and read from different file formats, like Excel 2007, PDF, HTML, … This project is built around Microsoft’s OpenXML standard and PHP.
This class set provides, such as setting spreadsheet meta data (author, title, description, …), multiple worksheets, different fonts and font styles, cell borders, fills, gradients, adding images to your spreadsheet and much, much more!

Quoted from PHPExcel homepage

Read the rest of this entry »

 

[PHP] PHPMailer – The Mail Library

The PHPMailer a powerful and most popular email transport class with a big features and small footprint that is simple to use and integrate into your own software.

PHPMailer is free and release under LGPL license.

Full Featured Email Transfer Class for PHP. PHPMailer features:

  • Supports emails digitally signed with S/MIME encryption!
  • Supports emails with multiple TOs, CCs, BCCs and REPLY-TOs
  • Works on any platform.
  • Supports Text & HTML emails.
  • Embedded image support.
  • Multipart/alternative emails for mail clients that do not read HTML email.
  • Flexible debugging.
  • Custom mail headers.
  • Redundant SMTP servers.
  • Support for 8bit, base64, binary, and quoted-printable encoding.
  • Word wrap.
  • Multiple fs, string, and binary attachments (those from database, string, etc).
  • SMTP authentication.
  • Tested on multiple SMTP servers: Sendmail, qmail, Postfix, Gmail, Imail, Exchange, etc.
  • Good documentation, many examples included in download.
  • It’s swift, small, and simple.

Quoted from PHPMailer homepage

Read the rest of this entry »

 

Detect Internet Explorer 6 in jQuery

Microsoft Internet Explorer 6 still is a popular browser in the world. but IE6 has are many problems so we always need to detect the browser version. jQuery provided a simple method to do this, see below

Read the rest of this entry »

 

Share my online tools

I developed some online tools for my self. share at here now .

Existing features:

  • Hashing Functions
  • Base64 Encode and Decode
  • Password Generator
  • Syntax Highlighter

Planning:

  • CSS Compressor
  • JavaScript Encode and Decode

Online Tools Homepage:

http://tools.yctin.com/

 

Barebone PC Photos – NC91F

In the last month, I purchased a barebone pc to build up the mini server.

Intel Atom CPU 330 1.6GHz
Jetway NC91-330-F Mini-ITX
Kingston DDR2 800 CL5
Seagate 500G Harddisk
Level-1 10/100 PCI NIC

Share some photo here:

Read the rest of this entry »