function deleteData($table_name, $id_val, $id_name = 'id') { //validasi input if (empty($id_val)) { return "Ada data yang kosong!"; } $id_val = validasi($id_val); //construct query $query = "DELETE FROM " . $table_name . " WHERE " . $id_name . "='" . $id_val . "'"; //echo $query; //proses query $proses = mysql_query($query); if (!$proses) { return "Operasi gagal!"; } }
<?php require_once "./script/config.php"; require_once $site_path . "script/library.php"; cekSession(); $id = validasi($_GET[id]); ?> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="shortcut icon" href="./design/favicon.ico"> <title><?php echo $site_title; ?> </title> </head> <body onload="body_onLoad()"> <div id="wrapper"> <div id="header"> <h1>Toko Kelontong Makmur</h1> <p>jl. antah berantah no.1</p> <p>No. Nota: <?php echo $id; ?> </p> <p>Tanggal: <?php echo date('d-m-Y'); ?> </p> </div> <div id="main">
require_once "./script/config.php"; require_once $site_path . "script/library.php"; // <<< CEK SESSION >>> //klo udah login, redirect ke homepage if (isLoggedIn()) { header("location: " . $site_path . "index.php"); } //inisialisasi data $pesan = ""; // <<< PROSES METHOD POST >>> if (!empty($_POST[action])) { if (empty($_POST[username]) || empty($_POST[password])) { $pesan = "Data ada yang kosong!"; } else { $username = validasi($_POST[username]); $password = md5($_POST[password]); $query = "SELECT id, id_status, nama_lengkap FROM pengguna WHERE username='******' AND password='******'"; //echo $query; $proses = mysql_query($query); if (!$proses) { $pesan = "Operasi gagal!"; } else { if (mysql_num_rows($proses) == 0) { $pesan = "Username atau Password tidak ditemukan!"; } else { $hasil = mysql_fetch_array($proses); //inisialisasi session /* session_register("id"); session_register("id_status");
$id = 0; while ($hasil = mysql_fetch_array($proses)) { echo "<tr><td>"; if ($id != $hasil[id]) { $id = $hasil[id]; echo $id; } $harga = $hasil[harga_beli] * (100 + $hasil[persen_markup]) / 100; echo "</td><td>{$hasil['kode']}</td><td>{$hasil['nama']}</td><td>{$harga}</td><td>{$hasil['jumlah']}</td><td>" . $harga * $hasil[jumlah] . "</td></tr>"; } } echo "</table>"; break; case 'penjualan_per_periode': $tgl_trans_awal = validasi($_GET[tgl_trans_awal]); $tgl_trans_akhir = validasi($_GET[tgl_trans_akhir]); echo "<h1>DAFTAR PENJUALAN PER-PERIODE</h1>"; echo "<div class=\"box\">Tanggal: " . convertDate($tgl_trans_awal) . " s/d " . convertDate($tgl_trans_akhir) . "</div>"; echo "<div class=\"box\">Tanggal Cetak: " . $tanggal . "</div>"; $query = "\tSELECT DATE(penjualan_umum.waktu) AS tanggal,\n\t\t\t\t\t\t\t\t\tpenjualan_umum.id AS id,\n\t\t\t\t\t\t\t\t\tbarang.kode AS kode,\n\t\t\t\t\t\t\t\t\tbarang.nama AS nama,\n\t\t\t\t\t\t\t\t\tbarang.harga_beli AS harga_beli,\n\t\t\t\t\t\t\t\t\tbarang.persen_markup AS persen_markup,\n\t\t\t\t\t\t\t\t\tpenjualan_detail.jumlah AS jumlah\n\t\t\t\t\t\t\t\tFROM penjualan_umum, penjualan_detail, barang\n\t\t\t\t\t\t\t\tWHERE barang.id = penjualan_detail.id_barang AND penjualan_detail.id_penjualan_umum = penjualan_umum.id AND DATE(penjualan_umum.waktu) >= '{$tgl_trans_awal}' AND DATE(penjualan_umum.waktu) <= '{$tgl_trans_akhir}'"; //echo $query; $proses = mysql_query($query); echo "<table>\n\t\t\t\t\t<tr><th>Tanggal</th><th>Id Transaksi</th><th>Kode Barang</th><th>Nama Barang</th><th>Harga Jual(Rp.)</th><th>Jumlah</th><th>Sub Total (Rp.)</th></tr>"; if ($proses) { $id = 0; $tgl_lama = 0; while ($hasil = mysql_fetch_array($proses)) { echo "<tr><td>"; if ($tgl_lama != $hasil[tanggal]) { $tgl_lama = $hasil[tanggal]; echo convertDate($tgl_lama);