1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | <?php include_once('common.inc.php'); include_header(); $db = $server->get_db('disclosr-agencies'); if (isset($_REQUEST['id'])) { //get an agency record as json/html, search by name/abn/id // by name = startkey="Ham"&endkey="Ham\ufff0" // edit? $row = $db->get($_REQUEST['id']); //print_r($row); echo '<table width="100%">'; echo '<tr> <td colspan="2"><h3>' . $row->name . "</h3></td></tr>"; echo "<tr><th>Field Name</th><th>Field Value</th></tr>"; foreach ($row as $key => $value) { if (is_a($value, 'stdClass')) { echo "<tr><td>$key</td><td>" . var_dump($value, true) . "</td></tr>"; } else echo "<tr><td>$key</td><td>$value</td></tr>"; } echo "</table>"; } else { $rows = $db->get_view("app", "showNamesABNs")->rows; //print_r($rows); foreach ($rows as $row) { // print_r($row); echo '<li><a href="getAgency.php?id=' . $row->key . '">' . (isset($row->value->name) && $row->value->name != "" ? $row->value->name : "NO NAME " . $row->value->abn) . '</a></li>'; } } include_footer(); |