Daily Call counter

Sucessfully conected to the database asterisk

TOTAL	CLID	Destination	Duration	context	Calldate
2	"102" <004368>	00914259981143	1	internal	2015-12-27 00:52:09

<?php

require_once("func.php");
require_once("setting.php");
$titles=Array("TOTAL","CLID","Destination","Duration","context","Calldate");

$record=array("total","clid","dst","billsec","dcontext","calldate");

$query="select Distinct count(dst) as total,billsec,clid,dst,dcontext,calldate  from cdr where SUBSTRING(calldate,1,10)=curdate() and dcontext like '%internal%' group by src";

$db_con=conect_db($setting[host],$setting[username],$setting[password],"asterisk");

table($titles);

display_records($db_con,$query,$record);


?>