Simple connection from PHP to Firebird - Revision history

George2: Created page with "
2024-03-21T10:47:47Z

Created page with "<source lang=php> <?php // Database connection settings $host = 'localhost'; $database = 'YOUR_DATABASE_NAME'; $username = 'YOUR_USERNAME'; $password = 'YOUR_PASSWORD'; try {..."

New page
<source lang=php>
<?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();
}
?>
</source>