商品列表-搜索-排序-翻

1、商品管理商品列表（搜索、排序、翻頁）1.商品控制器中的LST方法:/列表publi亡 function 1?t()$H0del = D (TGoods')>/獲取帯翻頁的數(shù)據(jù)- SmDdel->sear匚h門；$this->a5signarray(data1 =>Tdata，十r page1 => $data f TpageTt )；$ thig-xdisplay()2.在模型中添加search方法（取數(shù)據(jù)、翻頁、排序、搜索）public func七ion search()Sphere = array （） ;/默認(rèn)情況下的扌叟索條件為仝/商品窖稱的挫索$

2、goodsName = I(T get.goods name T);if($go odsNams)$wrherb T goods name' = array ( T like T，- rr% SgoodsNamerr)；/價(jià)格的搜素 - $ 呂七artPric e = T ( r ge七.呂t，);$ endFrice = I (T g e七* mndjiirice *);if ($startPrice & &. $ endPrice)$whe r ef p r£c e T= arrayb etween* f array($3七注工七Price, $ endP

3、 rice);elseif ($ s七ar七Price)$wheeeT price T = array(* eg七，扌七匹匸七Price);elseif (S endPrice)$where T pcice T = array (T elt-T z $ endPriae);/上架的搜索'?isOnSale = I (f get > is_orL_sale, , -1);if($isOnSale 1= -1)$wheFe * is. on_5aleT = a rr ay (T eq sQnSal e);/是否刪除的扌叟紊SisDele七已=I ( T get i s_dele七巳1

4、1_1);if ($isDelete 1= -1)$whe r e 11 i s_d el e 七呂= array (T eq T f SisDele 七巳)；¥十七十龍士七七卡卄十士七十涉十+士扌彳卡化十擊打”士十古軒協(xié)+士十命卄#-"!"¥Sorderby = * Id*/ /默認(rèn)排序字段$ orderway = T asc 1; /默認(rèn)排序方式Sodby = I(Tget.odby*);if ( $ odfciy && in_arr ay ( S odby, array ( r id_asc T , T id_desc:T , &#

5、39; price_asc:* f T pEJ_ce_desc T ) (if($ odtay = T id_desc T)$ orderway = T descT;elsei f (S odby = 匚$ ard erby = T price T;elseif (5 odby = f price_descT)$rderby = T priceT;5 orderway = T desc T；j 44亠4鼻44 4 4耳斗亠鼻#4 4 4斗斗亠亠4鼻*Jr fH總的記錄數(shù)Saaun七 二 S thi s- >whe c e ($wh ere)- a unt (); /生成豺頁對象Gpagb

6、 三 new ThinkPae 5county 2); /獲取翻頁寶符串Spag eString = Spage->3how ();/取出當(dāng)前頁的齣據(jù)Sdato = $thi3->wheee(SwheE!e) ->limil:(Spflge>fir3tR.owfe T * Spflge->li5tRoi*fl5)>order (,pSordertoy Sorderwiyjp)=>selec：t();/eeh口 $ thia->getLa stSq1 ();r曰七uirn a r r ay (FpageF > SpageStringf d a

7、 tn f => 5datar）；3.添加商品列表頁的 html:頁面包含兩部分搜索的表單和數(shù)據(jù)列表:搜索的表單:<1櫻窠的喪單<£.acm><input t.ype*"tiidde1,8 name-wpw valus-"I1*商品名<ioput type-t ext" name-wgDods_：LciJii=" valuE=fc"<?php e-ch口 IL1 get Lgnodl5_-bsmE ° ； 9>iU /Xhr /> fit 格：<inputext&q

8、uot; name-""star t_P-E left"ho I (1 enil peitc1 ； ?>H /'xbt />value-"<'?ph.p echo I (1 g&匕.3&SkE-t_pzice ' Ji ; ?>" />-<input type-'text,p 口amc-,!eo.dl_p!：itevalue-"<?php ecnHire-",iS Cn 3alfeMva丄u.esR,-1r <?php if i|

9、l 1Qn sale1 t -IJi-1J 亡亡la* 1 亡fafttkedtha亡丘巴已1*<lnpuc<input<inputtFSe-reLdiei"tpjie» "radio"tppea"radio"tpiie="£adLow口&皿"" on ssle"valu皀鼻即<7phpif (If'aet.is 力力 sals' , -1) sa 1)'亡tL±tke d-*i,cheekedR,-;an ssle,r

10、if (I ('act. is 力力 sale1 d -1)'亡d-*i,ch.t±ekedR, ;n&Dr« = r,is deleterptjain&=wi9 dsleE-effasane=w19 delece"7> “童邰V31ue = r,lff <7phii if 4111 口芒1. lTtlElECE | . -1) -=- it eeba 1 chetked="cELeekedff, ;丿二星YaluesrrOfffl 1a set«ls_eLelece1 t -d，T 0|i eehs

11、 】匸片啟匚Ke凸二”匚比己亡出宜!！"'：2>S<bx />言 delete' f -1= -1etheithetked-"亡Fl«皂匕堯芒汕1占1) echa 1 eh.e eked= wctLeekedff 1 ;< input i9pe-,siXbtDicrr二”揍宣"/xbi y><bEI的第二個(gè)參數(shù)是指當(dāng)這個(gè)值為空時(shí)，默認(rèn)值是什么T5,tie-1,radla"'tLame='*odbvR,-7Pe = ,TEadlioMrLaiDe = r,odbp"t&

12、#165;Pe = IT£'sclloHnatoR = niDcttiFUT：-7pe = n，radioHnistoe = r,odbr,value=,Tid 矽匕即 <?utip ii 11 1 ger -odkj?1 1 Id ase1)value=HldL dtesc"1 <?sp：b.p 1£ <I 1 act0他卩|)< input Dncllc：=ffpa£eDxNC'(le. submlc (;,r edN, ? ?> Fa桶US薄加時(shí)間降帛<ltipuc DBClLc=ITpareai

13、:Node. gubmlc Cl ；,r hectedrF, ; ?> "根據(jù)怕幅升常描庫方式：< 1 njiuc one 1 ick= rrpaiencNade；s訕miG t); d="eheccedH 1.; ?>心垠據(jù)莘加時(shí)間|f|庫< inpuc one 1 lck= "pare ox No de, subml c ( ;,rtnwjrecrr ?> ”根據(jù)it搐庫l?也t： />!= 1 id desc?') eclw ' ck-ectedLs rrctiecK value3"price a

14、sc"1 <?php It I 1 cec防卩丨)ss ' >rlce asc' | echo che£：ked=",c value3wpclee desc"* <?php if (141 adJoy'i ss 1 pr ice desc1 ) echo 1 cliecked=數(shù)據(jù)列表:3 <tskile width=rr100% * border=,rl,r cel lpadding=*5'* ce 11 gpacing= *5N>1 <tr>2 <tt>id<

15、/th>3 Yth埒加時(shí)間Y/ch>4 YthA商品容稱Y/thA5 <th>LOGO</th>67mYttLA是否上架Y/thA9YttlA是否冊除Y/th=YthA操作VftLh1</tr>E<?php foreach (5data a3 $k => ?v) i 7>3 日<tc>4 <td>$Vd idH/td><tdx?php echo date ( ' Y-iti-dSv 1 addt inie' ) ; ?></ td>6 <td>&l

16、t; $v< good3_nan*e</td>7 <tdximg srG/PubiiG/Upiaada/l ?Vn 3iv_logQ " /></cd>3<td>($vprice)</td><td>($¥ goodB_desG</td><tdx?pbp echa Sv 1- 1 ?'上架'i '下架'；1<tdx?php$v 11 - 1 ? 1 BN1S#1 :未刪齡；vtQ幅改刪蹤3</cr>i< ?php #nflto

17、reacb; ?>與匚<tr><td CC19P4D"*9k>( $p*ge</td></tr>g </tai3 1e>總結(jié):1.搜索的原理就是拼一個(gè) $where的數(shù)據(jù)并在取數(shù)據(jù)時(shí)加個(gè) where/mm 制肉 *mm/總的記錄數(shù)Scount = Sthis-whsre (Ewhcre) -F-aount ();/生咸劃反腐象-$ page new Thi nkS c ount, 2);"荻取翻頁字捋牢$ p a g e 3-t c x:ng = Spage,>shci,w( ) H取出當(dāng)前55的數(shù)捋

18、_= Sthia->wherb ( Swhers) ->liniit (Spage-> f irstFlow, T, T 5poge->listRows) ->order ( "S ordecby Sord b rway "2 丿這個(gè)數(shù)組的結(jié)構(gòu)可以查看手冊:WIILRL回 TABLE 0 AUAS ji DATA0 FIELD El ORDER 回 LIMIT |= PAGE 回 GROUPj HAVING El WIN 回 UNION.U'JNL' 回 LOCK 回CACHE El COMMENT 3 RELATION 回 USING 巨I fetchSql 13 TOKEN m H">FinT嚴(yán)T丟豹EQ舒（=】NEQ不等于g）GT丸于"EGT>= LTELT小于v <1序等于（<=LIKE按犧亙詞NOT BETWEENf不在區(qū)間査呵NOT I