View Issue Detail

ID	Project	Category	Submitted / Last Updated
00809	UserSpice	Misc	2020-02-07 18:04:03 / 2020-06-30 23:04:41
Reported	Dan Hoover	Assigned To	Unassigned
Priority	normal	Reported	5.0.09
Status	closed	Resolution Version and Commit
Summary	Add tableFromQuery function
Description	<p>function tableFromQuery($results,$opts = []){</p> <p>  if(!isset($opts['class'])) {$opts['class'] = "table table-striped paginate"; }</p> <p>  if(!isset($opts['thead'])) {$opts['thead'] = ""; }</p> <p>  if(!isset($opts['tbody'])) {$opts['tbody'] = ""; }</p> <p>  if(!isset($opts['keys'])){</p> <p>    foreach($results['0'] as $k=>$v){</p> <p>      $opts['keys'][] = $k;</p> <p>    }</p> <p>  }</p> <p>  ?></p> <p>  <table class="<?=$opts['class']?>"></p> <p>    <thead class="<?=$opts['thead']?>"></p> <p>      <tr></p> <p>        <?php foreach($opts['keys'] as $k){?></p> <p>          <th><?php echo ucfirst($k);?></th></p> <p>        <?php } ?></p> <p>      </tr></p> <p>    </thead></p> <p>    <tbody class="<?=$opts['tbody']?>"></p> <p>      <?php foreach($results as $r){?></p> <p>        <tr></p> <p>          <?php foreach($r as $k=>$v){ ?></p> <p>            <td><?=$v?></td></p> <p>          <?php } ?></p> <p>        </tr></p> <p>      <?php } ?></p> <p>    </tbody></p> <p>  </table></p> <p><?php } ?></p>