tegarkurniawan

Base Model.php

Jan 17th, 2015
360
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. <?php
  2.  
  3. namespace lib\MVC\Model;
  4.  
  5. abstract class BaseModel{
  6. public $db;
  7.  
  8.  
  9. public static function getDB() {
  10. return new \PDO("mysql:host=localhost;dbname=db_replikas", "root", "");
  11. }
  12. public function baseUrl(){
  13. return SITE_URL;
  14. }
  15. public function DeleteTable($table,$key,$value){
  16. $query = $db->prepare('DELETE FROM '.$table.' WHERE '.$key.'='.$value);
  17. $query->execute();
  18.  
  19.  
  20. }
  21. public function Select($table){
  22. $query = $db->prepare('SELECT * FROM '.$table);
  23. $query->execute();
  24. return $query->fetchAll();
  25.  
  26. }
  27. public function Insert($table,$data){
  28. // data dalam bentuk array()
  29. var_dump($db);
  30. $key = implode(',', array_keys($data)); // mengambil nilai key dalam array
  31. $value = implode('","',$data); // mengambil nilai value dalam array
  32. $query = $db->prepare('INSERT INTO '.$table.'('.$key.') VALUES("'.$value.'")');
  33. $query->execute();
  34. var_dump($query);
  35. }
  36. public function Update($table,$data,$key_name,$value_id){
  37. // mengambil key dan nilai dalam tiap indek dan memasukkannya ke dalam array
  38. $db = new \PDO("mysql:host=localhost;dbname=db_replikas", "root", "");
  39. foreach($data as $key => $value){
  40. $arg[] = $key .'="'.$value.'"';
  41. }
  42. $set = implode(',',$arg); // mengambil key dan nilai dalam array $arg
  43. $stmt = $db->prepare('UPDATE '.$table.' SET '.$set.' WHERE '.$key_name.'='.$value_id);
  44. $stmt->execute();
  45. }
  46.  
  47. }
Advertisement
Add Comment
Please, Sign In to add comment