</td>
</tr>
<?php
}
?>
</tbody>
</table>
<br />
Parent Database(s):<br />
<table border="1" style="width: 90%; margin-left: auto; margin-right: auto;"
class="table table-striped table-bordered table-hover">
<tbody>
<?php
//show parent databases
$parent_databases = Table::get_parent_databases($table_info['Table_ID']);
while ($parent_database = mysqli_fetch_assoc($parent_databases)) {
?>
<tr>
<td>
<a href="database_info.php?database_id=<?php
echo $parent_database['Database_ID'];
?>
"><?php
echo stripslashes($parent_database['Database_Name']);
?>
</a>
</td>
</tr>
<?php
}
<?php
include_once dirname(__FILE__) . '/../classes/table.php';
if (isset($_POST['Table_ID'])) {
$table_id = $_POST['Table_ID'];
} else {
$table_id = $_GET['table_id'];
}
//show parent databases
$parent_databases = Table::get_parent_databases($table_id);
while ($parent_database = mysqli_fetch_assoc($parent_databases)) {
?>
<div id="parent_database_<?php
echo $parent_database['Database_ID'];
?>
" class="btn btn-mini btn-warning">
<a href="javascript:;" title="Remove This Database" onclick="
if (confirm('Are you sure you want to delete this relationship?')) {
$.post(
'ajax/delete_database_table_relationship.php',
{
Database_Table_ID: <?php
echo $parent_database['Database_Table_ID'];
?>
},
function (response){
if (response == '') {
document.getElementById('table_message_box').innerHTML = '<i class=\'icon-ok\'></i> Removed relationship successfully';
$('#table_message_box').attr('class', 'alert alert-success');
$('#table_message_box').slideDown('slow').delay(3000).slideUp('slow');
} else {
