$array1 = array('a','b','c','a'); $array2 = array('c','A','d','c'); // 相交(比對) Array ( [0] => c [3] => c ) $r1 = array_intersect($array2,$array1); // 結合 (第一個變數為key 第二個為value) Array ( [a] => c [b] => A [c] => d ) $r2 = array_combine($array1,$array2); // 出現次數 Array ( [a] => 2 [b] => 1 [c] => 1 ) $r3 = array_count_values($array1); // 不同 Array ( [0] => a [1] => b [3] => a ) $r4 = array_diff($array1,$array2); // 不同連key都要相同 Array ( [0] => a [1] => b [2] => c [3] => a ) $r5 = array_diff_assoc($array1,$array2); // 是否有 1 的 key 值 $r6 = array_key_exists('1',$array1); // 列出所有的key Array ( [0] => 0 [1] => 1 [2] => 2 [3] => 3 ) $r7 = array_keys($array2); // 結合陣列有相同的key會結合 $r8 = array_merge_recursive($array1,$array2); // 亂數抓key $r9 = array_rand($array1); // 將值加入陣列 $r10 = array_push($array1,'d'); // 將value傳入function func($a,$b) 可傳多的值 $r11 = array_map("func",$array1,$array2); // 將key及value傳入function func($value,$key) 一個變數為key $r12 = array_walk($array1,"func"); // 目前第一個值 $r13 = current($array1); // 指到下一個值 $r14 = next($array1); // 洗牌 $r15 = shuffle($array1);
2015年1月15日 星期四
【PHP】較不常用的 array function
2015年1月8日 星期四
【Jquery】jQuery TWzipcode 地址縣市選擇
twzipcode 地址選擇縣市郵遞區號工具
方便的工具,不用自己寫ajax 官網
$(function(){ $('#addr').twzipcode({ // ID 名稱 countySel: '桃園市', // 城市預設值 districtSel: '平鎮區', // 地區預設值 zipcodeSel:'324', // 郵遞區號預設值 readonly:true, // 郵遞區號唯獨 css: ['county', 'district', 'zip'], // 個別的CSS 要另外自己寫 countyName: 'bill_county', // 城市欄位名稱 districtName: 'bill_district', // 地區欄位名稱 zipcodeName: 'bill_zip' // 郵遞區號欄位名稱 }); });
2014年12月18日 星期四
【PHP】PHP寄信 PHPMailer
1.一般寄信
※ $header 詳細說明: 連結
ini_set('SMTP','mail.threewell.com.tw'); $to ="wsxrtgvbuikm@gmail.com"; // 收件者 $subject = "發送測試"; //信件標題 $msg = '<!doctype html><html><head><meta charset="utf-8"></head><body><div style="background-color:#F00;color:#000" align="center">wsxrtgvbuikm@gmail.com</div></body></html>'; // 信件內容 $name = '賴俊銘'; // 寄件人 $sendMail = 'steven@threewell.com.tw'; // 寄件人信箱 要 smtp 允許的信箱 $headers = "From: ".$name ."<".$sendMail.">". "\r\n"; // 寄件人資料 $headers .= "Content-Type: text/html; charset=utf-8; format=flowed". "\r\n"; // 編碼方式 有用到html要用text/html $headers .= "MIME-Version: 1.0". "\r\n"; // MIME版本 $headers .= "Content-Transfer-Encoding: 8bit". "\r\n"; // 8位元ASCII碼。 $headers .= "X-Mailer: PHP". "\r\n"; // 哪邊發送的 if(mail($to, $subject, $msg, $headers)): echo '發送成功'; else: echo '發送失敗'; endif;
2.PHPMailer-master 使用套件
ini_set('SMTP','mail.threewell.com.tw'); require 'PHPMailer-master/PHPMailerAutoload.php'; $mail = new PHPMailer; $mail->setLanguage('zh'); // 設定語系 沒用的語言可刪掉 $mail->CharSet = 'UTF-8'; // 編碼 $mail->setFrom('steven@threewell.com.tw', '賴俊銘'); // 寄件人信箱及寄件人 $mail->addAddress('wsxrtgvbuikm@gmail.com', 'wsxrtgvbuikm'); // 收件人信箱及收件人 $mail->Subject = '信件標題'; // 標題 $mail->msgHTML('<a href="#">wsxrtgvbuikm</a>中文中文'); // 內容 $mail->addAttachment('HDT8GN.jpg'); // 附件 可多個 $mail->addAttachment('HDT8GN2.jpg'); if (!$mail->send()) { echo "寄信錯誤: " . $mail->ErrorInfo; } else { echo "寄信成功"; }
2014年12月10日 星期三
【PHP】串接 Yahoo 商城 API
1.API 文件
2.準備
首先要向 yahoo 提出申請 API,申請成功後會拿到 API Key 和 Secret,
API Key 就像帳號一樣,Shared Secret 是將資料編碼。
API Key 就像帳號一樣,Shared Secret 是將資料編碼。
3.製作簽章及使用API
製作簽章的方法在 Yahoo API 文件就有說明,
直接來實作抓取 Yahoo 商城分類,
在文件中找到 API > Product API > /v1/MallCategory/Get
固定的網址是 http://tw.ews.mall.yahooapis.com/stauth (後面加上功能名稱)
直接來實作抓取 Yahoo 商城分類,
在文件中找到 API > Product API > /v1/MallCategory/Get
固定的網址是 http://tw.ews.mall.yahooapis.com/stauth (後面加上功能名稱)
YahooAPI class
/* * @author wsxrtgvbuikm@gmail.com * 首先要先 define 以下幾個變數: * 1.YAHOO_API_KEY : YAHOO申請的KEY * 2.YAHOO_API_SECRET : YAHOO申請的SECRET * 3.YAHOO_API_ID : YAHOO的帳號 (測試過其實亂打都過) * 4.YAHOO_API_NAME : YAHOO的名稱 (通常是中文) * 5.YAHOO_API_URL : http://tw.ews.mall.yahooapis.com/stauth */ header("Content-Type: text/html; charset=utf-8"); define('YAHOO_API_KEY','輸入API KEY'); define('YAHOO_API_SECRET','輸入API_SECRET'); define('YAHOO_API_ID','輸入ID'); define('YAHOO_API_NAME','輸入名稱'); define('YAHOO_API_URL','http://tw.ews.mall.yahooapis.com/stauth'); class YahooAPI { public function yahoo_api($url,$arr=array(),$other_val=array()){ $url = YAHOO_API_URL.$url; $auth_arr = array('ApiKey'=>YAHOO_API_KEY, 'TimeStamp'=>time(), 'Id'=>YAHOO_API_ID, 'Name'=>YAHOO_API_NAME, 'Format'=>'json' ); $request_arr = array_merge($auth_arr,$arr); // 會有編碼的問題所以用foreach //$request = urldecode(http_build_query($request_arr)); $request = ''; foreach($request_arr as $key=>$val){ $request .= $key.'='.$val.'&'; } $request = substr($request,0,-1); // $request用SECRET sha1加密 $signature = hash_hmac('sha1',$request,YAHOO_API_SECRET); $request_arr['Signature'] = $signature; // 加入其他參數像是上傳圖片就不包含在加密範圍 $request_arr = array_merge($request_arr,$other_val); $this->request = $request_arr; $r = $this->curl_file_get_contents($url,$request_arr); $arr = json_decode($r,true); return $arr; } public function curl_file_get_contents($url,$request){ $ch = curl_init(); $timeout = 5; $cookie = "cookieLangId=zh_tw;"; curl_setopt ($ch, CURLOPT_COOKIE, $cookie); curl_setopt($ch, CURLOPT_ENCODING, "UTF-8"); curl_setopt ($ch, CURLOPT_URL, $url); curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt ($ch, CURLOPT_CONNECTTIMEOUT, $timeout); curl_setopt ($ch, CURLOPT_POST, true); // 啟用POST curl_setopt ($ch, CURLOPT_POSTFIELDS, $request); curl_setopt ($ch, CURLOPT_FOLLOWLOCATION, true); $r = curl_exec($ch); curl_close($ch); return $r; } }
取得分類
include("YahooAPI.php"); $Yahoo = new YahooAPI(); // 取得 YAHOO 商城分類 $url = '/v1/MallCategory/Get'; $arr = array('CategoryId'=>$CategoryId); $r = $Yahoo->yahoo_api($url,$arr); print_r($r);
上傳商品範例
在文件上有標記(Require)一定要填,
有些是要用API先去查代碼,其他(Optional)沒有傳值就不要出現不然會失敗..
有些是要用API先去查代碼,其他(Optional)沒有傳值就不要出現不然會失敗..
$url = '/v2/Product/SubmitMain'; $arr = array('SaleType'=>'Normal', // 商品銷售方式 'SaleTypeInfo'=>'Normal', // 商品銷售資訊 'ProductName'=>$rs['NAME'], // 商品名稱 'MallCategoryId'=>$rs['YAHOO_CAT'], // 商城商品分類代號 'StoreCategoryId'=>$rs['YAHOO_STORE_CAT'], // 商品歸類 'MarketPrice'=>$rs['MARKET_PRICE'], // 商品市價 'SalePrice'=>$rs['PRICE'], // 網路價 'CostPrice'=>$rs['COST'], // 成本價 'MaxBuyNum'=>$rs['LIMIT_NUM'], // 最高購買數量 'ShortDescription'=>$rs['DESC'], // 商品簡述 'LongDescription'=>$rs['CONTENT'], // 商品介紹 'PayTypeId'=>'1', // 付款方式代號 'PayTypeId'=>'2', // 付款方式代號 'PayTypeId'=>'4', // 付款方式代號 'PayTypeId'=>'8', // 付款方式代號 'PayTypeId'=>'9', // 付款方式代號 'PayTypeId'=>'10', // 付款方式代號 'ShippingId'=>'1', // 物流方式代號 'ShippingId'=>'2', // 物流方式代號 'IsTaxFree'=>'0', // 此商品是否為免稅商品 'SpecTypeDimension'=>'0', // 商品規格 'CustomizedMainProductId'=>$rs['PRODUCT_ID'], // 商品主貨號 'Stock'=>$rs['STOCK'], // 商品庫存量 'SaftyStock'=>$rs['SAFYSTOCK'], // 商品庫存最低警告量 ); $return = $Yahoo->yahoo_api($url,$arr);
上傳圖片
$url = '/v1/Product/UploadImage'; $arr = array('ProductId'=>$productId, // 商品ID 'MainImage'=>'ImageFile1', // 第一張圖 可一次傳多張 'Purge'=>'true' // 是否保留原圖 ); // 商品圖系統路徑 - 因為這個不加入簽章所以要另外放 // 前面加上@ CURL 就會當成檔案上傳 $request_arr['ImageFile1'] = '@'.HTTP_REAL_PATH.$rs['IMAGE']; $return = $this->yahoo_api($url,$arr,$request_arr);
2014年11月11日 星期二
【PHP】phpExcel範例
require_once("PHPExcel.php"); $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setTitle(" List"); $objPHPExcel->getProperties()->setCategory(" List"); $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getActiveSheet()->setCellValue('A1', '商品編號');
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(13); $objPHPExcel->getActiveSheet()->setCellValue('B1', '商品名稱'); $objPHPExcel->getActiveSheet()->setCellValue('C1', '醒目標題'); $objPHPExcel->getActiveSheet()->setCellValue('D1', '頁面標題'); $objPHPExcel->getActiveSheet()->setCellValue('E1', '頁面關鍵字'); $objPHPExcel->getActiveSheet()->setCellValue('F1', '頁面描述'); $objPHPExcel->getActiveSheet()->setCellValue('G1', '中類屬性'); $objPHPExcel->getActiveSheet()->setCellValue('H1', '小類屬性'); $objPHPExcel->getActiveSheet()->setCellValue('I1', '市價'); $objPHPExcel->getActiveSheet()->setCellValue('J1', '售價'); $objPHPExcel->getActiveSheet()->setCellValue('K1', '成本'); $objPHPExcel->getActiveSheet()->setCellValue('L1', '庫存數'); $objPHPExcel->getActiveSheet()->setCellValue('M1', '安全庫存數'); $objPHPExcel->getActiveSheet()->setCellValue('N1', '上架日'); $objPHPExcel->getActiveSheet()->setCellValue('O1', '下架日'); $objPHPExcel->getActiveSheet()->setCellValue('P1', '商品介紹'); $objPHPExcel->getActiveSheet()->setCellValue('Q1', '功能一標題'); $objPHPExcel->getActiveSheet()->setCellValue('R1', '功能一內容'); $objPHPExcel->getActiveSheet()->setCellValue('S1', '功能二標題'); $objPHPExcel->getActiveSheet()->setCellValue('T1', '功能二內容'); $objPHPExcel->getActiveSheet()->setCellValue('U1', '功能三標題'); $objPHPExcel->getActiveSheet()->setCellValue('V1', '功能三內容'); $objPHPExcel->getActiveSheet()->setCellValue('W1', '功能四標題'); $objPHPExcel->getActiveSheet()->setCellValue('X1', '功能四內容'); $objPHPExcel->getActiveSheet()->setCellValue('Y1', '功能五標題'); $objPHPExcel->getActiveSheet()->setCellValue('Z1', '功能五內容'); $objPHPExcel->getActiveSheet()->setCellValue('AA1', '功能六標題'); $objPHPExcel->getActiveSheet()->setCellValue('AB1', '功能六內容'); $objPHPExcel->getActiveSheet()->setCellValue('AC1', '功能七標題'); $objPHPExcel->getActiveSheet()->setCellValue('AD1', '功能七內容'); $objPHPExcel->getActiveSheet()->setCellValue('AE1', '功能八標題'); $objPHPExcel->getActiveSheet()->setCellValue('AF1', '功能八內容'); $objPHPExcel->getActiveSheet()->setCellValue('AG1', '商品圖片'); $i = 1; foreach($datas['data'] as $rs) { $i++; $objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $a); $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $b); $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $c); $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $d); $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $e); $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $f); $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, $g); $objPHPExcel->getActiveSheet()->setCellValue('H'.$i, $h); $objPHPExcel->getActiveSheet()->setCellValue('I'.$i, $i); $objPHPExcel->getActiveSheet()->setCellValue('J'.$i, $j); $objPHPExcel->getActiveSheet()->setCellValue('K'.$i, $k); $objPHPExcel->getActiveSheet()->setCellValue('L'.$i, $l); $objPHPExcel->getActiveSheet()->setCellValue('M'.$i, $m); $objPHPExcel->getActiveSheet()->setCellValue('N'.$i, $n); $objPHPExcel->getActiveSheet()->setCellValue('O'.$i, $o; $objPHPExcel->getActiveSheet()->setCellValue('P'.$i, $p); $objPHPExcel->getActiveSheet()->setCellValue('Q'.$i, $q); $objPHPExcel->getActiveSheet()->setCellValue('R'.$i, $r); $objPHPExcel->getActiveSheet()->setCellValue('S'.$i, $s); $objPHPExcel->getActiveSheet()->setCellValue('T'.$i, $t); $objPHPExcel->getActiveSheet()->setCellValue('U'.$i, $u); $objPHPExcel->getActiveSheet()->setCellValue('V'.$i, $v); $objPHPExcel->getActiveSheet()->setCellValue('W'.$i, $w); $objPHPExcel->getActiveSheet()->setCellValue('X'.$i, $x); $objPHPExcel->getActiveSheet()->setCellValue('Y'.$i, $y); $objPHPExcel->getActiveSheet()->setCellValue('Z'.$i, $z); $objPHPExcel->getActiveSheet()->setCellValue('AA'.$i, $aa); $objPHPExcel->getActiveSheet()->setCellValue('AB'.$i, $ab); $objPHPExcel->getActiveSheet()->setCellValue('AC'.$i, $ac); $objPHPExcel->getActiveSheet()->setCellValue('AD'.$i, $ad); $objPHPExcel->getActiveSheet()->setCellValue('AE'.$i, $ae); $objPHPExcel->getActiveSheet()->setCellValue('AF'.$i, $af); $objPHPExcel->getActiveSheet()->setCellValue('AG'.$i, $ag); } // OUTPUT header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="output'.date("YmdHis").'.xls"'); header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output');
實用筆記整理
error_reporting(E_ALL);
date_default_timezone_set(‘Asia/Taipei’);
/** PHPExcel */
require_once ‘Classes/PHPExcel.php';
date_default_timezone_set(‘Asia/Taipei’);
/** PHPExcel */
require_once ‘Classes/PHPExcel.php';
// 新增Excel物件
$objPHPExcel = new PHPExcel();
$objPHPExcel = new PHPExcel();
// 設定屬性
$objPHPExcel->getProperties()->setCreator(“PHP")
->setLastModifiedBy(“PHP")
->setTitle(“Title")
->setSubject(“Subject")
->setDescription(“Description")
->setKeywords(“Keywords")
->setCategory(“Category");
$objPHPExcel->getProperties()->setCreator(“PHP")
->setLastModifiedBy(“PHP")
->setTitle(“Title")
->setSubject(“Subject")
->setDescription(“Description")
->setKeywords(“Keywords")
->setCategory(“Category");
//設定操作中的工作表
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->setActiveSheetIndex(0);
//將工作表命名
$objPHPExcel->getActiveSheet(0)->setTitle(‘第一張表’);
$objPHPExcel->getActiveSheet(0)->setTitle(‘第一張表’);
//合併儲存格
$objPHPExcel->getActiveSheet(0)->mergeCells(‘A1:D2′);
$objPHPExcel->getActiveSheet(0)->mergeCells(‘A1:D2′);
//儲存格內容
$objPHPExcel->getActiveSheet(0)->setCellValue(‘A1′,’PHPEXCEL TEST’); //合併後的儲存格,設定時指定左上角那個。
$objPHPExcel->getActiveSheet(0)->setCellValue(‘A3′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘B3′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘C3′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘D3′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘A4′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘B4′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘C4′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘D4′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘A1′,’PHPEXCEL TEST’); //合併後的儲存格,設定時指定左上角那個。
$objPHPExcel->getActiveSheet(0)->setCellValue(‘A3′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘B3′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘C3′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘D3′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘A4′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘B4′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘C4′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘D4′,’test’);
//設定背景顏色單色
$objPHPExcel->getActiveSheet(0)->getStyle(‘A3:D3′)->applyFromArray(
array(‘fill’ => array(
‘type’ => PHPExcel_Style_Fill::FILL_SOLID,
‘color’ => array(‘argb’ => ‘D1EEEE’)
),
)
);
//設定漸層背景顏色雙色(灰/白) 經測試,Excel2007才有漸層
$objPHPExcel->getActiveSheet(0)->getStyle(‘A1:D2′)->applyFromArray(
array(
‘font’ => array(‘bold’ => true,
‘size’ => ’24’),
‘alignment’ => array(‘horizontal’ => PHPExcel_Style_Alignment::HORIZONTAL_CENTER),
‘borders’ => array(‘top’ => array(‘style’ => PHPExcel_Style_Border::BORDER_THIN)),
‘fill’ => array(‘type’ => PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR,
‘rotation’ => 90,
‘startcolor’ => array(‘rgb’ => ‘DCDCDC’),
‘endcolor’ => array(‘rgb’ => ‘FFFFFF’))
));
$objPHPExcel->getActiveSheet(0)->getStyle(‘A3:D3′)->applyFromArray(
array(‘fill’ => array(
‘type’ => PHPExcel_Style_Fill::FILL_SOLID,
‘color’ => array(‘argb’ => ‘D1EEEE’)
),
)
);
//設定漸層背景顏色雙色(灰/白) 經測試,Excel2007才有漸層
$objPHPExcel->getActiveSheet(0)->getStyle(‘A1:D2′)->applyFromArray(
array(
‘font’ => array(‘bold’ => true,
‘size’ => ’24’),
‘alignment’ => array(‘horizontal’ => PHPExcel_Style_Alignment::HORIZONTAL_CENTER),
‘borders’ => array(‘top’ => array(‘style’ => PHPExcel_Style_Border::BORDER_THIN)),
‘fill’ => array(‘type’ => PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR,
‘rotation’ => 90,
‘startcolor’ => array(‘rgb’ => ‘DCDCDC’),
‘endcolor’ => array(‘rgb’ => ‘FFFFFF’))
));
//框線 方法一:使用 setBorderStyle() 函數
$objPHPExcel->getActiveSheet(0)->getStyle(‘A5′)->getBorders()->getTop() ->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet(0)->getStyle(‘B5′)->getBorders()->getBottom() ->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet(0)->getStyle(‘C5′)->getBorders()->getleft() ->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet(0)->getStyle(‘D5′)->getBorders()->getright() ->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet(0)->getStyle(‘A7:C10′)->getBorders()->getAllborders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet(0)->getStyle(‘A5′)->getBorders()->getTop() ->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet(0)->getStyle(‘B5′)->getBorders()->getBottom() ->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet(0)->getStyle(‘C5′)->getBorders()->getleft() ->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet(0)->getStyle(‘D5′)->getBorders()->getright() ->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet(0)->getStyle(‘A7:C10′)->getBorders()->getAllborders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//框線 方法二:使用applyFromArray()函數
$styleArray = array(
‘borders’ => array(
‘allborders’ => array(
‘style’ => PHPExcel_Style_Border::BORDER_THIN,
‘color’ => array(‘argb’ => ‘000000’),
),
),
);
$objPHPExcel->getActiveSheet(0)->getStyle(‘A12:C15′)->applyFromArray($styleArray);
$styleArray = array(
‘borders’ => array(
‘allborders’ => array(
‘style’ => PHPExcel_Style_Border::BORDER_THIN,
‘color’ => array(‘argb’ => ‘000000’),
),
),
);
$objPHPExcel->getActiveSheet(0)->getStyle(‘A12:C15′)->applyFromArray($styleArray);
//框線 方法三:使用物件 + applyFromArray()函數
$style_obj = new PHPExcel_Style();
$style_array = array( ‘borders’ => array(‘allborders’=> array(‘style’ => PHPExcel_Style_Border::BORDER_THIN)),
‘alignment’ => array(‘wrap’=> true,
‘horizontal’ => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
‘vertical’ => PHPExcel_Style_Alignment::VERTICAL_CENTER
),
‘font’ => array(‘size’ => ‘8’)
);
$style_obj->applyFromArray($style_array);
$objPHPExcel->getActiveSheet(0)->setSharedStyle($style_obj, ‘E7:G10′);
$style_obj = new PHPExcel_Style();
$style_array = array( ‘borders’ => array(‘allborders’=> array(‘style’ => PHPExcel_Style_Border::BORDER_THIN)),
‘alignment’ => array(‘wrap’=> true,
‘horizontal’ => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
‘vertical’ => PHPExcel_Style_Alignment::VERTICAL_CENTER
),
‘font’ => array(‘size’ => ‘8’)
);
$style_obj->applyFromArray($style_array);
$objPHPExcel->getActiveSheet(0)->setSharedStyle($style_obj, ‘E7:G10′);
//斜線 方法一
$styleArray = array(‘borders’ => array(‘diagonal’ => array(‘style’ => PHPExcel_Style_Border::BORDER_THICK,
‘color’ => array(‘argb’ => ‘FFFF0000′),
),
‘diagonaldirection’ => PHPExcel_Style_Borders::DIAGONAL_UP
//’diagonaldirection’ => PHPExcel_Style_Borders::DIAGONAL_DOWN
//’diagonaldirection’ => PHPExcel_Style_Borders::DIAGONAL_BOTH
),
);
$objPHPExcel->getActiveSheet()->getStyle(“E1″)->applyFromArray($styleArray);
$styleArray = array(‘borders’ => array(‘diagonal’ => array(‘style’ => PHPExcel_Style_Border::BORDER_THICK,
‘color’ => array(‘argb’ => ‘FFFF0000′),
),
‘diagonaldirection’ => PHPExcel_Style_Borders::DIAGONAL_UP
//’diagonaldirection’ => PHPExcel_Style_Borders::DIAGONAL_DOWN
//’diagonaldirection’ => PHPExcel_Style_Borders::DIAGONAL_BOTH
),
);
$objPHPExcel->getActiveSheet()->getStyle(“E1″)->applyFromArray($styleArray);
//斜線 方法二
$objPHPExcel->getActiveSheet()->getStyle(‘F1′)->getBorders()->getDiagonal()->applyFromArray(array(
‘style’ => PHPExcel_Style_Border::BORDER_THIN,
‘color’ => array(‘argb’ => ‘FFFF0000′)
)
);
$objPHPExcel->getActiveSheet()->getStyle(‘F1′)->getBorders()->setDiagonalDirection(PHPExcel_Style_Borders::DIAGONAL_DOWN);
/*
註:
PHPExcel_Style_Borders::DIAGONAL_UP
PHPExcel_Style_Borders::DIAGONAL_DOWN
PHPExcel_Style_Borders::DIAGONAL_BOTH
*/
$objPHPExcel->getActiveSheet()->getStyle(‘F1′)->getBorders()->getDiagonal()->applyFromArray(array(
‘style’ => PHPExcel_Style_Border::BORDER_THIN,
‘color’ => array(‘argb’ => ‘FFFF0000′)
)
);
$objPHPExcel->getActiveSheet()->getStyle(‘F1′)->getBorders()->setDiagonalDirection(PHPExcel_Style_Borders::DIAGONAL_DOWN);
/*
註:
PHPExcel_Style_Borders::DIAGONAL_UP
PHPExcel_Style_Borders::DIAGONAL_DOWN
PHPExcel_Style_Borders::DIAGONAL_BOTH
*/
//設定一個範圍後套用相同格式
$objPHPExcel->getActiveSheet(0)->mergeCells(‘E12:F13′);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘E12′,"Hello \n World");
$style_obj = new PHPExcel_Style();
$style_array = array( ‘borders’ => array(‘allborders’=> array(‘style’ => PHPExcel_Style_Border::BORDER_THIN)),
‘alignment’ => array(‘wrap’=> true,
‘horizontal’ => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
‘vertical’ => PHPExcel_Style_Alignment::VERTICAL_CENTER
),
‘font’ => array(‘size’ => ‘8’)
);
$style_obj->applyFromArray($style_array);
$objPHPExcel->getActiveSheet(0)->setSharedStyle($style_obj, “E12:G14″);
$objPHPExcel->getActiveSheet(0)->mergeCells(‘E12:F13′);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘E12′,"Hello \n World");
$style_obj = new PHPExcel_Style();
$style_array = array( ‘borders’ => array(‘allborders’=> array(‘style’ => PHPExcel_Style_Border::BORDER_THIN)),
‘alignment’ => array(‘wrap’=> true,
‘horizontal’ => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
‘vertical’ => PHPExcel_Style_Alignment::VERTICAL_CENTER
),
‘font’ => array(‘size’ => ‘8’)
);
$style_obj->applyFromArray($style_array);
$objPHPExcel->getActiveSheet(0)->setSharedStyle($style_obj, “E12:G14″);
//設定字型(粗細、顏色) 也可參照上面的方法,用陣列的方式設定。
$objPHPExcel->getActiveSheet(0)->getStyle(‘B4′)->getFont()->setName(‘Candara’);
$objPHPExcel->getActiveSheet(0)->getStyle(‘B4′)->getFont()->setSize(16);
$objPHPExcel->getActiveSheet(0)->getStyle(‘B4′)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet(0)->getStyle(‘B4′)->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
$objPHPExcel->getActiveSheet(0)->getStyle(‘B4′)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLUE); //藍色
$objPHPExcel->getActiveSheet(0)->getStyle(‘C4′)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_RED); //紅色
$objPHPExcel->getActiveSheet(0)->getStyle(‘C4′)->getFont()->getColor()->setARGB(‘FF0000′); //紅色
$objPHPExcel->getActiveSheet(0)->getStyle(‘B4′)->getFont()->setName(‘Candara’);
$objPHPExcel->getActiveSheet(0)->getStyle(‘B4′)->getFont()->setSize(16);
$objPHPExcel->getActiveSheet(0)->getStyle(‘B4′)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet(0)->getStyle(‘B4′)->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
$objPHPExcel->getActiveSheet(0)->getStyle(‘B4′)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLUE); //藍色
$objPHPExcel->getActiveSheet(0)->getStyle(‘C4′)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_RED); //紅色
$objPHPExcel->getActiveSheet(0)->getStyle(‘C4′)->getFont()->getColor()->setARGB(‘FF0000′); //紅色
$objPHPExcel->getActiveSheet(0)->setCellValue(‘G2′, ‘2008-12-31′);
$objPHPExcel->getActiveSheet(0)->getStyle(‘G2′)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDDSLASH);
$objPHPExcel->getActiveSheet(0)->getStyle(‘G2′)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDDSLASH);
/*
註:這裡有列出可用英文單字表示的顏色,並不多。
註:這裡有列出可用英文單字表示的顏色,並不多。
COLOR_BLACK
COLOR_BLUE
COLOR_DARKBLUE
COLOR_DARKGREEN
COLOR_DARKRED
COLOR_DARKYELLOW
COLOR_GREEN
COLOR_RED
COLOR_WHITE
COLOR_YELLOW
COLOR_BLUE
COLOR_DARKBLUE
COLOR_DARKGREEN
COLOR_DARKRED
COLOR_DARKYELLOW
COLOR_GREEN
COLOR_RED
COLOR_WHITE
COLOR_YELLOW
*/
//使用函數
$objPHPExcel->getActiveSheet(0)->setCellValue(‘A5′,’3′);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘B5′,’4′);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘C5′, ‘=SUM(A5:B5)’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘A5′,’3′);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘B5′,’4′);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘C5′, ‘=SUM(A5:B5)’);
//設定A3內容為00123,並指定為文字型態。這樣在顯示的時候不會自動把0去掉。$objPHPExcel->getActiveSheet(0)->getCell(“A4″)->setValueExplicit(‘00123′, PHPExcel_Cell_DataType::TYPE_STRING);
//分離儲存格
//$objActSheet->unmergeCells(‘B1:C22′);
//$objActSheet->unmergeCells(‘B1:C22′);
//設定欄寬
$objPHPExcel->getActiveSheet(0)->getColumnDimension(‘A’)->setWidth(20);
$objPHPExcel->getActiveSheet(0)->getColumnDimension(‘A’)->setWidth(20);
//設定欄寬(自動欄寬)
//$objPHPExcel->getActiveSheet(0)->getColumnDimension(“A")->setAutoSize(true);
//$objPHPExcel->getActiveSheet(0)->getColumnDimension(“A")->setAutoSize(true);
//設定高度
$objPHPExcel->getActiveSheet(0)->getRowDimension(‘1′)->setRowHeight(150);
$objPHPExcel->getActiveSheet(0)->getRowDimension(‘1′)->setRowHeight(150);
//下底線
$objPHPExcel->getActiveSheet(0)->getStyle(“D3″)->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
$objPHPExcel->getActiveSheet(0)->getStyle(“D3″)->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
//旋轉文字
$objPHPExcel->getActiveSheet(0)->getStyle(‘A4′)->getAlignment()->setTextRotation(-90);
//對齊 //注意是 setVertiacl 還是 setHorizontal
$objPHPExcel->getActiveSheet(0)->getStyle(‘B4′)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet(0)->getStyle(‘C4′)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
/*
VERTICAL_CENTER 垂直置中
VERTICAL_TOP
HORIZONTAL_CENTER
HORIZONTAL_RIGHT
HORIZONTAL_LEFT
HORIZONTAL_JUSTIFY
*/
//add comment ———————————————–
$objPHPExcel->getActiveSheet()->getComment(‘A6′)->setAuthor(‘PHPExcel’);
$objPHPExcel->getActiveSheet()->getComment(‘A6′)->getText()->createTextRun(‘comment1 comment1 comment1 ‘);
$objPHPExcel->getActiveSheet()->getComment(‘A6′)->setWidth(‘200pt’);
$objPHPExcel->getActiveSheet()->getComment(‘A6′)->setHeight(‘100pt’);
$objPHPExcel->getActiveSheet()->getComment(‘A6′)->setMarginLeft(‘150pt’);
$objPHPExcel->getActiveSheet()->getComment(‘A6′)->getFillColor()->setRGB(‘dea66e’); //背景顏色
$objCommentRichText = $objPHPExcel->getActiveSheet()->getComment(‘A6′)->getText()->createTextRun(‘comment2 comment2 comment2 ‘);
$objCommentRichText->getFont()->setBold(true); //文字加粗
$objCommentRichText->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_RED); //文字顏色
$objPHPExcel->getActiveSheet(0)->getStyle(‘A4′)->getAlignment()->setTextRotation(-90);
//對齊 //注意是 setVertiacl 還是 setHorizontal
$objPHPExcel->getActiveSheet(0)->getStyle(‘B4′)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet(0)->getStyle(‘C4′)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
/*
VERTICAL_CENTER 垂直置中
VERTICAL_TOP
HORIZONTAL_CENTER
HORIZONTAL_RIGHT
HORIZONTAL_LEFT
HORIZONTAL_JUSTIFY
*/
//add comment ———————————————–
$objPHPExcel->getActiveSheet()->getComment(‘A6′)->setAuthor(‘PHPExcel’);
$objPHPExcel->getActiveSheet()->getComment(‘A6′)->getText()->createTextRun(‘comment1 comment1 comment1 ‘);
$objPHPExcel->getActiveSheet()->getComment(‘A6′)->setWidth(‘200pt’);
$objPHPExcel->getActiveSheet()->getComment(‘A6′)->setHeight(‘100pt’);
$objPHPExcel->getActiveSheet()->getComment(‘A6′)->setMarginLeft(‘150pt’);
$objPHPExcel->getActiveSheet()->getComment(‘A6′)->getFillColor()->setRGB(‘dea66e’); //背景顏色
$objCommentRichText = $objPHPExcel->getActiveSheet()->getComment(‘A6′)->getText()->createTextRun(‘comment2 comment2 comment2 ‘);
$objCommentRichText->getFont()->setBold(true); //文字加粗
$objCommentRichText->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_RED); //文字顏色
———————————————————————————–
———————————————————————————–
// 設定格式:使用物件的方式
$style_obj = new PHPExcel_Style();
$styleArray = array(‘borders’ => array(‘left’=> array(‘style’ => PHPExcel_Style_Border::BORDER_THICK),
‘top’=> array(‘style’ => PHPExcel_Style_Border::BORDER_THIN),
‘right’=> array(‘style’ => PHPExcel_Style_Border::BORDER_THIN),
‘bottom’=> array(‘style’ => PHPExcel_Style_Border::BORDER_THIN)
));
$style_obj->applyFromArray($styleArray);
———————————————————————————–
// 設定格式:使用物件的方式
$style_obj = new PHPExcel_Style();
$styleArray = array(‘borders’ => array(‘left’=> array(‘style’ => PHPExcel_Style_Border::BORDER_THICK),
‘top’=> array(‘style’ => PHPExcel_Style_Border::BORDER_THIN),
‘right’=> array(‘style’ => PHPExcel_Style_Border::BORDER_THIN),
‘bottom’=> array(‘style’ => PHPExcel_Style_Border::BORDER_THIN)
));
$style_obj->applyFromArray($styleArray);
$letter = PHPExcel_Cell::stringFromColumnIndex(0); //A
$cellname1 = $letter.’1′; // A1
$cellname2 = $letter.7; // A7
$cell_range = “$cellname1:$cellname2″;
$sheet->setSharedStyle($style_obj, “$cell_range");
$cellname1 = $letter.’1′; // A1
$cellname2 = $letter.7; // A7
$cell_range = “$cellname1:$cellname2″;
$sheet->setSharedStyle($style_obj, “$cell_range");
// 設定格式:使用陣列
$styleArray = array(
‘borders’ => array(
‘allborders’ => array(
‘style’ => PHPExcel_Style_Border::BORDER_THIN,
‘color’ => array(‘argb’ => ‘000000’)
),
),
‘font’ => array(‘bold’ => true,
‘size’ => ’12’,
‘color’ => array(‘argb’ => ‘FF0000′)
)
);
$objPHPExcel->getActiveSheet(0)->getStyle(‘A12:C15′)->applyFromArray($styleArray);
‘borders’ => array(
‘allborders’ => array(
‘style’ => PHPExcel_Style_Border::BORDER_THIN,
‘color’ => array(‘argb’ => ‘000000’)
),
),
‘font’ => array(‘bold’ => true,
‘size’ => ’12’,
‘color’ => array(‘argb’ => ‘FF0000′)
)
);
$objPHPExcel->getActiveSheet(0)->getStyle(‘A12:C15′)->applyFromArray($styleArray);
// 註解
$comment = “This is comment";
$sheet->getComment(“F1″)->getFillColor()->setRGB(‘FFFAD9′); //背景顏色
$sheet->getComment(“F1″)->setWidth(‘320pt’);
$objCommentRichText = $sheet->getComment(“F1″)->getText()->createTextRun(“$comment");
$objCommentRichText->getFont()->getColor()->setRGB(‘008080′); //文字顏色
$objCommentRichText->getFont()->setBold(true); //文字加粗
$sheet->getComment(“F1″)->getFillColor()->setRGB(‘FFFAD9′); //背景顏色
$sheet->getComment(“F1″)->setWidth(‘320pt’);
$objCommentRichText = $sheet->getComment(“F1″)->getText()->createTextRun(“$comment");
$objCommentRichText->getFont()->getColor()->setRGB(‘008080′); //文字顏色
$objCommentRichText->getFont()->setBold(true); //文字加粗
———————————————————————————–
// 設定其它工作表
// 設定其它工作表
$objPHPExcel->createSheet();
$objPHPExcel->setActiveSheetIndex(1);
$objPHPExcel->getActiveSheet()->setTitle(‘第二張表’);
$objPHPExcel->getActiveSheet()->setCellValue(‘A3′,"test1″);
$objPHPExcel->getActiveSheet()->setCellValue(‘B3′,’test2′);
$objPHPExcel->setActiveSheetIndex(1);
$objPHPExcel->getActiveSheet()->setTitle(‘第二張表’);
$objPHPExcel->getActiveSheet()->setCellValue(‘A3′,"test1″);
$objPHPExcel->getActiveSheet()->setCellValue(‘B3′,’test2′);
$objPHPExcel->setActiveSheetIndex(0);
//若要在 2003 跟 2007 之間切換,選然下面兩段其中一段即可。
//Excel 2007
header(‘Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet’);
header(‘Content-Disposition: attachment;filename="01simple.xlsx"‘);
header(‘Cache-Control: max-age=0′);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, ‘Excel2007′);
/*
//Excel 2003
header(‘Content-Type: application/vnd.ms-excel’);
header(‘Content-Disposition: attachment;filename="01simple.xls"‘);
header(‘Cache-Control: max-age=0′);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, ‘Excel5′); //Excel 2003 = Excel 5
*/
//若要在 2003 跟 2007 之間切換,選然下面兩段其中一段即可。
//Excel 2007
header(‘Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet’);
header(‘Content-Disposition: attachment;filename="01simple.xlsx"‘);
header(‘Cache-Control: max-age=0′);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, ‘Excel2007′);
/*
//Excel 2003
header(‘Content-Type: application/vnd.ms-excel’);
header(‘Content-Disposition: attachment;filename="01simple.xls"‘);
header(‘Cache-Control: max-age=0′);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, ‘Excel5′); //Excel 2003 = Excel 5
*/
//========================================================
$objWriter->save(‘php://output’);
exit;
$objWriter->save(‘php://output’);
exit;
2014年11月3日 星期一
【jquery】post 使用 json 傳值
post 使用 json 傳值
js
$.post("userorder_v2.php",{mod:'detail',orderid:$orderid},function ($data){ // 判斷CSS是否要隱藏 for($key in $data.data){ if (!$data.data[$key]){ $("#ar-"+$key).hide(); }else{ $("#ar-"+$key).show(); } $thisValue = $(".od-" + $key); // 加上另外的處理 if ($thisValue.hasClass("plus")){ // + $data.data[$key] = '+'+$data.data[$key]; }else if ($thisValue.hasClass("less")){ $data.data[$key] = '-'+$data.data[$key]; } // 將值放入對應的CSS中 $thisValue.html($data.data[$key]); } },"json");
HTML:
<table border="0" cellspacing="2" cellpadding="5" width="760"> <tr> <th colspan="4" align="center">訂單資料</th> </tr> <tbody> <tr> <td width="100" align="center">訂單編號</td> <td width="200" class="od-orderid"></td> <td width="100" align="center">付款方式</td> <td class="od-payWayName"></td> </tr> <tr> <td align="center">訂單金額</td> <td class="od-order_total"></td> <td align="center">取貨方式</td> <td class="od-get_goods_name"></td> </tr> <tr> <td align="center">訂單日期</td> <td class="od-order_time"></td> <td align="center"><span id="ar-identity">訂購身分</span></td> <td class="od-identity"></td> </tr> <tr> <td align="center">訂單狀態</td> <td colspan="3" class="od-shipName"></td> </tr> <tr> <td align="center">收貨地址</td> <td colspan="3" class="od-address"></td> </tr> <tr> <td align="center">gt;備註</td> <td colspan="3" class="od-comp_note"></td> </tr> </tbody> </table>
2014年10月8日 星期三
【CSS】顯示表格空白(empty-cells)、框線合併(border-collapse)
empty-cells
empty-cells:show -> 顯示空白表格
empty-cells:hide -> 不顯示空白表格 - 預設
empty-cells:inherit -> 繼承父屬性
1 | 2 |
3 |
border-collapse
border-collapse:collapse -> 框限線會合併
border-collapse:separate -> 框線分開
1 | 2 |
3 |
<style> #wsxrtgvbuikm14010082 .t1{ color:#1A6811; font-family: "微軟正黑體"; font-size:24px; padding: 0 10px; } #wsxrtgvbuikm14010082 .t2{ color:#1F1C97; font-family: "微軟正黑體"; font-size:16px; padding: 0 10px; margin-top:8px; margin-bottom:8px; } #wsxrtgvbuikm14010082 .t3{ color:#000; font-family: "微軟正黑體"; font-size:16px; padding: 0 5px; } #wsxrtgvbuikm14010082 .table-1 { width:300px; margin-left:10px; } #wsxrtgvbuikm14010082 .table-1 td{ border:1px solid #0088dd; padding:15px; empty-cells:hide; } #wsxrtgvbuikm14010082 .table-2 { width:300px; border-collapse:collapse; margin-left:10px; } #wsxrtgvbuikm14010082 .table-2 td{ border:1px solid #0088dd; padding:15px; empty-cells:hide; } </style> <div id="wsxrtgvbuikm14010082"> <div class="t1">empty-cells</div> <div class="t2">empty-cells:show -> 顯示空白表格</div> <div class="t2">empty-cells:hide -> 不顯示空白表格 - 預設</div> <div class="t2">empty-cells:inherit -> 繼承父屬性</div> <div> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="table-1"> <tr> <td>1</td> <td>2</td> </tr> <tr> <td>3</td> <td></td> </tr> </table> </div> <div class="t1" style="margin-top:30px;">border-collapse</div> <div class="t2">border-collapse:collapse -> 框限線會合併</div> <div class="t2">border-collapse:separate -> 框線分開</div> <div> <table width="100%" border="1" cellspacing="0" cellpadding="0" class="table-2"> <tr> <td>1</td> <td>2</td> </tr> <tr> <td>3</td> <td></td> </tr> </table> </div>
【CSS】list-style-position
項目符號的位置:list-style-position
list-style-position:outside -> 不縮排
list-style-position:inherit -> 如果有第二排會縮排 預設值
- SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC
- SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC
- SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC
// CSS .demo{ width:300px; margin:0px; padding-left:30px; list-style-position:inside; } .demo li{ margin-top:10px; list-style:circle; } ul.demo2{ /* 一定要用ul的樣子 */ width:300px; list-style-position:outside; margin:0px; padding-left:30px; padding-top:30px; } .demo2 li{ margin-top:10px; list-style:circle; } // HTML <div class="demo"> <li>SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC</li> <li>SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC</li> <li>SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC</li> </div> <ul class="demo2"> <li>SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC</li> <li>SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC</li> <li>SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC</li> </ul>
2014年9月17日 星期三
【SQL】if else
基本
PHP
if ($score >= 90) $str = 'A'; elseif ($score >= 70 && $score < 90) $str = 'B'; elseif ($score >= 60 && $score < 70) $str = 'C'; else{ $str = 'D'; }
SQL
CASE WHEN score >= 90 THEN 'A' WHEN score >= 90 THEN 'B' WHEN score >= 90 THEN 'C' ELSE 'D' END AS str
欄位值
Name | Answer |
---|---|
張一 | 1 |
王二 | 2 |
李三 | 3 |
SELECT Name, case Answer when 1 then '喜歡' when 2 then '不喜歡' when 3 then '一般' END FROM table; OR SELECT Name, case when Answer=1 then '喜歡' when Answer=2 then '不喜歡' when Answer=3 then '一般' END AS Answer FROM table;
2014年8月27日 星期三
【MySQL】LIKE 搜尋
一、一般
1.name LIKE '豬%' -> 找豬開頭的文字後面不論字數,例如:豬八戒、豬頭2.name LIKE '%豬%' -> 只有出現豬就算找到,如豬、神豬、豬頭
3.name LIKE '豬_' -> 限定字數只找豬開頭兩個字,底線在那邊就一定要有字
4.name LIKE '%豬%戒%' -> 只要字串包含順序有豬跟界就符合
二、應用搜尋
// 將字切開並加上% $arr = $this->utf8_str_split($keywords); $keywordSplit = implode('%',$arr); // 這樣比 '%$keywords%' 搜尋到更多結果 $sql = "SELECT * FROM user WHERE name LIKE '%$keywordSplit%'"; $rs = $pdo->query($sql); // 用UTF8切文字 function utf8_str_split($str, $split_len = 1){ if (!preg_match('/^[0-9]+$/', $split_len) || $split_len < 1) return FALSE; $len = mb_strlen($str, 'UTF-8'); if ($len <= $split_len) return array($str); preg_match_all('/.{'.$split_len.'}|[^\x00]{1,'.$split_len.'}$/us', $str, $ar); return $ar[0]; }
訂閱:
文章 (Atom)