Laravel数据库CURD

查询对象 object

$object = DB::table('table_name');

Select

$object = $object->select('name', 'email');
$object = $object->distinct();
$object = $object->select('name as user_name')->get();
$object = $object->addSelect('age');

where

$object = $object->where('filed_name','zhangsan');

whereIn
    $object = $object->whereIn('filed_id', array(1, 2, 3));

whereNotIn
    $object = $object->whereNotIn('filed_id', array(1, 2, 3));

whereBetween
    $object = $object->whereBetween('filed_id', array(1, 100));

whereNotBetween
    $object = $object->whereNotBetween('filed_id', array(1, 100));

where > <
   $object = $object->where('filed_id', '>', 100);

orWhere
    $object->orWhere('filed_name', 'zhangsan');

orderBy & groupBy & having
    $object->orderBy('filed_name', 'desc')
    ->groupBy('filed_name')
    ->having('filed_name', '>', 100);

Offset & Limit
    $object->skip(10)->take(5);

聚合 count max min avg sum

$total = $object->count();
$total = $object->max('price');
$total = $object->min('price');
$total = $object->avg('price');
$total = $object->sum('votes');

Insert

$object->insert(
    array('email' => 'abc01@qq.com', 'ids' => 0),
    array('email' => 'abc02@qq.com', 'ids' => 1)
);

如果表有一个自动递增的id字段使用insertGetId插入一个记录和检索id:

$id = $object->insertGetId(
    array('email' => 'abc@qq.com', 'ids' => 0)
);

Delete

$object->where('ids', '<', 100)->delete();

Update

 $object->where('number_id', 1)->update(array('ids' => 1));

事务

DB::beginTransaction();
$sql = DB::table('table_a')->where('id',100)->delete();
$sql2 = DB::table('table_b')->where('id',101)->delete();
if ( $sql && $sql2 ){
    DB::commit();
    return success;
}else{
    DB::rollback();
    return error;
}