Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- namespace lib\MVC\Model;
- abstract class BaseModel{
- public $db;
- public static function getDB() {
- return new \PDO("mysql:host=localhost;dbname=db_replikas", "root", "");
- }
- public function baseUrl(){
- return SITE_URL;
- }
- public function DeleteTable($table,$key,$value){
- $query = $db->prepare('DELETE FROM '.$table.' WHERE '.$key.'='.$value);
- $query->execute();
- }
- public function Select($table){
- $query = $db->prepare('SELECT * FROM '.$table);
- $query->execute();
- return $query->fetchAll();
- }
- public function Insert($table,$data){
- // data dalam bentuk array()
- var_dump($db);
- $key = implode(',', array_keys($data)); // mengambil nilai key dalam array
- $value = implode('","',$data); // mengambil nilai value dalam array
- $query = $db->prepare('INSERT INTO '.$table.'('.$key.') VALUES("'.$value.'")');
- $query->execute();
- var_dump($query);
- }
- public function Update($table,$data,$key_name,$value_id){
- // mengambil key dan nilai dalam tiap indek dan memasukkannya ke dalam array
- $db = new \PDO("mysql:host=localhost;dbname=db_replikas", "root", "");
- foreach($data as $key => $value){
- $arg[] = $key .'="'.$value.'"';
- }
- $set = implode(',',$arg); // mengambil key dan nilai dalam array $arg
- $stmt = $db->prepare('UPDATE '.$table.' SET '.$set.' WHERE '.$key_name.'='.$value_id);
- $stmt->execute();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment