% layout "$controller/common", title => "Select * from $table";

<h2>select * from <i><%= $table %></i></h2>
<form method="get" action="<%= url_for %>" >
  <div class="condition">
    where <%= select_field condition_column => $header %>
      like
      <%= input_tag 'condition_value', size => 50 %>
      <%= submit_button 'Search' %>
      <%= hidden_field database => param('database') %>
      <%= hidden_field table => param('table') %>
  </div>
</form>
<div style="margin-left:40px; margin-bottom:15px; font-size:150%">
  % my $first_count = ($pager->current_page - 1) * $pager->entries_per_page + 1;
  % my $last_count = $first_count + $pager->entries_on_this_page - 1;
  <%= $first_count %> to <%= $last_count %> (Total <i><%= $pager->total_entries %></i> count)
</div>

<table>
<tr>
  % for my $h (@$header) {
      <th><%= $h %></th>
  % }
</tr>
% for my $row (@$rows) {
  <tr>
    % for my $data (@$row) {
      <td><%= $data %></td>
    % }
  </tr>
% }
</table>

%= include "$controller/pagenavi";