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:31] – [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: | ||
- | |||
- | |||
- | |||
- | ===== Example 3: Inserting ===== | ||
- | |||
- | 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(' | ||
- | $conn = adoONewConnection(' | ||
- | $conn-> | ||
- | |||
- | /* | ||
- | * Inserting a string containing quote characters | ||
- | * may cause a statement to fail if not pre-processed | ||
- | */ | ||
- | $shipto = $conn-> | ||
- | $orderDate = $conn-> | ||
- | |||
- | $sql = " | ||
- | $sql .= " | ||
- | |||
- | if ($conn-> | ||
- | print 'error inserting: ' | ||
- | |||
- | </ | ||
- | |||
- | 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: | ||
- | |||
- | 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: | ||
- | |||
- | 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: | ||
+ | ===== Additional Documentation ===== | ||
+ | < | ||
+ | <wrap left 180px> | ||
+ | <wrap left 450px>A guide to establishing connections across the supported databases</ | ||
+ | </ | ||
+ | ---------------------------- | ||
+ | < | ||
+ | <wrap left 180px> | ||
+ | <wrap left 450px> | ||
+ | </ | ||
+ | ---------------------------- | ||
+ | < | ||
+ | <wrap left 180px> | ||
+ | <wrap left 450px> | ||
+ | </ | ||
+ | ---------------------------- | ||
+ | < | ||
+ | <wrap left 180px> | ||
+ | <wrap left 450px> | ||
+ | </ | ||
+ | ---------------------------- | ||
+ | < | ||
+ | <wrap left 180px> | ||
+ | <wrap left 450px> | ||
+ | </ | ||
+ | ---------------------------- | ||
+ | < | ||
+ | <wrap left 180px> | ||
+ | <wrap left 450px> | ||
+ | </ | ||
+ | ----------------------------- | ||
+ | < | ||
+ | <wrap left 180px> | ||
+ | <wrap left 450px> | ||
+ | </ | ||
+ | ---------------------------- | ||
+ | < | ||
+ | <wrap left 180px> | ||
+ | <wrap left 450px> | ||
+ | </ |
v5/userguide/userguide_index.txt · Last modified: 2020/01/13 15:50 by dregad