Linux 抓檔案

wget http://nchc.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.9.0.tar.gz

linux ftp 下載檔案方法

匿名登入
lftp ftp://mp3.budaedu.org/
get ghosa/C006/T0A77n/A77102AM.mp3
get ghosa/C006/T0A77n/A77102BM.mp3

ssh 帳號@IP <===連到另一台主機
fssh IP <=== 用SSH抓檔案

Excel 相關應用

session_cache_limiter('private');

session_cache_limiter('public');
header("Content-type: application/vnd.ms-excel; charset=BIG5;");
header("Content-Disposition: inline; filename=UniformCashNewReport.xls;");

or

session_cache_limiter('public');
header("Content-type: application/vnd.ms-excel; charset=UTF8;");
header("Content-Disposition: inline; filename=MachAuditReport.xls;");

日期格式
Style='mso-number-format:\"yyyy\\-mm\\-dd\"'
Style='mso-number-format:\"yyyy\\-mm\\-dd hh\\:mm\"'

字串格式
Style='mso-number-format:\"\@\";'

找出 相同資料的SQL

SELECT emp_sn, count(emp_sn) FROM uniform_cash
GROUP BY emp_sn HAVING count(emp_sn) > 1

GB2312 to UTF-8 for MySQL

$link = @mysql_pconnect("127.0.0.1","leeyc","xxxxxx") or die(throwError('unable to establish a connection'));

@mysql_select_db("chilier", $link) or die(throwError('unable to select database'));

mysql_query("set names utf8", $link); // 轉 GB2312 to UTF-8 需要先下這行指令


// 將 GB2312 碼轉為 UTF-8
function encodeString($s) {
$s = mb_convert_encoding($s, 'UTF-8', 'GB2312');
$s = htmlspecialchars($s, ENT_COMPAT, 'UTF-8');
return $s;
}