Ejemplo n.º 1
0
<?php

$idNo = $_SESSION['idNo'];
$count = 0;
require_once 'includes/database_master.inc.php';
$database_master = new DatabaseMaster();
$query = "SELECT *\n                  FROM projects\n                  WHERE submittedTo = {$idNo} AND status='pending';\n                  ";
$queryResult = $database_master->queryCount($query);
$count += $queryResult;
$query1 = "SELECT *\n                  FROM reports\n                  WHERE reportedTo = {$idNo} AND status='pending';\n                  ";
$queryResult1 = $database_master->queryCount($query1);
$count += $queryResult1;
if ($count > 0) {
    ?>
        	<span class="badge"><?php 
    echo $count;
    ?>
</span>
        <?php 
}
?>