4, 4.1.y y>12 and also works in 4.0.11, so I decided not to // check for version if ($tbl_type == 'MYISAM' || $tbl_type == 'INNODB') { $sql_query .= !empty($new_auto_increment) ? ' auto_increment=' . PMA_sqlAddslashes($new_auto_increment) : ''; } $result = PMA_DBI_query($sql_query); $message = $strSuccess; $reread_info = TRUE; } if ($reread_info) { require('./tbl_properties_table_info.php'); } unset($reread_info); /** * Reordering the table has been requested by the user */ if (isset($submitorderby) && !empty($order_field)) { $sql_query = 'ALTER TABLE ' . PMA_backquote($table) . ' ORDER BY ' . PMA_backquote(urldecode($order_field)); if (isset($order_order) && $order_order == 'desc') { $sql_query .= ' DESC'; } $result = PMA_DBI_query($sql_query); $message = $result ? $strSuccess : $strError; } // end if /** * Gets tables informations */ require_once('./tbl_properties_table_info.php'); /** * Displays top menu links */ require_once('./tbl_properties_links.php'); /** * Get columns names */ $local_query = 'SHOW COLUMNS FROM ' . PMA_backquote($table) . ' FROM ' . PMA_backquote($db); $result = PMA_DBI_query($local_query); for ($i = 0; $row = PMA_DBI_fetch_assoc($result); $i++) { $columns[$i] = $row['Field']; } PMA_DBI_free_result($result); unset($result); ?>
$arr) { $join_query = 'SELECT ' . PMA_backquote($table) . '.* FROM ' . PMA_backquote($table) . ' LEFT JOIN ' . PMA_backquote($arr['foreign_table']); if ($arr['foreign_table'] == $table) { $foreign_table = $table . '1'; $join_query .= ' AS ' . PMA_backquote($foreign_table); } else { $foreign_table = $arr['foreign_table']; } $join_query .= ' ON ' . PMA_backquote($table) . '.' . PMA_backquote($master) . ' = ' . PMA_backquote($foreign_table) . '.' . PMA_backquote($arr['foreign_field']) . ' WHERE ' . PMA_backquote($foreign_table) . '.' . PMA_backquote($arr['foreign_field']) . ' IS NULL AND ' . PMA_backquote($table) . '.' . PMA_backquote($master) . ' IS NOT NULL'; echo ' ' . '' . $master . ' -> ' . $arr['foreign_table'] . '.' . $arr['foreign_field'] . ' ' . "\n"; unset($foreign_table); unset($join_query); } // end while ?> |