v5:userguide:learn_abstraction:record_insertion
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
v5:userguide:learn_abstraction:record_insertion [2016/03/15 02:10] – mnewnham | v5:userguide:learn_abstraction:record_insertion [2016/03/20 16:48] (current) – [Inserting A Record] mnewnham | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | <- v5: | + | <- v5: |
~~NOTOC~~ | ~~NOTOC~~ | ||
====== Inserting And Updating Records ====== | ====== Inserting And Updating Records ====== | ||
===== AutoExecute ===== | ===== AutoExecute ===== | ||
- | ADOdb provides a helper routine, [[v5: | + | ADOdb provides a helper routine, [[v5: |
==== Inserting A Record ==== | ==== Inserting A Record ==== | ||
In order to insert a record, it is sufficient to know: | In order to insert a record, it is sufficient to know: | ||
Line 26: | Line 26: | ||
/* | /* | ||
- | * result executes " | + | * result executes " |
+ | | ||
*/ | */ | ||
</ | </ | ||
+ | |||
+ | AutoExecute helps, because it can automatically determine the type of the field to be created, quoting data appropriately, | ||
==== Updating A Record ==== | ==== Updating A Record ==== | ||
To update a record, we must also know how to retrieve the record uniquely, for example there might be a sequence number on the table that uniquely identifies each one. In the following example, the requested record is identified by an id number of 305: | To update a record, we must also know how to retrieve the record uniquely, for example there might be a sequence number on the table that uniquely identifies each one. In the following example, the requested record is identified by an id number of 305: | ||
Line 42: | Line 45: | ||
/* | /* | ||
- | * result executes " | + | * result executes " |
+ | * last_name=' | ||
+ | * WHERE id=305"; | ||
*/ | */ | ||
</ | </ | ||
Line 49: | Line 54: | ||
If the record match statement produces a non-unique result set, then **ALL** records that match will be updated. | If the record match statement produces a non-unique result set, then **ALL** records that match will be updated. | ||
- | | + | <code php> |
+ | $db-> | ||
+ | </ | ||
+ | ===== Limitations ===== | ||
+ | AutoExecute is designed to be used as a UX helper, and contains multiple layers of validation which may cause performance issues. For improved performance, | ||
+ | <WRAP info 300px center> | ||
+ | **End Of Lesson** | ||
+ | </ |
v5/userguide/learn_abstraction/record_insertion.1458004202.txt.gz · Last modified: 2017/04/21 11:40 (external edit)