Differences

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

--- dictionary:metaforeignkeys [2016/01/03 01:30] – mnewnham
+++ v5:dictionary:metaforeignkeys [2021/11/08 17:44] (current) – [metaForeignKeys] change default value for $tableName dregad
@@ Line 5: / Line 5: @@
     mixed metaForeignKeys(
         string $tableName,
-        optional string $owner=false,
+        optional string $owner='',
         optional bool $upperCase=false,
         optional bool $associative=false
@@ Line 19: / Line 19: @@
 ==== $associative====
 If specified, returns the result in associative mode. If ADODB_FETCH_MODE is already associative, then this parameter is discarded. Some drivers ignore this parameter.
+===== Return Value =====
+The method returns an array of data:
+  *  the main key represents the foreign table that the key associated with.
+  * The values of the key are either a key=>value pair, the key being the column name of the source table and the value being the column name of the foreign table if the request is ''associative'', or a numeric key with value being the same data represented as ''local column'' + '=' + ''foreign column''.
 ===== Usage =====
 <code php>
@@ Line 24: / Line 29: @@
  * Connection to MySql Employees Sample database
 */
+$db->setFetchMode(ADODB_FETCH_NUM);
 $p = $db->metaForeignKeys('dept_emp');
 print_r($p);
@@ Line 41: / Line 48: @@
 )
+*/
+</code>
+==== Same Code In Associative Mode ====
+<code php>
+$db->setFetchMode(ADODB_FETCH_ASSOC);
+$p = $db->metaForeignKeys('dept_emp');
+print_r($p);
+/*
+ * prints
+Array
+(
+    [employees] => Array
+        (
+            [emp_no]=>emp_no
+        )
+    [departments] => Array
+        (
+            [dept_no]=>dept_no
+        )
+)
+*/
 </code>