Advertisement
Guest User

Untitled

a guest
Jun 15th, 2019
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.68 KB | None | 0 0
  1. require_once('DBConnection.php');
  2. define("DB_HOST", "localhost");
  3. define("DB_USER", "placidojrc");
  4. define("DB_PASS", "");
  5. define("DB_NAME", "proyecto_fitness");
  6. $app->get('/usuarios', function () {
  7.  
  8. $response = array();
  9. $dbc = new DBConnection();
  10. $sql="SELECT 'nombre' FROM usuarios";
  11. $rs=$dbc->getQuery($sql);
  12. $profile=$rs->fetch();
  13. echoResponse(200, $response);
  14. });
  15.  
  16. <?php
  17.  
  18. class DBConnection{
  19.  
  20. private $host = DB_HOST;
  21. private $db = DB_NAME;
  22. private $user = DB_USER;
  23. private $pass = DB_PASS;
  24. private $dbh;
  25. private $error=null;
  26.  
  27.  
  28. public function __construct(){
  29. $options = array(
  30. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
  31. );
  32. $dsn="mysql:host=" . $this->host . ";dbname=" . $this->db . ";";
  33.  
  34. try{
  35. $this->dbh=new PDO($dsn, $this->user, $this->pass, $options);
  36. }
  37. catch(PDOException $ex){
  38. $this->error=$ex->getMessage();
  39. }
  40.  
  41. }
  42.  
  43. public function __toString(){
  44. return $this->error;
  45. }
  46.  
  47. public function __destruct(){
  48. $dbh=null;
  49. }
  50.  
  51. public function getError(){
  52. return $this->error;
  53. }
  54.  
  55. public function runQuery($query){
  56. try{
  57. return $this->dbh->exec($query);
  58. }
  59. catch(PDOException $ex){
  60. $this->error=$ex->getMessage();
  61. return "Error";
  62. }
  63. }
  64.  
  65. public function getQuery($query){
  66. try{
  67. $sentencia = $this->dbh->query($query);
  68. $sentencia->setFetchMode(PDO::FETCH_ASSOC);
  69. return $sentencia;
  70. }
  71. catch(PDOException $ex){
  72. $this->error=$ex->getMessage();
  73. return "Error";
  74. }
  75. }
  76.  
  77.  
  78. }?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement