Persiapan ujian usk e-commerce
cluster 2 web e-commerce printer koneksi.php <?php $db = mysqli_connect("localhost", "root", "", "clus1"); function beli($data){ global $db; $id = $_GET['idPrinter']; $pembeli = $data['idPembeli']; $produk = $data['idPrinter']; $jml = $data['jumlah']; $insert = mysqli_query($db, "INSERT INTO transaksi (idPembeli, idProduk, jumlah, status) VALUES ('$pembeli', '$produk', '$jml', 'bd')"); return mysqli_affected_rows($db); } function edit($data){ global $db; $id = $_GET['id']; $printer = mysqli_real_escape_string($db, $data['printer']); $spesifikasi = mysqli_real_escape_string($db,$data['spesifikasi']); $harga = $data['harga']; $update = mysqli_query($db, "UPDATE printer SET namaPrinter = '$printer', spesifikasi = '$spesifikasi', harga = '$harga' WHERE idPrinter = &