What is Tinker? How to Insert Data using Tinker?
In this tutorial i’m going What is tinker and why using it and how to insert data using of tinker in easy way. I’m going to describe each of every thing from sctatch so please follow these tutorials.
What is Tinker?
Tinker Command(php artisan tinker) is used to interact directly with the database table to insert, delete, update data. It executes SQL commands through the command line.
First let’s go to install laravel project
composer create-project --prefer-dist laravel/laravel tinker"5.8.*"
After Installation setup database So go to the .env file and add the database credentials. lets go to .env folder and put database name and connect to database.
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=crud-operation
DB_USERNAME=root
DB_PASSWORD=
Now Create Post table
php artisan make:migration create_posts_table --table=posts
Next go to your create_posts_table and add below column
$table->bigIncrements('id');
$table->integer('user_id')->unsigned();
$table->string('title');
$table->text('content');
$table->timestamps();
Now migrate the table.
php artisan migrate
Next go to your terminal and run below command.
php artisan tinker
Just paste below code as define.
$post = App\Post::create(['title'=>'php post tinker','content'=>'php content store tinker']);
Thanks i hope it’s helpfull for you 👍👍