2018-10-11

Laravel Create Article

migrations

• use increments to auto_increment id’s value
  • string type can not be null when applying to id
• use timestamp to create two fields
  • created_at
  • updated_at
• when using factory, the table will be automately filled update time and create date to the relative fields

Create Article

// create controller with resource methods
> php artisan make:controller ArticleController --resource
// create model along with migration
> php artisan make:model Article --migration

seeder

• there are two ways to insert data to table via command line

> php artisan db:seed
> php artisan migrate:refresh --seed

• both ways need adding customed seeder to Databaseseeder.php
  • db:seed however only execute seeds run() function
• if you don’t want to use factory to get fake data, you can just use db:seed command to insert your customed data.
• remember to add the seeder you create to Databaseseeder.php

set index to field(migrations)

• belongsTo

 // \database\migrations\2018_10_05_094912_message_board_table.php

$table->unsignedInteger('user_id')->index();

// app\Messageboard.php
	public function user() {
        return $this->belongsTo(User::class);
    }

Laravel