if (!$res) { $body->line('no further feedback'); } else { $table = new Table(); $table->setClas('result'); $table->setId('listing'); $table->build(); $odd = TRUE; foreach ($res as $item) { if (!$titles) { $tr = new Th(); $names = array_keys(get_object_vars($item)); foreach ($names as $title) { $tr->add($title); } $tr->build(); $titles = TRUE; } $tr = new Tr(); if ($odd) { $tr->setGlobalClass('even'); $odd = FALSE; } else { $tr->setGlobalClass('odd'); $odd = TRUE; } foreach ($item as $data) { // display odd characters $tr->add(htmlentities($data)); } $tr->build();
$body->line(); $q = "PRAGMA index_list(" . $req->get('table') . ")"; $sql->qo($q); $res = $sql->fo(); if (!$res) { $body->line('No indexes defined<br>'); } else { $table = new Table(); $table->setClas('result'); $table->build(); $th = new Th(); $th->add('Name'); $th->add('Unique ?'); $th->add('Columns'); $th->add(' '); $th->build(); foreach ($res as $item) { if ($item->unique == 1) { $uniq = 'Y'; } else { $uniq = 'N'; } $drop = new Link(); $drop->setHref('controller.php?cmd=drop_idx&idxname=' . $item->name . '&table=' . $req->get('table')); $drop->setName('[ drop ]'); $drop->setJs(' onclick="return PSA.really_drop(\' index [' . $item->name . ']\');" '); $tr = new Tr(); if ($odd) { $tr->setGlobalClass('even'); $odd = FALSE; } else {