Difference between revisions of "Simple connection from PHP to Firebird"

<?php
// Database connection settings
$host = 'localhost';
$database = 'YOUR_DATABASE_NAME';
$username = 'YOUR_USERNAME';
$password = 'YOUR_PASSWORD';
 
try {
    $conn = new PDO("firebird:host=$host;dbname=$database", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
 
    $sql = "SELECT * FROM YOUR_TABLE_NAME";
    $stmt = $conn->prepare($sql);
    $stmt->execute();
 
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        // Access data from the row
        echo $row['column1'] . " - " . $row['column2'] . "<br>";
    }
 
} catch(PDOException $e) {
    echo "Error: " . $e->getMessage();
}
?>