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

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 Kumar Thakur Experienced as s Software Developer with a demonstrated history of working in the information technology and services industry. Skilled in HTML, CSS, Bootstrap4, PHP, Laravel-9 , REST API,FB API,Google API, Youtube Api, Bitbucket,Github,Linux and jQuery. Strong engineering professional focused in Computer/Information Technology Administration and Management. Currently my profile is to Software Developer, analyze the requirement, creating frame for web application, coding and maintenance.

Related Posts

Best DevOps Freelancer in the World

In the dynamic and ever-evolving world of DevOps, finding individuals who not only excel in their technical capabilities but also lead with innovation and insight is rare….

File structure of drupal | Basic Directory Structure of a Drupal ?

What is Drupal ? Drupal is a popular open-source content management system (CMS) written in PHP and built upon the Symfony framework. It is used worldwide to…

How to send attachment files to email using laravel | Upload Document and send Mail in Laravel

In this tutorial im going to demonstrate how to upload document and send data via Email. Please follow some easy steps mentioned below. First let’s go to…

Top 25 Linux Commands for Users ?

In this tutorial i’m going to share Top 50 Important Linux Command for users with example. 1. Use of ls -la command. The ls -la command is…

XAMPP: Starting ProFTPD…/opt/lampp/share/xampp/xampplib: line 22: netstat: command not foundfail.

In this tutorial we’re going to solve the error XAMPP: Starting ProFTPD…/opt/lampp/share/xampp/xampplib: line 22: netstat: command not foundfail. Solution :- Next to restart the server

SQLSTATE[HY000] [2002] No such file or directory (Connection: mysql, SQL: insert into `oauth_clients` (`user_id`, `name`, `secret`

In this tutorial we are going to solve error SQLSTATE[HY000] [2002] No such file or directory (Connection: mysql, SQL: insert into oauth_clients (user_id, name, secret error: –…

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x