12.数据库(2)

---

1.新建一个 Student Model

public function orm1()
    {
        //all()
//        $students = Student::all();

        //find()
//        $student = Student::find(1001);

        //findOrFail()，根据主键查找，没找到抛出异常
//        $student = Student::findOrFail(10011);

        // get(),获取所有
//        $student = Student::get();

        // first()
//        $student = Student::where('id','>',1001)->orderBy('age','desc')->first();

        // chunk()
        /*Student::chunk(2,function($students){
            var_dump($students);
        });*/

        //count(),聚合函数
        $num = Student::count();
        $max = Student::where('id','>',1001)->max('age');
        var_dump($max);
    }

---

public function orm2()
    {
        //使用模型新增数据
        /*$student = new Student();
        $student->name = 'aaabbbbwer';
        $student->age = 18222234;
        $bool = $student->save();
        var_dump($bool);*/

        /*$student = Student::find(1008);
        //输出的是自动格式化的时间
        echo $student->created_at;
        echo '<br/>';
        // 关闭后，自己格式化时间
        echo date('Y-m-d H:i:s',$student->created_at);die;*/

        //使用模型的 Create 方法新增数据,需要指定允许批量赋值的字段
        /*$student = Student::create(
            ['name' => 'iioo', 'age' => 18]
        );
        var_dump($student);*/

        // firstOrCreate,以属性查找，若没有则创建，并取得新增实例
        /*$student = Student::firstOrCreate(
            ['name' => 'bbb']
        );
        var_dump($student);*/

        // firstOrNew(),以属性查找，若没有则创建，如果需要保持，自己调用save
        $student = Student::firstOrNew(
            ['name' => 'oooppp']
        );
        $bool = $student->save();
        var_dump($bool);
    }

---

public function orm3()
    {
        //通过模型更新数据,会自动更新时间戳
        /*$student = Student::find(1001);
        $student->name = 'kitty';
        $bool = $student->save();
        var_dump($bool);*/

        $num = Student::where('id','>','1001')->update(
            ['age' => 41]
        );
        var_dump($num);
    }

---

public function orm4()
    {
        //通过模型删除
        /*$student = Student::find(1001);
        $bool = $student->delete();
        var_dump($bool);*/

        //通过主键删除
//        $num = Student::destroy(1002);
//        $num = Student::destroy(1003, 1004);
//        $num = Student::destroy([1005,1006]);
//        var_dump($num);

        //删除指定条件数据
        $num = Student::where('id','>',1011)->delete();
        var_dump($num);
    }

---

<?php
/**
 * Created by PhpStorm.
 * User: Hua
 * Date: 2016/10/24
 * Time: 22:33
 */

namespace App;

use Illuminate\Database\Eloquent\Model;

class Student extends Model
{
    //指定表名
    protected $table = 'student';

    //指定主键
    protected $primaryKey = 'id';

    // 关闭维护时间戳 为 false,打开为 true, create_at, updated_at
    public $timestamps = true;

    //指定允许批量赋值的字段
    protected $fillable = ['name', 'age'];

    //指定不允许批量赋值的字段
    protected $guarded = ['sex'];

    protected function getDateFormat()
    {
        // 自动关联的为时间戳
        return time();
        return parent::getDateFormat(); // TODO: Change the autogenerated stub
    }

    //关闭自动转换时间格式的功能
    protected function asDateTime($value)
    {
        return $value;
        return parent::asDateTime($value); // TODO: Change the autogenerated stub
    }
}