Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class MakananTools {
- private $db;
- public function __construct($pdo) {
- $this->db = $pdo;
- }
- public function InputMakanan($nama_makanan, $harga_makanan) {
- $sql = $this->db->prepare("INSERT INTO tbl_makanan (id_makanan, nama_makanan, harga_makanan) VALUES (UUID(), :nama_makanan, :harga_makanan)");
- $sql->bindParam(':nama_makanan', $nama_makanan, PDO::PARAM_STR);
- $sql->bindParam(':harga_makanan', $harga_makanan);
- $execute = $sql->execute();
- if ($execute) {
- return $execute;
- } else {
- throw new Exception("Error Processing Request", 1);
- }
- }
- public function DaftarDataMakanan() {
- $sql = $this->db->prepare('SELECT * FROM tbl_makanan');
- $sql->execute();
- $fetchAll = $sql->fetchAll();
- return $fetchAll;
- }
- public function GetDataMakananById($id_makanan) {
- $sql = $this->db->prepare('SELECT * FROM tbl_makanan WHERE id_makanan = ?');
- $sql->bindParam(1, $id_makanan);
- $exe = $sql->execute();
- $fetch = $sql->fetch(PDO::FETCH_ASSOC);
- if ($fetch) {
- return $fetch;
- } else {
- throw new Exception("Error Processing Request", 1);
- }
- }
- public function GantiDataMakanan($id_makanan, $nama_makanan, $harga_makanan) {
- $sql = $this->db->prepare('UPDATE tbl_makanan SET nama_makanan = ?, harga_makanan = ? WHERE id_makanan = ?');
- $sql->bindParam(1, $nama_makanan);
- $sql->bindParam(2, $harga_makanan);
- $sql->bindParam(3, $id_makanan);
- $execute = $sql->execute();
- if ($execute) {
- return $execute;
- } else {
- throw new Exception("Error Processing Request", 1);
- }
- }
- public function HapusDataMakanan($id_makanan) {
- $sql = $this->db->prepare('DELETE FROM tbl_makanan WHERE id_makanan = ?');
- $sql->bindParam(1, $id_makanan);
- $execute = $sql->execute();
- if ($execute) {
- return $execute;
- } else {
- throw new Exception("Error Processing Request", 1);
- }
- }
- public function HashId($id) {
- $a = base64_encode($id);
- return $a;
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment