[Asterisk-Users] Web Interface for CDRs

[Masakazu Nakano]

like that but poor :-)

// CDR access
$connect = @mysql_connect ("localhost","USERNAME","PASSWORD");
mysql_select_db("asteriskcdrdb");

$result = mysql_query ("select dstchannel from cdr where dstchannel like '%IAX%'",$connect);
$iax = mysql_num_rows($result);

$result = mysql_query ("select dstchannel from cdr where dstchannel like '%SIP%'",$connect);
$sip = mysql_num_rows($result);

$result = mysql_query ("select dstchannel from cdr where dstchannel like '%Zap%'",$connect);
$pstn = mysql_num_rows($result);

$result = mysql_query ("select dstchannel from cdr where dstchannel like '%H323%'",$connect);
$h323 = mysql_num_rows($result);

mysql_close($connect);

print<<<EOH
IAX {$iax}
SIP {$sip}
PSTN {$pstn}
H323 {$h323}
EOH;

mack_jpn

On Tue, 9 Dec 2003 09:55:33 -0500
"Bruce Hedreen" <luvbeach at clis.com> wrote:

> Does anyone know where that nice .php is that was written to access the
> CDRs from mysql DB?
>  
> Bruce W. Hedreen
> Computer Technologies of Eastern Carolina, LLC
>  
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003
>