philwaters/database

Simple database interface with row iterator

Database

Simple database interface with row iterator., _(*1)

Examples

Instantiation

$database = new Database($connection);

Query

To select a row from table., _(*2)

$query =
    "SELECT col1
       FROM table
      WHERE id = :col2_value";
$params = array(
    "id" => 123
);
$rows = $database->query($query);

To insert a row into table., _(*3)

$query =
    "INSERT INTO table
               ( col1 )
        VALUES ( :col1_value,
                 :col2_value )";
$params = array(
    "col1_value" => "foo",
    "col2_value" => "bar"
);
$database->query($query, $params);

Truncating Tables

To truncate table., _(*4)

$database->truncate("table");

Transactions

Using database transactions., _(*5)

$database->beginTransaction();
$database->query(...);

if (isOK()) {
    $database->commit();
} else {
    $database->rollback();
}

Renaming Tables

Renaming old_name to new_name., _(*6)

$database->renameTable("old_name", "new_name");

Swapping Tables

Swapping table_working with table_live. This can be useful when updating a working copy of a table then once complete swap it with the live table., _(*7)

$database->swapTables("table_working", "table_live");

Iterating Rows

To iterate all selected rows using foreach., _(*8)

$query =
    "SELECT a, b, c
       FROM table";
$rows = $database->query($query);

foreach ($rows as $row) {
    echo $row['a'];
}

Get All Rows

To get all rows as an array., _(*9)

$rows = $database->query($query);

echo json_encode($rows->all);

Row Count

To get the number of rows selected., _(*10)

$rows = $database->query($query);

echo count($rows);

Array Access

To access a specific row., _(*11)

$rows = $database->query($query);

echo $row[7]['col'];