anilkumarthakur60

try with this

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">

try with this

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">

$entities = Entity::where('user_id', $user_id)->sum('bills_sum_pa_amount')->get();

when I am doing @console.log(id) I am not getting the id of that input filed while view source everything is all right here is my code

  <div class="card-header">Ajax todo List <a href="" id="addnewlist" class=" btn btn-sm btn-danger float-right" data-toggle="modal" data-target="#mymodal"><i class="fa fa-plus" aria-hidden="true"></i></a> </div>
            <div class="card-body" id="items">
              <ul class="list-group">
                  @foreach ($items as $todoitem)
                  <li class="list-group-item ouritem"data-toggle="modal" data-target="#mymodal"><span class="badge badge-danger">{{ $todoitem->id }}</span> {{$todoitem->item  }}</li>
                  <input type="hidden" name="" id="itemid" value="{{ $todoitem->id }}">
                  @endforeach

              </ul>
               </div>
          </div>


<!-- Modal -->
<div class="modal fade" id="mymodal" tabindex="-1" role="dialog" aria-labelledby="mymodal" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="title" >Todo add new item </h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">
          <input type="hidden" name="" id="id">
        <input type="text" name="" placeholder="Enter item here" class="form-control" id="additem">
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-warning" data-dismiss="modal" id="delete" style="display: none" >Delete</button>
        <button type="button" class="btn btn-primary " style="display: none" id="savechanges">Save changes</button>
        <button type="button" class="btn btn-primary" id="addbutton" data-dismiss="modal">Add item</button>
      </div>
    </div>
  </div>
</div>
@csrf


    <script>
      $(document).ready(function(){
        $(document).on('click','.ouritem',function (event) {
            var text=$(this).text();
            // var id=$(document.getElementById('itemid')).val();
            var id=$(this).find('#itemid').val();
            $('#title').text('edit item');
            $('#additem').val(text);
            $('#delete').show('400');
            $('#savechanges').show('400');
            $('#addbutton').hide('400');
            $('#id').val(id);
            console.log(text);

        });

        //hide shavechanges and delete button on click addnewlist id
        $(document).on('click','#addnewlist',function (event) {
            $('#title').text('Add New item');
            $('#additem').val("");
            $('#delete').hide('400');
            $('#savechanges').hide('400');
            $('#addbutton').show('400');

          });

          //ajax add
        $('#addbutton').click(function(event){
            var text=$('#additem').val();
            $.post('list',{'text':text,'_token':$('input[name=_token]').val()},
                function (data, textStatus, jqXHR) {
                },
                "dataType"
            );
            console.log(text);
            $('#items').load(location.href +' #items');
        });

        $('#delete').click(function (event) {
            var id=$('#id').val();
            console.log(id); //unable to get id in console
          
        });







      });

    </script>

@foreach ($products as $product)
<img src="{{asset('/storage/'.$product->image)}}" alt="">

@endforeach

make sure your storage folder is linked

@foreach ($products as $product)
<img src="{{asset('/storage/'.$product->image)}}" alt="">

@endforeach

make sure your storage folder is linked

in 1st controller i put that data in session and access that data in second controller

in 1st controller i put that data in session and access that data in second controller

in the blade file, I have a form with input as the date

 <form action="{{ route('searchreportresultdate') }}" method="POST" >
                             @csrf
                            <div class="modal-body pd-20">
                                <div class="form-group">
                                    <label for="brand name">Seach By Date</label>
                                    <input type="date" required name="date" id="name" value="" class="form-control">
                                </div>

                            </div>
                            <div class="modal-footer">
                                <button type="submit" class="btn btn-info pd-x-20">Submit</button>
                           </div>

                        </form>

in the controller, i want to check the date passed from the form and product created timestamp(created_at)

while dd($result) i am getting nothing

   public function searchreportresultdate(Request $request){
        $date=$request->date; //=2021-2-20
        $result=Product::where('status',1)->where('created_at',$date)->get();

        dd($result);

     }

i think the date in the database is in y-m-d h:m:s how that h:m:s can be excluded and get the only created_at in format=Y-m-d

how about trying

  <a href="{{route('category.index', [$category->id, $category->slug])}}">
                {{$category->name}} <span>({{$category->count()}})</span>
              </a>

i want to get sum of column data when payment_status field=1

   public function gettotalvalue(){
    
        $received_amount=Order::where('payment_status',1)
                                ->select('orders.amt')
                                ->get();
        	//sum of $received_amount
        return view('admin.order.transactiondone')->with('amounts',$received_amount);

}

so i need to pass the data from first controller to second controller so that i can push that data from second controller to database

make sure you have done

php artisan storage:link

if you have linked then

<img src="{{ asset('/stoage/'.$p->document) }}"/> 

might work for you

order model is working fine ... need to insert shipping detail after successful payment

1st controller

class PaymentController extends Controller
{
    public function paymentprocess(paymentRequest $request){
        $name=$request->name;
		$email=$request->email;
$phone=$request->phone;
$city=$request->city;
$address=$request->address;
$payment=$request->payment;

        if ($payment=='esewa') {
            toastr()->success('payment method esewa');
           return view('pages.payment.esewa')->with('cartcontent',Cart::content());
        }
        elseif($request->payment=='khalti') {
            toastr()->success('payment method khalti');
            return view('pages.payment.khalti');
        }
        elseif($request->payment=='cashondelivery'){
            toastr()->success('payment method cash ondelivery');
            return view('pages.payment.cashondelivery');

        }

    }
    //
}

2nd controller

class EsewaController extends Controller
{
  public function success(Request $request){

        $setting=Setting::first();

        foreach (Cart::content() as $carts) {
            $rowid=$carts->rowId;
            }

        if(isset($request->oid) && isset($request->amt) && isset($request->refId)){


               $refId=$request->refId;
               if($request->session()->has('coupon')){
                $balance =$request->session()->get('coupon')['balance'];
                    $amt=number_format($balance*(1+$setting->vat/100)+$setting->shipping_charge,2);

                 }else{
                     $amt=Cart::subtotal()*(1+$setting->vat/100)+$setting->shipping_charge;
                 }

            $url = "https://uat.esewa.com.np/epay/transrec";

            $data =[

                    'amt'=>$amt,
                    'rid'=>$refId,
                    'pid'=>$rowid,
                    'scd'=> 'EPAYTEST'
                ];


                $curl = curl_init($url);
                curl_setopt($curl, CURLOPT_POST, true);
                curl_setopt($curl, CURLOPT_POSTFIELDS, $data);
                curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
                $response = curl_exec($curl);

                curl_close($curl);


                if(strpos($response,'Success')==true){
                    $user_id=Auth::id();
                      Order::create(['user_id'=>$user_id,'amt'=>$request->amt,'oid'=>$request->oid,'refId'=>$request->refId,'status'=>1,'payment_method'=>'esewa']);
                     // $info=$this->paymentprocess(); i can access paymentprocess method data here i can insert here
                     // Shipping::create(['order_id'=>$info->oid,'name'=>$info->name,'phone'=>$info->phone,'email'=>$info->email,'city'=>$info->city,'address'=>$info->address,'payment'=>'esewa']);
                      toastr()->success('payment success and your order has been placed ');
                      return redirect(route('index'));

                }else{
                  toastr()->warning('Transaction failled try again');
                  return view('pages.payment')->with('cartconten',Cart::content());
                }

            }


    }
}

i want to get data from the controller PaymentController @paymentprocess method to EsewaController @success method in paymentprocess method data is being sent from the form as name email phone address city and these data is needed to insert in the shipping table after the successful payment . in success method i am geeting data from the online payment gateway so i need to access the data from the paymentprocess method how can i do that help me

mistakely i clicked in the best answer i was trying to reply to you

make sure you have done

php artisan storage:link

if you have linked then

<img src="{{ asset('/stoage/'.$p->document) }}"/> 

might work for you

you want to fetch only aba North and aba South, exclude rest?

$lgas=Lga::orderBy('state')->select('tabe_name.lga')->get();

in the second controller I am getting data from the online payment gateway, not from the form, I need to store data after successful payment in the second controller from the 1st controller

1st controller is

 public function paymentprocess(paymentRequest $request){
  $data=array();
        $data['name']=$request->name;
        $data['phone']=$request->phone;
        $data['email']=$request->email;
        $data['city']=$request->city;
        $data['address']=$request->address;
        $data['payment']=$request->payment;

        if ($request->payment=='esewa') {
            toastr()->success('payment method esewa');
           return view('pages.payment.esewa')->with('cartcontent',Cart::content());
        }

    }

2nd controller is

i want to get $data value in 2nd controller from 1st controller

  public function success(Request $request){
//get data from $data array in this controller from  1st controller
}

$data= //your data ;

return  response()->json($data);

this will give you data in JSON format

provie the view page source of image

when i am passing the session data in to input value i am getting error invalid

@if (Session::has('coupon'))
 <input value="{{(Session::get('coupon')['balance'])*(1+$setting->vat/100)+$setting->shipping_charge}}" name="tAmt" type="hidden">
 <input value="{{(Session::get('coupon')['balance'])*(1+$setting->vat/100)+$setting->shipping_charge}}" name="amt" type="hidden">
  @else
        <input value="{{Cart::subtotal()*(1+$setting->vat/100)+$setting->shipping_charge}}" name="tAmt" type="hidden">
           <input value="{{Cart::subtotal()*(1+$setting->vat/100)+$setting->shipping_charge}}" name="amt" type="hidden">
  @endif

<img src="{{ asset('/storage/'.$school->logo_path) }}" alt="">

I have a shopping cart package, I want to get all id in the concatenated form to send all id in form for the payment also I want to have the same concatenate id in the controller to check for that id

@foreach ($cartcontent as $cart)
{{ $id=$cart->id }}
@endforeach
{{$id}} //in concatenate form 

in controller

foreach (Cart::content() as $carts) {
    $id=$carts->id;
}
$id= ? // concatenate form 

this might be error due to type casting ...thousand separator in cart.php ...without removing thousand separator in cart.php can't be done

   public function coupon(Request $request){
        $coupon=$request->coupon;
        $check=Coupons::where('coupon',$coupon)->first();
        if($check){
            $name=$check->coupon;
            $discount=$check->discount;
            $balance=Cart::subtotal()-$discount;
            Session::put('coupon',['name'=>$name,'discount'=>$discount,'balance'=>$balance]);
            toastr()->success('Coupon applied successfully');
            return  redirect()->back();
        }
        else{
            toastr()->error('Coupon invalid or  unavailable');
            return redirect()->back();
        }


     }

make middleware for each role

i am doing ecommerce project ,for the product i have setup 4 images per products but while updating the product image it gets updated but non updated imge gets deleted my model is

    public function delete_images(){
        Storage::delete($this->product_image_1);
        Storage::delete($this->product_image_2);
        Storage::delete($this->product_image_3);
        Storage::delete($this->product_image_4);
    }

controller is

  public function update(editProductRequest $request, Products $product)
    {
        $data=$request->only([
                                'category_id',
                                'subcategory_id',
                                'brand_id',
                                'product_name',
                                'product_code',
                                'product_quantity',
                                'product_detail',
                                'product_color',
                                'product_size',
                                'selling_price',
                                'discount_price',
                                'video_link',
                                'main_slider',
                                'hot_deal',
                                'best_rated',
                                'mid_slider',
                                'hot_new',
                                'trend',

                                'status']);

        if($request->hasFile('product_image_1')){

            $product_image_1=$request->product_image_1->store('products','public');
            $product->delete_images();
            $data['product_image_1']=$product_image_1;

        }
        if($request->hasFile('product_image_2')){
            $product_image_2=$request->product_image_2->store('products','public');
            $product->delete_images();

            $data['product_image_2']=$product_image_2;

        }
        if($request->hasFile('product_image_3')){
            $product_image_3=$request->product_image_3->store('products','public');
            $product->delete_images();

            $data['product_image_3']=$product_image_3;

        }
        if($request->hasFile('product_image_4')){
            $product_image_4=$request->product_image_4->store('products','public');
            $product->delete_images();

            $data['product_image_4']=$product_image_4;

        }
        $product->update($data);
        toastr()->success('Product updated successfully');
        return redirect(route('products.index'));



    }

how can i correct it

use Cart;

in addtocart controller resolved my problem

use Cart;

in addtocart controller resolved my problem

i installed the package shopping cart package

bumbummen99/shoppingcart

blade file with ajax ,

@foreach($products as $product)
  <button class="addwishlist" data-id="{{ $product->id }}">
                                                    <div class="product_fav"><i class="fas fa-heart"></i></div>
     </button>
@endforeach

  <script src="https://code.jquery.com/jquery-3.5.1.min.js" integrity="sha256-9/aliU8dGd2tb6OSsuzixeV4y/faTqgFtohetphbbj0=" crossorigin="anonymous"></script>

<script>
    $(document).ready(function(){
        $('.addtocart').on('click',function(){
            var id=$(this).data('id');

            if(id){
                $.ajax({
                    url:"{{url('add/to/cart/')}}/"+id,
                    type:"GET",
                    dataType:'json',

                    success:function(data){

                        const Toast = Swal.mixin({
                                toast: true,
                                position: 'top-end',
                                showConfirmButton: false,
                                timer: 3000,
                                timerProgressBar: true,
                                didOpen: (toast) => {
                                    toast.addEventListener('mouseenter', Swal.stopTimer)
                                    toast.addEventListener('mouseleave', Swal.resumeTimer)
                                }
                                })
                                if($.isEmptyObject(data.error)){

                                Toast.fire({
                                icon: 'success',
                                title: data.success
                                    })
                                }
                                else{
                                    Toast.fire({
                                icon: 'error',
                                title: data.error
                                 })
                                }
                    },
                });
            }else{
                alert('danger');
            }
        });

    });
</script>

route & controller

Route::get('add/to/cart/{id}','Addtocart\[email protected]')

 public function addtocart($id){

        $product=Products::where('id',$id)->first();
        
        $data=array();

        if($product->discount_price==null){
        $data['id']=$product->id;
        $data['name']=$product->product_name;
        $data['qty']=1;
        $data['price']=$product->product_price;
        $data['weight']=1;
        $data['option']['image']=$product->product_image_1;
        Cart::add($data);

        return response()->json(['success'=>'product added to cart']);
        }
        else{
            $data['id']=$product->id;
            $data['name']=$product->product_name;
            $data['qty']=1;
            $data['price']=$product->discount_price;
            $data['weight']=1;
            $data['option']['image']=$product->product_image_1;
            Cart::add($data);
           return response()->json(['success'=>'product added to cart']);

        }


        }

<select class="form-control form-select form-select-sm" name="select_name" aria-label="Default select example">
                        <option selected>Open this select menu</option>
                @foreach($institutions as $institution)
                        <option value="{{ $institution->name }}">{{ $institution->name }}</option>
                @endforeach
</select>

use that name="select_name" in your controller

$section->field_name

composer require realrashid/sweet-alert

'providers' => [
    /*
    * Package Service Providers...
    */
    RealRashid\SweetAlert\SweetAlertServiceProvider::class,
],

Also, add the Alert facade to the aliases array in your app configuration file:

'Alert' => RealRashid\SweetAlert\Facades\Alert::class,

in blade file

@include('sweetalert::alert')

use sweetalert in controller instead in web.php

Route::get('/','[email protected]')

in WelcomeController showalert method as

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Alert;
class WelcomeController extends Controller
{
    public function showalert(){
        alert()->info('Title','Lorem Lorem Lorem');

        return view('welcome');

    }
    //
}

hope this will work

<script>
@if (session('alert'))
    swal("{{ session('alert') }}");
@endif
</script>

shoe me your origional php file where you want to use it may be i can help you

use cdn for sweetalert2

<script src="https://cdnjs.cloudflare.com/ajax/libs/limonte-sweetalert2/10.14.0/sweetalert2.all.min.js" integrity="sha512-LXVbtSLdKM9Rpog8WtfAbD3Wks1NSDE7tMwOW3XbQTPQnaTrpIot0rzzekOslA1DVbXSVzS7c/lWZHRGkn3Xpg==" crossorigin="anonymous"></script>

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/limonte-sweetalert2/10.14.0/sweetalert2.min.css" integrity="sha512-A374yR9LJTApGsMhH1Mn4e9yh0ngysmlMwt/uKPpudcFwLNDgN3E9S/ZeHcWTbyhb5bVHCtvqWey9DLXB4MmZg==" crossorigin="anonymous" />

const swalWithBootstrapButtons = Swal.mixin({
  customClass: {
    confirmButton: 'btn btn-success',
    cancelButton: 'btn btn-danger'
  },
  buttonsStyling: false
})

swalWithBootstrapButtons.fire({
  title: 'Are you sure?',
  text: "You won't be able to revert this!",
  icon: 'warning',
  showCancelButton: true,
  confirmButtonText: 'Yes, delete it!',
  cancelButtonText: 'No, cancel!',
  reverseButtons: true
}).then((result) => {
  if (result.isConfirmed) {
    swalWithBootstrapButtons.fire(
      'Deleted!',
      'Your file has been deleted.',
      'success'
    )
  } else if (
    /* Read more about handling dismissals below */
    result.dismiss === Swal.DismissReason.cancel
  ) {
    swalWithBootstrapButtons.fire(
      'Cancelled',
      'Your imaginary file is safe :)',
      'error'
    )
  }
})

i am using the shopping cart package as

https://packagist.org/packages/bumbummen99/shoppingcart

while migrating the it throws the error

 SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name '' (SQL: create table `` (`identifier` varchar(255) not null, `instance` varchar(255) not null, `content` longtext not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

  at C:\xampp\htdocs\laraecommerce\vendor\laravel\framework\src\Illuminate\Database\Connection.php:671
    668|         // message to include the bindings with SQL, which will make this exception a
    669|         // lot more helpful to the developer instead of just the database's errors.
    670|         catch (Exception $e) {
  > 671|             throw new QueryException(
    672|                 $query, $this->prepareBindings($bindings), $e
    673|             );
    674|         }
    675| 

  1   C:\xampp\htdocs\laraecommerce\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458
      PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ''")

  2   C:\xampp\htdocs\laraecommerce\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458
      PDO::prepare("create table `` (`identifier` varchar(255) not null, `instance` varchar(255) not null, `content` longtext not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'")
PS C:\xampp\htdocs\laraecommerce> php artisan vendor:publish --provider="Gloudemans\Shoppingcart\ShoppingcartServiceProvider" --tag="migrations"
Copied Directory [\vendor\bumbummen99\shoppingcart\src\Database\migrations] To [\database\migrations]
Publishing complete.
PS C:\xampp\htdocs\laraecommerce> php artisan migrate
Migrating: 2018_12_23_120000_create_shoppingcart_table

   Illuminate\Database\QueryException 

  SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name '' (SQL: create table `` (`identifier` varchar(255) not null, `instance` varchar(255) not null, `content` longtext not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

  at C:\xampp\htdocs\laraecommerce\vendor\laravel\framework\src\Illuminate\Database\Connection.php:671
    667|         // If an exception occurs when attempting to run a query, we'll format the error
    668|         // message to include the bindings with SQL, which will make this exception a
    669|         // lot more helpful to the developer instead of just the database's errors.
    670|         catch (Exception $e) {
  > 671|             throw new QueryException(
    672|                 $query, $this->prepareBindings($bindings), $e
    673|             );
    674|         }
    675| 

  1   C:\xampp\htdocs\laraecommerce\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458
      PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ''")

  2   C:\xampp\htdocs\laraecommerce\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458
      PDO::prepare("create table `` (`identifier` varchar(255) not null, `instance` varchar(255) not null, `content` longtext not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'")

while migrating the data base it says the error

 SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name '' (SQL: create table `` (`identifier` varchar(255) not null, `instance` varchar(255) not null, `content` longtext not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

i am using the package called

https://packagist.org/packages/bumbummen99/shoppingcart

i have list of categories in the backend which i want to show in me frondend but its showing error showing as

Undefined variable: categories (View: C:\xampp\htdocs\laraecommerce\resources\views\layouts\menubar.blade.php)

my route is

Route::get('/','frontend\index\[email protected]');

my list of blade file are

app.blade.php inside layouts directory

<!doctype html>
<html lang="en">
  <head>
    <title>Title</title>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

    <!-- Bootstrap CSS -->
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
  </head>
  <body>
      
      @yield('content)

    <!-- Optional JavaScript -->
    <!-- jQuery first, then Popper.js, then Bootstrap JS -->
    <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>
  </body>
</html>

inside pages directory index.blade.php

@extends('layouts.app')
@section('content')

@include('layouts.menubar')
	//content here 
@endsection

menubar.blade.php inside layouts directory

 @foreach ($categories as $category)
                        <ul class="cat_menu">
                            <li class="hassubs">
                                <a href="#">{{ $category->name }}<i class="fas fa-chevron-right"></i></a>
                                <ul>
                                    <li class="hassubs"><a href="#">Menu Item<i class="fas fa-chevron-right"></i></a>  </li>                                </li>
                                    <li><a href="#">Menu Item<i class="fas fa-chevron-right"></i></a></li>
                                    <li><a href="#">Menu Item<i class="fas fa-chevron-right"></i></a></li>
                                    <li><a href="#">Menu Item<i class="fas fa-chevron-right"></i></a></li>
                                </ul>
                            </li>
                        </ul>
 @endforeach

my controller is

class FrontEndIndexController extends Controller
{
    public function index(){
        return view('pages.index');
    }

    public function category(){
        return view('layouts.menubar')->with('categories',Category::all());
    }
}

help me to solve this issue

using ajax

<script type="text/javascript">
    $(document).ready(function(){
   $('select[name="category_id"]').on('change',function(){
        var category_id = $(this).val();
        if (category_id) {

          $.ajax({
            url: "{{ url('/get/subcategory/') }}/"+category_id,
            type:"GET",
            dataType:"json",
            success:function(data) {
            var d =$('select[name="subcategory_id"]').empty();
            $.each(data, function(key, value){

            $('select[name="subcategory_id"]').append('<option value="'+ value.id +'">' + value.name + '</option>');

            });
            },
          });

        }else{
          alert('danger');
        }

          });
    });

</script>

route

Route::get('get/subcategory/{category_id}','Admin\Products\[email protected]');

controller is

 public function GetSubcate($category_id){
      
        $cat=SubCategory::where('category_id',$category_id)->get();
        return json_encode($cat);
        //using route model binding

    }

using ajax

<script type="text/javascript">
    $(document).ready(function(){
   $('select[name="category_id"]').on('change',function(){
        var category_id = $(this).val();
        if (category_id) {

          $.ajax({
            url: "{{ url('/get/subcategory/') }}/"+category_id,
            type:"GET",
            dataType:"json",
            success:function(data) {
            var d =$('select[name="subcategory_id"]').empty();
            $.each(data, function(key, value){

            $('select[name="subcategory_id"]').append('<option value="'+ value.id +'">' + value.name + '</option>');

            });
            },
          });

        }else{
          alert('danger');
        }

          });
    });

</script>

route

Route::get('get/subcategory/{category_id}','Admin\Products\[email protected]');

controller is

 public function GetSubcate($category_id){
      
        $cat=SubCategory::where('category_id',$category_id)->get();
        return json_encode($cat);
        //using route model binding

    }

i want to get only list of subcategories under the selected category while editing the product categories

here is my controller for edit

 public function edit(Products $product)
    {
        return view('admin.products.add')->with('product',$product)->with('categories',Category::all())->with('brands',Brand::all())->with('subcategories',SubCategory::all());
        //
    }

here is my blade file

 <div class="col-lg-4">
                      <div class="form-group mg-b-10-force">
                        <label class="form-control-label">Category: <span class="tx-danger">*</span></label>
                        <select class="form-control select2" required name="category_id" data-placeholder="Choose Category">
                            <option label="Choose Category">Choose Category</option>
                            @foreach ($categories as $category)
                            <option value="{{ $category->id }}" @if (isset($product))
                                @if($category->id==$product->category_id) selected  @endif
                            @endif   >{{$category->name  }}</option>
                            @endforeach

                        </select>
                      </div>
                    </div><!-- col-4 -->


                    <div class="col-lg-4">
                        <div class="form-group mg-b-10-force">
                          <label class="form-control-label">Sub Category: <span class="tx-danger">*</span></label>
                          <select class="form-control select2" required name="subcategory_id" data-placeholder="Choose Sub Category">

                              @if (isset($product))
                                 @foreach ($subcategories. as $subcategory)
                                 <option value="{{ $subcategory->id }}" @if($subcategory->id==$product->subcategory_id) selected  @endif >{{ $subcategory->name }}</option>
                                 @endforeach
                              @endif

                          </select>
                        </div>
                    </div><!-- col-4 -->

<script type="text/javascript">
    $(document).ready(function(){
   $('select[name="category_id"]').on('change',function(){
        var category_id = $(this).val();
        if (category_id) {

          $.ajax({
            url: "{{ url('/get/subcategory/') }}/"+category_id,
            type:"GET",
            dataType:"json",
            success:function(data) {
            var d =$('select[name="subcategory_id"]').empty();
            $.each(data, function(key, value){

            $('select[name="subcategory_id"]').append('<option value="'+ value.id +'">' + value.name + '</option>');

            });
            },
          });

        }else{
          alert('danger');
        }

          });
    });

</script>

while editing the any product, while clicking in the subcategory list it shows list of all subcategories under the selected category

for example i have 20 subcategory under 1st category there is 4 subcategory but while editing list of all categories is showing under previous selected catetegory

$product=DB::table('products') ->join('categories','products.category_id','categories.id') ->join('brands','products.brand_id','brands.id') ->select('products.*','categories.name as category_name','brands.name as brand_name') ->get();

i dont know how to do that ..help me with code

Category table is

Schema::create('categories', function (Blueprint $table) {
            $table->id();
            $table->string('name')->unique();
            $table->timestamps();
        });

brand table is

Schema::create('brands', function (Blueprint $table) {
            $table->id();
            $table->string('name')->unique();
            $table->string('logo');
            $table->timestamps();
        });

my product controller is

      public function index()
    {   
		  $product=DB::table('products')
                ->join('categories','products.category_id','categories.id')
                ->join('brands','products.brand_id','brands.id')
                ->select('products.*','categories.name','brands.name')
                ->get();
                // return response()->json($product);

    	    return view('admin.products.index')->with('products',$product);
        //
    }

my blade file is

 @foreach ($products as $product)
                    <tr>
                        <td>{{ $product->id }} </td>
                        <td>{{ $product->product_name }} </td>
                        <td>{{ $product->category->name }} </td>{{--  display category name --}}
						
                        <td>{{ $product->brand->name }} </td>{{-- display brand name --}}
                        <td>{{ $product->subcategory_id }} </td>
                        <td>{{ $product->brand_id }} </td>
                        <td><img src="{{ asset('/storage/'.$product->product_image_1) }}" height="50px" alt=""> </td>

                        <td>{{ $product->selling_price }} </td>
                        <td>{{ $product->discount_price }} </td>
                        <td>{{ $product->product_code }} </td>

                        <td>@if ($product->status==1)
                                    active
                                    @else
                                    deactive
                                @endif
                        </td>
                        <td>
                            <a href="{{ route('products.edit',$product->id) }}" class="btn btn-sm btn-info mr-2 float-left">Edit</a>
                            <form action="{{ route('products.destroy',$product->id) }}" method="POST">
                                @csrf
                                @method('DELETE')
                                <button type="submit" class="btn btn-sm btn-danger delete-confirm pull-left">Delete</button>
                            </form>
                        </td>
                    </tr>
                    @endforeach

both category field (name) and brand field (name) are same how can i acces both of them in blade file

how can i get the subcategory list while clicking in the category list

here is my route

Route::resource('admindashboard/subcategory','Admin\SubCategory\SubCategoryController');
Route::resource('admindashboard/category','Admin\Category\CategoryController');
Route::resource('admindashboard/products','Admin\Products\ProductController');

here is my blade file

 <div class="col-lg-4">
                      <div class="form-group mg-b-10-force">
                        <label class="form-control-label">Category: <span class="tx-danger">*</span></label>
                        <select class="form-control select2" name="category_id" data-placeholder="Choose Category">
                            <option label="Choose Category">Choose Category</option>
                            @foreach ($categories as $category)
                            <option value="{{ $category->id }}">{{$category->name  }}</option>
                            @endforeach

                        </select>
                      </div>
                    </div><!-- col-4 -->


                    <div class="col-lg-4">
                        <div class="form-group mg-b-10-force">
                          <label class="form-control-label">Sub Category: <span class="tx-danger">*</span></label>
                          <select class="form-control select2" name="subcategory_id" data-placeholder="Choose Sub Category">
			//get list of sub categories while selecting category
                          </select>
                        </div>
                    </div><!-- col-4 -->

here is my product controller

 public function index()
    {
        return view('admin.products.index');
        //
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        return view('admin.products.add')->with('categories',Category::all())->with('brands',Brand::all());
        //
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        //
    }

field name in categories and subcategories are

 public function up()
    {
        Schema::create('categories', function (Blueprint $table) {
            $table->id();
            $table->string('name')->unique();
            $table->timestamps();
        });
    }

 public function up()
    {
        Schema::create('sub_categories', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->integer('category_id');
            $table->timestamps();
        });
    }

i think this can be done through ajax but i dont know help me with code

thank a lot