Working with Laravel Database

by | Feb 9, 2021 | Education | 0 comments

When we create database in Laravel, we need to know dealing with Migration. Migration is way for versioning database in Laravel. Inside of Database Migrations there has two files by default. One is for users table and other is for password reset table.
Migration is nothing more than a Migration class and a migration has two method: up() and down()
up() method is dealing Schema structure all database create, edit, update and down() method is dealing opposite of up() method. We can study how to create table from default users table.
For creating default tables in Database we can run this command for creating all tables in Database
php artisan migrate

For creating our own table and migration we can create by this command

php artisan make:migration create_pages_table --create=content

In this command create_pages_table will be migration name &

–create=content will be table name and code will be like this:

class CreatePagesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create(‘content’, function (Blueprint $table) {
            $table->id();
            $table->timestamps();
        });
    }
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists(‘content’);
    }
}
We can also create exactly same table by using model class
Here will be the model class
php artisan make:model Page --migration
Orphp artisan make:model Page -m
Same table will be created
if we get error for php artisan command, we need to write in the ‘app’ folder providers
AppServiceProvider.php
use Illuminate\Support\Facades\Schema;
And in the boot function
public function boot()
{
Schema::defaultStringLength(191)
}
We all know in Laravel we can create login logout just a command
php artisan make:auth
And Login Logout done.

Submit a Comment

Your email address will not be published. Required fields are marked *