Hi i have problem when generate pdf report from laravel dom pdf?

dont use shared host
and use git

Which hosting plan is better?

use vultr, digitalocean or bandwagon for starting up, 5 dollars per month doesn’t cost much for me

Thanks alot ✊

if you need referral link, dm me

(except for bandwagon

your choice is open, you can also use aws or azure or any other vps

Am not upgrading now though

</div>
<div class=”card-footer”>
<button class=”btn btn-primary”>Is it ok?</button>
</div>
</div>
</form>

ReportController.php

public function show (Order $order)
{
return view(‘Home.report’, compact(‘order’));
}

public function store (Request $request)
{
$report = new Report($request->all());
$report->date = $request->date;
$report->time = $request->time;
$report->category_id = category_id;
$report->save();
}

Look at my codes.

web.php

Route::get(‘/internets’, ‘InternetController@index’)->name(‘internets’);
Route::post(‘/internets/store’, ‘InternetController@store’)->name(‘internets.store’);

Route::get(‘reports/show/{order}’, ‘ReportController@show’)->name(‘reports.show’);
Route::post(‘reports/store’, ‘ReportController@store’)->name(‘reports.store’);

InternetController.php

public function store(Request $request)
{
if (auth()->check()) {
$order = new Order($request->all());
$order->category_id = $request->category_id;
$order->user_id = auth()->user()->id;
$order->status = 0;
$order->description = $request->description;
$order->save();
alert()->success(‘ok’)->persistent(“ok”);
return redirect()->route(‘reports.show’, $order);
}
}

When I press save button. I see http://localhost:8000/reports/show/5 in address bar.

How to get this 5 for save the order.

show.blade.php

<form action=”{{ route(‘reports.store’) }}” method=”post”>
@csrf
<div class=”card”>
<div class=”table-responsive”>
<table class=”table”>
<thead>
<tr>
<th>first_name </th>
<th>last_name </th>
<th>mobile</th>
<th>city</th>
<th>category name</th>
</tr>
</thead>
<tbody>
<tr>
<td>{{ $order->user->first_name }}</td>
<td>{{ $order->user->last_name }}</td>
<td>{{ $order->user->mobile }}</td>
<td>{{ $order->user->city->city_name }}</td>
<td>{{ $order->categories->name }}</td>
</tr>
</tbody>
</table>
</div>
<div class=”card-body”>
<h3>Expert visit time</h3>
<div class=”row”>
<div class=”col-md-7″>
<div class=”input-group”>
<div class=”input-group-prepend”>
<span class=”input-group-text cursor-pointer” id=”date”>
<i class=”fas fa-calendar-alt”></i>
</span>
</div>
<div class=”row”>
<div class=”col-sm-6″>
<input type=”text” name=”date” id=”inputDate” class=”form-control” placeholder=”date” aria-label=”date” aria-describedby=”date”>
</div>
<div class=”col-md-6″>
<div class=”input-group date” id=”datetimepicker3″ data-target-input=”nearest”>
<input type=”text” name=”time” class=”form-control datetimepicker-input” data-target=”#datetimepicker3″/>
<div class=”input-group-append” data-target=”#datetimepicker3″ data-toggle=”datetimepicker”>
<div class=”input-group-text”><i class=”fas fa-clock”></i></div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class=”col-md-5″>
<p class=”float-left m-0″>{{ $order->description }}</p>
</div>
</div>

public function store(Request $request, $id){
dd($id);
}

you will get the 5

No I get this error

Too few arguments to function AppHttpControllersReportController::store(), 1 passed and exactly 2 expected

sorry, store function is for new data, you should add id on update function, not the store function

Yes that’s normal, look at the route, you have to send the id.

Exactly, you can’t expect to use id if you don’t send it, and in store you are creating a new, so the id is not necessary.

Route::post(‘reports/store/{id}’, ‘ReportController@store’)->name(‘reports.store’);

I added in web.php

Missing required parameters for [Route: reports.store] [URI: reports/store/{id}]. (View: C:xampphtdocsnewkhosravi-shopresourcesviewsHomereport.blade.php)

I get this error

Why you add the id to store function?

I lead him mistakenly, it’s my fault

And you should read about restful, it could help you.

Ok ok.

It is not necessary?

Ask yourself, why you need the id.

（to save the data

Is easy to respond, the thing is that you should learn.

So ask, why or for what you use the id.

Or maybe you are confusing store with update?

Have you anydesk

Yes or no

No

Show the blade where save button is.

Also, according to your code structure, what you are getting is correct

You are getting url/reports/show/5 because you redirected to reports.show. According to your code 5 is the order ID passed to the route.

The question is, if this is not what you want, then what do you want to achieve?

Hi i have problem when generate pdf report from laravel dom pdf? very slow and show error 500

can help me or share advice for fixed problem?

Here is my code

public function print_pdf(Request $request)
{
$start_date = $request->start_date;
$end_date = $request->end_date;

$ppra = DB::select(‘EXEC SPGetPPRA ?,?’, array($start_date, $end_date));

$pdf = PDF::loadView(‘ppra.pdf’, compact(‘ppra’));
// $pdf->setPaper(‘a4’, ‘potrait’);
return $pdf->stream();
}

Get data from stored procedure sql server

what’s the exact error? 500 it’s just error code
just like you tell doctor that you are ill, but you dont tell what you feel

Lol, that’s a different way to “speak but say nothing”

That just means that something went wrong.

Check the error in storage/logs/laravel.log

Oke thanks @skys215

Plz explain how to implement route and path

I dont understand the question

I mean in laravel how to understand route and path

How to give route and when we give route