Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $hostname = "127.0.0.1";
- $username = "root";
- $password = "";
- $dbName = "asteriskcdrdb";
- $userstable = "cdr";
- if (!mysql_connect($hostname,$username,$password)) {
- echo(mysql_error());
- die(mysql_error());
- };
- if (!mysql_select_db($dbName)) {
- echo(mysql_error());
- die(mysql_error());
- };
- mysql_query("SET NAMES utf8;");
- $arCli = Array(
- Array("100","Енин"),
- Array("113","Клинков"),
- Array("105","Канов"),
- Array("111","Крепков"),
- Array("104","Славаков"),
- );
- foreach($arCli as $cli):
- $Ext = $cli[0];
- $Ext = $cli[0];
- $sql = mysql_query("SELECT SUM(billsec)
- FROM $userstable
- WHERE `src` = '$Ext'
- );
- $up = 0;
- $up = mysql_fetch_array($sql);
- echo $cli[1];
- echo $up;
- endforeach;
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement