Laravel小记

1.创建表:

php artisan migrate:make create_movies_table

目录app/database/migrations/下生成一个表文件,它有一个up()和down()函数,down()是up的反向操作,比如说创建字段 > 移除字段

2.创建字段

public function up() { Scheme::create('movies', function($table){ $table->incretments('moive_id'); }); } public function down() { Schema::drop('movies'); }

3.生成表

php artisan migrate

回滚操作

php artisan migrate:rollback

4.创建表,并执行Schema的操作

php artisan migrate:make create_reviews_table --create=reviews

app/database/migrations/下多了个表文件

class CreateReviewsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('reviews', function(Blueprint $table) { $table->increments('id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('reviews'); } }

执行php artisan migrate

5.修改表,添加字段

php artisan migrate:make add_movie_title_to_movies_table --table=movies

执行后

class AddMovieTitleToMoviesTable extends Migration{ /** * Run the migrations. * @return void */ public function up(){ Schema::table('movies', function(Blueprint $table){ $table->string('movie_title', 150);//长度150 }) } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('movies', function(Blueprint $table) $table->dropColumn('movie_title');//自己添加 ); } }

6.添加数据

<?php class MovieTableSeeder extends Seeder { public function run() { $data = array( array('movie_title' => '魔戒'), array('movie_tile' => '冰与火'), array('movie_tile' => '龙珠') ); DB:table('movies')->insert($data); } } <?php class DatabaseSeeder extends Seeder { /** * Run the database seeds * @return void */ public function run() { Eloquent::unguard(); $this->call('MovieTableSeeder'); } }

执行php artisan db:seed

7.添加常用字段

$table->increments('movie_id');//设置主键 $table->string('movie_title'); $table->text('movie_content'); $table->integer('movie_budget')->unsigned(); $table->data('movie_date')->default('0000-00-00'); $table->primary('movie_id');//设置主键,与increments一样,不可重用 $table->timestamps();

php artisan migrate:reset 重置所有表