1.laravel new project (open command prompt on xampp/htdocs directory)
[code language=”sql”]
composer create-project –prefer-dist laravel/laravel projectname
[/code]
2.cd projectname
3.[code language=”sql”]
php artisan make:auth
[/code]
4.Customise users table(database/migration/create_users_table.php)
[code language=”sql”]
$table->bigInteger(‘role_id’)->default(2);
$table->string(‘name’);
$table->string(‘username’)->unique();
$table->string(’email’)->unique();
$table->string(‘password’);
$table->string(‘image’)->default(‘default.png’);
$table->string(‘about’)->nullable();
[/code]
5.Make Model and Migration for Role Table
[code language=”sql”]
php artisan make:model Role -m
[/code]
6.Customise roles table(database/migration/create_roles_table.php)
[code language=”sql”]
$table->string(‘name’);
$table->string(‘slug’);
[/code]
7.Make Relationship between users and roles tables through Role Model and User Model
8. In Role Model create users() Function for Relationship
[code language=”sql”]
public function users()
{
return $this->hasMany(‘App\User’);
}
[/code]
9.In User Model create role() Function for relationship
[code language=”sql”]
public function users()
public function role()
{
return $this->belongsTo(‘App\Role’);
}
[/code]
10.Make UsersTableSeeder file for insert data in users table through migration
[code language=”sql”]
php artisan make:seed UsersTableSeeder
[/code]
11.Make RolesTableSeeder file for insert data in roles table through migration
[code language=”sql”]php artisan make:seed RoleTableSeeder[/code]
12.Edit RoleTableSeeder.php(database/seeds/RoleTableSeeder.php) file for insert data in roles table
[code language=”sql”]
use Illuminate\Support\Facades\DB;
public function run()
{
DB::table(‘roles’)->insert([
‘name’ => ‘Admin’,
‘slug’ => ‘admin’,
]);
DB::table(‘roles’)->insert([
‘name’ => ‘User’,
‘slug’ => ‘user’,
]);
}
[/code]
13.Edit UserTableSeeder.php(database/seeds/UserTableSeeder.php) file for insert data in users table
[code language=”sql”]
use Illuminate\Support\Facades\DB;
public function run()
{
DB::table(‘users’)->insert([
‘role_id’ => ‘1’,
‘name’ => ‘Admin’,
‘username’ => ‘admin’,
’email’ => ‘admin@blog.com’,
‘password’ => bcrypt(‘rootadmin’),
]);
DB::table(‘users’)->insert([
‘role_id’ => ‘2’,
‘name’ => ‘User’,
‘username’ => ‘user’,
’email’ => ‘user@blog.com’,
‘password’ => bcrypt(‘rootuser’),
]);
}
[/code]
14.Set Server and Database Name in .env file
[code language=”sql”]
DB_DATABASE=blog
DB_USERNAME=root
DB_PASSWORD=
[/code]
15.Migration of tables in database
[code language=”sql”]
php artisan migrate
[/code]
php artisan migrate
16.Define UsersTableSeeder and RoleTableSeeder Class on DatabaseSeeder.php file (database/seeds/DatabaseSeeder.php)
[code language=”sql”]
php artisan migrate
[/code]
- Best AI tools for Software Engineers - November 4, 2024
- Installing Jupyter: Get up and running on your computer - November 2, 2024
- An Introduction of SymOps by SymOps.com - October 30, 2024