Neil's Note

for file in *.gif; do mv "$file" "`basename $file .gif`.jpg" done

/////////////////程式將jpg丟給瀏覽器開始///////////////// $img_path = '/var/www/html/XXX//img/a.jpg'; //成功後吐出圖片回傳 $type = 'image/jpeg'; header('Content-Type:'.$type); header('Content-Length: ' . filesize($img_path)); readfile($img_path); /////////////////程式將jpg丟給瀏覽器結束///////////////// /////////////////程式將jpg丟給瀏覽器開始///////////////// /*load library*/ $this->load->library('image_lib'); $this->load->library('net_util'); //必須在linux上安裝gd2 $this->img['image_library'] = 'gd2'; $this->img['maintain_ratio'] = TRUE; //縮圖使用 private function img_resize($source,$target,$width,$height,$crop=true,$img_name,$new_foler){ list($w,$h)=getimagesize($source); if ($w/$width>$h/$height){ $this->img['width'] = $w*($height/$h); $this->img['height'] = $height; $this->img['x_axis'] = ($this->img['width']-$width)/2; $this->img['y_axis'] = 0; }else{ $this->im...

case when reference: http://jax-work-archive.blogspot.tw/2008/06/case-mysql-switch-if-else.html 必須在 SELECT,UPDATE,INSERT,DELETE 中 具有 switch 與 if else 兩種方式可用 #switch 的用法 SELECT CASE a WHEN 100 THEN a WHEN 50 THEN '0' ELSE '3' END FROM table; #if else 的用法 SELECT CASE WHEN a>100 THEN a WHEN a>50 THEN '0' ELSE '3' END FROM table; IFNULL reference: http://www.barryblogs.com/mysql-ifnull-if/ SELECT IFNULL(0, 1) ->0!=null,所以回傳0 SELECT IFNULL(1, 10) => 1!=null,所以回傳1 SELECT IFNULL(NULL, 'YES') =>若第一個參數為null時,回傳第二個參數,回傳YES