Tampilan Laporan Data Lab PDF Menggunakan PHP

Tampilan Awal Laporan Data Lab

- Laporan Data Dosen Menggunakan PDF

<?php

//koneksi mysql

mysql_connect("localhost", "root", "");

mysql_select_db("db_labor");

require('fpdf.php');

class PDF extends FPDF {

// Page header

    function Header() {

        // Arial bold 15

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

        // Move to the right

        $this->Cell(60);

        // Title

        $this->Cell(60, 7, 'Laporan Data Dosen', 1, 0, 'C');

        // Line break

        $this->Ln(20);

    }

// Page footer

    function Footer() {

        // Position at 1.5 cm from bottom

        $this->SetY(-15);

        // Arial italic 8

        $this->SetFont('Arial', 'I', 8);

        // Page number

        $this->Cell(0, 10, 'Page ' . $this->PageNo() . '/{nb}', 0, 0, 'C');

    }

}

// Instanciation of inherited class

$pdf = new PDF();

$pdf->AliasNbPages();

$pdf->AddPage();

$pdf->SetFont('Times', '', 8);

$pdf->Cell(60, 10, 'Laporan Dosen', 0, 1,'L');

$pdf->Cell(18, 6,"Nip", 1);

$pdf->Cell(18, 6,"Nama", 1);

$pdf->Cell(20, 6,"Hp", 1);

$pdf->Cell(20, 6,"Jabatan", 1);

$pdf->Cell(20, 6,"Kel Keahlian", 1);

$pdf->Cell(25, 6, "E-Mail", 1, 1, 'L');

$query = mysql_query("select * from tbl_Dosen");

while ($rs = mysql_fetch_array($query)) {

    $pdf->Cell(18, 6, $rs['Nip'], 1);

$pdf->Cell(18, 6, $rs['Nama'], 1);

$pdf->Cell(20, 6, $rs['Hp'], 1);

$pdf->Cell(20, 6, $rs['Jabatan'], 1);

$pdf->Cell(20, 6, $rs['Kel_Keahlian'], 1);

    $pdf->Cell(25, 6, $rs['E-Mail'], 1, 1, 'L');

}

$pdf->Output();

?>

-Laporan Data Alat Menggunakan PDF

<?php

//koneksi mysql

mysql_connect("localhost", "root", "");

mysql_select_db("db_labor");

require('fpdf.php');

class PDF extends FPDF {

// Page header

    function Header() {

        // Arial bold 15

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

        // Move to the right

        $this->Cell(45);

        // Title

        $this->Cell(90, 7, 'Laporan Data Alat Laboratorium Dasar', 1, 0, 'C');

        // Line break

        $this->Ln(20);

    }

// Page footer

    function Footer() {

        // Position at 1.5 cm from bottom

        $this->SetY(-15);

        // Arial italic 8

        $this->SetFont('Arial', 'I', 8);

        // Page number

        $this->Cell(0, 10, 'Page ' . $this->PageNo() . '/{nb}', 0, 0, 'C');

    }

}

// Instanciation of inherited class

$pdf = new PDF();

$pdf->AliasNbPages();

$pdf->AddPage();

$pdf->SetFont('Times', '', 8);

$pdf->Cell(60, 10, 'Laporan Alat', 0, 1,'L');

$pdf->Cell(15, 6,"Kode Alat", 1);

$pdf->Cell(15, 6,"Nama Alat", 1);

$pdf->Cell(15, 6,"Kode Lab", 1);

$pdf->Cell(15, 6,"Nama Lab", 1);

$pdf->Cell(15, 6,"Tgl Masuk", 1);

$pdf->Cell(20, 6,"Tgl Pengajuan", 1);

$pdf->Cell(22, 6,"Tgl Penghapusan", 1);

$pdf->Cell(17, 6,"Type", 1);

$pdf->Cell(17, 6,"Spesifikasi", 1);

$pdf->Cell(17, 6,"Jumlah", 1);

$pdf->Cell(17, 6, "Status", 1, 1, 'L');

$query = mysql_query("select * from tbl_alat");

while ($rs = mysql_fetch_array($query)) {

    $pdf->Cell(15, 6, $rs['Kode_Alat'], 1);

$pdf->Cell(15, 6, $rs['Nama_Lab'], 1);

$pdf->Cell(15, 6, $rs['Kode_Lab'], 1);

$pdf->Cell(15, 6, $rs['Nama_Lab'], 1);

$pdf->Cell(15, 6, $rs['Tgl_Masuk'], 1);

$pdf->Cell(20, 6, $rs['Tgl_Pengajuan'], 1);

$pdf->Cell(22, 6, $rs['Tgl_Penghapusan'], 1);

$pdf->Cell(17, 6, $rs['Type'], 1);

$pdf->Cell(17, 6, $rs['Spesifikasi'], 1);

$pdf->Cell(17, 6, $rs['Jumlah'], 1);

    $pdf->Cell(17, 6, $rs['Status'], 1, 1, 'L');

}

$pdf->Output();

?>

- Laporan Data Mahasiswa Menggunakan PDF

<?php

//koneksi mysql

mysql_connect("localhost", "root", "");

mysql_select_db("db_labor");

require('fpdf.php');

class PDF extends FPDF {

// Page header

    function Header() {

        // Arial bold 15

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

        // Move to the right

        $this->Cell(80);

        // Title

        $this->Cell(60, 10, 'Laporan Mahasiswa', 1, 0, 'C');

        // Line break

        $this->Ln(20);

    }

// Page footer

    function Footer() {

        // Position at 1.5 cm from bottom

        $this->SetY(-15);

        // Arial italic 8

        $this->SetFont('Arial', 'I', 8);

        // Page number

        $this->Cell(0, 10, 'Page ' . $this->PageNo() . '/{nb}', 0, 0, 'C');

    }

}

// Instanciation of inherited class

$pdf = new PDF();

$pdf->AliasNbPages();

$pdf->AddPage();

$pdf->SetFont('Times', '', 8);

$pdf->Cell(60, 10, 'Laporan Mahasiswa', 0, 1,'L');

$pdf->Cell(18, 6,"Nim", 1);

$pdf->Cell(20, 6,"Nama", 1);

$pdf->Cell(20, 6,"Hp", 1);

$pdf->Cell(30, 6,"EMail", 1);

$pdf->Cell(20, 6,"Jurusan", 1);

$pdf->Cell(15, 6, "Semester", 1, 1, 'L');

$query = mysql_query("select * from tbl_Mahasiswa");

while ($rs = mysql_fetch_array($query)) {

    $pdf->Cell(18, 6, $rs['Nim'], 1);

$pdf->Cell(20, 6, $rs['Nama'], 1);

$pdf->Cell(20, 6, $rs['Hp'], 1);

$pdf->Cell(30, 6, $rs['EMail'], 1);

$pdf->Cell(20, 6, $rs['Jurusan'], 1);

    $pdf->Cell(15, 6, $rs['Semester'], 1, 1, 'L');

}

$pdf->Output();

?>`

- Lapran Data Staf Menggunakan PDF

<?php

//koneksi mysql

mysql_connect("localhost", "root", "");

mysql_select_db("db_labor");

require('fpdf.php');

class PDF extends FPDF {

// Page header

    function Header() {

        // Arial bold 15

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

        // Move to the right

        $this->Cell(80);

        // Title

        $this->Cell(60, 10, 'Laporan Staf', 1, 0, 'C');

        // Line break

        $this->Ln(20);

    }

// Page footer

    function Footer() {

        // Position at 1.5 cm from bottom

        $this->SetY(-15);

        // Arial italic 8

        $this->SetFont('Arial', 'I', 8);

        // Page number

        $this->Cell(0, 10, 'Page ' . $this->PageNo() . '/{nb}', 0, 0, 'C');

    }

}

// Instanciation of inherited class

$pdf = new PDF();

$pdf->AliasNbPages();

$pdf->AddPage();

$pdf->SetFont('Times', '', 8);

$pdf->Cell(60, 10, 'Laporan Staf', 0, 1,'L');

$pdf->Cell(18, 6,"Nip", 1);

$pdf->Cell(20, 6,"Nama", 1);

$pdf->Cell(20, 6,"Jabatan", 1);

$pdf->Cell(30, 6,"Hp", 1);

$pdf->Cell(37, 6, "E-Mail", 1, 1, 'L');

$query = mysql_query("select * from tbl_Staf");

while ($rs = mysql_fetch_array($query)) {

    $pdf->Cell(18, 6, $rs['Nip'], 1);

$pdf->Cell(20, 6, $rs['Nama'], 1);

$pdf->Cell(20, 6, $rs['Jabatan'], 1);

$pdf->Cell(30, 6, $rs['Hp'], 1);

    $pdf->Cell(37, 6, $rs['E-Mail'], 1, 1, 'L');

}

$pdf->Output();

?>`

- Laporan Data Lost & Found Menggunakan PDF

<?php

//koneksi mysql

mysql_connect("localhost", "root", "");

mysql_select_db("db_labor");

require('fpdf.php');

class PDF extends FPDF {

// Page header

    function Header() {

        // Arial bold 15

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

        // Move to the right

        $this->Cell(80);

        // Title

        $this->Cell(60, 10, 'Laporan Ketinggalan', 1, 0, 'C');

        // Line break

        $this->Ln(20);

    }

// Page footer

    function Footer() {

        // Position at 1.5 cm from bottom

        $this->SetY(-15);

        // Arial italic 8

        $this->SetFont('Arial', 'I', 8);

        // Page number

        $this->Cell(0, 10, 'Page ' . $this->PageNo() . '/{nb}', 0, 0, 'C');

    }

}

// Instanciation of inherited class

$pdf = new PDF();

$pdf->AliasNbPages();

$pdf->AddPage();

$pdf->SetFont('Times', '', 8);

$pdf->Cell(60, 10, 'Laporan Ketinggalan', 0, 1,'L');

$pdf->Cell(18, 6,"Tgl", 1);

$pdf->Cell(20, 6,"Hari", 1);

$pdf->Cell(20, 6,"Jam", 1);

$pdf->Cell(30, 6,"Nama Barang", 1);

$pdf->Cell(30, 6,"Spesifiksi", 1);

$pdf->Cell(30, 6,"Jumlah", 1);

$pdf->Cell(37, 6, "Ket", 1, 1, 'L');

$query = mysql_query("select * from tbl_Ketinggalan");

while ($rs = mysql_fetch_array($query)) {

    $pdf->Cell(18, 6, $rs['Tgl'], 1);

$pdf->Cell(20, 6, $rs['Hari'], 1);

$pdf->Cell(20, 6, $rs['Jam'], 1);

$pdf->Cell(30, 6, $rs['Nama_Barang'], 1);

$pdf->Cell(30, 6, $rs['Spesifikasi'], 1);

$pdf->Cell(30, 6, $rs['Jumlah'], 1);

    $pdf->Cell(37, 6, $rs['Ket'], 1, 1, 'L');

}

$pdf->Output();

?>`

- Laporan Data Pinjam menggunakan PDF

<?php

//koneksi mysql

mysql_connect("localhost", "root", "");

mysql_select_db("db_labor");

require('fpdf.php');

class PDF extends FPDF {

// Page header

    function Header() {

        // Arial bold 15

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

        // Move to the right

        $this->Cell(80);

        // Title

        $this->Cell(60, 10, 'Laporan Pinjam', 1, 0, 'C');

        // Line break

        $this->Ln(20);

    }

// Page footer

    function Footer() {

        // Position at 1.5 cm from bottom

        $this->SetY(-15);

        // Arial italic 8

        $this->SetFont('Arial', 'I', 8);

        // Page number

        $this->Cell(0, 10, 'Page ' . $this->PageNo() . '/{nb}', 0, 0, 'C');

    }

}

// Instanciation of inherited class

$pdf = new PDF();

$pdf->AliasNbPages();

$pdf->AddPage();

$pdf->SetFont('Times', '', 8);

$pdf->Cell(60, 10, 'Laporan pinjam', 0, 1,'L');

$pdf->Cell(15, 6,"Id", 1);

$pdf->Cell(15, 6,"Nama", 1);

$pdf->Cell(20, 6,"Nama Alat", 1);

$pdf->Cell(20, 6,"Tgl Pinjam", 1);

$pdf->Cell(20, 6,"Tgl Kembali", 1);

$pdf->Cell(20, 6,"Status", 1);

$pdf->Cell(20, 6,"Jumlah", 1);

$pdf->Cell(30, 6,"Penanggung jawab", 1, 1, 'L');

$query = mysql_query("select * from tbl_pinjam");

while ($rs = mysql_fetch_array($query)) {

    $pdf->Cell(15, 6, $rs['Id'], 1);

$pdf->Cell(15, 6, $rs['Nama'], 1);

$pdf->Cell(20, 6, $rs['Nama_Alat'], 1);

$pdf->Cell(20, 6, $rs['Tgl_Pinjam'], 1);

$pdf->Cell(20, 6, $rs['Tgl_Kembali'], 1);

$pdf->Cell(20, 6, $rs['Status'], 1);

$pdf->Cell(20, 6, $rs['Jumlah'], 1);

    $pdf->Cell(30, 6, $rs['Penanggung_jawab'], 1, 1, 'L');

}

$pdf->Output();

?>`

- Laporan Data Iventaris menggunakan PDF

<?php

//koneksi mysql

mysql_connect("localhost", "root", "");

mysql_select_db("db_labor");

require('fpdf.php');

class PDF extends FPDF {

// Page header

    function Header() {

        // Arial bold 15

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

        // Move to the right

        $this->Cell(80);

        // Title

        $this->Cell(60, 10, 'Laporan Iventaris', 1, 0, 'C');

        // Line break

        $this->Ln(20);

    }

// Page footer

    function Footer() {

        // Position at 1.5 cm from bottom

        $this->SetY(-15);

        // Arial italic 8

        $this->SetFont('Arial', 'I', 8);

        // Page number

        $this->Cell(0, 10, 'Page ' . $this->PageNo() . '/{nb}', 0, 0, 'C');

    }

}

// Instanciation of inherited class

$pdf = new PDF();

$pdf->AliasNbPages();

$pdf->AddPage();

$pdf->SetFont('Times', '', 8);

$pdf->Cell(60, 10, 'Laporan Iventaris', 0, 1,'L');

$pdf->Cell(18, 6,"Nama Barang", 1);

$pdf->Cell(18, 6,"Kode Lab", 1);

$pdf->Cell(20, 6,"Nama Lab", 1);

$pdf->Cell(20, 6,"Tgl Pengajuan", 1);

$pdf->Cell(20, 6,"Tgl Masuk", 1);

$pdf->Cell(22, 6,"Tgl Penghapusan", 1);

$pdf->Cell(17, 6,"Spesifikasi", 1);

$pdf->Cell(17, 6,"Jenis Barang", 1);

$pdf->Cell(18, 6,"Tn Pembuatan", 1);

$pdf->Cell(13, 6,"Jumlah", 1);

$pdf->Cell(14, 6, "Ket", 1, 1, 'L');

$query = mysql_query("select * from tbl_Iventaris");

while ($rs = mysql_fetch_array($query)) {

    $pdf->Cell(18, 6, $rs['Nama_Barang'], 1);

$pdf->Cell(18, 6, $rs['Kode_Lab'], 1);

$pdf->Cell(20, 6, $rs['Nama_Lab'], 1);

$pdf->Cell(20, 6, $rs['Tgl_Pengajuan'], 1);

$pdf->Cell(20, 6, $rs['Tgl_Masuk'], 1);

$pdf->Cell(22, 6, $rs['Tgl_Penghapusan'], 1);

$pdf->Cell(17, 6, $rs['Spesifikasi'], 1);

$pdf->Cell(17, 6, $rs['Jenis_Barang'], 1);

$pdf->Cell(18, 6, $rs['Tn_Pembuatan'], 1);

$pdf->Cell(13, 6, $rs['Jumlah'], 1);

    $pdf->Cell(14, 6, $rs['Ket'], 1, 1, 'L');

}

$pdf->Output();

?>`