How can I make a select in PHP With FIREBIRD PDO?

Question:

I've already made a correct connection with Firebird using PHP, however I would like to know how I can make a select in a certain database. Can someone help me please?

<?php

$user = "SYSDBA";
$pass = "masterkey";
try{
$lokos=new PDO("firebird:localhost=ja sei 0;dbname=ja sei também",$user,$pass);
 }catch(PDOException $e) {

        echo "Falha na conexão.".$e->getcode();
 }

?>

Answer:

Do it this way:

 $user = "SYSDBA"; $pass = "masterkey"; try{ $lokos=new PDO("firebird:localhost=ja sei 0;dbname=ja sei também",$user,$pass); }catch(PDOException $e) { echo "Falha na conexão.".$e->getcode(); } $stmt = $lokos->prepare("select * from tabela"); $stmt->execute(); $dados = $stmt->fetchAll(PDO::FETCH_OBJ); foreach ($dados as $row) { echo "{$row->nome_do_campo} <br/>"; } ?>

For more details, read the official documentation .