ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:userguide:learn_abstraction:basic_query

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
v5:userguide:learn_abstraction:basic_query [2016/03/15 01:18] – mnewnhamv5:userguide:learn_abstraction:basic_query [2016/03/15 14:27] (current) – mnewnham
Line 1: Line 1:
 <- v5:userguide:learn_abstraction:establishing_connection|Establishing A Connection ^ v5:userguide:learn_abstraction:start_lesson|Start Of Lesson ^ v5:userguide:learn_abstraction:key_value_pairs|Key/Value Pairs -> <- v5:userguide:learn_abstraction:establishing_connection|Establishing A Connection ^ v5:userguide:learn_abstraction:start_lesson|Start Of Lesson ^ v5:userguide:learn_abstraction:key_value_pairs|Key/Value Pairs ->
 +~~NOTOC~~
 ====== A Basic Query ====== ====== A Basic Query ======
 The simplest way that ADOdb can retrieve data is through the [[v5:reference:connection:getall|getAll()]] method. This method reads the selected rows from the database into an array. Once retrieved, the data in the recordset is inserted into an array. The simplest way that ADOdb can retrieve data is through the [[v5:reference:connection:getall|getAll()]] method. This method reads the selected rows from the database into an array. Once retrieved, the data in the recordset is inserted into an array.
Line 27: Line 27:
 </code> </code>
  
 +===== Changing How Data Is Returned =====
 The array can be returned in one of 3 ways: numeric, associative or mixed. The example above shows the returned data in associative format. In numeric format, the same array would look like this: The array can be returned in one of 3 ways: numeric, associative or mixed. The example above shows the returned data in associative format. In numeric format, the same array would look like this:
  
Line 46: Line 47:
 For more information on setting the returned data format, see [[v5:reference:adodb_fetch_mode|$ADODB_FETCH_MODE]] For more information on setting the returned data format, see [[v5:reference:adodb_fetch_mode|$ADODB_FETCH_MODE]]
  
-==== Similar Commands ====+===== Alternative Commands =====
 There are a number of similar commands that can be used as coding shortcuts. For an exhaustive list, see the [[v5:reference:index|Reference Manual]]. There are a number of similar commands that can be used as coding shortcuts. For an exhaustive list, see the [[v5:reference:index|Reference Manual]].
  
 ^Command^Description| ^Command^Description|
-|[[v5:reference:connection:getcol|getCol()]]|Executes a provided SQL statement and returns the first row of the entire recordset into a numeric array|  +|[[v5:reference:connection:getcol|getCol()]]|Executes a provided SQL statement and returns the first **column** of the entire result set into a numeric array, no matter how large. If multiple columns are retrieved by the SQL statement, all but the first are discarded|  
-|[[v5:reference:connection:getone|getOne()]]|Retrieves the first column of the first matching row of an executed SQL statement|  +|[[v5:reference:connection:getone|getOne()]]|Executes a provided SQL statement and returns the first **column** of the first matching **row** into a variable. If multiple columns are retrieved by the SQL statement, all but the first are discarded|  
-|[[v5:reference:connection:getrow|getRow()]]|Retrieves the first matching row of an executed SQL statement|+|[[v5:reference:connection:getrow|getRow()]]|Executes a provided SQL statement and returns the first matching **row** into a array. If multiple rows are retrieved by the SQL statement, all but the first are discarded|
v5/userguide/learn_abstraction/basic_query.1458001120.txt.gz · Last modified: 2017/04/21 11:40 (external edit)