修改配置:./app/config/databases.php中修改mysql的配置
'mysql' => array(
'driver' => 'mysql',
'host' => 'localhost',
'database' => 'laravel',
'username' => 'root',
'password' => 'password',
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => 'cms_',/*表前缀*/
),
2. 使用命令创建表:
php artisan migrate --package=cartalyst/sentry /*创建5张sentry自己的表*/
3.权限系统数据库配置
'Cartalyst\Sentry\SentryServiceProvider',在./app/config/app.php中'providers' => array(增加
'Sentry' => 'Cartalyst\Sentry\Facades\Laravel\Sentry',在./app/config/app.php中'aliases' => array(增加
4.运行命令创建2个数据库迁移文件(有点类似于yii中的migrate的意思)
php artisan migrate:make create_articles_table --create=articles
php artisan migrate:make create_pages_table --create=pages
5.编辑生成的./app/databases/migrations/文件
Schema::create('articles', function(Blueprint $table)
{
$table->increments('id');
$table->string('title');
$table->string('slug')->nullable();
$table->text('body')->nullable();
$table->string('image')->nullable();
$table->integer('user_id');
$table->timestamps(); });
Schema::create('pages', function(Blueprint $table)
{
$table->increments('id');
$table->string('title');
$table->string('slug')->nullable();
$table->text('body')->nullable();
$table->integer('user_id');
$table->timestamps();
});
6.创建表(表建立完成啦)
php artisan migrate /*真心好像yii的 migdate*/
7.创建模型
php artisan generate:model article
php artisan generate:model page
这个时候就在app/model下出现俩个模型类
8.插入数据
php artisan generate:seed page
php artisab generate:seed article
这个时候就在./app/config/seeds下出现2个文件 分别更改着2个文件 /*循环插入10条*/
/*PageTableSeeder.php*/
foreach(range(1, 10) as $index)
{
Page::create([
'title' => $faker->sentence($nbWords = 6),
'slug' => 'first-page',
'body' => $faker->paragraph($nbSentences = 5),
'user_id' => 1,
]);
}
/*ArticleTableSeeder.php*/
foreach(range(1, 10) as $index)
{
Article::create([
'title' => $faker->sentence($nbWords = 6),
'slug' => 'first-post',
'body' => $faker->paragraph($nbSentences = 5),
'user_id' => 1,
]);
}
然后在databaseSeeder.php增加2行
$this->call('ArticleTableSeeder');
$this->call('PageTableSeeder');
执行
php artisan db:send
这样就插入10条数据到2张表中