Guest User

Untitled

a guest
Nov 4th, 2016
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.76 KB | None | 0 0
  1. <?php
  2.  
  3.     define("DB", "D:/MYDB_UTF8.FDB");
  4.  
  5.     define("USER", "SYSDBA");
  6.     define("PW", "A");
  7.  
  8.     try {
  9.  
  10.         $dsn = "firebird:dbname=localhost/3050:".DB.";charset=UTF8"; //dbname=host/porta:path
  11.         $pdoconn = new PDO($dsn, USER, PW);
  12.         $pdoconn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  13.         $pdoconn->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
  14.  
  15.         //$q = $pdoconn->query("SELECT * FROM USUARIO");
  16.  
  17.         $q = $pdoconn->prepare("SELECT * FROM USUARIO");
  18.         $q->execute();
  19.  
  20.         while($row = $q->fetch(PDO::FETCH_OBJ)){
  21.             echo $row->CODIGO."=";
  22.             echo $row->ACESSOSISTEMA.'=';
  23.             var_dump($row->ACESSOSISTEMA);
  24.             echo "<br>";
  25.         }
  26.  
  27.     } catch (PDOException $e) {
  28.         echo "código do erro: ". $e->getCode() ."<br>". $e->getMessage();
  29.     }
  30. ?>
Add Comment
Please, Sign In to add comment