Location: PHPKode > projects > phpMyDesigner > pmd_relation_new.php
<?php
include_once 'pmd_session.php';
$die_save_pos = 0;
include_once 'pmd_save_pos.php';
require_once './libraries/relation.lib.php';
extract($_POST); 

PMA_getRelationsParam();

//include_once 'pmd_relation_innodb_new.php'; // if innoDB tables
//++++++++++++++++++++++++++++++++++++++++++++++++++++ InnoDB ++++++++++++++++++++++++++++++++++++++++++++++++++++

//
$table_info_result = PMA_DBI_query('SHOW TABLE STATUS LIKE \'' . PMA_sqlAddslashes($T1, true) . '\';', NULL, PMA_DBI_QUERY_STORE);
$showtable         = PMA_DBI_fetch_assoc($table_info_result);
PMA_DBI_free_result($table_info_result);
unset( $table_info_result );
$type_T1 = strtoupper($showtable['Type']);
$table_info_result = PMA_DBI_query('SHOW TABLE STATUS LIKE \'' . PMA_sqlAddslashes($T2, true) . '\';', NULL, PMA_DBI_QUERY_STORE);
$showtable         = PMA_DBI_fetch_assoc($table_info_result);
PMA_DBI_free_result($table_info_result);
unset( $table_info_result );
$type_T2 = strtoupper($showtable['Type']);
if($type_T1 == 'INNODB' and $type_T2 == 'INNODB')
{
  // relation exist?
  $existrel_innodb = PMA_getForeigners($db, $T2, '', 'innodb'); 
  if(isset($existrel_innodb[$F2]['constraint'])) PMD_return(0,'ERROR : Relation already exists!');
  // select fields PK ?
  $result      = PMA_DBI_query('SHOW INDEX FROM ' . PMA_backquote($T1) . ';');
  $pk_array1   = array(); // will be use to emphasis prim. keys in the table view
  while ($row = PMA_DBI_fetch_assoc($result))
    if ($row['Key_name'] == 'PRIMARY')
      $pk_array1[$row['Column_name']] = 1;
  PMA_DBI_free_result($result);
  
  $result     = PMA_DBI_query('SHOW INDEX FROM ' . PMA_backquote($T2) . ';');
  $pk_array2  = array(); // will be use to emphasis prim. keys in the table view
  while ($row = PMA_DBI_fetch_assoc($result)) 
    if ($row['Key_name'] == 'PRIMARY')
      $pk_array2[$row['Column_name']] = 1;
  PMA_DBI_free_result($result);

  if(!empty($pk_array1[$F1]) && !empty($pk_array2[$F2])) 
  {
    $upd_query  = 'ALTER TABLE ' . PMA_backquote($T2)
                 . ' ADD FOREIGN KEY ('
                 . PMA_backquote($F2) . ')'
                 . ' REFERENCES '
                 . PMA_backquote($db) . '.'
                 . PMA_backquote($T1) . '('
                 . PMA_backquote($F1) . ')';

    if ($on_delete != 'nix') 
      $upd_query   .= ' ON DELETE ' . $on_delete;
    if ($on_update != 'nix') 
      $upd_query   .= ' ON UPDATE ' . $on_update;
    PMA_DBI_try_query($upd_query) or PMD_return(0,'ERROR : Relation not added!!!');
    PMD_return(1,'InnoDB relation added!');
  }
}
//---------------------------------------------------------------------------------------------------------
//
$result      = PMA_DBI_query('SHOW INDEX FROM ' . PMA_backquote($T1) . ';');
$pk_array1   = array(); // will be use to emphasis prim. keys in the table view
while ($row = PMA_DBI_fetch_assoc($result))
  if ($row['Key_name'] == 'PRIMARY')
    $pk_array1[$row['Column_name']] = 1;
PMA_DBI_free_result($result);

if(!isset($pk_array1[$F1])) PMD_return(0,'ERROR : Relation not added! First field is not Primary Key!');
//' . PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['table_coords'])
//$cfg['Server']['relation']
$q = "INSERT INTO ".PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['relation'])." 
       (master_db, master_table, master_field, foreign_db, foreign_table, foreign_field)
       VALUES ('".$db."','".$T2."','$F2','".
       $db."','".$T1."','$F1')";
PMA_query_as_cu( $q , true, PMA_DBI_QUERY_STORE);// or PMD_return(0,'ERROR : Relation not added!'); 
       
PMD_return(1,'Internal relation added!'); 

function PMD_return($b,$ret)
{
  global $db,$T1,$F1,$T2,$F2;
  die('<root act="relation_new" return="'.$ret.'" b="'.$b.'" DB1="'.$db.'" T1="'.$T1.'" F1="'.$F1.'" DB2="'.$db.'" T2="'.$T2.'" F2="'.$F2.'"></root>');
}
?>
Return current item: phpMyDesigner