ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:dictionary:metaforeignkeys

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:dictionary:metaforeignkeys [2026/02/14 01:09] – change description of options mnewnhamv5:dictionary:metaforeignkeys [2026/02/26 00:40] (current) – [Return Value] dregad
Line 22: Line 22:
 The method returns an array of data: The method returns an array of data:
   * The main key represents the foreign table that the key associated with.   * 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''.+  * 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''.
  
 +===== Explanation =====
 +A table **//parent_table//** has a foreign key that references **//foreign_table//**. **//parent_table//** has 2 columns **//parent_id//** and **//parent_type//**. These 2 columns reference corresponding columns in **//foreign_table//**, **//foreign_id//** and **//foreign_type//**. ''metaForeignKeys('parent_table')'' presents this data in the following way:
 +==== Associative Mode ==== 
 +<code php>
 +[
 +    ['foreign_table'] [
 +        ['parent_id'] => 'foreign_id',
 +        ['parent_type'] => 'foreign_type'
 +    ]
 +]
 +</code>
 +==== Numeric Mode ====
 +<code php>
 +[
 +    ['foreign_table'] => [
 +        [0] => 'parent_id=foreign_id',
 +        [1] => 'parent_type=foreign_type'
 +    ]
 +]
 +</code>
 ===== Usage ===== ===== Usage =====
 <code php> <code php>
v5/dictionary/metaforeignkeys.1771027756.txt.gz · Last modified: by mnewnham