PHP Classes
elePHPant
Icontem

File: test-class.columns.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Carl Friis-Hansen  >  printSimpelColumns  >  test-class.columns.php  >  Download  
File: test-class.columns.php
Role: Unit test script
Content type: text/plain
Description: Test of class using public accessable MySQL database
Class: printSimpelColumns
Simple columns in console mode
Author: By
Last change:
Date: 12 years ago
Size: 3,193 bytes
 

Contents

Class file image Download
<?
 
// This is a console mode program!!!!!
  // It expect you have Internet access to access a database on port 3306

 
include("class.columns.php");

 
define("SERVER", "213.84.144.19" ); // You are wellcome to select data from this database server
 
define("USERNAME", "friend" ); // There are currently three databases you can access:
 
define("PASSWORD", "friendly" ); // cdx, gps and photo
                                            // You are only given Select priviledges.


 
if($argc < 4)
  {
    print
"\r\nThis program is GPL and copyright 2002 by Carl Friis-Hansen\r\n\r\n" .
         
"USAGE:\r\n" .
         
" PHP $argv[0] COS110|COS111|COS129|COS136 from to [FULL [HTML]]\r\n\r\n" .
         
"from on the form YYYYMMDD\r\n" .
         
"to on the form YYYYMMDD\r\n\r\n" .
         
"The program interrogates cdx.logcdx and summes the column COS???.\r\n" .
         
"The result is a tab delimited line with number of calls and the total cost.\r\n";
    exit();
  }



 
// resource mysql_connect (string [server], string [username], string [password])
 
if($dbf = @mysql_connect(SERVER, USERNAME, PASSWORD))
  {
   
// print SERVER . "/" . USERNAME . " is connected\r\n--------------------------------\r\n";
 
} else {
    exit(
"Error: " . SERVER . "/" . USERNAME . " is NOT connected\r\n--------------------------------\r\n");
  }



  function
doQuery($Query="")
  {
    global
$dbf;
    global
$dbResult;

    if(
$Query != "")
    {
     
$dbResult = mysql_query($Query, $dbf);
    }
   
$result = mysql_fetch_row($dbResult);
    return
$result;
  }
// doQuery()



 
if($argv[4] == "FULL" or $argv[4] == "full")
  {
   
$psc = new printSimpelColumns();
   
$psc->setColumnDefinition(0, "EndDate" ,"%-8s | ");
   
$psc->setColumnDefinition(1, "EndTime" ,"%-8s | ");
   
$psc->setColumnDefinition(2, "Duration" ,"%-8s | ");
   
$psc->setColumnDefinition(3, "Price" ,"%7s | ");
   
$psc->setColumnDefinition(4, "Name" ,"%-8s | ");
   
$psc->setColumnDefinition(5, "Digits" ,"%-17s\r\n");

    if(
$argv[5] == "HTML" or $argv[5] == "html")
    {
      print
"<pre>\r\n";
    }
   
    print
$psc->getHeaderLine();

   
$a = doQuery( "select EndDate, EndTime, DurationT, $argv[1], AlarmC, Digits" .
                   
" from cdx.logcdx" .
                   
" where EndDate >= $argv[2]" .
                   
" && EndDate <= $argv[3]" .
                   
" && $argv[1] <> ''" .
                   
" order by RecID ASC" );
    print
$psc->getDataLine($a);
    while(
$a = doQuery())
    {
      print
$psc->getDataLine($a);
    }
    if(
$argv[5] == "HTML" or $argv[5] == "html")
    {
      print
"</pre>\r\n";
    }
  } else {
   
$a = doQuery( "select count(*), sum($argv[1])" .
                   
" from cdx.logcdx" .
                   
" where EndDate >= $argv[2]" .
                   
" && EndDate <= $argv[3]" .
                   
" && $argv[1] <> ''" .
                   
" order by RecID ASC" );

    print
"Number of calls: " . $a[0] . " for a total of EUR " . $a[1] . "\r\n";
  }
 
mysql_close($dbf);
?>