Viewing File: D:\INETPUB\VHOSTS\officespacebangalore.com\httpdocs\admin-1\properties.php

<?php $title='Properties'; require_once __DIR__.'/_header.php'; $rows=db()->query('SELECT pid,title,city,state,stype,price,size,status,isFeatured,date FROM property ORDER BY pid DESC')->fetchAll(); ?><section class="admin-panel"><div class="panel-head"><div><h2>Property inventory</h2><p class="muted">Every record comes from your existing <code>property</code> table.</p></div><a class="admin-btn" href="<?=url('admin/property-edit.php')?>">+ Add property</a></div><div class="table-wrap"><table><thead><tr><th>ID</th><th>Property</th><th>Location</th><th>Purpose</th><th>Area</th><th>Price</th><th>Featured</th><th>Status</th><th>Actions</th></tr></thead><tbody><?php foreach($rows as $p):?><tr><td>#<?=$p['pid']?></td><td><strong><?=e($p['title'])?></strong></td><td><?=e($p['city'])?>, <?=e($p['state'])?></td><td><?=e($p['stype'])?></td><td><?=number_format((int)$p['size'])?> sqft</td><td><?=money($p['price'])?></td><td><?=$p['isFeatured']?'Yes':'—'?></td><td><?=e($p['status'])?></td><td><a class="table-link" href="<?=url('admin/property-edit.php?id='.$p['pid'])?>">Edit</a> <a class="danger-link" onclick="return confirm('Delete this property?')" href="<?=url('admin/property-edit.php?delete='.$p['pid'].'&csrf='.urlencode(csrf()))?>">Delete</a></td></tr><?php endforeach;?></tbody></table></div></section><?php require __DIR__.'/_footer.php'; ?>