- May 09 Sat 2015 01:53
-
在OSX 10.10上安裝MySQL會遇到的問題
- Apr 29 Tue 2014 23:43
-
nginx.conf設定筆記 - server_name
當多個server block時，server name匹配順序為：
萬用字元：
正則表達式
- Apr 14 Mon 2014 16:15
-
在EC2上面安裝nginx
sudo su -
yum update
yum install nginx php-fpm php-xml php-pdo php-odbc \
php-soap php-common php-cli php-mbstring php-bcmath php-ldap \
yum update
yum install nginx php-fpm php-xml php-pdo php-odbc \
php-soap php-common php-cli php-mbstring php-bcmath php-ldap \
- Apr 03 Thu 2014 14:42
-
撰寫API時 用目錄分類controller的寫法
RewriteEngine On
#強制轉到/api下 拿掉的話就轉到該相對目錄
#RewriteBase /api
RewriteCond %{REQUEST_FILENAME} !-f
#強制轉到/api下 拿掉的話就轉到該相對目錄
#RewriteBase /api
RewriteCond %{REQUEST_FILENAME} !-f
- Jan 26 Sun 2014 00:59
-
四種實作分類樹的優缺點
https://www.slideshare.net/billkarwin/models-for-hierarchical-data
- Mar 20 Tue 2012 15:34
-
Apache Log Format
Apache Custom Log Formats
Format String
Description
%%
百分比符號
%a
遠端 IP 位址
%A
本機 IP 位址
%B
伺服器處理請求的最後狀態、以及在伺服器的回應中所傳送的網頁內容的位元組數
%b
伺服器處理請求的最後狀態、以及在伺服器的回應中所傳送的網頁內容的位元組數
跟%B不同的是以CLF 格式顯示。例如用-來代替0
%{Foobar}C
傳送到伺服器的 Foobar cookie 的內容
%D
request 傳送到伺服器的時間 (microseconds)
%{FOOBAR}e
伺服器環境變數 FOOBAR 的內容
%f
檔名
%h
用戶端的主機名稱或IP位址
%H
request 的通訊協定
%{Foobar}i
The contents of
%{Referer}i
連結至所請求之文件的網頁的URL
%{User-agent}i
提出請求的瀏覽器或其他用戶端軟體的名稱與版本
%k
在一個 connection requests handled 中 keepalive 的數量
%l
用戶端上的使用者名稱(如RFC1413所定義，並且以IdentityCheck On指令啟用此功能)
%m
The request method.
%{Foobar}n
The contents of note Foobar from another module.
%{Foobar}o
The contents of Foobar: header line(s) in the reply.
%p
伺服器回應一個 request 的 canonical port number
%{format}p
The canonical port of the server serving the request or the server's actual port or the client's actual port.
Valid formats are canonical, local, or remote.
%P
回應 request 時的 PID
%{format}P
The process ID or thread id of the child that serviced the request. Valid formats are pid, tid, and hextid. hextid requires APR 1.2.0 or higher.
%q
The query string (prepended with a ? if a query string exists, otherwise an empty string).
%r
First line of request.
%s
狀態. 若是由內部轉址來的 request，則將顯示原始 request 的狀態
%t
伺服器收到 request 的時間 (standard english format)
%{format}t
同上，但以自訂的格式來顯示時間
%T
伺服器回應 request 的時間 (in seconds)
%u
驗證用戶端所用的使用者名稱(如果伺服器有啟用弱存取控制)
%U
The URL path requested (not including any query string)
%v
伺服器回應 request 時的 canonical ServerName
%V
The server name according to the UseCanonicalName setting.
%X
Connection status when response is completed :
X：connection aborted before the response completed.
+：connection may be kept alive after the response is sent.
-：connection will be closed after the response is sent.
This directive was %c in late versions of Apache 1.3, but this conflicted with the historical ssl %{var}c syntax.
%I
Bytes received, including request and headers, cannot be zero. You need to enable mod_logio to use this.
%O
Bytes sent, including headers, cannot be zero. You need to enable mod_logio to use this.
跟%B不同的是以CLF 格式顯示。例如用-來代替0
Foobar: header line(s) in the request sent to the server. Changes made by other modules (e.g.mod_headers) affect thisValid formats are canonical, local, or remote.
X：connection aborted before the response completed.
+：connection may be kept alive after the response is sent.
-：connection will be closed after the response is sent.
This directive was %c in late versions of Apache 1.3, but this conflicted with the historical ssl %{var}c syntax.
- Jun 07 Tue 2011 15:43
-
MySQL rollup 與order by 混用
SELECT * FROM (SELECT country, sum(id) as cnt FROM mygroup GROUP BY country WITH rollup) t ORDER BY cnt;
參考網址: https://www.sqlusa.com/bestpractices2005/subtotaltotalgrandtotal/
參考網址: https://www.sqlusa.com/bestpractices2005/subtotaltotalgrandtotal/
- Apr 14 Thu 2011 15:58
-
PDO、PHP Mysql等LIB函式比較表
https://www.greaterscope.net/documentation/php_database_abstraction_class_comparison.html
節錄如下
Comparison of PHP Database Abstraction Classes
節錄如下
Comparison of PHP Database Abstraction Classes
- Apr 14 Thu 2011 15:15
-
PHPExcel 讀取時間格式的欄位
function Read_Excel_File2($file_name,&$result){
require_once 'include/PHPExcel/Classes/PHPExcel/IOFactory.php';
$result=null;
$objReader = PHPExcel_IOFactory::createReader('Excel5');
// $objReader->setReadDataOnly(true);
try{
$objPHPExcel = $objReader->load($file_name);
}catch(Exception $e){}
if(!isset($objPHPExcel)) return "无法解析文件";
$allobjWorksheets = $objPHPExcel->getAllSheets();
foreach($allobjWorksheets as $objWorksheet){
$sheetname=$objWorksheet->getTitle();
$highestRow = $objWorksheet->getHighestRow(); // e.g. 10
$highestColumn = $objWorksheet->getHighestColumn();
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
for ($row = 1; $row <= $highestRow; ++$row) {
for ($col = 0; $col <= $highestColumnIndex; ++$col) {
$cell =$objWorksheet->getCellByColumnAndRow($col, $row);
$value=$cell->getValue();
if($cell->getDataType()==PHPExcel_Cell_DataType::TYPE_NUMERIC){
$cellstyleformat=$cell->getParent()->getStyle( $cell->getCoordinate() )->getNumberFormat();
$formatcode=$cellstyleformat->getFormatCode();
if (preg_match('/^(\[\$[A-Z]*-[0-9A-F]*\])*[hmsdy]/i', $formatcode)) {
$value=gmdate("Y-m-d", PHPExcel_Shared_Date::ExcelToPHP($value));
}else{
$value=PHPExcel_Style_NumberFormat::toFormattedString($value,$formatcode);
}
// echo $value,$formatcode,'<br>';
}
$result[$sheetname][$row-1][$col]=$value;
}
}
}
return 0;
}
- Apr 08 Fri 2011 09:23
-
PHPEXCEL記憶體使用量過大
今天在使用PHPExcel撰寫匯出EXCEL表格的功能時，之前一向用的好好的，但這次卻莫名其妙停住了。
看了一下Apache error log 顯示PHP Fatal error: Allowed memory size of 67108864 bytes exhausted
暫時將記憶體使用限制調整為 1024M也不行
ini_set( 'memory_limit', '1024M' );
看了一下Apache error log 顯示PHP Fatal error: Allowed memory size of 67108864 bytes exhausted
暫時將記憶體使用限制調整為 1024M也不行
ini_set( 'memory_limit', '1024M' );
1
