Web Prepration

Web Concept Tutorials

Laravel

Here you can study most popular and useful tutorials of Laravel, we have lists of tutorials, Interview Questions and answers of  Laravel.

Larave 9, Laravel, Laravel 7, Laravel 8
Webprepration
30 March 2022
No Comments

In this article, I am going to explain laravel 9 many to many relationship. This tutorial give you simple example of laravel 9 belongstomany tutorial. This tutorial will give you simple example of laravel 9 many to many sync. So in this article, you can understand how to create many-to-many relationships with migration with a foreign key schema for one to many relationships, use sync with a pivot table, create records, attach records, get all records, delete, update, where condition and everything related to many to many relationship. Many to Many Relationship will use  “belongsToMany()”  for relation. So in this example, i will create  “posts”, “category” and “post_category” tables. each table is connected with each other. now we will create many to many relationships with each other by using the laravel Eloquent Model. We will first create database migration, then model, retrieve records and then how to create records too.

read more >>
Laravel, Laravel 7, Laravel 8, Others
Webprepration
8 January 2022
No Comments

In this article, we will cover “How to implement laravel conditional query”. I would like to show your laravel eloquent if condition but laravel added a new function when(), using when() you can ignore to write manually if conditional statement and else statement. I will give you some example how to use it when and how to write if condition with eloquent query builder. you can also use when() with laravel 6, laravel 7 and laravel 8 version: Simple When() Example:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
 
<?php
  
namespace App\Http\Controllers;
  
use App\Models\User;
use Illuminate\Http\Request;
  
class UserController extends Controller
{
    /**
     * Write code on Method
     *
     * @return response()
     */
    public function index(Request $request)
    {
        $users = User::select("*")
                    ->when($request->has('country'), function ($query) use ($request) {
                        $query->where('country', $request->country);
                    })
                    ->get();
  
        dd($users);
    }
}
 

When() Else Example:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
 
<?php
  
namespace App\Http\Controllers;
  
use App\Models\User;
use Illuminate\Http\Request;
  
class UserController extends Controller
{
    /**
     * Write code on Method
     *
     * @return response()
     */
    public function index(Request $request)
    {
        $users = User::select("*")
                    ->when($request->get('order_by') == "created_at", function ($query) {
                            return $query->orderBy('created_at', 'desc');
             }, function ($query) {
                        return $query->orderBy('id', 'desc');
                    })
                    ->get();
  
        dd($users);
    }
}
 

Multiple When() Condition Example:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
 
<?php
  
namespace App\Http\Controllers;
  
use App\Models\User;
use Illuminate\Http\Request;
  
class UserController extends Controller
{
    /**
     * Write code on Method
     *
     * @return response()
     */
    public function index(Request $request)
    {
        $users = User::select("*")
                    ->when($request->has('country'), function ($query) use ($request) {
                        $query->where('country', $request->country);
                    })
                    ->when($request->has('state'), function ($query) use ($request) {
                        $query->where('state', $request->state);
                    })
                    ->when($request->has('name'), function ($query) use ($request) {
                        $query->where('name', 'LIKE', '%' . $request->name .'%');
                    })
                    ->get();
  
        dd($users);
    }
}
 

  WebpreprationI’m a full-stack developer.  My hobby and profession to write blog and programming tips that helps to others. I am a great admirer of PHP, Laravel, Codeigniter, AngularJS,  Vue.js,  Javascript, JQuery, WordPress, Plugin Development, Theme Development and Bootstrap from the early stage.   webprepration.com/

read more >>
Laravel, Laravel 7, Laravel 8
Webprepration
7 January 2022
No Comments
Clear cache in Laravel

In this articale, you will learn how to clear caches in laravel application. In laravel application you can clear cache two types using artisan command and from browsers. I will mention few commands you can use to clear various types of cache like config cache, view cache, route cache and application cache from your laravel application. If you want to clear cache using commnad then open your terminal and go to the laravel application’s folder and execute below commands: Clear Application Cache To clear laravel application cache, run the following artisan command:

1
2
3
 
php artisan cache:clear
 

Clear Route Cache To clear route cache of your Laravel application run the following artisan command:

1
2
3
 
php artisan route:clear
 

Clear Configuration Cache To clear the config cache of your laravel application, run the following artisan command:

1
2
3
 
php artisan config:clear
 

Clear Compiled Views Cache To clear the view cache of your laravel application which are basically compiled view files, run the following

read more >>
Laravel, Laravel 7, Laravel 8
Webprepration
3 January 2022
No Comments

In this article I will be explain “how to generate qr code in laravel”, In this article we will implements qr code in laravel 8. if you want to emplement qr code in your application then you are right place. simplesoftwareio/simple-qrcode simple-qrcode is package for generate qr code in laravel application. simple-qrcode provide to send sms and email with generated qr code. you can create qr code for geo, phoneNumber, birthdate using simple qrcode package. For that we require to install simple-qrcode package for qr code generator in application, So we just need to run below command in terminal.

1
2
3
 
composer require simplesoftwareio/simple-qrcode
 

After that open config/app.php file and add service provider and aliase.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
'providers' => [
 
    ....
 
    SimpleSoftwareIO\QrCode\QrCodeServiceProvider::class
 
],
 
'aliases' => [
 
    ....
 
    'QrCode' => SimpleSoftwareIO\QrCode\Facades\QrCode::class
 
],
 

Next we need to create route for testing qr-code

1
2
3
4
5
6
7
8
9
10
11
12
13
 
<?php
 
 
Route::get('qr-code-test', function () {
  
    \QrCode::size(500)
            ->format('png')
            ->generate('Webprepration', public_path('images/qrcode.png'));    
  return view('qrCode');
    
});
 

Now create a blade file to display the qr code, so let’s create blade file as like bellow code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
 
<!DOCTYPE html>
 
<html>
 
<head>
 
    <title>How to Generate QR Code in Laravel 8? - webprepration.com</title>
 
</head>
 
<body>
 
    
 
<div class="visible-print text-center">
 
    <h1>Laravel 8 - QR Code Generator Example</h1>
 
    
 
    {!! QrCode::size(250)->generate('webprepration'); !!}
 
    
 
    <p>example by webprepration.com</p>
 
</div>
 
    
 
</body>
 
</html>
 

  WebpreprationI’m a full-stack developer.  My hobby and

read more >>
Laravel, Laravel 7, Laravel 8
Webprepration
5 August 2021
No Comments

When we are working on any projects then many times we need to get last executed query, If you are working on laravel framework and use laravel query builder And want to get last executed mysql query from laravel. Then you have to first enable query log that way it can be store query log. At last getQueryLog() through you can get last executed query. I give you example of how to get last executed mysql query. you can use example as following example.

1
2
3
4
5
6
7
8
9
 
public function querylog()
{
DB::enableQueryLog();
$item = Item::find(2);
$last_query = DB::getQueryLog();
print_r($last_query);
}
 

  WebpreprationI’m a full-stack developer.  My hobby and profession to write blog and programming tips that helps to others. I am a great admirer of PHP, Laravel, Codeigniter, AngularJS,  Vue.js,  Javascript, JQuery, WordPress, Plugin Development, Theme Development and Bootstrap from the early stage.   webprepration.com/

read more >>
Laravel
Webprepration
3 August 2021
No Comments

In this post, I am going to explain How to remove foreign key constraint and database column that hosts a foreign key relationship, and we add wrong column with foreign key constraint on table. here, we will remove foreign key constraint using migration in laravel 6, laravel 7 and laravel 8. We can’t remove directly using dropColumn() if column applied foreign key constraint, So we should drop foreign key constraint of that column using dropForeign() and then we can delete column using dropColumn(). You can see as bellw migration, first i added migration with wrong column then other migration for remove that column. Wrong Column Migration:

1
2
3
4
5
6
7
8
9
10
11
12
 
Schema::create('admins', function (Blueprint $table) {
    $table->increments('id');
    $table->string('fullname');
    $table->string('email')->unique();
    $table->string('imagepath');
    $table->string('password', 60);
    $table->integer('post_id')->unsigned();
    $table->foreign('post_id')->references('id')->on('posts')->onDelete('cascade');
    $table->timestamps();
});
 

Drop Column Migration:

1
2
3
4
5
6
 
Schema::table('admins', function (Blueprint $table) {
    $table->dropForeign('admins_post_id_foreign');
    $table->dropColumn('post_id');
});
 

  WebpreprationI’m a full-stack developer.  My hobby and profession to write blog and programming tips that helps to others. I am a great admirer of PHP, Laravel, Codeigniter, AngularJS,  Vue.js,  Javascript, JQuery, WordPress, Plugin Development, Theme Development and Bootstrap

read more >>

Recent Posts

Categories

© Copyright 2019-2022 By Webprepration.com | Web Development Tutorials & Demos. All Right Reserved.