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

<?php $title='Dashboard'; require_once __DIR__.'/_header.php'; $pdo=db();$properties=(int)$pdo->query('SELECT COUNT(*) FROM property')->fetchColumn();$available=(int)$pdo->query("SELECT COUNT(*) FROM property WHERE status='available'")->fetchColumn();$users=(int)$pdo->query('SELECT COUNT(*) FROM user')->fetchColumn();$enquiries=(int)$pdo->query('SELECT COUNT(*) FROM contact')->fetchColumn();$latest=$pdo->query('SELECT pid,title,city,price,stype,status,date FROM property ORDER BY pid DESC LIMIT 8')->fetchAll(); ?>
<div class="admin-cards"><div><span>Total properties</span><strong><?=$properties?></strong></div><div><span>Available</span><strong><?=$available?></strong></div><div><span>Users / agents</span><strong><?=$users?></strong></div><div><span>Enquiries</span><strong><?=$enquiries?></strong></div></div><section class="admin-panel"><div class="panel-head"><h2>Latest properties</h2><a class="admin-btn small" href="<?=url('admin/property-edit.php')?>">+ Add property</a></div><div class="table-wrap"><table><thead><tr><th>ID</th><th>Property</th><th>City</th><th>Purpose</th><th>Price</th><th>Status</th><th></th></tr></thead><tbody><?php foreach($latest as $p):?><tr><td>#<?=$p['pid']?></td><td><strong><?=e($p['title'])?></strong></td><td><?=e($p['city'])?></td><td><?=e($p['stype'])?></td><td><?=money($p['price'])?></td><td><span class="status-dot"><?=e($p['status'])?></span></td><td><a class="table-link" href="<?=url('admin/property-edit.php?id='.$p['pid'])?>">Edit</a></td></tr><?php endforeach;?></tbody></table></div></section>
<?php require __DIR__.'/_footer.php'; ?>