PENDAFTARAN - DOWNLOAD

 Berliana Panca Dewi Nurhidayah

5053231028

RPL 

Tugas : Mendownload file PDF dari data list siswa yang mendaftar

KODE 

<?php

// Include library FPDF

require('libs/fpdf.php');

// Buat koneksi ke database

include("config.php");

// Ambil data dari database

$sql = "SELECT * FROM calon_siswa";

$query = mysqli_query($db, $sql);

// Buat instance FPDF

$pdf = new FPDF();

$pdf->AddPage();

$pdf->SetFont('Arial', 'B', 16);

// Header PDF

$pdf->Cell(0, 10, 'Data Pendaftaran Siswa Baru', 0, 1, 'C');

$pdf->Ln(10);

// Header tabel

$pdf->SetFont('Arial', 'B', 12);

$pdf->Cell(10, 10, 'No', 1, 0, 'C');

$pdf->Cell(40, 10, 'Nama', 1, 0, 'C');

$pdf->Cell(50, 10, 'Alamat', 1, 0, 'C');

$pdf->Cell(30, 10, 'Jenis Kelamin', 1, 0, 'C');

$pdf->Cell(30, 10, 'Agama', 1, 0, 'C');

$pdf->Cell(40, 10, 'Sekolah Asal', 1, 1, 'C');

// Isi tabel

$pdf->SetFont('Arial', '', 12);

$no = 1;

while ($siswa = mysqli_fetch_array($query)) {

    $pdf->Cell(10, 10, $no, 1, 0, 'C');

    $pdf->Cell(40, 10, $siswa['nama'], 1, 0);

    $pdf->Cell(50, 10, $siswa['alamat'], 1, 0);

    $pdf->Cell(30, 10, $siswa['jenis_kelamin'], 1, 0, 'C');

    $pdf->Cell(30, 10, $siswa['agama'], 1, 0, 'C');

    $pdf->Cell(40, 10, $siswa['sekolah_asal'], 1, 1);

    $no++;

}

// Output file PDF

$pdf->Output('I', 'Data_Pendaftaran_Siswa.pdf');

?>