Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- define("DB", "D:/MYDB_UTF8.FDB");
- define("USER", "SYSDBA");
- define("PW", "A");
- try {
- $dsn = "firebird:dbname=localhost/3050:".DB.";charset=UTF8"; //dbname=host/porta:path
- $pdoconn = new PDO($dsn, USER, PW);
- $pdoconn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $pdoconn->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
- //$q = $pdoconn->query("SELECT * FROM USUARIO");
- $q = $pdoconn->prepare("SELECT * FROM USUARIO");
- $q->execute();
- while($row = $q->fetch(PDO::FETCH_OBJ)){
- echo $row->CODIGO."=";
- echo $row->ACESSOSISTEMA.'=';
- var_dump($row->ACESSOSISTEMA);
- echo "<br>";
- }
- } catch (PDOException $e) {
- echo "código do erro: ". $e->getCode() ."<br>". $e->getMessage();
- }
- ?>
Add Comment
Please, Sign In to add comment