How to work with database in Laravel

Steps:

1. Create a MySQL database

2. Open the .env file and set the database connection
3. Run the following command to set project namespace

php artisan app:name todoparrot

4. Create a model named todolist using the following command

php artisan make:model Todolist

5. Open the migration folder and delete all existing file

6. Run the following command to create a migration file for todolist table

php artisan make:migration create_todolist_table

7. Open the migration file and modify up function by the following code

Schema::create('todolists', function(Blueprint $table)
{
$table->increments('id');

$table->string('name');
$table->text('description');
$table->timestamps();
});

8. Run the following command to create the todolist table using migration file

php artisan migrate

9. Run the following command to create migration file for adding new column to todolist table

php artisan make:migration add_note_to_todolist_table --table=todolist

10. Open the migration file and modify the code

public function up()
{
Schema::table('tasks', function(Blueprint $table)
{
$table->string('note');
});
}
public function down()
{
Schema::table('tasks', function(Blueprint $table)
{
$table->dropColumn('note');
});
}

11. Run the migration command again
12. Add the following code in the up function to add new column with order.

$table->string('address', 100)->after('description');

The steps are shown in the following video tutorial.