王明昌博客如果你对该文章中的内容有疑问/不解,可以点击此处链接提问
要注明问题和此文章链接地址 点击此处跳转
$waiterData = Db::name('user u')
->field('u.*,g.name gname,FROM_UNIXTIME(u.ctime, "%Y-%m-%d %H:%i:%s") AS dat, insert(u.tel, 4, 4, "XXXX") as mobile')
->field('u.*')
->join('zf_user_group g','g.id = u.gid')
->where($where)
->order("u.id desc")
->page($page,$limit)
->select();
时间戳转时间
FROM_UNIXTIME(u.ctime, “%Y-%m-%d %H:%i:%s”) AS dat
手机号中间四位xxx
insert(u.tel, 4, 4, “XXXX”) as mobile
