Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host ='localhost';
- $user ='grupphp';
- $pass ='';
- $db ='fb_tutorial';
- $pdo = new PDO('mysql:host='.$host.';dbname='.$db, $user, $pass);
- // use the connection here
- try{
- $makan = new MakananTools($pdo);
- $makan->InputMakanan('siomay',10000);
- $makan->InputMakanan(545,'');
- $makan->InputMakanan('unknown 2');
- } catch (Exception $e) {
- echo nl2br(print_r($e,1));
- }
- class MakananTools {
- private $db;
- public function __construct($pdo) {
- $this->db = $pdo;
- }
- public function InputMakanan($nama_makanan="", $harga_makanan=0) {
- $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) {
- echo '<br/>OK';
- return $execute;
- }
- else {
- echo '<br/>Failed';
- 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
Advertisement