v5:userguide:userguide_index
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:userguide_index [2016/03/19 04:04] – [Example 4: Debugging] mnewnham | v5:userguide:userguide_index [2016/04/18 03:29] – [Additional Documentation] mnewnham | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | <WRAP todo> | ||
- | This page is under reconstruction | ||
- | </ | ||
<WRAP right box> | <WRAP right box> | ||
[[v5: | [[v5: | ||
Line 9: | Line 6: | ||
===== List Of Tutorials ===== | ===== List Of Tutorials ===== | ||
==== Basic Tasks ==== | ==== Basic Tasks ==== | ||
- | |[[v5: | + | < |
- | |[[v5: | + | <wrap left 180px>[[v5: |
- | |[[v5: | + | <wrap left 450px>Using basic ADOdb commands to read data from and write back to the database</ |
+ | </ | ||
+ | -------------------------- | ||
+ | < | ||
+ | <wrap left 180px>[[v5: | ||
+ | <wrap left 450px>How to obtain information about database fields, columns and tables</ | ||
+ | </ | ||
+ | ---------------------------- | ||
+ | < | ||
+ | <wrap left 180px>[[v5: | ||
+ | <wrap left 450px>Understanding how to work with the most detailed level of data provided by ADOdb</ | ||
+ | </ | ||
+ | ------------------------------- | ||
==== Advanced Tasks ==== | ==== Advanced Tasks ==== | ||
- | | [[v5: | + | < |
- | | [[v5: | + | <wrap left 180px>[[v5: |
- | | [[v5: | + | <wrap left 450px>Understanding Transaction scope, and how to start, stop and roll back transactions |
- | ===== Additional Documentation ===== | + | </ |
+ | ---------------------------- | ||
+ | < | ||
+ | <wrap left 180px> | ||
+ | <wrap left 450px> | ||
+ | </ | ||
+ | ---------------------------- | ||
+ | < | ||
+ | <wrap left 180px>[[v5: | ||
+ | <wrap left 450px>Controlling connections and transaction | ||
+ | </ | ||
+ | ---------------------------- | ||
+ | < | ||
+ | <wrap left 180px> | ||
+ | <wrap left 450px> | ||
+ | </ | ||
+ | --------------------------- | ||
+ | < | ||
+ | <wrap left 180px>[[v5: | ||
+ | <wrap left 450px>Adding new functionality and changing the behaviour of existing drivers</ | ||
+ | </ | ||
+ | -------------------------- | ||
- | [[v5: | ||
- | [[project: | ||
- | [[v5: | ||
- | [[v5: | ||
- | [[v5: | ||
- | [[v5: | ||
- | [[v5: | ||
+ | ===== Additional Documentation ===== | ||
- | + | < | |
- | ===== Example 3: Inserting ===== | + | <wrap left 180px> |
- | + | <wrap left 450px>A guide to establishing connections across | |
- | Insert a row to the Orders table containing dates and strings that need to be quoted before they can be accepted by the database, eg: the single-quote in the word John' | + | </ |
- | + | ---------------------------- | |
- | <code php> | + | < |
- | include(' | + | <wrap left 180px> |
- | $conn = adoONewConnection(' | + | <wrap left 450px> |
- | $conn-> | + | </ |
- | + | ---------------------------- | |
- | /* | + | < |
- | * Inserting a string containing quote characters | + | <wrap left 180px> |
- | * may cause a statement | + | <wrap left 450px> |
- | */ | + | </WRAP> |
- | $shipto = $conn->qstr(" | + | ---------------------------- |
- | $orderDate = $conn->dbDate(time()); | + | <WRAP> |
- | + | <wrap left 180px> | |
- | $sql = " | + | <wrap left 450px> |
- | $sql .= " | + | </ |
- | + | ---------------------------- | |
- | if ($conn->Execute($sql) === false) | + | <WRAP> |
- | print 'error inserting: ' | + | <wrap left 180px>[[v5: |
- | + | <wrap left 450px> | |
- | </code> | + | </WRAP> |
- | + | ---------------------------- | |
- | In this example, we see the advanced date and quote handling facilities of ADOdb. The unix timestamp (which is a long integer) is appropriately formatted for Access with [[v5:reference: | + | < |
- | + | <wrap left 180px>[[v5:userguide:stored_procedure|Stored Procedure Example]]</ | |
- | The correct escape character is used for quoting the John's Old Shoppe, which is John``s Old Shoppe and not PHP's default John's Old Shoppe by using [[v5:reference:connection: | + | <wrap left 450px> |
- | + | </ | |
- | Observe the error-handling of the Execute statement. False is returned by Execute() if an error occurred. The error message for the last error that occurred is displayed in [[v5:reference: | + | ---------------------------- |
+ | < | ||
+ | <wrap left 180px>[[v5:userguide:deprecated|Deprecated Functionality]]</ | ||
+ | <wrap left 450px> | ||
+ | </ | ||
+ | ----------------------------- | ||
+ | < | ||
+ | <wrap left 180px>[[v5:database:feature_comparison|Feature Comparison Matrix]]</ | ||
+ | <wrap left 450px> | ||
+ | </ | ||
v5/userguide/userguide_index.txt · Last modified: 2020/01/13 15:50 by dregad