thinkphpmysql自定义函数_ThinkPHP中获得一条数据表信息自定义函数publicfunctionget()...

/* 一般情况 */

public function get(){

return $this->where("id&＃61;".(int)I(&＃39;id&＃39;))->find();

}

/* 获取信息后拆分多图 */

public function get(){

$m &＃61; M(&＃39;products&＃39;);

$rs &＃61; $m->where("productId&＃61;".(int)I(&＃39;id&＃39;))->find();

if($rs[&＃39;productImg2&＃39;]!&＃61;&＃39;&＃39;)$rs[&＃39;productImg2&＃39;] &＃61; explode(&＃39;,&＃39;,$rs[&＃39;productImg2&＃39;]);

return $rs;

}

/* 获取信息后&＃xff0c;需要获取另外一个表的信息 */

public function get(){

$rs &＃61; $this->where("productId&＃61;".(int)I(&＃39;id&＃39;))->find();

//获取关联的分类

$sql &＃61; "select * from __PREFIX__goods_cat_products where productId&＃61;".(int)I(&＃39;id&＃39;);

$catproducts &＃61; $this->query($sql);

if(!empty($catproducts)){

foreach ($catproducts as $key &＃61;> $v){

$rs[&＃39;catproducts_&＃39;.$v[&＃39;catId&＃39;]] &＃61; 1;

}

}

return $rs;

}

/* 通过关联表获取信息 */

public function get(){

$id &＃61; (int)I(&＃39;id&＃39;);

$sql &＃61; "select a.*,aa.content,aa.id from __PREFIX__faqs a left join __PREFIX__faq_answers aa on a.faqId&＃61;aa.faqId and aa.isMaster&＃61;1 where a.faqId&＃61;".$id;

return $this->queryRow($sql);

}