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

--

--

--

Hi I am Amit Experienced Web Developer with a demonstrated history of working in the information technology and services industry.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Share Your Search Results with Your Neighbours

Best Angular Question and Answer (Update)

Parsing JSON in Dart/Flutter

Setting up laravel-websockets on production server using nginx proxy with letsencrypt ssl

The Difference Between For Loops and While Loops in JavaScript

Web Scraping With Node.js: How To Scrape Websites/Apps With Puppeteer & Node.js

Web scraping with Node.js and Puppeteer Chromium Library

Muuri.js — responsive, sortable, filterable, draggable and animated layout

Javascript String, number, array

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Amit Kumar

Amit Kumar

Hi I am Amit Experienced Web Developer with a demonstrated history of working in the information technology and services industry.

More from Medium

In The Beginning…

Assemble Web applications with HTML 5

How to Avail GitHub Student Developer Pack — A Complete Guide

IELTS Complicated Sentences- Easy Ways to Create & Use It in IELTS Writing