If you want to store or insert form data in JSON format in MySQL database in your Laravel applications. And also want to store and download the JSON data of the form by putting it in a JSON file.
So In this tutorial, you will learn how to save/insert JSON data to a txt file & MySQL database and download it from a text (txt) file.
Laravel 10 Create Txt JSON File and Download Tutorial Example
By using the following steps, you can store form data in JSON format in MySQL database in your Laravel application. And store and download the data of the form by putting it in a JSON file.
- Step 1: Create New Laravel 10 Project
- Step 2: Setup Database with Laravel Project
- Step 3: Create Migration and Model File
- Step 4: Run Migration
- Step 5: Define Routes
- Step 6: Create a Controller
- Step 7: Create blade view
- Step 8: Start Development Server
Step 1: Create New Laravel 10 Project
Firstly, Open your terminal and command prompt.
Then you need to execute the following command into it to download and install laravel 10 new project in your server:
composer create-project --prefer-dist laravel/laravel LaravelJson
Step 2: Setup Database with Laravel Project
Once you have installed laravel new project in your server. Now, you need to setup database with laravel project.
So, visit your project root directory and find .env file. Then setup database details like the following:
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=here your database name here
DB_USERNAME=here database username here
DB_PASSWORD=here database password here
Step 3: Create Migration and Model File
In this step, you need to generate one migration and model name file.
So, execute the following command on cmd to create these files:
php artisan make:model Test -m
Once you have created the model and migration file by using the above-given command.
Now, you need to visit app/database/migration directory and find the migration file name create_tests_table.php. Then update the following code into it:
public function up()
{
Schema::create('tests', function (Blueprint $table) {
$table->increments('id');
$table->string('token')->nullable();
$table->text('data')->nullable();
$table->timestamps();
});
}
Step 4: Run Migration
Now, open again your terminal or command prompt.
Then execute the following mirgrtion command into it to create some tables in our database:
php artisan migrate
Step 5: Define Routes
In this step, you need to define two routes in the web.php file.
So, visit app/routes/ directory and open web.php file. Then define the following routes into it:
use App\Http\Controllers\JsonController;
Route::get('laravel-json', [JsonController::class, 'index']);
Route::post('json-file-download', [JsonController::class, 'download']);
Step 6: Create a Controller
In this step, you need to create one controller named JsonController.php.
So execute the following command on command prompt or terminal to create a controller:
php artisan make:controller JsonController
Once you have created controller by using the above given command. Then visit app/http/controllers directory and open JsonController.php file. And add the following methods into it:
<?php
namespace App\Http\Controllers;
use Redirect,Response;
use Illuminate\Http\Request;
use App\Models\Test;
class JsonController extends Controller
{
public function index()
{
return view('json_form');
}
public function download(Request $request)
{
$data = $request->only('name','email','mobile_number');
$test['token'] = time();
$test['data'] = json_encode($data);
Test::insert($test);
$fileName = $test['token']. '_datafile.json';
File::put(public_path('/upload/json/'.$fileName),$test);
return download(public_path('/upload/jsonfile/'.$fileName));
}
}
Note that:- The first method display the form and the second method convert Laravel string form data to json format and saves it to the database.
Step 7: Create a Blade view
In this step, you need to create one blade view name json.blade.php file. So, go to resources/views directory and create a blade view file then add the following code into it:
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="csrf-token" content="{{ csrf_token() }}">
<title>Laravel Store Data To Json Format In Database - Tutsmake.com</title>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />
<style>
.error{ color:red; }
</style>
</head>
<body>
<div class="container">
<h2 style="margin-top: 10px;">Laravel Store Data To Json Format In Database - Tutsmake.com</h2>
<br>
<br>
@if ($message = Session::get('success'))
<div class="alert alert-success alert-block">
<button type="button" class="close" data-dismiss="alert">×</button>
<strong>{{ $message }}</strong>
</div>
<br>
@endif
<form id="laravel_json" method="post" action="{{url('json-file-download')}}">
@csrf
<div class="form-group">
<label for="formGroupExampleInput">Name</label>
<input type="text" name="name" class="form-control" id="formGroupExampleInput" placeholder="Please enter name">
</div>
<div class="form-group">
<label for="email">Email Id</label>
<input type="text" name="email" class="form-control" id="email" placeholder="Please enter email id">
</div>
<div class="form-group">
<label for="mobile_number">Mobile Number</label>
<input type="text" name="mobile_number" class="form-control" id="mobile_number" placeholder="Please enter mobile number">
</div>
<div class="form-group">
<button type="submit" class="btn btn-success">Submit</button>
</div>
</form>
</div>
</body>
</html>
Step 8: Start Development Server
Finally, execute the following command on cmd or terminal to start the development server:
php artisan serve If you want to run the project diffrent port so use this below command php artisan serve --port=8080
Now you are ready to start your laravel app on browser by using the following URLs:
http://localhost:8000/
Or direct hit in your browser
http://localhost/LaravelJson/public
Conclusion
In this comprehensive Laravel tutorial, you will learn how to efficiently store JSON data in a database. By following the step-by-step instructions provided, you will successfully implement a Laravel project that stores data in JSON format within the database. The examples provided in this tutorial have been meticulously designed for optimal performance, ensuring that your code runs quickly and smoothly.
Throughout the tutorial, you will gain a solid understanding of the best practices and techniques for working with JSON data in Laravel. You will explore various approaches to handle JSON formatting and storage, allowing you to choose the most suitable method for your specific application requirements.
By the end of this tutorial, you will have the necessary skills and knowledge to confidently store JSON data in your Laravel project’s database. The lessons learned in this tutorial will enable you to efficiently manage and manipulate JSON data, ensuring the smooth operation of your application while maintaining excellent performance.
Recommended Laravel Posts
If you have any questions or thoughts to share, use the comment form below to reach us.
