Guest User

Untitled

a guest
Nov 25th, 2018
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.84 KB | None | 0 0
  1. <?php
  2.  
  3. class User extends Conn{
  4.  
  5. private $nombre;
  6. private $username;
  7.  
  8. public function ValidarExistencia($user, $password){
  9. $md5pass = md5($password);
  10.  
  11. $sql = "SELECT * FROM usuario WHERE username = :user AND password = :password";
  12. $query = $this->connect()->prepare($sql);
  13. $query->execute(['user' => $user, 'password' => $md5pass]);
  14.  
  15. if($query->fetch(PDO::FETCH_ASSOC)){
  16. return true;
  17. }else{
  18. return false;
  19. }
  20. }
  21.  
  22. public function SetUser($user){
  23. $sql = "SELECT * FROM usuario WHERE username = :user";
  24. $query = $this->connect()->prepare($sql);
  25. $query->execute(['user' => $user]);
  26.  
  27. foreach ($query as $currentUser) {
  28. $this->nombre = $currentUser['nombre'];
  29. $this->username = $currentUser['username'];
  30. }
  31. }
  32.  
  33. public function getNombre(){
  34. return $this->nombre;
  35. }
  36.  
  37. }
  38.  
  39. ?>
  40.  
  41. <?php
  42.  
  43. class Conn
  44. {
  45.  
  46. //Atributos de la base de datos
  47. private $dbname;
  48. private $host;
  49. private $user;
  50. private $pass;
  51. private $port;
  52. private $conexion;
  53.  
  54. //Métodos
  55. public function __construct()
  56. {
  57. $this->dbname = "scrum";
  58. $this->host = "localhost";
  59. $this->user = "postgres";
  60. $this->pass = "1234";
  61. $this->port = "5432";
  62. }
  63.  
  64. public function connect(){
  65. try{
  66. $this->conexion = new PDO("pgsql:host=".$this->host.
  67. ";port=".$this->port.
  68. ";dbname=".$this->dbname.
  69. ";user=".$this->user.
  70. ";password=".$this->pass);
  71. }catch(Exception $e)
  72. {
  73. echo "Tienes el siguiente error:", $e->getMessage();
  74. }
  75. }
  76.  
  77. }
  78.  
  79. ?>
  80.  
  81. class User extends Conn
  82.  
  83. require 'Conn.php';
  84.  
  85. class User extends Conn
  86. {
  87. .....
  88. }
Add Comment
Please, Sign In to add comment