mysqlのパスワードが分からない時

ログに初期パスワードの記載有無を確認
$ sudo cat /var/log/mysqld.log

ないときは、再設定
$ service mysqld stop
$ mysqld_safe –skip-grant-tables &
$ mysql -u root
$ use mysql;
$ update user set password=PASSWORD(“${password}”) where User=’root’;
$ flush privileges;
$ quit
$ service mysqld stop
$ service mysqld start

パスワード失念した時は、冷静に^^

controllerから変数をviewに渡す

controller

public function contact(){

        $people = ['Edwin', 'Jose', 'James', 'Peter', 'maria'];
        return view('contact', compact('people'));
    }

contact.blade.php

<h1>Contact Page</h1>
	@if (count($people))
	 <ul>
	 @foreach($people as $person)
	 	<li>{{$person}}</li>
	 @endforeach
	 </ul>
	@endif

bladeの中での書き方が特殊なので、慣れるまで少し時間がかかるやもしれません。

layout/app.blade.php

<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title>Document</title>
</head>
<body>
	<div class="container">
		@yield('content')
	</div>

	@yield('footer')
</body>
</html>

extendsでincludeして、sectionで入れる

@extends('layouts.app')

@section('content')

<h1>Contact Page</h1>

@endsection

javascriptも同じ
scriptタグで書いていく

@section('footer')
<script>alert('hello visitor')</script>

@endsection

Laravelでcontrollerからviewにデータを渡す

変数の$idとその名前’id’を一緒に渡す

public function show_post($id){
        return view('post')->with('id', $id);
    }

post.blade.php

<div class="container">
		<h1>Post {{ $id }}</h1>
	</div>

databaseから値を持ってくる際は、変数をfunctionの中で定義するが、routingの場合も仕組みは同じ
with(‘id’, $id)は、compact(‘id’)とも書ける

return view('post', compact('id'));

表示は、->with(‘id’, $id) と同じ

複数渡す場合

Route::get('post/{id}/{name}/{password}', 'PostsController@show_post');

public function show_post($id, $name, $password){
        // return view('post')->with('id', $id);
        return view('post', compact('id','name','password'));
    }

<div class="container">
		<h1>Post {{ $id }} {{ $name }} {{ $password }}</h1>
	</div>

It’s sweet, isn’t it!

Laravel View

controller

    public function contact(){
        return view('contact');
    }

route

Route::get('/contact', 'PostsController@contact');

contact.blade.php

<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title>Document</title>
</head>
<body>
	<div class="container">
		<h1>Contact Page</h1>
	</div>	
</body>
</html>

はじめの一歩です

routeからcontrollerへのデータパス

getでcontrollerを呼ぶとき

Route::get('/post', 'PostsController@index');

public function index()
    {
        return "its working";
    }

ここで、routeからデータを渡したい
ブランケットで囲むとデータを引き継げる

Route::get('/post/{id}/', 'PostsController@index');

indexがfunction

public function index($id)
    {
        return "its working with" . $id;
    }

php artisan一覧

$ php artisan
Laravel Framework version 5.2.45

Usage:
command [options] [arguments]

Options:
-h, –help Display this help message
-q, –quiet Do not output any message
-V, –version Display this application version
–ansi Force ANSI output
–no-ansi Disable ANSI output
-n, –no-interaction Do not ask any interactive question
–env[=ENV] The environment the command should run under.
-v|vv|vvv, –verbose Increase the verbosity of messages: 1 for normal output, 2 for more verbose output and 3 for debug

Available commands:
clear-compiled Remove the compiled class file
down Put the application into maintenance mode
env Display the current framework environment
help Displays help for a command list Lists commands
migrate Run the database migrations
optimize Optimize the framework for better performance
serve Serve the application on the PHP development server
tinker Interact with your application
up Bring the application out of maintenance mode
app
app:name Set the application namespace
auth
auth:clear-resets Flush expired password reset tokens
cache
cache:clear Flush the application cache
cache:table Create a migration for the cache database table
config
config:cache Create a cache file for faster configuration loading
config:clear Remove the configuration cache file
db
db:seed Seed the database with records
event
event:generate Generate the missing events and listeners based on registration
key
key:generate Set the application key
make
make:auth Scaffold basic login and registration views and routes
make:console Create a new Artisan command
make:controller Create a new controller class
make:event Create a new event class
make:job Create a new job class
make:listener Create a new event listener class
make:middleware Create a new middleware class
make:migration Create a new migration file
make:model Create a new Eloquent model class
make:policy Create a new policy class
make:provider Create a new service provider class
make:request Create a new form request class
make:seeder Create a new seeder class
make:test Create a new test class
migrate
migrate:install Create the migration repository
migrate:refresh Reset and re-run all migrations
migrate:reset Rollback all database migrations
migrate:rollback Rollback the last database migration
migrate:status Show the status of each migration
queue
queue:failed List all of the failed queue jobs
queue:failed-table Create a migration for the failed queue jobs database table
queue:flush Flush all of the failed queue jobs
queue:forget Delete a failed queue job
queue:listen Listen to a given queue
queue:restart Restart queue worker daemons after their current job
queue:retry Retry a failed queue job
queue:table Create a migration for the queue jobs database table
queue:work Process the next job on a queue
route
route:cache Create a route cache file for faster route registration
route:clear Remove the route cache file
route:list List all registered routes
schedule
schedule:run Run the scheduled commands
session
session:table Create a migration for the session database table
vendor
vendor:publish Publish any publishable assets from vendor packages
view
view:clear Clear all compiled view files

make, migrate以外にもたくさんありますね。

Laravel Controller：–resource

filename:camelcase

namespace
-> namespace is wide scope does for variable basically allow

名前の集合を分割することで衝突の可能性を低減しつつ参照を容易にする概念

namespace App\Http\Controllers;

use
-> right to import that specific class or name space

use Illuminate\Foundation\Bus\DispatchesJobs;
use Illuminate\Routing\Controller as BaseController;
use Illuminate\Foundation\Validation\ValidatesRequests;
use Illuminate\Foundation\Auth\Access\AuthorizesRequests;
use Illuminate\Foundation\Auth\Access\AuthorizesResources;

artisanコマンドでの作成
$ php artisan make:controller PostsController

–resouceとすると、index(), function create(), store(Request $request), show($id), edit($id), update(Request $request, $id), destory($id)ができる
$ php artisan make:controller –resource PostsController

なるほど、method名がdeleteではなくdestroyってのは若干違和感を感じるが、こんなもんかしらね。

Laravel Route

基礎をやります。
パラメーターを渡す。

Route::get('/post/{id}/{name}', function($id, $name){
	return "this is post number " . $id . "," . $name;
});

asで引数を渡す。
パスが長い場合は書き換える

Route::get('/admin/posts/example', array('as'=>'admin.home', function(){
	$url = route('admin.home');
	return "this url is" . $url;

}));

php artisan route:listで表示

$ php artisan route:list
+——–+———-+———————+————+———+————+
| Domain | Method | URI | Name | Action | Middleware |
+——–+———-+———————+————+———+————+
| | GET|HEAD | / | | Closure | web |
| | GET|HEAD | about | | Closure | web |
| | GET|HEAD | admin/posts/example | admin.home | Closure | web |
| | GET|HEAD | post/{id}/{name} | | Closure | web |
+——–+———-+———————+————+———+————+

Github wikiの活用とブログとの切り分け

git hub wikiにプロジェクトのドキュメントを書いていく
記事単位のブログと違って、ページ単位だから、ノウハウ系のドキュメントはブログよりも管理しやすく、後から振り返る時も分かり易いかも。。

ブログはメモ、トラブルシューティング、自由日記みたいな感じだが、github wikiはどちらかというと、体系立てて、よりフォーマルな記述か。。