ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:dictionary:metaforeignkeys

This is an old revision of the document!


metaForeignKeys

Syntax
  mixed metaForeignKeys(
      string $tableName,
      optional string $owner=false,
      optional bool $upperCase=false,
      optional bool $associative=false
      )

Description

The function metaForeignKeys() returns an array of the foreign keys associated with a specific table. If there are no foreign keys then the function returns false.

Optional Parameters

$owner

If specified, only returns foreign keys associated with a table owned by that name. Some drivers discard this parameter

$upper

if specified, only matches the table with the uppercase name. This parameter is discarded by some drivers

$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

/*
 * Connection to MySql Employees Sample database
*/
$db->setFetchMode(ADODB_FETCH_NUM);
 
$p = $db->metaForeignKeys('dept_emp');
print_r($p);
/*
 * prints
Array
(
    [employees] => Array
        (
            [0] => emp_no=emp_no
        )
 
    [departments] => Array
        (
            [0] => dept_no=dept_no
        )
 
)
*/
 
$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
        )
 
)
*/
v5/dictionary/metaforeignkeys.1451829319.txt.gz · Last modified: 2017/04/21 11:27 (external edit)