Advertisement
Guest User

Untitled

a guest
Apr 21st, 2017
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.42 KB | None | 0 0
  1. public function __CONSTRUCT()
  2. {
  3. try
  4. {
  5. $this->pdo = new PDO('mysql:host=localhost;dbname=deimos1;charset=UTF8', 'root', '');
  6. $this->pdo->setAttribute(PDO::MYSQL_ATTR_INIT_COMMAND, "SET NAMES 'utf8'");
  7. $this->pdo->exec("SET NAMES 'utf8';");
  8. }
  9. catch(Exception $e)
  10. {
  11. die($e->getMessage());
  12. }
  13. }
  14.  
  15. public function Obtener($acronimo) {
  16. try {
  17. $stm = $this->pdo->prepare('SELECT * FROM categoria WHERE acronimo = ?');
  18. $stm->execute(array($acronimo));
  19. $r = $stm->fetch(PDO::FETCH_ASSOC);
  20.  
  21. $alm = new Categoria();
  22.  
  23. $alm->__SET('acronimo', $r["acronimo"]);
  24. $alm->__SET('categoria', $r["categoria"]);
  25.  
  26. return $alm;
  27. } catch (Exception $e) {
  28. die($e->getMessage());
  29. }
  30. }
  31.  
  32. $r = $stm->fetchObject(PDO::FETCH_OBJ);
  33.  
  34. <meta http-equiv="Content-Type" content="text/html"; charset=utf-8"/>
  35.  
  36. $pdo = new PDO("mysql:host=localhost;dbname=DB;charset=UTF8");
  37.  
  38. <?php
  39. $dsn = 'mysql:host=localhost;dbname=testdb';
  40. $username = 'username';
  41. $password = 'password';
  42. $options = array(
  43. PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
  44. );
  45.  
  46. $dbh = new PDO($dsn, $username, $password, $options);
  47. ?>
  48.  
  49. $alm->__SET('acronimo', $r->acronimo);
  50. $alm->__SET('categoria', $r->categoria);
  51.  
  52. $r = $stm->fetch(PDO::FETCH_ASSOC);
  53.  
  54. $alm->__SET('acronimo', $r["acronimo"]);
  55. $alm->__SET('categoria', $r["categoria"]);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement