PHP通過參數(shù)來生成MYSQL語句類

PHPMYSQL類PAGEPAGE2————————————————————————————————作者：————————————————————————————————日期：PHPMYSQLMySQL。指定表和字段創(chuàng)DELETE語。創(chuàng)SQLWHERE，使LEFTJOIN和ORDER例子:<?php/＊***＊＊＊＊*****＊*＊*＊＊＊****＊＊*＊*＊＊***＊＊*＊＊＊＊**＊＊**＊*＊*＊＊***＊**＊＊*＊*＊＊＊*ExamplefileThisexampleshowshowtousetheMyLibSQLGenclassTheexampleisbasedonthefollowingMySQLtable：（idint(10)unsignedNOTNULLauto_increment，namevarchar（60）NOTNULLdefault",addressvarchar（60）NOTNULLdefault”,cityvarchar（60）NOTNULLdefault”,PRIMARYKEY（cust_id））TYPE=MyISAM；*＊＊***＊*＊＊**＊***＊*＊＊＊＊*****＊＊***＊＊******＊**＊***＊*＊***＊***＊＊＊＊****＊**/e（”n—0p”s=y（"e”，”s"，"y"；values=Array(”Fadjar","ResultmangRayaStreet”,”Jakarta”）;tables=Array（”customer”)；44echo”〈b>ResultGenerateInsert</b>br>";t=wn；object->clear_all_assign();//torefreshallpropertybutitnoneedwhenfirsttimeexecuteobject->setFields（fields）;object->setValues（values）;t>（s；f(！t〉）ot；t｝else｛sql=object〉echosql.”<br>”;}echo”〈b>ResultGenerateUpdate〈/b〉<br>";fields=Array（”name”，”address”，"city”);values=Array（"Fadjar”,”ResultmangRayaStreet",”Jakarta”)；tables=Array(”customer”);id=1;conditions[0][”condition”］=”id='id’”;conditions[0］["connection”]=“";object-〉clear_all_assign（)；object—>setFields（fields)；object—>）;object->tables）;object->setConditions（conditions)；f(！tL｛ot>r；telse｛sql=object〉Result;echosql.”<br>”;}echo”<b>ResultGenerate/b>〈〉”;s=y(”r”；s[0［”n”]=”=1′"；s[0［”n”］="R"；s[1[”n”]=”2′”；conditions[1]［"connection”］=”O(jiān)R";s［2［"n”］=”=′”；conditions[2]［”connection"］=“”；PAGE5PAGE5objectclear_all_assign();t(s;t>(s；f(tL{ot;t｝elsesqlobject—Resultechosql”<br”;}echo” 〈ResultGenerateList/b>br；s=y”id” ，"e”,”s” ，”y” ；s=y"r”id=1;conditions［0］["condition"]=”id='id'”;conditions［0]［”connection"］=“”;t；t>ss；ts；t-ss;f(totrt}e｛l=tol.”r”echo” 〈ResultGenerateListwithsearchonallfields</bbr；s=y("d” ，”e"，”s”,”y” ；s=y"r” id=1；search=”FadjarNurswanto";t)；t>(s；t>(s)；t-hf(t{ot—rt}e{l=tol。"b”echo”ResultGenerateListwithsearchonsomefields〈/b〈br” ；s=y”id””e",”s”,”y”；s=y(”r”；id=1;search=Array(”name”=>”FadjarNurswanto"，”address””)；t；t—ss)；ts;t—(h；f(!t—(otrte{l=t—>;ol。”r”}?>類代碼:<？php/*CreatedByFadjarNurswanto<fajr_n@〉E：—PRODUCTNAME:classMyLibSQLGenPRODUCTVERSION：1.0.0DESCRIPTION：classyangberfungsiuntukmenggenerateSQLDENPENCIES：*/classMyLibSQLGen｛varResult；rs=y(；rs=y(;rs=y；rs=yvarCondition;rn=y;varSearch；varSort=”ASC”;varOrder；varError；n｝functionBuildCondition()｛funct=”BuildCondition”;e=sss=s—fs{s—>(tnef(!y(s)）｛this—ErrorclassName::funct\nVariableconditionsnotArray；return;}r(i=0itsi)｛sns[i"n”.””.s[i”connection”]?！薄?；｝returntrue;｝n）｛funct=”BuildLeftJoin”;e=s(sf!s—>{sr=”tnsy”;n}s=s—>(；hasil=false；foreach(LeftJoinVarsasLeftJoinVar）｛@l”TN”。r[”e”;h(r"n"]sr)PAGE8PAGE8｛rr”n”].””。r”n”］?！薄?；}hasil。=”O(jiān)N（”。condvar。"）”;unset（condvar);}thisResultLeftJoin=hasil;returntrue；}functionBuildOrder()｛funct="BuildOrder”；className=get_class（this);—”sy”；n｝f(！s—〉ssr=”tFieldswasempty";return；}s=s〉s；Orders=this—getOrder（)；f（g(”,”，s){s=e(”,”,r}if（！y(ss=y（s｝foreach(OrdersasOrder){if（！c（rs—〉r="trtc”；n｝f(r>t（s)sr=”tvalueofpropertySortis”。count(this->Fields);return；}@r=sr］.”,”;｝s—>r=”RY”.r（r，0— 1；99returntrue;｝nh｛funct="BuildSearch"；e=s(s)；f(!s-hsr=”thsy”;n｝f(!s—sr=”tysy”n｝s=s—；e=s-hfye)｛foreach(Fieldsasfield）｛f@ed）{s=e"”ed;(as)｛@hasilfield”LIKE””%OR；｝fl)｛＠l。=””.r(l0-4?！?D”；t(l)；｝}}hasil=hasil_final；｝else｛PAGE11PAGE11hssd)｛Values=explode(”",xvalue)；foreach(ValuesasValue）｛@hasil。=field。”LIKE‘％"。Value.”％'OR”;}}｝s>h=r(l，0，-4;returntrue;}nn｛this-〉Result=null;thisResultSearchnullResultLeftJoinnullResultnull；s—〉s=y(;s— >s=y(；s— >s=y；ss=y(；this— >Condition=null；thisLeftJoinArraythis— 〉Sort=”ASC；this— >Order=null；this— Search=null；this-〉fieldSQL=null;this-〉valueSQL=null；this— 〉partSQL=null;this— >Error=nullreturntrue；｝functionCombineFieldValue(manual=false){funct=”CombineFieldsPostVar";e=sss=ss)；valuesthis—fys｛s>r="etesty”；return;}ifys）｛s>r=":testy”;return；｝f(ts=ts){thisErrorofandnot;return}fori=0i<ts;i+)｛sLs[i]?！?”;([i]””[i]”"｜|[i]””）{s>L=”(‘”.s［i].”，”;s>L=s[i］.”(‘”.s[i］。””；｝else｛fc(s［i]）{@this—>valueSQL。=values[i].”,”；@this—partSQLfields［i］.””values［i””;}else{s-L。=”‘”。s［i］?！?”;s>L=s［i].”=’"。s[i]。",";}}｝｝s>L=rsL01;s>L=rs—>L0,—1；sL=rsL,0—1；returntrue；}n{t=L";e=sss=s>s;f(s|t(s){thisdbgFailedfuncts>r="etesy；return；}fori=0;itsi){@e。=s[i］。";｝Table=substr(Table,0,—1);l=EM.e；fs>(){f(!s—>)｛s>t;n｝l="E.s>;}this—>Result=sql；returntrue;｝functiongetInsertSQL()｛funct=”getInsertSQL”；e=ss；f!s—>)s>r=”etssy”n｝f(s—>ss—>r=”etssy”n｝fs{s—r=”etssy”n}f(s)s(t;n}s=s—l=”TO”。s［0］.””。s-L.”(”。this—>valueSQL.”)”；thisResultsql；returntrue；}n)｛funct="getUpdateSQL”;className=get_class(this);f(s—({s-r=”tssy”;n;｝fs>() s>r="tysy"n;｝f(!s—>){s—r="etssy”;n;｝f!s—>(s—>tn｝f(s—({sdtn}s=s—；sql””0”””this-n;this->Result=sql；returntrue；｝functiongetQuerySQL()｛funct=”getQuerySQL”；e=ss；f(s—>() sr=”tysy”n｝f!s-s{s—>r=”tssy”;n｝s=s—>s)；s=ss)；hssd@wd",”hsse@ee.”,”｝s—>t="T"r(w,0,— 1)”M".(e,0— 1；fsn{if(s—s){s—tnthisResult””this—ResultLeftJoin;}f(s>)）{if!s—ns—(tns—t”E”s—>n.””;｝fs—)）｛f(!s-){s-(t)nfs）PAGEPAGE15｛f(i("E”s—>ts—>t=”D”.sResultSearch；}else{this-〉Result.=”WHERE”。this-〉ResultSearch；}｝｝if（s〉（)）｛f(！s—>r){s-〉(tnthisResult?！薄眛his—ResultOrder；｝if（this-〉getSort(）｛if(＠this->ResultOrder)｛this—〉Result。=”"。this-〉getSort（);}}returntrue;｝functiongetCondition（){return＠t