v5:userguide:portable_sql
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
v5:userguide:portable_sql [2016/02/27 18:39] – mnewnham | v5:userguide:portable_sql [2016/03/13 23:52] – [Inserting Records] mnewnham | ||
---|---|---|---|
Line 34: | Line 34: | ||
==== Fetch Modes Within Select Statements ==== | ==== Fetch Modes Within Select Statements ==== | ||
- | PHP allows you to retrieve database records as arrays. You can choose to have the arrays indexed by field name or number. However different low-level PHP database drivers are inconsistent in their indexing efforts. ADOdb allows you to determine your prefered mode. You set this by setting the variable [[v5: | + | PHP allows you to retrieve database records as arrays. You can choose to have the arrays indexed by field name or number. However different low-level PHP database drivers are inconsistent in their indexing efforts. ADOdb allows you to determine your prefered mode. You set this by setting the variable [[v5: |
* ADODB_FETCH_NUM (for numeric indexes) | * ADODB_FETCH_NUM (for numeric indexes) | ||
* ADODB_FETCH_ASSOC (using field names as an associative index). | * ADODB_FETCH_ASSOC (using field names as an associative index). | ||
Line 44: | Line 44: | ||
Another problem with SELECTs is that some databases do not return the number of rows retrieved from a select statement. This is because the highest performance databases will return records to you even before the last record has been found. | Another problem with SELECTs is that some databases do not return the number of rows retrieved from a select statement. This is because the highest performance databases will return records to you even before the last record has been found. | ||
- | In ADOdb, [[v5: | + | In ADOdb, [[v5: |
If you prefer to set '' | If you prefer to set '' | ||
Line 98: | Line 98: | ||
===== Inserting Records ===== | ===== Inserting Records ===== | ||
- | When you create records, you need to generate unique id's for each record. There are two common techniques: | + | When you create records, you need to generate unique id's for each record. There are two common techniques: |
+ | * Auto-increment | ||
+ | * Sequences | ||
- | Auto-incrementing | + | Auto-increment |
+ | |||
+ | Different tables can have different sequences. | ||
<code php> | <code php> | ||
$id = $connection-> | $id = $connection-> | ||
$connection-> | $connection-> | ||
- | values ($id, $firstname, $lastname)" | + | values ($id, $firstname, $lastname)" |
</ | </ | ||
- | For databases that do not support | + | For databases that do not provide native |
===== Binding ===== | ===== Binding ===== |
v5/userguide/portable_sql.txt · Last modified: 2020/12/30 21:32 by peterdd