<?php session_start(); require_once "library/koneksi.php"; require_once "library/fungsi_standar.php"; $a = "SELECT * FROM jual"; $b = "SELECT inc FROM jual ORDER BY inc DESC LIMIT 1"; $inc = penambahan($a, $b); if (isset($_POST['run']) and $_POST['run'] == "form2") { $cekQty = "SELECT * FROM stok WHERE barang_nama='{$_POST['pilih_barang']}'"; $qcekQty = mysql_query($cekQty); $dcekQty = mysql_fetch_array($qcekQty); if (!empty($_POST['qty']) and !empty($_POST['harga'])) { //ambil dari stok $buah = "SELECT * FROM stok WHERE barang_nama='{$_POST['pilih_barang']}'"; $qbuah = mysql_query($buah); $dbuah = mysql_fetch_array($qbuah); $sisa_qty = $dbuah['qty'] - $_POST['qty']; if ($sisa_qty >= 0) { //insert ke temp_beli_detail $harga_total = $_POST['qty'] * $_POST['harga']; $input = "INSERT INTO temp_jual_detail(jual_id, barang_id, barang_nama, kategori, qty, satuan, harga_satuan, harga_total)\n\t\t\tVALUES('JL-{$inc}', '{$dbuah['barang_id']}', '{$_POST['pilih_barang']}', '{$dbuah['kategori']}', '{$_POST['qty']}', 'box', \n\t\t\t'{$_POST['harga']}', '{$harga_total}')"; mysql_query($input); //update tabel stok $upstok = "UPDATE stok SET qty='{$sisa_qty}' WHERE barang_id='{$dbuah['barang_id']}'"; mysql_query($upstok); } else { echo "\n\t\t\t<script type=text/javascript>"; echo "alert('Qty yang diambil melebihi stok')"; echo "</script>"; }
} function penambahan($a, $b) { return $a + $b; } function login($username, $password) { // 1. sanitazie arguments // 2. validate argumenets // 3. prepare statements // 4. excute sql // if ok, start session, return true // else return false } function logout() { // destroy session // redirect to main page } $user_list = array('nasrul', 'hazim', 'mohamad', 'mahdin', 'othman', 'ahmad'); $name = 'nasrul bin hazim bin mohamad bin mahdin bin othman bin ahmad'; // p(join(' bin ', $user_list)); // p(implode(' bin ', $user_list)); // p(count($user_list)); // var_dump(explode(' bin ', $name)); $result_a = penambahan(1, 1); $result_b = penambahan(1, 10); // p($result_a); // p($result_b); ?>