Differences

This shows you the differences between two versions of the page.

--- v5:reference:connection:substr [2016/04/10 15:02] – mnewnham
+++ v5:reference:connection:substr [2016/04/10 23:42] (current) – mnewnham
@@ Line 6: / Line 6: @@
   string substr(
       string $fieldName,
-      integer $offset,
+      int $startPoint,
-      optional integer $length
+      optional int $length
       )
 </WRAP>
-===== Desscription =====
+===== Description =====
 The method ''substr()'' creates an SQL statement that returns the substring of a specified string field.
  ===== Parameters =====
@@ Line 16: / Line 16: @@
 The fieldname to be substringed. The fieldname must be accessible as part of the current SQL statement.
-==== $startpoint ====
+==== $startPoint ====
 The starting point within the original string for the substring to begin. Offsets in SQL statements are 1 based, rather than the normal 0 (Zero) based offsets used in PHP.
@@ Line 26: / Line 26: @@
 <code php>
 /*
-* To return the first code plus the first 20 characters of a description.
+* To return the an associative array of codes plus
+* the first 20 characters of a description.
 */
 $sql = "SELECT code, {$db->substr('description',1,20)} FROM some_table";
 $data = $db->getAssoc($sql);
 </code>
+===== Negative Offsets =====
+Not all databases support the use of negative offsets (to return values based on the end of the string), so use in portable applications is not recommended.