// Connect to PostgreSQL using the mysqli-style API
$conn = mysqlipg_connect('localhost', 'postgres', 'password', 'mydb', 5432);

// Queries are automatically translated from MySQL to PostgreSQL
$result = mysqlipg_query($conn, "SHOW TABLES");
while ($row = mysqlipg_fetch_assoc($result)) {
    print_r($row);
}

// MySQL functions are translated transparently
$result = mysqlipg_query($conn, "SELECT IFNULL(name, 'unknown'), RAND() FROM users LIMIT 10,5");
// Becomes: SELECT COALESCE(name, 'unknown'), RANDOM() FROM users LIMIT 5 OFFSET 10

// Backtick-quoted identifiers work
$result = mysqlipg_query($conn, "SELECT `user`.`name` FROM `user` WHERE `id` = 1");

// Prepared statements
$stmt = mysqlipg_prepare($conn, "SELECT * FROM users WHERE age > ? AND city = ?");
mysqlipg_stmt_bind_param($stmt, "is", $age, $city);
mysqlipg_stmt_execute($stmt);
$result = mysqlipg_stmt_get_result($stmt);
while ($row = mysqlipg_fetch_assoc($result)) {
    print_r($row);
}
mysqlipg_stmt_close($stmt);

mysqlipg_close($conn);

$conn = new MysqliPg('localhost', 'postgres', 'password', 'mydb', 5432);

$result = $conn->query("SELECT DATABASE() AS db");
$row = $result->fetch_assoc();
echo $row['db']; // current PostgreSQL database name

// Transactions
$conn->begin_transaction();
$conn->query("INSERT INTO orders (product, qty) VALUES ('Widget', 5)");
$conn->query("UPDATE inventory SET stock = stock - 5 WHERE product = 'Widget'");
$conn->commit();

// Prepared statements
$stmt = $conn->prepare("INSERT INTO logs (msg, level) VALUES (?, ?)");
$stmt->bind_param("si", $message, $level);
$stmt->execute();
echo $conn->insert_id;
$stmt->close();

$conn->close();