Advertisement
Guest User

Untitled

a guest
Mar 4th, 2016
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.40 KB | None | 0 0
  1. <?php
  2. /**
  3. *@author [Miguel Sánchez Troncoso] <[<migueltroncoso88@gmail.com>]>
  4. */
  5.  
  6. require_once('mis_datos.php');
  7.  
  8. $objeto= new Datos;
  9. $objeto->mostrar();
  10.  
  11.  
  12. abstract class DBAbstractModel{
  13.  
  14. private static $db_host = 'localhost';
  15. private static $db_user = 'root';
  16. private static $db_pass = 'root';
  17. protected $db_name = 'mydb';
  18. protected $query;
  19. protected $rows = array();
  20. private $conn;
  21.  
  22. //metodos abstractos para ABM de clases que hereden
  23. abstract protected function get();
  24. abstract protected function set();
  25. abstract protected function edit();
  26. abstract protected function delete();
  27.  
  28. //los siguientes métodos pueden definirse con exactitud y no son abstractos
  29.  
  30. //conectar con la base de datos
  31. private function open_connection(){
  32. $this->conn = new mysqli(self::$db_host, self::$db_user, self::$db_pass, $this->db_name);
  33. }
  34.  
  35. //desconectar de la base de datos
  36. private function close_connection(){
  37. $this->conn->close();
  38. }
  39.  
  40. //ejecutar un query de DELETE, INSERT Y UPDATE
  41. protected function execute_single_query(){
  42. $this->open_connection();
  43. $this->conn->query($this->query);
  44. $this->close_connection();
  45. }
  46.  
  47. //traer resultados de una consulta en un array
  48. protected function get_results_from_query(){
  49. $this->open_connection();
  50. $result = $this->conn->query($this->query);
  51. while ($this->rows[] = $result->fetch_assoc());
  52. $result->close();
  53. $this->close_connection();
  54. array_pop($this->rows);
  55. }
  56. }
  57. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement