PHP实体层基础类
<span class</span><span BaseModel { </span><span private</span> <span $tableName</span><span ; </span><span private</span> <span $fields</span>=<span array</span><span (); </span><span function</span><span __construct() { </span><span $this</span>->tableName=<span rtrim</span>(<span get_class</span>(<span $this</span>),'M'<span ); } </span><span function</span> __get(<span $n</span><span ) { </span><span return</span>(<span $this</span>-><span $n</span><span ); } </span><span function</span> __set(<span $n</span>, <span $value</span><span ) { </span><span $this</span>-><span $n</span> = <span $value</span><span ; </span><span $this</span>->fields[<span $n</span>]=<span $value</span><span ; } </span> <span function</span><span Add() { </span><span $f</span>=''<span ; </span><span $f1</span>=''<span ; </span><span $arrKeys</span>=<span array_keys</span>(<span $this</span>-><span fields); </span><span foreach</span>(<span $arrKeys</span> <span as</span> <span $row</span><span ) { </span><span $f</span>.=<span $row</span>.','<span ; </span><span $f1</span>.=':'.<span $row</span>.','<span ; } </span><span $f</span>=<span rtrim</span>(<span $f</span>,','<span ); </span><span $f1</span>=<span rtrim</span>(<span $f1</span>,','<span ); </span><span $sql</span>='insert into '.<span $this</span>->tableName.'('.<span $f</span>.') values('.<span $f1</span>.')'<span ; </span><span //</span><span echo $sql;</span> <span global</span> <span $dbh</span><span ; </span><span return</span> <span $dbh</span>->edit(<span $sql</span>,<span $this</span>-><span fields); } </span> <span function</span> Update(<span $sql_where</span>,<span $params</span>=<span array</span><span ()) { </span><span $f</span>=''<span ; </span><span $f1</span>=''<span ; </span><span $arrKeys</span>=<span array_keys</span>(<span $this</span>-><span fields); </span><span foreach</span>(<span $arrKeys</span> <span as</span> <span $row</span><span ) { </span><span $f</span>.=<span $row</span>.'=:'.<span $row</span>.','<span ; } </span><span $f</span>=<span rtrim</span>(<span $f</span>,','<span ); </span><span $sql</span>='update '.<span $this</span>->tableName.' set '.<span $f</span>.' where '.<span $sql_where</span><span ; </span><span $arrKeys1</span>=<span array_keys</span>(<span $params</span><span ); </span><span foreach</span>(<span $arrKeys1</span> <span as</span> <span $row</span><span ) { </span><span $this</span>->fields[<span $row</span>]=<span $params</span>[<span $row</span><span ]; } </span><span global</span> <span $dbh</span><span ; </span><span return</span> <span $dbh</span>->Edit(<span $sql</span>,<span $this</span>-><span fields); } </span><span function</span> Delete(<span $sql_where</span>,<span $params</span>=<span array</span><span ()) { </span><span $sql</span>='delete from '.<span $this</span>->tableName.' where '.<span $sql_where</span><span ; </span><span //</span><span echo $sql;</span> <span global</span> <span $dbh</span><span ; </span><span return</span> <span $dbh</span>->Edit(<span $sql</span>,<span $params</span><span ); } }</span>
实体层:
<span class</span> proM <span extends</span><span BaseModel {</span> <span private</span> <span $proName</span>; <span private</span> <span $proDetail</span>; <span private</span> <span $proPic</span>; <span private</span> <span $proPic1</span>; <span private</span> <span $proAttr</span>; <span private</span> <span $proTaxis</span>; <span private</span> <span $proIsHome</span>; <span private</span> <span $proIsTJ</span>; <span private</span> <span $proIsCTJ</span>; <span private</span> <span $proIsDel</span>; <span private</span> <span $proAddTime</span>; <span private</span> <span $proisHot</span>; <span private</span> <span $proisPorClass</span>; <span private</span> <span $proisYN</span>; <span private</span> <span $proGL</span>; <span private</span> <span $proSeoT</span>; <span private</span> <span $proSeoK</span>; <span private</span> <span $proSeoD</span>; <span private</span> <span $proBH</span><span ; </span><span private</span> <span $FK_proClass</span><span ; </span><span private</span> <span $proModel</span><span ; </span><span private</span> <span $proPrice</span><span ; </span><span private</span> <span $proDiscount</span><span ; </span><span private</span> <span $proHit</span><span ; </span><span private</span> <span $proURL</span><span ; </span><span private</span> <span $proisKdWords</span><span ; </span><span private</span> <span $proisKdDone</span><span ; </span><span private</span> <span $proFL</span><span ; }</span>
使用:
<span $m</span>=<span new</span><span proM(); </span><span $m</span>->proName='代码'<span ; </span><span $m</span>->proDetail='php开发'<span ; </span><span $m</span>->Update('proID=:proID',<span array</span>(proID=>1));