加入收藏 | 设为首页 | 会员中心 | 我要投稿 安卓应用网 (https://www.0791zz.com/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 编程开发 > PHP > 正文

Laravel 5框架学习之Eloquent (laravel 的ORM)

发布时间:2020-05-23 23:43:37 所属栏目:PHP 来源:互联网
导读:Laravel 的 Eloquent ORM 提供了漂亮、简洁的 ActiveRecord 实现来和数据库的互动。 每个数据库表会和一个对应的「模型」互动。在开始之前,记得把 config/database.php 里的数据库连接配置好。

我们来生成第一个模型

代码如下:

查看一下生成的文件 app/Article.php

use IlluminateDatabaseEloquentModel;

class Article extends Model {

//

}

没什么特别的,除了继承自 Model 以外,但是具有强大的功能,这些都封装在laravel的Model中。模型自动具有了 save() update() findXXX() 等强大的功能。

tinker 是 laravel提供的命令行工具,可以和项目进行交互。

以下是在tinker中的交互输入

Psy Shell v0.4.1 (PHP 5.4.16 — cli) by Justin Hileman

$name = 'zhang jinglin';
=> "zhang jinglin"

$name
=> "zhang jinglin"

$article = new AppArticle;
=> <AppArticle #000000005c4b7ee400000000ab91a676> {}

$article->title = 'My First Article';
=> "My First Article"

$article->body = 'Some content...';
=> "Some content..."

$article->published_at = CarbonCarbon::now();
=> <CarbonCarbon #000000005c4b7ee600000000ab91dcb6> {
date: "2015-03-28 06:37:22",timezone_type: 3,timezone: "UTC"
}

$article;
=> <AppArticle #000000005c4b7ee400000000ab91a676> {
title: "My First Article",body: "Some content...",published_at: <CarbonCarbon #000000005c4b7ee600000000ab91dcb6> {
date: "2015-03-28 06:37:22",timezone: "UTC"
}
}

$article->toArray();
=> [
"title" => "My First Article","body" => "Some content...","published_at" => <CarbonCarbon #000000005c4b7ee600000000ab91dcb6> {
date: "2015-03-28 06:37:22",timezone: "UTC"
}
]

$article->save();
=> true

查看数据结果,添加了一条记录

AppArticle::all()->toArray();
=> [
[
"id" => "1","title" => "My First Article","published_at" => "2015-03-28 06:37:22","created_at" => "2015-03-28 06:38:53","updated_at" => "2015-03-28 06:38:53"
]
]

$article->title = 'My First Update Title';
=> "My First Update Title"

$article->save();
=> true

AppArticle::all()->toArray();
=> [
[
"id" => "1","title" => "My First Update Title","updated_at" => "2015-03-28 06:42:03"
]
]

$article = AppArticle::find(1);
=> <AppArticle #000000005c4b7e1600000000ab91a676> {
id: "1",title: "My First Update Title",published_at: "2015-03-28 06:37:22",created_at: "2015-03-28 06:38:53",updated_at: "2015-03-28 06:42:03"
}

$article = AppArticle::where('body','Some content...')->get();
=> <IlluminateDatabaseEloquentCollection #000000005c4b7e1800000000ab91a676> [
<AppArticle #000000005c4b7e1b00000000ab91a676> {
id: "1",updated_at: "2015-03-28 06:42:03"
}
]

$article = AppArticle::where('body','Some content...')->first();
=> <AppArticle #000000005c4b7e1900000000ab91a676> {
id: "1",updated_at: "2015-03-28 06:42:03"
}

$article = AppArticle::create(['title' => 'New Article','body' => 'New body','published_at' => CarbonCarbon::now()]);
IlluminateDatabaseEloquentMassAssignmentException with message 'title'

MassAssignmentException,laravel保护我们不能直接插入记录。比如,在一些特殊情况下我们需要直接利用表单的信息填充数据库记录,但是如果我们并没有在表单中添加密码字段,而黑客产生了密码字段连同我们的其他字段一起送回服务器,这将产生修改密码的危险,所以我们必须明确的告诉laravel我们的模型那些字段是可以直接填充的。

修改我们的模型文件 Article.php

use IlluminateDatabaseEloquentModel;

class Article extends Model {

protected $fillable = [
'title','body','published_at'
];

}

表示,title,body,published_at 是可以直接填充的。

退出 tinker,重新进入

>> $article = AppArticle::create(['title' => 'New Article','published_at' => CarbonCarbon::now()]); => { title: "New Article",body: "New body",published_at: { date: "2015-03-28 06:55:19",timezone: "UTC" },updated_at: "2015-03-28 06:55:19",created_at: "2015-03-28 06:55:19",id: 2 }

It's ok

AppArticle::all()->toArray();
=> [
[
"id" => "1","updated_at" => "2015-03-28 06:42:03"
],[
"id" => "2","title" => "New Article","body" => "New body","published_at" => "2015-03-28 06:55:19","created_at" => "2015-03-28 06:55:19","updated_at" => "2015-03-28 06:55:19"
]
]

$article = AppArticle::find(2);
=> <AppArticle #000000005051b22b000000007ec432dd> {
id: "2",title: "New Article",published_at: "2015-03-28 06:55:19",updated_at: "2015-03-28 06:55:19"
}

$article->update(['body' => 'New Updaet Body']);
=> true

update自动调用save()

以上所述就是本文的全部内容了,希望能够对大家学习Laravel5框架有所帮助。

(编辑:安卓应用网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读