PEAR::DB

25/64

dbx

Metabase

• Bundled with PHP (part of PEAR)
• Written in PHP
• Supports: dBase, FrontBase, Interbase, Informix, mSQL, Microsoft SQL Server, MySQL, Oracle, ODBC, PostgreSQL, Sybase
• Next major version to be based on Metabase

<?php
require 'DB.php';

$conn = DB::connect("dsn");
if (DB::isError($conn))
  die("connection failed: ".$conn->getMessage());

$result = $conn->query("SELECT ... ");
if (DB::isError($result))
  die("query failed: ".$result->getMessage());

while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) {
  echo " $row[id] ... ";
}