[Solved] Retrieve image long raw datatype stored in oracle database in php

I’m using this same functionality in one of my project, please check my code below you can either make a page that will render the image <img src=”https://stackoverflow.com/questions/50098121/image.php?id=123″ /> That image.php page would have this: $sql = “SELECT image FROM images WHERE image_id = ” . (int) $_GET[‘id’]; $stid = oci_parse($conn, $sql); oci_execute($stid); $row = … Read more

[Solved] resource controller, pass multiple parameters using AJAX

You can add that specific route above the resource (I’m assuming you are using GET for your ajax requests): Route::group(array(‘prefix’ => ‘api/v1’), function(){ Route::get(‘event/{start}/{end}’, ‘EventController@index’); Route::resource(‘event’, ‘EventController’); }); In your controller, make your parameters optional so you can use the same controller action for both routes, api/v1/event and api/v1/event: <?php class EventController extends BaseController { … Read more

[Solved] convert mysql query to laravel query builder

\DB::table(‘cars’) ->join(‘garage’, ‘garage.id’, ‘=’, ‘cars.garage’) ->where(‘garage.name’, ‘main’) The above solves the garage and cars part, but you never specified what is aliased to p. If p is a different table then you need to add another call to join() and making the following \DB::table(‘cars’) ->join(‘garage’, ‘garage.id’, ‘=’, ‘cars.garage’) //<Other table join goes here for table … Read more

[Solved] I need to get time with hours and minutes [closed]

Make sure you surround the date value with quotes and provide it in ISO format: <input type=”datetime-local” class=”form-control” name=”date” value=”{{$date}}” readonly> Your $date should be in the format 2022-07-31T15:35 for instance. Note the T in the middle. 5 solved I need to get time with hours and minutes [closed]

[Solved] Where I should put the model creation code? [closed]

I would choose Factory. With this pattern you can easily create your new object and along with it anything you need. You juste need to pass the right parameters to your service. check these docs for creating Factory pattern in SYmfony https://symfony.com/doc/current/service_container/factories.html solved Where I should put the model creation code? [closed]

[Solved] How to use json decoded data in blade laravel

You can Decode json data in view.blade.php like this : <tbody> @foreach($vehicles as $vehicle) <tr> <td> @foreach(json_decode($vehicles->plate_number) as $plate) {{ $plate[‘variable_name’] }} @endforeach </td> <td>{{ $vehicles->delivery_capacity }}</td> </tr> @endforeach </tbody> solved How to use json decoded data in blade laravel