Queries

Once you have a Solar_Sql_Adapter object, you can start issuing queries directly and getting PDOStatement objects in return:

<?php
$sql = Solar::factory('Solar_Sql');
$pdoStatement = $sql->query('SELECT * FROM table_name');
?>

You can select rows using the fetch*() methods:

• Solar_Sql_Adapter::fetchAll() returns a sequential array of all rows. The rows themselves are associative arrays (keys are the column names).

• Solar_Sql_Adapter::fetchAssoc() returns an associative array of all rows (key is the first column).

• Solar_Sql_Adapter::fetchCol() returns a sequential array of all values in the first column.

• Solar_Sql_Adapter::fetchOne() returns the first row as an associative array (keys are the column names).

• Solar_Sql_Adapter::fetchPairs() returns an associative array where each key is the first column and each value is the second column.

• Solar_Sql_Adapter::fetchValue() returns the value of the first row in the first column.

(You can also use the Solar_Sql_Select class to programmatically build SELECT statements piece-by-piece.)

Solar_Sql also comes with some convenience methods to aid in common data manipulation tasks:

• Solar_Sql_Adapter::insert()

• Solar_Sql_Adapter::update()

• Solar_Sql_Adapter::delete()