======= Queries ======= Once you have a Solar_Sql_Adapter object, you can start issuing queries directly and getting PDOStatement objects in return: {{code: 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 [[Class::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()]]