thinkphp基础

最新推荐文章于 2024-11-14 15:58:29 发布

卷卷卷卷发

最新推荐文章于 2024-11-14 15:58:29 发布

阅读量167

点赞数

本文链接：https://blog.youkuaiyun.com/u013685199/article/details/72903281

版权

1.查询

$m=M("material_stored");

$name=$_POST["material_name"];

if($name!=""){
$where1["material_name"]=array(like,"%$name%");
}

$where1['material_stored.matState']=1;
$sql11="LEFT JOIN material_stored ON (new_mat_add.material_id=material_stored.material_idhao)"; //主表id=附表id
//需要的字段
$field1="material_stored.material_idhao as material_idhao,material_stored.material_name as material_name,material_stored.material_describe as material_describe,material_stored.matState as matstate,
new_mat_add.add_time as add_time,
mat_type.mattype_name as mattype_name,
user.user_name as user_name";

$matHisAdd=M('new_mat_add')->join($sql11)->join($sql12)->join($sql13)->where($where1)->field($field1)->order('material_stored.material_idhao desc')->select();
$this->assign('matHisAdd',$matHisAdd);