Advertisement
Guest User

Untitled

a guest
Jul 29th, 2015
218
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.06 KB | None | 0 0
  1. <?php
  2.    $hostname = "127.0.0.1";
  3.         $username = "root";
  4.         $password = "";
  5.         $dbName = "asteriskcdrdb";
  6.   $userstable = "cdr";
  7.     if (!mysql_connect($hostname,$username,$password)) {
  8.             echo(mysql_error());
  9.             die(mysql_error());
  10.         };
  11.         if (!mysql_select_db($dbName)) {
  12.             echo(mysql_error());
  13.             die(mysql_error());
  14.         };
  15.  
  16.         mysql_query("SET NAMES utf8;");
  17.  
  18.         $arCli = Array(
  19.             Array("100","Енин"),
  20.             Array("113","Клинков"),
  21.             Array("105","Канов"),
  22.             Array("111","Крепков"),
  23.             Array("104","Славаков"),
  24.  
  25.         );
  26.  
  27.  
  28.       foreach($arCli as $cli):
  29.  
  30.             $Ext = $cli[0];
  31.  
  32.  
  33.             $Ext = $cli[0];
  34.  
  35.  
  36.                 $sql = mysql_query("SELECT SUM(billsec)
  37.                    FROM $userstable
  38.                    WHERE `src` = '$Ext'
  39.                );
  40.                $up = 0;
  41.                $up = mysql_fetch_array($sql);
  42.  
  43. echo $cli[1];
  44. echo $up;
  45.  
  46. endforeach;
  47. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement