public static function createTable($table_name, $column_array)
{
$db_obj = new DatabaseAccess();
$exist_table_array = $db_obj->getAllTables();
if (!in_array($table_name, $exist_table_array)) {
$variable_list = "";
foreach ($column_array as $column_name => $attribute) {
switch ($column_name) {
case 'id':
case 'is_deleted':
case 'create_time':
case 'modify_time':
case 'delete_time':
break;
default:
$variable_list .= '`' . $column_name . '` ' . $attribute . ', ';
break;
}
// end switch ($column_name)
}
// end foreach ($column_array as $column_name => $attribute)
$sql = 'CREATE TABLE IF NOT EXISTS `' . $table_name . '` ( ' . '`id` int(11) unsigned NOT NULL, ' . $variable_list . '`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT \'0\', ' . '`create_time` datetime NOT NULL, ' . '`modify_time` datetime NOT NULL DEFAULT \'0000-00-00 00:00:00\', ' . '`delete_time` datetime NOT NULL DEFAULT \'0000-00-00 00:00:00\' ' . ') ENGINE=InnoDB DEFAULT CHARSET=utf8;';
$create_result = $db_obj->query($sql);
$sql = "ALTER TABLE `{$table_name}` ADD PRIMARY KEY (`id`);";
$primary_key_result = $db_obj->query($sql);
$sql = "ALTER TABLE `{$table_name}` MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT;";
$auto_increment_result = $db_obj->query($sql);
unset($db_obj);
return $create_result && $primary_key_result && $auto_increment_result;
} else {
// end if (!in_array($table_name, $exist_table_array))
unset($db_obj);
return false;
}
// end if (!in_array($table_name, $exist_table_array)) else
}
<label class="control-label" for="table-list">Import Table</label>
<div class="controls">
<div class="span2" style="margin-left: 0;">
<input type="hidden" id="table-list" name="table_list" value="" />
<table class="table table-bordered table-condensed">
<thead>
</thead>
<tbody>
<tr>
<td><input type="checkbox" id="table-checkbox-all" /></td>
<td class="span2"><strong>Table Name</strong></td>
</tr>
<tr><td colspan="2"></td></tr>
<?php
$db_obj = new DatabaseAccess();
$exist_table_array = $db_obj->getAllTables();
$new_table_array = array();
foreach (glob(TABLE_SQL_ROOT . '/*.sql') as $sql_file) {
$new_table_array[] = str_replace('.sql', '', str_replace(TABLE_SQL_ROOT . '/', '', $sql_file));
}
// foreach (glob(TABLE_SQL_ROOT.'/*.sql') as $sql_file)
$total_table_array = array_unique(array_merge($exist_table_array, $new_table_array));
asort($total_table_array);
foreach ($total_table_array as $table_name) {
if (in_array($table_name, $exist_table_array)) {
?>
<tr>
<td></td>
<td class="input-medium"> <?php
echo $table_name;
?>
