Laravel

How to checkbox get selected from database table

Ravindra Kumar

In this tutorial I am going to explain how can we get selected checkbox automatically by checking the recording into database table in Laravel. In this tutorial program will checker whether the value of checkbox is already in table or not, If the value is already available in database table it will be checked and if is not available in table it will remain unchecked.so following are the step which you need to follow to make this working.

Step 1

First, You need to create a Laravel project with following artisan command

composer create-project laravel/laravel testPro

testPro is the project name and your project folder name is also testPro

Step 2

Now, Create a database and Table of it.You can specify

In this table you can see there is a column called “cat_name” the ckeckboxed will be compared with this column of table.

Step 3

Now, Create a blade file under resources folder and create controller, routes for your project. In this Blade file you are going to fetch the data from database table.

Step 4

Following is the code to fetch and display the categories from the database table in Blade file of your project.

@foreach($category as $cat)
<input type="checkbox" name="category[]" value="{{$cat->id}}" @if(Str::contains($rec->category, $cat->id)) checked @endif /> {{$cat->cat_name}}<br />
@endforeach

Str::contains() function is used to check weather the category id is already in records or not if it is available in the records, it will be checked otherwise it will remain unchecked.

Ravindra Kumar

Ravindra is a passionate full stack developer and dedicated blogger with a flair for crafting user-friendly web applications and insightful articles. With expertise spanning front-end and back-end technologies, Ravindra brings ideas to life through innovative coding solutions.

Suggested Reading

How to Clear Cache in Laravel Without Using Artisan Commands

When working with Laravel, caching plays a key role in improving your application’s performance by storing compiled configurations, routes, views, and other data. However, during development or after making changes, you may need to clear the cache to see your latest updates. Usually, developers use Artisan commands like php artisan cache:clear or php artisan optimize:clear. […]

Upload (restore/import) a MySQL database backup via the command prompt (CLI)

To upload (restore/import) a MySQL database backup via the command prompt (CLI), you can use the mysql command-line utility. Here’s how: You must follow these requirement You must have a MySQL backup file (e.g., backup.sql) MySQL server should be installed and running You should have credentials for the MySQL user If you are working with […]

How to add new column in laravel migration without losing data

To add a new column in a Laravel migration without losing existing data, you can create a new migration file that alters the existing table. Laravel makes this easy using the php artisan make:migration command with the --table option. Step-by-Step Guide: You can generate a new migration php artisan make:migration add_column_name_to_your_table_name_table --table=your_table_name Replace column_name with […]

imagick php extension must be installed to use this driver in Laravel

It means that your Laravel app (or a package like Intervention Image, Spatie Media Library, or Laravel Snappy) is trying to use the Imagick image processing library, but it’s not installed or enabled on your server. If you’re using Ubuntu/Debian (Linux server): sudo apt-get update sudo apt-get install -y php-imagick sudo service apache2 restart # […]

Attempt to read property “id” on null in Laravel

The error message “Attempt to read property ‘id’ on null” in Laravel typically occurs when you’re trying to access the id property of an object that is null. This commonly happens when you’re expecting an object to be returned (such as a database record), but instead, null is returned. You can handle this null value […]

How to check first record in Laravel blade file

Here’s how to check the first iteration in a Blade @foreach loop: You can use Laravel’s built-in $loop variable: @foreach ($all_categories_ as $vals) <li class="nav-item" role="presentation"> <button class="nav-link p-3 border-0 text-start lh-sm w-100 rounded-0 fs-6 fw-medium {{ $loop->first ? 'active' : '' }}" id="pills-navTab{{ $vals->id }}-tab" data-bs-toggle="pill" data-bs-target="#pills-navTab{{ $vals->id }}" type="button" role="tab" aria-controls="pills-navTab{{ $vals->id }}" […]