Laravel基础使用Eloquent ORM操作数据库之新增【二】

电玩女神 2022-03-27 03:07 287阅读 0赞

**laravel Eloquent ORM 文档:**[https://laravel-china.org/docs/laravel/5.5/eloquent/1332][https_laravel-china.org_docs_laravel_5.5_eloquent_1332]

**实战项目的话 在我的博客Laravel使用ORM操作数据库增删改查有:**[https://blog.csdn.net/qq\_42611547/article/details/86313955][https_blog.csdn.net_qq_42611547_article_details_86313955]

先创建模型

<?php
     
    namespace App;
     
    use Illuminate\Database\Eloquent\Model;
     
     
    class Vote extends Model
    {
    	//指定表名
    	protected $table = 'Kcb';
    	//指定主键
        protected $primaryKey = 'id';
     
       //时间变成fales
        public $timestamps=false;
    }
     
     
     
    ?>

<?php
    namespace App\Http\Controllers;
    use App\Kcb;
    use Illuminate\Support\Facades\DB;
    class KcbController extends Controller
    {
        public function ormadd()
        {
            //使用模型新增记录
            //需处理unix时间戳
            $kcb = new Kcb();
            $kcb->branch = 4;
            $kcb->class = '16春检验';
            $kcb->course = '生物化学';
            $bool = $kcb->save();
            dd($bool);
            //显示记录
            $kcb = Kcb::find(5);
            echo $kcb->created_at;
            //格式化日期时间
            echo date('Y-m-d H:i:s',$kcb->created_at);
            //使用模型的Create方法新增记录
            //需指定指定允许批量赋值的字段
            $kcb = Kcb::create(
              ['branch' => 5,'class' => '16秋药学','course' => '药剂学']
            );
            //以属性查询，如没有则添加
            $kcb = Kcb::firstOrCreate(
            [class' => '16秋药学']
            );
            //以属性查询，如没有则创建新的实例，如需保存要调用save()
            $kcb = Kcb::firstOrNew(
                ['class' => '13秋药学']
            );
            $bool = $kcb->save();
            dd($bool);
        }
    }

[https_laravel-china.org_docs_laravel_5.5_eloquent_1332]: https://laravel-china.org/docs/laravel/5.5/eloquent/1332
[https_blog.csdn.net_qq_42611547_article_details_86313955]: https://blog.csdn.net/qq_42611547/article/details/86313955