Advertisement
Guest User

Untitled

a guest
Jan 26th, 2017
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. class IQTCulturaBD{
  2. protected $mysqli;
  3. const LOCALHOST = 'localhost';
  4. const USER = 'xxxx';
  5. const PASSWORD = 'xxxxxxx';
  6. const DATABASE = 'fffff';
  7. /**
  8. * Constructor de clase
  9. */
  10. public function __construct() {
  11. try{
  12. //conexion a base de datos
  13. $this->mysqli = new mysqli(self::LOCALHOST, self::USER, self::PASSWORD, self::DATABASE);
  14. }catch (mysqli_sql_exception $e){
  15. //Si no se puede realizar la conexion
  16. http_response_code(500);
  17. exit;
  18. }
  19. }
  20.  
  21. public function geElemento($id=0){
  22. $stmt = $this->mysqli->prepare("SELECT * FROM elemento WHERE id=?");
  23. $stmt->bind_param('s', $id);
  24. $stmt->execute();
  25. $result = $stmt->get_result();
  26. $elemento = $result->fetch_all(MYSQLI_ASSOC);
  27. $stmt->close();
  28. return $elemento;
  29. }
  30. public function getElementos(){
  31. $sql = "SELECT id,nombre,encabezado,latitud,longitud FROM elemento";
  32. $result = $this->mysqli->query($sql);
  33. $elementos = $result->fetch_all(MYSQLI_ASSOC);
  34. $result->close();
  35. return $elementos;
  36. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement