SURAT KETERANGAN Hasil Uji Program Tugas Akhir

Menampilkan.php $a,$b,$c,$d
"; $sql = mysql_query("select * from vending_machine where kode ='S12'"); $data = mysql_fetch_array($sql); $e = $data["kode"]; $f = $data["harga"]; $g = $data["sisa"]; $h = $data["gambar"]; //echo"
$e,$f,$g,$h
"; $sql = mysql_query("select * from vending_machine where kode ='S13'"); $data = mysql_fetch_array($sql); $i = $data["kode"]; $j = $data["harga"]; $k = $data["sisa"]; $l = $data["gambar"]; //echo"
$i,$j,$k,$l
"; $sql = mysql_query("select * from vending_machine where kode ='S14'"); $data = mysql_fetch_array($sql); $m = $data["kode"]; $n = $data["harga"]; $o = $data["sisa"];

Universitas Sumatera Utara

$p = $data["gambar"]; //echo"
$m,$n,$o,$p
"; $sql = mysql_query("select * from vending_machine where kode ='S15'"); $data = mysql_fetch_array($sql); $q = $data["kode"]; $r = $data["harga"]; $s = $data["sisa"]; $t = $data["gambar"]; //echo"
$q,$r,$s,$t
"; $sql = mysql_query("select * from vending_machine where kode ='S16'"); $data = mysql_fetch_array($sql); $u = $data["kode"]; $v = $data["harga"]; $w = $data["sisa"]; $x = $data["gambar"]; //echo"
$u,$v,$w,$x
"; $sql = mysql_query("select * from vending_machine where kode ='S21'"); $data = mysql_fetch_array($sql); $y = $data["kode"]; $z = $data["harga"]; $yz = $data["sisa"]; $zz = $data["gambar"]; //echo"
$y,$z,$yz,$zz
";

$sql = mysql_query("select * from vending_machine where kode ='S22'"); $data = mysql_fetch_array($sql); $aa = $data["kode"]; $ab = $data["harga"]; $ac = $data["sisa"]; $ad = $data["gambar"]; //echo"
$aa,$ab,$ac,$ad
"; $sql = mysql_query("select * from vending_machine where kode ='S23'"); $data = mysql_fetch_array($sql); $ae = $data["kode"]; $af = $data["harga"]; $ag = $data["sisa"]; $ah = $data["gambar"]; //echo"
$ae,$af,$ag,$ah
"; $sql = mysql_query("select * from vending_machine where kode ='S24'"); $data = mysql_fetch_array($sql); $ai = $data["kode"];

Universitas Sumatera Utara

$aj = $data["harga"]; $ak = $data["sisa"]; $al = $data["gambar"]; //echo"
$ai,$aj,$ak,$al
"; $sql = mysql_query("select * from vending_machine where kode ='S25'"); $data = mysql_fetch_array($sql); $am = $data["kode"]; $an = $data["harga"]; $ao = $data["sisa"]; $ap = $data["gambar"]; //echo"
$am,$an,$ao,$ap
"; $sql = mysql_query("select * from vending_machine where kode ='S26'"); $data = mysql_fetch_array($sql); $aq = $data["kode"]; $ar = $data["harga"]; $as = $data["sisa"]; $at = $data["gambar"]; //echo"
$aq,$ar,$as,$at
";

$sql = mysql_query("select * from vending_machine where kode ='S31'"); $data = mysql_fetch_array($sql); $ba = $data["kode"]; $bb = $data["harga"]; $bc = $data["sisa"]; $bd = $data["gambar"]; //echo"
$ba,$bb,$bc,$bd
"; $sql = mysql_query("select * from vending_machine where kode ='S32'"); $data = mysql_fetch_array($sql); $be = $data["kode"]; $bf = $data["harga"]; $bg = $data["sisa"]; $bh = $data["gambar"]; //echo"
$be,$bf,$bg,$bh
"; $sql = mysql_query("select * from vending_machine where kode ='S33'"); $data = mysql_fetch_array($sql); $bi = $data["kode"]; $bj = $data["harga"]; $bk = $data["sisa"]; $bl = $data["gambar"];

Universitas Sumatera Utara

//echo"
$bi,$bj,$bk,$bl
"; $sql = mysql_query("select * from vending_machine where kode ='S34'"); $data = mysql_fetch_array($sql); $bm = $data["kode"]; $bn = $data["harga"]; $bo = $data["sisa"]; $bp = $data["gambar"]; //echo"
$bm,$bn,$bo,$bp
"; $sql = mysql_query("select * from vending_machine where kode ='S35'"); $data = mysql_fetch_array($sql); $bq = $data["kode"]; $br = $data["harga"]; $bs = $data["sisa"]; $bt = $data["gambar"]; //echo"
$bq,$br,$bs,$bt
";

$sql = mysql_query("select * from vending_machine where kode ='S36'"); $data = mysql_fetch_array($sql); $bu = $data["kode"]; $bv = $data["harga"]; $bw = $data["sisa"]; $bx = $data["gambar"]; //echo"
$bu,$bv,$bw,$bx
"; $sql = mysql_query("select * from vending_machine where kode ='D41'"); $data = mysql_fetch_array($sql); $ca= $data["kode"]; $cb = $data["harga"]; $cc = $data["sisa"]; $cd = $data["gambar"]; //echo"
$ca,$cb,$cc,$cd
"; $sql = mysql_query("select * from vending_machine where kode ='D42'"); $data = mysql_fetch_array($sql); $ce= $data["kode"]; $cf = $data["harga"]; $cg = $data["sisa"]; $ch = $data["gambar"]; //echo"
$ce,$cf,$cg,$ch
"; $sql = mysql_query("select * from vending_machine where kode ='D43'");

Universitas Sumatera Utara

$data = mysql_fetch_array($sql); $ci= $data["kode"]; $cj = $data["harga"]; $ck = $data["sisa"]; $cl = $data["gambar"]; //echo"
$ci,$cj,$ck,$cl
"; $sql = mysql_query("select * from vending_machine where kode ='D44'"); $data = mysql_fetch_array($sql); $cm= $data["kode"]; $cn = $data["harga"]; $co = $data["sisa"]; $cp = $data["gambar"]; //echo"
$cm,$cn,$co,$cp
";

$sql = mysql_query("select * from vending_machine where kode ='D45'"); $data = mysql_fetch_array($sql); $cq= $data["kode"]; $cr = $data["harga"]; $cs = $data["sisa"]; $ct = $data["gambar"]; //echo"
$cq,$cr,$cs,$ct
";

$sql = mysql_query("select * from vending_machine where kode ='D46'"); $data = mysql_fetch_array($sql); $cu= $data["kode"]; $cv = $data["harga"]; $cw = $data["sisa"]; $cx = $data["gambar"]; //echo"
$cu,$cv,$cw,$cx
"; $sql = mysql_query("select * from vending_machine where kode ='D51'"); $data = mysql_fetch_array($sql); $da= $data["kode"]; $db = $data["harga"]; $dc = $data["sisa"]; $dd = $data["gambar"];

Universitas Sumatera Utara

//echo"
$da,$db,$dc,$dd
"; $sql = mysql_query("select * from vending_machine where kode ='D52'"); $data = mysql_fetch_array($sql); $de = $data["kode"]; $df = $data["harga"]; $dg = $data["sisa"]; $dh = $data["gambar"]; //echo"
$de,$df,$dg,$dh
"; $sql = mysql_query("select * from vending_machine where kode ='D53'"); $data = mysql_fetch_array($sql); $di= $data["kode"]; $dj = $data["harga"]; $dk = $data["sisa"]; $dl = $data["gambar"]; //echo"
$di,$dj,$dk,$dl
"; $sql = mysql_query("select * from vending_machine where kode ='D54'"); $data = mysql_fetch_array($sql); $dm= $data["kode"]; $dn = $data["harga"]; $do = $data["sisa"]; $dp = $data["gambar"]; //echo"
$dm,$dn,$do,$dp
"; $sql = mysql_query("select * from vending_machine where kode ='D55'"); $data = mysql_fetch_array($sql); $dq= $data["kode"]; $dr = $data["harga"]; $ds = $data["sisa"]; $dt = $data["gambar"]; //echo"
$dq,$dr,$ds,$dt
"; $sql = mysql_query("select * from vending_machine where kode ='D56'"); $data = mysql_fetch_array($sql); $du= $data["kode"]; $dv = $data["harga"]; $dw = $data["sisa"]; $dx = $data["gambar"]; //echo"
$du,$dv,$dw,$dx
"; ?>

Proses
Universitas Sumatera Utara

$uang = $_POST["uangfinal"]; $kode_barang = $_POST["kodebarang"]; $query = mysql_query("select * from vending_machine '$kode_barang'"); $query2 = mysql_query("select * from vending_machine"); $sql = mysql_fetch_array($query); $harga = $sql[harga]; $nama = $sql[nama_produk]; $kode = $sql[kode]; $gambar = $sql[gambar]; $sisa = $sql[sisa]; $sisa_uang = $_GET[sisa];

where

kode

=

if($uang!=0){ $uang = $uang; } Else{ $uang = $sisa_uang; } if($uang>10000){ header('location: mesin_otomatis.php?act=uang&uang='.$uang); } elseif($kode_barang==NULL){ header('location: mesin_otomatis.php?act=kodebarang&uang='.$uang); } elseif($uang < $harga){ header('location: mesin_otomatis.php?act=gagal&uangkurang='.$uang); //echo $uang, $sisa_uang; } elseif($sisa<=0){ if($kode == 0) header('location: mesin_otomatis.php?act=tidakada&uang='.$uang); else header('location: mesin_otomatis.php?act=kurang&nilai='.$sisa); } elseif ($uang >= $harga){ if(!empty($uang)) $kembali = $uang - $harga; else $kembali = $sisa_uang - $harga; $query = mysql_query("update vending_machine set sisa = sisa - 1 where kode = '$kode_barang'"); header('location: mesin_otomatis.php?act=berhasil&harga='.$harga.'&nama='.$nama.'&kode='.$kode.' &gambar='.$gambar.'&kembali='.$kembali); } ?>

Universitas Sumatera Utara