https://drive.google.com/file/d/1hvvBccVj4HdQ4nK_lhUP2Me-dW32Sd6p/view?usp=sharing
login
https://drive.google.com/drive/folders/1fXjdZycen9c2BmW6wnOk_JNLIzWPs_sD?usp=sharing
Lalu jalankan satu-satu:
php artisan key:generate
php artisan config:clear
php artisan cache:clear
php artisan optimize:clear
public function cetakPdf()
{
$categories = DB::table('categories')
->join('books', 'categories.id', '=', 'books.katID')
->select(
'categories.id',
'categories.nama',
'categories.deskripsi',
'books.penerbit'
)
->get();
$data = [
'title' => 'Daftar Kategori Buku - BooksLover',
'date' => date('d/m/Y'),
'categories' => $categories
];
$pdf = Pdf::loadView('categories.pdf', $data);
return $pdf->stream('categorieslist.pdf');
}
bagian view
<tbody>
@php $no = 1; @endphp
@forelse($categories as $kategoribuku)
<tr>
<td class="text-center">{{ $no++ }}</td>
<td class="text-center">{{ $kategoribuku->id }}</td>
<td>{{ $kategoribuku->nama }}</td>
<td>{{ $kategoribuku->deskripsi ?? '-' }}</td>
<td>{{ $kategoribuku->penerbit ?? '-' }}</td>
</tr>
@empty
<tr>
<td colspan="5" class="text-center">
Data kategori tidak ditemukan.
</td>
</tr>
@endforelse
</tbody>





