leonsuke

OOP basis PDO (Class MakananTools)

Mar 19th, 2016
196
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.01 KB | None | 0 0
  1. <?php
  2. class MakananTools {
  3. private $db;
  4.  
  5. public function __construct($pdo) {
  6. $this->db = $pdo;
  7. }
  8.  
  9. public function InputMakanan($nama_makanan, $harga_makanan) {
  10. $sql = $this->db->prepare("INSERT INTO tbl_makanan (id_makanan, nama_makanan, harga_makanan) VALUES (UUID(), :nama_makanan, :harga_makanan)");
  11. $sql->bindParam(':nama_makanan', $nama_makanan, PDO::PARAM_STR);
  12. $sql->bindParam(':harga_makanan', $harga_makanan);
  13. $execute = $sql->execute();
  14.  
  15. if ($execute) {
  16. return $execute;
  17. } else {
  18. throw new Exception("Error Processing Request", 1);
  19. }
  20. }
  21.  
  22. public function DaftarDataMakanan() {
  23. $sql = $this->db->prepare('SELECT * FROM tbl_makanan');
  24. $sql->execute();
  25. $fetchAll = $sql->fetchAll();
  26.  
  27. return $fetchAll;
  28. }
  29.  
  30. public function GetDataMakananById($id_makanan) {
  31. $sql = $this->db->prepare('SELECT * FROM tbl_makanan WHERE id_makanan = ?');
  32. $sql->bindParam(1, $id_makanan);
  33. $exe = $sql->execute();
  34. $fetch = $sql->fetch(PDO::FETCH_ASSOC);
  35.  
  36. if ($fetch) {
  37. return $fetch;
  38. } else {
  39. throw new Exception("Error Processing Request", 1);
  40. }
  41. }
  42.  
  43. public function GantiDataMakanan($id_makanan, $nama_makanan, $harga_makanan) {
  44. $sql = $this->db->prepare('UPDATE tbl_makanan SET nama_makanan = ?, harga_makanan = ? WHERE id_makanan = ?');
  45. $sql->bindParam(1, $nama_makanan);
  46. $sql->bindParam(2, $harga_makanan);
  47. $sql->bindParam(3, $id_makanan);
  48. $execute = $sql->execute();
  49.  
  50. if ($execute) {
  51. return $execute;
  52. } else {
  53. throw new Exception("Error Processing Request", 1);
  54. }
  55. }
  56.  
  57. public function HapusDataMakanan($id_makanan) {
  58. $sql = $this->db->prepare('DELETE FROM tbl_makanan WHERE id_makanan = ?');
  59. $sql->bindParam(1, $id_makanan);
  60. $execute = $sql->execute();
  61.  
  62. if ($execute) {
  63. return $execute;
  64. } else {
  65. throw new Exception("Error Processing Request", 1);
  66.  
  67. }
  68. }
  69.  
  70. public function HashId($id) {
  71. $a = base64_encode($id);
  72.  
  73. return $a;
  74. }
  75. }
  76. ?>
Advertisement
Add Comment
Please, Sign In to add comment