php TP3.2 增删改查 总结

1. 增

2. 删

$ret = M("Message")->where($data)->delete();

3. 改

$data['status']= 1;

$map['id'] =11;

M()->where($map)->save($data);

4查

4.1

$field = "count(1) AS count, t.client_id, m.user_id";
$map['m.status'] = array('eq', 1);
$map['t.client_id'] = array('in', $cids);
$rs = M("Message")->alias("m")->join("LEFT JOIN __TOKEN__ AS t ON m.user_id=t.uid")->field($field)->where($map)->group("t.client_id")->select();