What is Tinker? How to Insert Data using Tinker?

Posted by

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 👍👍