Notes

class DB {
private $server = 'localhost';
private $user = 'root';
private $pass = '';
private $database = 'sample_paper';

public function conn()
{
$con = new mysqli($this->server,$this->user,$this->pass,$this->database) or die(mysqli_connect_error());

return $con;
}

public function get_agents()
{
$con = $this->conn();
$result = $con->query("select * from agent_master") or die($con->error);

if($result->num_rows > 0)
{
while($data = $result->fetch_assoc())
{
echo "
<option value=$data[Agent_No]>$data[Agent_Name]</option>
";
}
}
}

public function get_scheme()
{
$con = $this->conn();
$result = $con->query("select * from scheme_master") or die($con->error);

if($result->num_rows > 0)
{
while($data = $result->fetch_assoc())
{
echo "
<option value=$data[Scheme_no]>$data[Scheme_Name]</option>
";
}
}
}

public function no_policy()
{
$con = $this->conn();
$q ="SELECT count(policy_details.Policy_No) as p,agent_master.Agent_Name,scheme_master.Scheme_Name from policy_details inner join scheme_master,agent_master where agent_master.Agent_No = policy_details.Agent_No and scheme_master.Scheme_no = policy_details.Scheme_no group by scheme_master.Scheme_Name";

$result = $con->query($q) or die($con->error);

if($result->num_rows > 0)
{
while($data = $result->fetch_assoc())
{

?>
<tr class="table-primary">
<th scope="row"><?php echo $data['Agent_Name']; ?></th>
<td><?php echo $data['Scheme_Name']; ?></td>
<td><?php echo $data['p']; ?></td>
</tr>
<?php
}
}



}

public function commission()
{
$con = $this->conn();
$q = "SELECT sum(policy_details.commission) as c,agent_master.Agent_Name from policy_details inner join agent_master where agent_master.Agent_No = policy_details.Agent_No group by agent_master.agent_Name";
$result = $con->query($q);
while($data = $result->fetch_assoc())
{
?>
<tr class="table-primary">

<th scope="row"><?php echo $data['Agent_Name']; ?></th>

<td><?php echo $data['c']; ?></td>

<?php
echo "</tr>";

}


}

}