Sistem Informasi

Aplikasi toko sederhana menggunakan PHP

Hallo sobat dimanapun kalian berada, kali ini saya akan share aplikasi penjualan(toko) sederhana menggunakan PHP. Pertama-tama kita harus membuat database terlebih dahulu, disini saya menggunakan MySQL.

1. Tabel Barang (tblbarang)

2. Tabel Supplier (tblsupplier)

3. Tabel Detail Penjualan (detailpenjualan)

Setelah selesai membuat database maka selanjutnya kita mulai membuat file php.

1. Koneksi.php

<?php
//koneksi ke basisdata
$MyServer="localhost";
$MyUser="root";
$MyPass="";
$MyDb="tokosql";

$konek = mysql_connect ($MyServer,$MyUser,$MyPass)
or die ("Gagal Konek ke Server");

if ($konek){

} else {
echo "Koneksi SQL Server gagal";
}

mysql_select_db($MyDb, $konek)
or die ("Gagal mengaktifkan database".mysql_error());

?>

2. Index.php

<!doctype html>

<html>

<head>

<title>TOKO MUBAR</title>

<style>

body {

position: relative;

}

#input {padding-top:100px;height:800px;color: #0A0909; background-color: #FDFDFD;}

#proses {padding-top:100px;height:800px;color: #0A0909; background-color: #FDFDFD;}

#hasil {padding-top:100px;height:800px;color: #0A0909; background-color: #FDFDFD;}

</style>

</head>

TOKO MUGI BAROKAH

</h3>

</button>

</div>

<li><a href="supplier.php">Supplier</a></li>

<li><a href="transaksi.php">Transaksi</a></li>

<li><a href="laporan.php">Laporan</a></li>

</ul>

</div>

</nav>

<h3 align='center'> Data Barang </h3>

<thead>

<tr>

<th>Id Barang</th>

<th>Nama Barang</th>

<th>Harga Beli</th>

<th>Harga Jual</th>

<th>Kode Supplier</th>

<th>Operasi</th>

</tr>

</thead>

<?php

include "koneksi.php";

$sql_barang= "select*from tblbarang order by kode";

$qry_barang=mysql_query($sql_barang,$konek)

or die("Gagal query ".mysql_error());

while ($data=mysql_fetch_array($qry_barang)){

<tr>

"onclick = "return confirm('Apa anda yakin, data ini akan dihapus?');"

class="btn btn-danger btn-xs">Hapus</a> |

<a href="barangedit.php?kode=<?php echo $data['kode'];?>"

class="btn btn-warning btn-xs">Edit</a>

</td>

</tr>

<?php

}

mysql_free_result($qry_barang);

mysql_close($konek);

</table>

<br>

<a href="baranginsim.php" class="btn btn-success btn-s">Input Data</a></td>

</form>

</html>

Tampilan program

3. Supplier.php

<!doctype html>

<html>

<head>

<title>TOKO MUBAR</title>

<style>

body {

position: relative;

}

#input {padding-top:100px;height:800px;color: #0A0909; background-color: #FDFDFD;}

#proses {padding-top:100px;height:800px;color: #0A0909; background-color: #FDFDFD;}

#hasil {padding-top:100px;height:800px;color: #0A0909; background-color: #FDFDFD;}

</style>

</head>

TOKO MUGI BAROKAH

</h3>

</button>

</div>

<li><a href="supplier.php">Supplier</a></li>

<li><a href="transaksi.php">Transaksi</a></li>

<li><a href="laporan.php">Laporan</a></li>

</ul>

</div>

</nav>

<h3 align='center'> Data Supplier </h3>

<thead>

<tr>

<th>Id Supplier</th>

<th>Nama Supplier</th>

<th>Alamat</th>

<th>Nomer Telepon</th>

<th>Operasi</th>

</tr>

</thead>

<?php

include "koneksi.php";

$sql_supplier= "select*from tblsupplier order by kode_supp";

$qry_supplier=mysql_query($sql_supplier,$konek)

or die("Gagal query ".mysql_error());

while ($data=mysql_fetch_array($qry_supplier)){

<tr>

"onclick = "return confirm('Apa anda yakin, data ini akan dihapus?');"

class="btn btn-danger btn-xs">Hapus</a> |

<a href="supplieredit.php?kode_supp=<?php echo $data['kode_supp'];?>"

class="btn btn-warning btn-xs">Edit</a>

</td>

</tr>

<?php

}

mysql_free_result($qry_supplier);

mysql_close($konek);

</table>

<br>

<a href="supplierinsim.php" class="btn btn-success btn-s">Input Data</a></td>

</form>

</html>

Tampilan Program

4. Transaksi.php

<!doctype html>

<html>

<head>

<title>TOKO MUBAR</title>

<style>

body {

position: relative;

}

#input {padding-top:100px;height:800px;color: #0A0909; background-color: #FDFDFD;}

#proses {padding-top:100px;height:800px;color: #0A0909; background-color: #FDFDFD;}

#hasil {padding-top:100px;height:800px;color: #0A0909; background-color: #FDFDFD;}

</style>

</head>

TOKO MUGI BAROKAH

</h3>

</button>

</div>

<li><a href="supplier.php">Supplier</a></li>

<li><a href="transaksi.php">Transaksi</a></li>

<li><a href="laporan.php">Laporan</a></li>

</ul>

</div>

</nav>

<h3 align='center'> Data Transaksi </h3>

<thead>

<tr>

<th>Nomer Nota</th>

<th>Id Barang</th>

<th>Tanggal Transaksi</th>

<th>Harga</th>

<th>Jumlah</th>

<th>Total Bayar</th>

</tr>

</thead>

<?php

include "koneksi.php";

$sql_transaksi= "select*from detailpenjualan order by nonota";

$qry_transaksi=mysql_query($sql_transaksi,$konek)

or die("Gagal query".mysql_error());

while ($data=mysql_fetch_array($qry_transaksi)){

<tr>

</tr>

<?php

}

mysql_free_result($qry_transaksi);

mysql_close($konek);

</table>

<br>

<a href="transaksiinsim.php" class="btn btn-success btn-s">Input Data</a></td>

</form>

</html>

Tampilan Program

nb: pada bagian transaksi ini tidak diberi tombol hapus dan edit dikarenakan agar memperkecil resiko hilangnya data maupun kecurangan dari kasir.

5. Laporan.php

<!doctype html>

<html>

<head>

<title>TOKO MUBAR</title>

<style>

body {

position: relative;

}

#input {padding-top:100px;height:800px;color: #0A0909; background-color: #FDFDFD;}

#proses {padding-top:100px;height:800px;color: #0A0909; background-color: #FDFDFD;}

#hasil {padding-top:100px;height:800px;color: #0A0909; background-color: #FDFDFD;}

</style>

</head>

TOKO MUGI BAROKAH

</h3>

</button>

</div>

<li><a href="supplier.php">Supplier</a></li>

<li><a href="transaksi.php">Transaksi</a></li>

<li><a href="laporan.php">Laporan</a></li>

</ul>

</div>

</nav>

<h3 align='center'> Cetak Laporan </h3>

<thead>

<tr>

<th>Laporan Data Barang</th>

<th>Laporan Data Supplier</th>

<th>Laporan Data Transaksi</th>

</tr>

</thead>

<tr>

<td width ="200" align="center"><a href="printbarang.php" class="btn btn-info btn-s">Print</a></td>

<td width ="200" align="center"><a href="printsupplier.php" class="btn btn-info btn-s">Print</a></td>

<td width ="200" align="center"><a href="printtransaksi.php" class="btn btn-info btn-s">Print</a></td>

</tr>

</table>

</html>

Tampilan Program

Cetak laporan disini dibagi 3 yaitu: Laporan data barang, laporan data supplier, dan laporan transaksi.

Berikut adalah tampilan program secara keseluruhan.

Form edit barang

Form hapus barang

Form edit supplier

Form hapus supplier

no	field	type	Size	ket
1	No retur	var	10	primary
2	No nota jual	Var	10	secondary
3	Tanggalretur	date
4	Jumlahretur	integer
5	Keterangancacat	var	50

Sistem Informasi

Senin, 22 Mei 2017

PRAKTEK SQL SERVER MEMBUAT RETUR JUAL

Selasa, 02 Mei 2017

201553079 - Andrianus

PRAKTEK SQL SERVER MEMBUAT RETUR JUAL