<? $this->title('Structure of `'.$table.'`') ?> <p><a href="<?php echo $app->_url('table-data', $table); ?> ">Table data</a></p> <?php echo '<table><thead><tr>'; echo '<th>Name</th>'; $k0 = key($columns); foreach ($columns[$k0] as $k => $v) { echo '<th>' . $this::html($k) . '</th>'; } echo '</tr></thead><tbody>'; foreach ($columns as $name => $row) { echo '<tr>'; echo '<td>' . $this::html(row\utils\Inflector::spacify($name)) . '</td>'; foreach ($row as $k => $v) { echo '<td>' . $this::html($v) . '</td>'; } echo '</tr>'; } echo '</tbody></table>';
<? $this->title('Tables') ?> <ul> <?foreach( $tables AS $table ):?> <li><?php echo row\utils\Inflector::spacify($table); ?> ( <a href="<?php echo $app->_url('table-data', $table); ?> ">data</a> - <a href="<?php echo $app->_url('table-structure', $table); ?> ">structure</a> )</li> <?endforeach?> </ul>
</ul> <?else:?> <p><a href="<?php echo $app->_url('table-data', $table . '/add'); ?> ">Add more data</a></p> <table> <thead> <tr> <? $k0 = key($data) ?> <?foreach( $data[$k0] AS $k => $v ):?> <th><?php echo $this::html(row\utils\Inflector::spacify($k)); ?> </th> <?endforeach?> <td colspan=2></td> </tr> </thead> <tbody> <?foreach( $data AS $row ):?> <tr> <? $pkValues = array() ?> <?foreach( $row AS $k => $v ):?> <td><?php echo $this::html($v); ?> </td>