随机应变 ABCD: Always Be Coding and … : хороший
Base
sometimes
bail
存在チェック系
required
present
filled
in
not_in
in_array
型チェック
boolean
accepted
文字列判定
string
alpha
alpha_dash
alpha_num
email
url
active_url
ip
json
timezone
regex
日付判定
date
date_format
after
before
数値判定
integer
numeric
digits
digits_between
配列判定
array
distinct
大きさ判定
size
min
max
between
比較判定
gt
gte
lt
lte
ファイル判定
file
image
dimensions
mimes
同値チェック
confirmed
same
different
controller
public function store(Request $request){
$this->validate($request, [
'login_id' => 'required|min:3',
'role' => 'required|min2',
'name' => 'required|min2',
'password' => 'required',
'mail' => 'required',
'test_mail' => 'required',
'updated_person' => 'required|min:3'
]);
$article = new Article();
$article->login_id = $request->login_id;
$article->role = $request->role;
$article->name = $request->name;
$article->password = $request->password;
$article->mail = $request->mail;
$article->test_mail = $request->test_mail;
$article->updated_person = $request->updated_person;
$article->save();
return redirect('/');
}
create.blade.php
@extends('layouts.default')
@section('title', '新規登録')
@section('content')
<h1><a href="/">登録情報</a></h1>
<h3>新規登録</h3>
<form method="post" action="{{ url('/articles') }}">
{{ csrf_field()}}
<p>
<input type="text" name="login_id" placeholder="ログインID" value="{{ old('login_id') }}">
@if($errors->has('login_id'))
<span class="error">{{ $errors->first('login_id') }}</span>
@endif
</p>
<p>
<input type="text" name="role" placeholder="権限" value="{{ old('role') }}">
@if($errors->has('role'))
<span class="error">{{ $errors->first('role') }}</span>
@endif
</p>
<p>
<input type="text" name="name" placeholder="氏名" value="{{ old('name') }}">
@if($errors->has('name'))
<span class="error">{{ $errors->first('name') }}</span>
@endif
</p>
<p>
<input type="text" name="password" placeholder="パスワード" value="{{ old('password') }}">
@if($errors->has('password'))
<span class="error">{{ $errors->first('password') }}</span>
@endif
</p>
<p>
<input type="text" name="mail" placeholder="メールアドレス" value="{{ old('mail') }}">
@if($errors->has('mail'))
<span class="error">{{ $errors->first('mail') }}</span>
@endif
</p>
<p>
<input type="text" name="test_mail" placeholder="テストメール" value="{{ old('test_mail') }}">
@if($errors->has('test_mail'))
<span class="error">{{ $errors->first('test_mail') }}</span>
@endif
</p>
<p>
<input type="text" name="updated_person" placeholder="更新者氏名" value="{{ old('updated_person') }}">
@if($errors->has('updated_person'))
<span class="error">{{ $errors->first('updated_person') }}</span>
@endif
</p>
<p>
<input type="submit" value="登録">
</p>
</form>
@endsection
form
WoW!
public function store(Request $request){
$this->validate($request, [
'login_id' => 'required|min:3',
'role' => 'required|min2',
'name' => 'required|min2',
'password' => 'required',
'mail' => 'required',
'test_mail' => 'required',
'updated_person' => 'required|min:3'
]);
$article = new Article();
$article->login_id = $request->login_id;
$article->role = $request->role;
$article->name = $request->name;
$article->password = $request->password;
$article->mail = $request->mail;
$article->test_mail = $request->test_mail;
$article->updated_person = $request->updated_person;
$article->save();
return redirect('/');
}
password, メールアドレスのバリデーションがよくわらんね。
まずrouting
createをつくります。
Route::get('/', 'ArticlesController@index');
Route::get('/articles/create', 'ArticlesController@create');
Route::get('/articles/{id}', 'ArticlesController@show')->where('post','[0-9]+');
public function create(){
return view('articles.create');
}
create.blade.php
@extends('layouts.default')
@section('title', '新規登録')
@section('content')
<h1><a href="/">登録情報</a></h1>
<h3>新規登録</h3>
<form method="post" action="{{ url('/articles') }}">
{{ csrf_field()}}
<p>
<input type="text" name="login_id" placeholder="ログインID">
</p>
<p>
<input type="text" name="role" placeholder="権限">
</p>
<p>
<input type="text" name="name" placeholder="氏名">
</p>
<p>
<input type="text" name="password" placeholder="パスワード">
</p>
<p>
<input type="text" name="mail" placeholder="メールアドレス">
</p>
<p>
<input type="text" name="test_mail" placeholder="テストメール">
</p>
<p>
<input type="text" name="updated_person" placeholder="更新者氏名">
</p>
<p>
<input type="submit" value="登録">
</p>
</form>
@endsection
フォームができました。
ルーティング
Route::post('/articles', 'ArticlesController@store');
入れてみよう
入った！
すげー
ルーティングを追加します。
Route::get('/', 'ArticlesController@index');
Route::get('/articles/{id}', 'ArticlesController@show')
一覧
<div class="container">
<h1>Articles</h1>
<h3>氏名一覧</h3>
<ul>
@foreach ($articles as $article)
<li>{{$article->login_id}} <a href="{{ action('ArticlesController@show', $article->id) }}">{{ $article->name}}</a></li>
@endforeach
</ul>
</div>
詳細
<head>
<meta charset="utf-8">
<title>{{ $article->name}}</title>
<link rel="stylesheet" href="/css/styles.css">
</head>
<body>
<div class="container">
<h1><a href="/">登録情報</a></h1>
<h3>{{ $article->name}}</h3>
<p>{{$article->login_id}}</p>
<p>{{$article->name}}</p>
<p>{{$article->role}}</p>
<p>{{$article->password}}</p>
</div>
</body>
おう、なんとなく詳細はできたか。。
default.bladeをつくっていく。
<!DOCTYPE>
<html>
<head>
<meta charset="utf-8">
<title>@yield('title')</title>
<link rel="stylesheet" href="/css/styles.css">
</head>
<body>
<div class="container">
@yield('content')
</div>
</body>
</html>
ほうほう、
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Article;
class ArticlesController extends Controller
{
//
public function index(){
$articles = Article::all();
dd($articles->toArray());
return view('articles.index');
}
}
<ul>
@foreach ($articles as $article)
<li><a href="">{{ $article->name }}</a></li>
@endforeach
</ul>
ほうほう、少しわかってきたぞー
<h1>Articles</h1>
<ul>
@foreach ($articles as $article)
<li><a href="">{{ $article->name }}</a></li>
@endforeach
</ul>
まずrouting
routesフォルダからweb.phpを開きます。ArticlesControllerを指定。
Route::get('/', 'ArticlesController@index');
make:controller
[vagrant@localhost laravel]$ php artisan make:controller ArticlesController
Controller created successfully.
app/Http/Controllersに ArticlesController.phpがつくられる。
あーなるほど。
namespace App\Http\Controllers;
use Illuminate\Http\Request;
class ArticlesController extends Controller
{
//
}
namespace App\Http\Controllers;
use Illuminate\Http\Request;
class ArticlesController extends Controller
{
//
public function index(){
return "hello";
}
}
class ArticlesController extends Controller
{
//
public function index(){
return view('articles.index');
}
}
<!DOCTYPE> <html> <head> <meta charset="utf-8"> <title>Articles</title> </head> <body> <h1>Articles</h1> <ul> <li><a href="">name1</a></li> <li><a href="">name2</a></li> </ul> </body> </html>
カスタマイズすると大分勝手が違うな～
>>> $article = App\Article::find(2);
=> App\Article {#2907
id: 2,
login_id: “user2”,
role: “master”,
name: “goto”,
password: “password”,
mail: “laravel@hotmail.com”,
test_mail: “laravel_test@hotmail.com”,
updated_person: “sasaki”,
created_at: “2018-09-22 08:31:54”,
updated_at: “2018-09-22 08:31:54”,
}
>>> $article->password = ‘himitsu’;
=> “himitsu”
>>> $article->save();
=> true
>>> App\Article::all()->toArray();
=> [
[
“id” => 1,
“login_id” => “user1”,
“role” => “master”,
“name” => “taniguchi”,
“password” => “passowrd”,
“mail” => “laravel@gmail.com”,
“test_mail” => “laravel_test@gmail.com”,
“updated_person” => “sasaki”,
“created_at” => “2018-09-21 21:39:07”,
“updated_at” => “2018-09-21 21:39:07”,
],
[
“id” => 2,
“login_id” => “user2”,
“role” => “master”,
“name” => “goto”,
“password” => “himitsu”,
“mail” => “laravel@hotmail.com”,
“test_mail” => “laravel_test@hotmail.com”,
“updated_person” => “sasaki”,
“created_at” => “2018-09-22 08:31:54”,
“updated_at” => “2018-09-22 08:51:32”,
],
]
ほう、sqlコマンドを打たなくてもOKだ。
php artisan tinkerとは？
-既に読み込まれているPHPアプリケーションのためのREPL (Read-Eval-Print Loop)を提供
-データベースへのアクセス、モデルを使うなどが可能
appにあるArticle.phpを編集する。protected $fillableを追加。
class Article extends Model
{
//
protected $fillable = ['loginid','role','name','password','mail','test_mail','updated_person']
}
再度artisan tinker
[vagrant@localhost laravel]$ php artisan tinker
Psy Shell v0.9.8 (PHP 7.1.21 — cli) by Justin Hileman
>>> App\Article::create([‘login_id’=>’user2′,’role’=>’master’,’name’=>’goto’,
… ‘password’=>’password’,’mail’=>’laravel@hotmail.com’,’test_mail’=>’laravel_test@hotmail.com’,
… ‘updated_person’=>’sasaki’]);
=> App\Article {#2913
login_id: “user2”,
role: “master”,
name: “goto”,
password: “password”,
mail: “laravel@hotmail.com”,
test_mail: “laravel_test@hotmail.com”,
updated_person: “sasaki”,
updated_at: “2018-09-22 08:31:54”,
created_at: “2018-09-22 08:31:54”,
id: 2,
}
うお！
mysql側で確認
mysql> select * from articles;
+—-+———-+——–+———–+———-+———————+————————–+—————-+———————+———————+
| id | login_id | role | name | password | mail | test_mail | updated_person | created_at | updated_at |
+—-+———-+——–+———–+———-+———————+————————–+—————-+———————+———————+
| 1 | user1 | master | taniguchi | passowrd | laravel@gmail.com | laravel_test@gmail.com | sasaki | 2018-09-21 21:39:07 | 2018-09-21 21:39:07 |
| 2 | user2 | master | goto | password | laravel@hotmail.com | laravel_test@hotmail.com | sasaki | 2018-09-22 08:31:54 | 2018-09-22 08:31:54 |
+—-+———-+——–+———–+———-+———————+————————–+—————-+———————+———————+
2 rows in set (0.00 sec)
抽出もできる。
>>> App\Article::where(‘id’, ‘>’, 1)->get()->toArray();
=> [
[
“id” => 2,
“login_id” => “user2”,
“role” => “master”,
“name” => “goto”,
“password” => “password”,
“mail” => “laravel@hotmail.com”,
“test_mail” => “laravel_test@hotmail.com”,
“updated_person” => “sasaki”,
“created_at” => “2018-09-22 08:31:54”,
“updated_at” => “2018-09-22 08:31:54”,
],
]
これでも取得できる。
>>> App\Article::orderBy(‘created_at’,’desc’)->get()->toArray();
[vagrant@localhost laravel]$ php artisan tinker
Psy Shell v0.9.8 (PHP 7.1.21 — cli) by Justin Hileman
>>> $article = new App\Article();
=> App\Article {#2900}
>>> $article->login_id = ‘user1’;
=> “user1”
>>> $article->role = ‘master’;
=> “master”
>>> $article->name = ‘taniguchi’;
=> “taniguchi”
>>> $article->password = ‘passowrd’;
=> “passowrd”
>>> $article->mail = ‘laravel@gmail.com’;
=> “laravel@gmail.com”
>>> $article->test_mail = ‘laravel_test@gmail.com’;
=> “laravel_test@gmail.com”
>>> $article->updated_person = ‘sasaki’;
=> “sasaki”
>>> $article->save();
=> true
>>> App\Article::all();
=> Illuminate\Database\Eloquent\Collection {#2908
all: [
App\Article {#2909
id: 1,
login_id: “user1”,
role: “master”,
name: “taniguchi”,
password: “passowrd”,
mail: “laravel@gmail.com”,
test_mail: “laravel_test@gmail.com”,
updated_person: “sasaki”,
created_at: “2018-09-21 21:39:07”,
updated_at: “2018-09-21 21:39:07”,
},
],
}
なるほど♪
mysqlにも入っています。
mysql> select * from articles;
+—-+———-+——–+———–+———-+——————-+————————+—————-+———————+———————+
| id | login_id | role | name | password | mail | test_mail | updated_person | created_at | updated_at |
+—-+———-+——–+———–+———-+——————-+————————+—————-+———————+———————+
| 1 | user1 | master | taniguchi | passowrd | laravel@gmail.com | laravel_test@gmail.com | sasaki | 2018-09-21 21:39:07 | 2018-09-21 21:39:07 |
+—-+———-+——–+———–+———-+——————-+————————+—————-+———————+———————+
1 row in set (0.00 sec)