Get Data By search for comparing two tables

Question

i'm trying to make a data comparing page, i wanted to get the data by search on each table (theres only two tho), with a single url by using the server-side method. but can't seem to make it work

here's my controller i made each func search for the two table

class CompareController extends Controller{
    public function readSimsCompare(Request $request){
        if(isset($_GET['search'])){
            $search_text = $_GET['search'];
            $penyelenggara = DB::table('penyelenggaras')->where('curr_lic_num','LIKE', '%'.$search_text.'%')->paginate(1);
            return view('comparation', ['penyelenggaraList' => $penyelenggara]);
        }else{
            return view('comparation');
        }
    }
    public function readPemeriksaanCompare(Request $request){
        if(isset($_GET['search-pemeriksaan'])){
            $search_text2 = $_GET['search-pemeriksaan'];
            $ml = DB::table('microwave_links')->where('curr_lic_num','LIKE', '%'.$search_text2.'%')->paginate(1);
            return view('comparation', ['microwaveLinkList' => $ml]);
        }else{
            return view('comparation');
        }
    }

    
}

here's the blade view the view on my web page

@extends('layouts.user_type.auth')

@section('content')


    
        
            Data tidak Sesuai! 
        
        
            {{-- Search ISR SIMS --}}
            
                
                
                    
                   
            
            
                
                    
                        
                            Data SIMS
                        
                    
                
                
                    
                        @if(isset($penyelenggaraList))
                        
                                @if(count($penyelenggaraList) > 0)
                                    @foreach ($penyelenggaraList as $penyelenggara)
                                    
                                    @endforeach
                                @endif
                            
                            
                                        No ISR
                                        
                                            {{  $penyelenggara->curr_lic_num  }}
                                        
                                    
                                    
                                        Link ID
                                        
                                            {{  $penyelenggara->link_id }}
                                        
                                    
                                    
                                        STN Name
                                        
                                            {{ $penyelenggara->stn_name }}
                                        
                                    
                                    
                                        STN Lawan
                                        
                                            {{ $penyelenggara->stasiun_lawan }}
                                        
                                    
                                    
                                        Koor Long
                                        
                                            {{ $penyelenggara->longitude }}
                                        
                                    
                                    
                                        Koor Lat
                                        
                                            {{$penyelenggara->latitude}}
                                        
                                    
                                    
                                        Tx (MHz)
                                        
                                            {{ $penyelenggara->freq }}
                                        
                                    
                                    
                                        Rx (MHz)
                                        
                                            {{ $penyelenggara->freq_pair }}
                                        
                                    
                                    
                                        BW (MHz)
                                        
                                            {{ $penyelenggara->bwidht }}
                                        
                                    
                                    
                                        Merk/Type Perangkat
                                        
                                            {{ $penyelenggara->eq_mdl }}
                                        
                                    
                                    
                                        Keterangan
                                        
                                            
                                        
                                    
                                    
                                        Creation Date
                                        
                                            
                                        
                                    
                        
                        @endif
                    
                
            
        

        
            {{-- Search ISR Pemeriksaan --}}
            
                
                
                    
                   
            
            
                
                    
                        
                            Data Pemeriksaan
                        
                    
                
                {{-- Table 2 --}}
                
                    
                        @if (isset($microwaveLinkList))
                        
                                @if(count($microwaveLinkList) > 0)
                                    @foreach ($microwaveLinkList as $ml)
                                    
                                @endforeach
                            @endif
                        
                            
                                        Client Name
                                        
                                            {{ $ml->client_name }}
                                         
                                    
                                    
                                        Curr Lic Num
                                        
                                            {{ $ml->curr_lic_num }}
                                         
                                    
                                    
                                        Link Id
                                        
                                            {{ $ml->link_id }}
                                         
                                    
                                    
                                        Tanggal
                                        
                                            {{ $ml->tanggal }}
                                         
                                    
                                    
                                        Metode
                                        
                                            {{ $ml->metode }}
                                         
                                    
                                    
                                        No Risalah Hasil
                                        
                                            {{ $ml->no_risalah_hasil }}
                                         
                                    
                                    
                                        Stn Name
                                        
                                            {{ $ml->stn_name }}
                                         
                                    
                                    
                                        Stasiun Lawan
                                        
                                            {{ $ml->stasiun_lawan }}
                                         
                                    
                                    
                                        KOOR Long
                                        
                                            {{ $ml->koor_long }}
                                         
                                    
                                    
                                        KOOR Lat
                                        
                                            {{ $ml->koor_lat }}
                                         
                                    
                                    
                                        TX(mhz)
                                        
                                            {{ $ml->tx_mhz }}
                                         
                                    
                                    
                                        RX(mhz)
                                        
                                            {{ $ml->rx_mhz }}
                                        
                                    
                                    
                                        BW(mhz)
                                        
                                            {{ $ml->bw_mhz }}
                                        
                                    
                                    
                                        Merk Perangkat
                                        
                                            {{ $ml->merk_perangkat }}
                                        
                                    
                                    
                                        Sertifikat
                                        
                                            {{ $ml->sertifikat }}
                                        
                                    
                                    
                                        Status
                                        
                                            {{ $ml->status }}
                                        
                                    
                                    
                                        Keterangan
                                        
                                            {{ $ml->keterangan }}
                                        
                                    
                                
                        @endif
                    
                
            
        
    

 
@endsection

here's the route

//compare
Route::get('/compare/get-sims', [CompareController::class, 'readSimsCompare']);
Route::get('/compare/get-pemeriksaan', [CompareController::class, 'readPemeriksaanCompare']);

Get Data By search for comparing two tables

0 Answers