Perancangan relasi antar tabel untuk form peminjaman lab iventaris berbasis desktop

Dalam perancangan relasi tabel disini tabel peminjaman menjadi sebagai tabel master. id pada tabel peminjaman sebagai primery key, sedangkan nama, kode alat, nama alat, sebagai foren key.

Langkah Awal Membuat Report Berbasis Desktop

Menu laporan

Contoh Laporan Mahasiswa

Langkah-langkah untuk menampilkan report
1.    Download Sap Crystal Report For Microsoft Visual Studio 2010
http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_13_0_4.exe
2.    Download : mysql-connector-odbc-5.2.3-win32 di PC anda, link download: http://www.mysql.com/downloads/connector/odbc/
3.    Lalu Lakukan Proses Installasi, setelah selesai, maka,
4.    Buat Sebuah Project Di C#,
5.    Tambahkan di Project Anda, Add new item – windows form,
6.    Lalu, tambahkan add new item – Crystal Report,
7.    Lalu tambahkan add new item – Dataset,

Form utama aplikasi lab iventaris

                                                          Gambar Form utama aplikasi Lab Iventaris

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace LAB_INVENTARIS
{
    public partial class Form9 : Form
    {
        public Form9()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            Form frm2 = new Form2();
            frm2.Show();
            this.Show();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            Form frm3 = new Form3();
            frm3.Show();
            this.Show();
        }

        private void button3_Click(object sender, EventArgs e)
        {
            Form frm4 = new Form4();
            frm4.Show();
            this.Show();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            Form frm5 = new Form5();
            frm5.Show();
            this.Show();
        }

        private void button5_Click(object sender, EventArgs e)
        {
            Form frm6 = new Form6();
            frm6.Show();
            this.Show();
        }

        private void button6_Click(object sender, EventArgs e)
        {
            Form frm7 = new Form7();
            frm7.Show();
            this.Show();
        }

        private void button7_Click(object sender, EventArgs e)
        {
            Form frm8 = new Form8();
            frm8.Show();
            this.Show();
        }
 
        private void button8_Click(object sender, EventArgs e)
        {
            iventaris syah = new iventaris();
            DataTable tabel = new DataTable();
            tabel = syah.bacasemua();
            dataGridView1.DataSource = tabel;
        }

        private void button9_Click(object sender, EventArgs e)
        {
            alat syah = new alat();
            DataTable tabel = new DataTable();
            tabel = syah.bacasemua();
            dataGridView1.DataSource = tabel;
        }

        private void button10_Click_1(object sender, EventArgs e)
        {
            peminjam syah = new peminjam();
            DataTable tabel = new DataTable();
            tabel = syah.bacasemua();
            dataGridView1.DataSource = tabel;
        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void button11_Click(object sender, EventArgs e)
        {
            this.Refresh();
        }
        static string a, b, c;
        private void timer1_Tick(object sender, EventArgs e)
        {
            // Tulisan Berjalan Ke Kiri
         
            a = label8.Text;
            b = a.Substring(0, 1);
            c = a.Substring(1, a.Length - 1);
            label8.Text = c + b;
        }

        private void timer2_Tick(object sender, EventArgs e)
        {
            DateTime date = DateTime.Now;
            label10.Text = DateTime.Now.ToLongTimeString();
        }
    }
}

Sistem kerja Lab Inventory berbasis WEB

Lab inventory berbasis web adalah aplikasi yang dibuat untuk mengolah data-data alat, inventaris, dan peminjaman di Laboratorium dasar STEI ITB agar menjadi lebih terstruktur dibandingkan dengan mengolah data secara manual. aplikasi web ini terbagi menjadi tiga pengguna yaitu admin, operator dan member.

1. Admin dapat mengakses halaman admin, halaman operator, halaman member dan halaman umum.  
2. Operator dapat mengakses halaman operator, halaman member dan halaman umum.
3. Member dapat mengakses halaman member dan halaman umum

Halaman Admin:

• Mengolah data pengguna yaitu mengolah username dan password yang terdiri dari admin, operator dan member.
• Mengolah data dosen 
• Mengolah data mahasiswa atau member.
• Mengolah data peminjam
• Mengolah data alat 
• Mengolah data inventaris
• Mengolah data lost & found yaitu penemuan barang yang ditinggal oleh pemiliknya karena lupa atau ketinggalan dan diinformasikan di aplikasi web ini agar mudah pemilik menemukannya. 
• Informasi kontak Lab

Halaman Operator:

• Mengolah data pengguna yaitu mengolah username dan password yang terdiri dari operator dan member.
  
• Mengolah data dosen 
• Mengolah data mahasiswa atau member.
• Mengolah data peminjam
• Mengolah data alat 
• Mengolah data inventaris
• Mengolah data lost & found yaitu penemuan barang yang ditinggal oleh pemiliknya karena lupa atau ketinggalan dan diinformasikan diaplikasi web ini agar mudah pemilik menemukannya. 
• Informasi kontak Lab

Halaman Member: 

• Informasi alat dan dapat melakukan peminjaman
• Informasi data alat yang dipinjam
• Informasi Lost & Found   
• Mengubah Username dan Passwordnya
• Informasi kontak Lab

Halaman Umum:

• Home yaitu terdiri dari informasi Lab dan form login
• Informasi alat
• Informasi lost & found
• Informasi kontak Lab

Tabel Alat menggunakan phpgrid

 Database
 

Field	Jenis	Kosong	Default
Kode_Alat	int(10)	Ya
Nama_Alat	varchar(50)	Ya
Kode_Lab	varchar(40)	Ya
Nama_Lab	varchar(50)	Ya
Tgl_Masuk	date	Ya
Tgl_Pengajuan	date	Ya
Tgl_Penghapusan	date	Ya
Type	varchar(10)	Ya
Spesifikasi	varchar(50)	Ya
Jumlah	varchar(50)	Ya
Ket	varchar(100)	Ya
Foto	blob	Ya

Source code php

<?php 
include("include/fungsi_del.php");
if ($_GET['act']=="del") hapus_alat();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>

<style title="currentStyle" type="text/css">
   @import "javascript/css/demo_page.css";
   @import "javascript/css/demo_table.css";
   
</style>
  <script language="javascript" src="javascript/js/jquery.js" type="text/javascript">
</script>
  <script language="javascript" src="javascript/js/jquery.dataTables.js" type="text/javascript">
</script>
  <script charset="utf-8" type="text/javascript">
   $(document).ready(function() {
    $('#example').dataTable({
     "sPaginationType": "full_numbers"
    });
   } );
   
</script>
</head>

<body id="dt-example">
<table  width="100%" border="0" bgcolor="#CCCCCC" class="display" id="example">
  <thead>
    <tr>
      <th colspan="8" align="left" valign="top"><a href="admin_home.php?page=13">+Tambah Data Alat
<!--Tambah Data Barang -->
</a> </th>
    </tr>
    <tr>
    <th width="5">N0</th>
    <th>Kode Alat</th>
    <th>Nama Alat</th>
	<th>Kode_Lab</th>
	<th>Nama_Lab</th>
	<th>Spesifikasi</th>
	<th>Foto</th>
	<th>Aksi</th>
  </tr>
</thead>
<tbody>


<?php
include"include/koneksi.php";
$tampil=mysql_query("select*from tbl_alat order by Kode_Alat");
$no=$posisi+1;
while($data=mysql_fetch_array($tampil)){
echo"<tr class='odd gradeU'>
	<td valign='top'>$no</td>
	<td valign='top'>$data[Kode_Alat]</td>
	<td valign='top'>$data[Nama_Alat]</td>
	<td valign='top'>$data[Kode_Lab]</td>
	<td valign='top'>$data[Nama_Lab]</td>
	<td valign='top'>$data[Spesifikasi]</td>
	<td><a href=\"foto_alat.php?Kode_Alat=$data[Kode_Alat]\"target=\"_blank\"><img src='foto_alat/$data[Foto]' title='$data[Nama_Alat]' width='50' height='50'><a></td>
	<td align='center' valign='center' class='style22'><a href=\"detail_alat.php?Kode_Alat=$data[Kode_Alat]\" target=\"_blank\"><img src='images/detail.png' title='Detail rincian data alat' width='20' height='20'></a>
	<a href=\"detail_alat.php?Kode_Alat=$data[Kode_Alat]\" target=\"_blank\"><img src='images/edit.png' title='Edit data alat' width='25' height='25'></a>
	<a href=\"admin_home.php?page=6&act=del&Kode_Alat=$data[Kode_Alat]\"><img src='images/delete.png' title='Hapus rincian data alat' width='20' height='20' onClick=\"return confirm('Apakah anda akan menghapus $data->Nama_Alat?')\"></a>
 	</td>

</tr>";
$no++;
}
?>
</tbody>
</table>
</body>
</html>

Hasil Tampilan

Konsep Login System Lab Inventory (Tengku Musri)

konsep dan alur dalam proses  Login 

• Membuat sebuah Database dengan sebuah Table, dimana terdapat Field id_login, username, password dan level
• Level digunakan untuk menentukan Tingkat pengguna
• Memasukkan data informasi login user ke dalam Table tersebut.
• Membuat Form Login / Interface Login untuk memasukkan username dan password
• Merancang home admin, Home User, dan Home Oprator
• Proses Login dimana hasil Inputan username dan password di cocokkan dengan data yang ada di Database.

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();

?>`

Desain form peminjaman

1. Form Peminjaman Barang

Membuat tombol save, delete, update, show, refresh, dan exit di c#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace LAB_INVENTARIS
{
    public partial class Form2 : Form
    {
        public Form2()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
         
            string alamat = "server=localhost; database= db_labor; uid=root; password= ;";
            MySqlConnection con;
            con = new MySqlConnection(alamat);
            con.Open();
            MySqlCommand cmnd = new MySqlCommand("INSERT INTO tbl_staf (Nip, Nama, Jabatan, Hp, Email) values ('" + txtnip.Text.ToString() + "', '" + txtnama.Text.ToString() + "', '" + txtjabatan.Text.ToString() + "', '" + txthp.Text.ToString() + "', '" + txtemail.Text.ToString() + "')", con);
            cmnd.ExecuteNonQuery();
            try
            {
            DataTable table = new DataTable();
            MessageBox.Show("Data berhasil disimpan!!!");
            }
            catch (Exception err)
            {
                MessageBox.Show(err.ToString());
            }

        }
        static string a, b, c;
        private void timer1_Tick(object sender, EventArgs e)
        {
            // Tulisan Berjalan Ke Kiri
            a = label8.Text;
            b = a.Substring(0, 1);
            c = a.Substring(1, a.Length - 1);
            label8.Text = c + b;
        }

        private void button2_Click(object sender, EventArgs e)
        {
            txtnip.Text = "";
            txtnama.Text = "";
            txtjabatan.Text = "";
            txthp.Text = "";
            txtemail.Text = "";
        }

        private void button7_Click(object sender, EventArgs e)
        {
            staf syah = new staf();
            DataTable tabel = new DataTable();
            tabel = syah.bacasemua();
            dataGridView1.DataSource = tabel;
        }

        private void button4_Click(object sender, EventArgs e)
        {
            string alamat = "server=localhost; database= db_labor; uid=root; password= ;";
            MySqlConnection con;
            con = new MySqlConnection(alamat);
            con.Open();

            MySqlCommand cmnd = new MySqlCommand("UPDATE tbl_staf SET (Nip)=('" + txtnip.Text.ToString() + "')", con);
            cmnd.ExecuteNonQuery();
            try
            {

                DataTable table = new DataTable();
                MessageBox.Show("Data berhasil Update!!!");
            }
            catch (Exception err)
            {
                MessageBox.Show(err.ToString());
            }
        }

        private void button5_Click(object sender, EventArgs e)
        {
            string alamat = "server=localhost; database= db_labor; uid=root; password= ;";
            MySqlConnection con;
            con = new MySqlConnection(alamat);
            con.Open();

            MySqlCommand cmnd = new MySqlCommand("DELETE FROM tbl_staf WHERE (Nip) = ('" + txtnip.Text.ToString() + "')", con);
            cmnd.ExecuteNonQuery();
            try
            {

                DataTable table = new DataTable();
                MessageBox.Show("Data berhasil Didelete!!!");
            }
            catch (Exception err)
            {
                MessageBox.Show(err.ToString());
            }
        }

        private void button3_Click(object sender, EventArgs e)
        {
            string alamat = "server=localhost; database= db_labor; uid=root; password= ;";
            MySqlConnection con;
            con = new MySqlConnection(alamat);
            con.Open();

            MySqlCommand cmnd = new MySqlCommand("SELECT * FROM tbl_staf (Nip, Nama, Jabatan, Hp, Email) values ('" + txtnip.Text.ToString() + "', '" + txtnama.Text.ToString() + "', '" + txtjabatan.Text.ToString() + "', '" + txthp.Text.ToString() + "', '" + txtemail.Text.ToString() + "')", con);
            cmnd.ExecuteNonQuery();
            try
            {

                DataTable table = new DataTable();
                MessageBox.Show("Data berhasil !!!");
            }
            catch (Exception err)
            {
                MessageBox.Show(err.ToString());
            }
         
        }

        private void button9_Click(object sender, EventArgs e)
        {
            this.Refresh();
        }

        private void button10_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

    }

 }