while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
$table = $row[0];
$arr = explode(' ', $row[1]);
$type = end($arr);
if (preg_match('/#/', $table)) {
continue;
}
$create = DbWrapper::getCreate($table);
$rs = preg_match("/ENGINE=.+COMMENT='(.+)'\$/", $create, $matches);
$comment = $rs ? $matches[1] : '';
$table_info = compact('table', 'type', 'comment', 'create');
$found = true;
if ($f) {
$found = false;
// 这里可以用 like 语句-
$fields = DbWrapper::getFields($table);
foreach ($fields as $field) {
if (preg_match('/' . $f . '/', $field['Field'])) {
$table_info['find_field'] = $found = true;
$table_info['field_matches'][] = $field;
}
}
}
if ($found) {
$tables[] = $table_info;
}
}
$tpl = 'index-list';
}
// render
include 'index.phtml';
