tableKeyHasMany

Syntax

void ADODB_Active_Record::tableKeyHasMany(
  string $parentTable, 
  string $parentTablePrimaryKey, 
  string $childTable,
  optional string $foreignKey = ' ', 
  optional string $foreignClass = 'ADODB_Active_Record'
 )

Description

For some classes, the mapping between class name and table name (which is the pluralised version) might not match or the primary key is not the default id. For example, the class name might be person, but the table name might be people

Parameters

$parentTable

The parent table in the relationship

$parentTablePrimaryKey

The key field for the parent table

$childTable

The child table in the relationship

$foreignKey

If, due to database design constraints, the key field in the child table is not named the same as that of the parent table, specify it here.

$foreignClass

If the class name for the child table differs from that of the parent, for example there has been some extension of methods, specify it here

Usage

ADODB_Active_Record::TableKeyHasMany('people', 'pid', 'children', 'person_id');