Laravel - Unable to fetch data in blade from Oracle

Question

I want to fetch data from a view in Oracle, SQL query in controller is as follows :

$cnx = DB::connection('oracle');
$outs = $cnx->select("SELECT client FROM M_CLIENT 
                      WHERE INSTR(STATUS, 'OUT')>0 
                      AND DPTID=:dptid",['dptid'=>$dptId[0]->dptid]);

and the return : return view('clients.home', compact('outs'));

But if I loop though outs in controller

for ($i=0; $i < count($outs); $i++) { 
            print_r($outs[$i]->client );
            echo '<br/>';
        }

I get the list of clients as wanted

While in blade, I tried :

@for ($i = 0; $i < 3; $i++)
   <tr>
     <td> {{ $outs[$i]['client'] }} </td>
   </tr>
@endfor

and :

@foreach($outs as $out)
   <tr>
     <td> {{ $out['client'] }} </td>
   </tr>
@endforeach

and :

@foreach($outs as $out)
   <tr>
     <td> {{ $out->client }} </td>
   </tr>
@endforeach

I get a blank page with 500 server error.

PS: The output of dd($outs) is :

array:7 [▼
0 => {#1290 ▼
    +"client": "Client1: OUT"
  }..

1K412 · Accepted Answer · 2022-04-09 12:39:09Z

0

Problem fixed

Forgot about /storage/logs/laravel.log where log errors are written.. Turned out some code wrapped in comment in blade was being executed, and The right code in blade is

@foreach($outs as $out)
   <tr>
     <td> {{ $out->client }} </td>
   </tr>
@endforeach

answered Apr 9, 2022 at 12:39

1K412

471 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel - Unable to fetch data in blade from Oracle

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related