Using Database in Menagerie

gistfile1.aw

<?php

/* this is assuming we have a database configured in the config file under the
alias of 'default' - for this example we assume it is MySQL. */

require('m/application.php');
$db = new m/database;
$id = 42;

// when using the queryf method of the database library, all format arguments
// are automatically string escaped for you using the proper database escape
// function provided by the database driver.

$query = $db->queryf(
    'SELECT * FROM test WHERE id=%d LIMIT 1;',
    $id
);

while($row = $query->next()) {
    var_dump($row);
}

?>