ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:userguide:learn_abstraction:record_insertion

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:record_insertion [2016/03/20 16:45] – [Updating A Record] mnewnhamv5:userguide:learn_abstraction:record_insertion [2016/03/20 16:48] (current) – [Inserting A Record] mnewnham
Line 26: Line 26:
    
 /* /*
- * result executes "INSERT INTO people (first_name,last_name) values ('Carol',Smith')";+ * result executes "INSERT INTO people (first_name,last_name)  
 +                                values ('Carol',Smith')";
  */  */
 </code> </code>
 +
 +AutoExecute helps, because it can automatically determine the type of the field to be created, quoting data appropriately, and can even handle special characters in the fields.
 ==== 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:
v5/userguide/learn_abstraction/record_insertion.1458488713.txt.gz · Last modified: (external edit)