require ("security.php");
$koneksi = odbc_connect("apotek", "" , "");
?>
Entry Data Stok Barang
//echo $kode_barang1;
//require("connect.inc.php");
if ($_POST[act]<>"Yes") {
//echo $_SESSION['username'];
?>
}
else
{
$nama_barang = $_POST[nama_barang];
$masuk_stok = $_POST[masuk_stok];
$trans = odbc_exec($koneksi, "SELECT [nama barang] FROM transaksi where [nama barang]='".$nama_barang."'");
// $a = odbc_num_rows($trans);
//echo $a;
$i=0;
while ($data_trans = odbc_fetch_array($trans))
{
$i++;
}
//echo $i;
if($i==0) {
$query = "INSERT INTO transaksi ([nama barang],[masuk stok]) values ('$nama_barang', $masuk_stok)";
$entri = odbc_exec($koneksi, $query);
} else {
$query = "update transaksi set [nama barang] ='$nama_barang',[masuk stok] = $masuk_stok where [nama barang]='$nama_barang'";
$entri = odbc_exec($koneksi, $query);
}
echo "Proses Input Berhasil!";
echo '';
}
?>