CORE Revision 1.1.45

The links you see here are partly for instructional examples, but mostly for object debugging.

This page tests the various ways that data is obtained. One quick way to show data is this:

echo new data($query);

XML http://66.129.64.42/em7/api.em7?username=portal&password=potato&roa_id=181

The EM7 API may be OFF now, so this may not work (may, 07)

Warning:
mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO)
/home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php, line 120 (Array)

Error:
Connect: Access denied for user 'root'@'localhost' (using password: NO)

Error:
Existing database connection not found

dataTable

Error:
Existing database connection not found

There is no data to display Access denied for user 'root'@'localhost' (using password: NO)

data (from query)

Error:
Existing database connection not found

There is no data to display Access denied for user 'root'@'localhost' (using password: NO)

Warning:
mysql_connect() [function.mysql-connect]: Access denied for user 'peak10'@'localhost' (using password: YES)
/home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php, line 120 (Array)

Error:
Connect: Access denied for user 'peak10'@'localhost' (using password: YES)

McCormiquery

Error:
Existing database connection not found

There is no data to display Access denied for user 'peak10'@'localhost' (using password: YES)

dataArray

a purposefully bad query, to test error logging

Error:
Existing database connection not found

There is no data to display Access denied for user 'peak10'@'localhost' (using password: YES)

/home/bartniedner_com/core.bartniedner.com/htdocs/examples/data.php

<?
/**
 * Core Example File
 *
 * @author Mark Young
 * @version $Id: data.php 327 2007-05-23 17:46:48Z mark.young $
 * @copyright MarkYoung, 19 February, 2007
 * @package examples
 **/

include("head.php");
include("ticket_functions.php");
?>
This page tests the various ways that data is obtained.  One quick way to show data is this:

<li> echo new data($query);

<hr>
<?
$url = TICKET_URL."&roa_id=181";
echo "<li> XML ".$url;
$d = new dataXML($url);
$o = new outputTable($d);
 $o->Description="The EM7 API may be OFF now, so this may not work (may, 07)";
 $o->AJAX=false;
 $o->Display();



Connect(DATA_EM7);
SelectDatabase('master');
echo "<li>  dataTable";
$d = new dataTable(false);
 $d->Tables="legend_customer"; // this can be an array, like $d->Tables=array("if_billing", "if_someothingelse") and the object will craete a left join
 $d->Fields=array(	"roa_id as id", // aliasing
 					"'edit' as cmd",  // fixed text
					"company",  // plain ol columns
					"concat(city, ', ', state) as location" // sql functions
				);
 $d->OrderBy=array("company");
 $d->Where=array("state='FL'");
 $d->Limit=5;
 $d->LoadData();
echo $d;
echo "<li>  data (from query)";
$query = "SELECT DISTINCT SQL_CACHE roa_id as id, 'edit' as cmd, company, concat(city, ', ', state) as location
FROM legend_customer
WHERE (state='FL')
ORDER BY company limit 5";
$d = new data($query);
 $d->LoadData();
echo $d;

CONNECT(DATA_SHERPA);
echo "<li>  McCormiquery";
$query = "SELECT   l.location,
         l.abbr,
         IFNULL(ROUND(SUM(tots.qty * tots.mrc)),0) AS thesum
FROM     locations l
         LEFT JOIN ((SELECT bs.quantity - IFNULL((SELECT   SUM(IF(pi2.`change` = 'REMOVE',-pi2.quantity,pi2.quantity))
                                                  FROM     proposals pro2,
                                                           proposal_items pi2,
                                                           location_items li2
                                                  WHERE    pro2.proposal_id = pi2.proposal_id
                                                           AND pro2.revision = pi2.revision
                                                           AND pi2.location_item_id = li2.location_item_id
                                                           AND pro2.date_status < (SELECT MAX(date_status)
                                                                                   FROM   proposals pro3
                                                                                   WHERE  pro3.billing_id = pro2.billing_id
                                                                                          AND pro3.proposal_type = 'PROPOSAL'
                                                                                          AND pro3.status = 'SIGNED'
                                                                                          AND pro3.signature_confirmed = 'TRUE')
                                                           AND pro2.date_status >= IFNULL((SELECT MAX(date_status)
                                                                                           FROM   proposals pro3
                                                                                           WHERE  pro3.billing_id = pro2.billing_id
                                                                                                  AND pro3.proposal_type = 'PROPOSAL'
                                                                                                  AND pro3.status = 'SIGNED'
                                                                                                  AND pro3.signature_confirmed = 'TRUE'
                                                                                                  AND pro3.date_status < (SELECT MAX(date_status)
                                                                                                                          FROM   proposals pro4
                                                                                                                          WHERE  pro4.billing_id = pro3.billing_id
                                                                                                                                 AND pro4.proposal_type = 'PROPOSAL'
                                                                                                                                 AND pro4.status = 'SIGNED'
                                                                                                                                 AND pro4.signature_confirmed = 'TRUE')),
                                                                                          '0000-00-00 00:00:00')
                                                           AND li2.location_id = l.location_id
                                                           AND li2.item_id = i.item_id
                                                           AND pro2.billing_id = pro.billing_id
                                                  GROUP BY pro2.billing_id),0) - IFNULL((SELECT SUM(bs2.quantity)
                                                                                         FROM   billing_summary bs2
                                                                                         WHERE  bs2.proposal_item_id = bs.proposal_item_id
                                                                                                AND bs2.billing_summary_id != bs.billing_summary_id),
                                                                                        0) AS qty,
                            IF(i.item = 'SPEC-DISC',-pi.mrc,pi.mrc) AS mrc,
                            li.location_id
                     FROM   billing_summary bs,
                            proposal_items pi,
                            proposals pro,
                            location_items li,
                            locations l,
                            items i
                     WHERE  bs.proposal_item_id = pi.proposal_item_id
                            AND pi.proposal_id = pro.proposal_id
                            AND pi.location_item_id = li.location_item_id
                            AND li.location_id = l.location_id
                            AND li.item_id = i.item_id
                            AND pro.renewal > 0
                            AND bs.date_installed LIKE '2007-01%'
                            AND pi.`change` = 'ADD'
                     HAVING qty > 0)
                    UNION 
                    (SELECT   IFNULL(SUM(bs.quantity),0) AS qty,
                              IF(i.item = 'SPEC-DISC',-pi.mrc,pi.mrc) AS mrc,
                              li.location_id
                     FROM     proposal_items pi,
                              location_items li,
                              billing_summary bs,
                              proposals pro,
                              items i
                     WHERE    pi.location_item_id = li.location_item_id
                              AND pi.`change` = 'ADD'
                              AND pi.proposal_item_id = bs.proposal_item_id
                              AND pi.proposal_id = pro.proposal_id
                              AND pro.signature_confirmed = 'TRUE'
                              AND pro.status = 'SIGNED'
                              AND bs.date_installed LIKE '2007-01%'
                              AND li.item_id = i.item_id
                              AND pro.renewal = 0
                     GROUP BY pi.proposal_item_id
                     HAVING   qty > 0)) AS tots
           USING(location_id)
GROUP BY l.location_id
ORDER BY thesum DESC,
         location";
		$d = new data($query);
		 $d->LoadData();
		echo $d;
echo "<li>  dataArray";
		
$a['row1'] = array("col1"=>2,"col2"=>3,"col3"=>4,"col4"=>5);		
$a['row2'] = array("col1"=>9,"col2"=>6,"col3"=>3,"col4"=>1);		
$d = new dataArray($a);

$o = new outputTable($d);
 $o->Sorting=true;
 $o->Title='a simple array';
 $o->Display();

echo "<li>  a purposefully bad query, to test error logging";
$query= "select distinct order by crap";
$d = new data($query);
$o = new outputTable($d);
 $o->AJAX=false;
 $o->Title='Bad Data';
 $o->Display();

include("foot.php");
?>

Debug Log:

Memory Usage: 825.75k, Number of Queries: 0

[0.0000]db.inc.php File included include_once, line 21 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
[0.0480]include End head.php include, line 52 home/bartniedner_com/core.bartniedner.com/htdocs/examples/head.php
[0.0283]LoadXMLData LoadXMLData: http://66.129.64.42/em7/api.em7?username=portal&password=potato&roa_id=181 LoadXMLData, line 52 home/bartniedner_com/core.bartniedner.com/htdocs/include/xml_functions.php
[0.5931]LoadData LoadData() called when data was already loaded! You dummy!! LoadData, line 302 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
[0.0001]LoadJavascript Loaded http://core.bartniedner.com/include/javascript/ajax.js LoadJavascript, line 854 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0000]DrawTopPart outputTable -
1. [0.0000]LoadJavascript Loaded http://core.bartniedner.com/include/javascript/jquery.js LoadJavascript, line 854 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
2. [0.0000]LoadJavascript Loaded http://core.bartniedner.com/include/javascript/core.js LoadJavascript, line 854 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
3. [0.0000]LoadJavascript Loaded http://core.bartniedner.com/include/javascript/firebug/firebug.js LoadJavascript, line 854 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
4. [0.0003]ErrorHandler array_shift() [function.array-shift]: The argument should be an array
  /home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php, line 376 (Array) ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
5. [0.0003]DrawBottomPart cached: /tmp/object1XWOAQd DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
6. [0.0000]DrawBottomPart End
outputTable - DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
[0.0000]Connect mysql://root:@localhost/master_data Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
[0.0003]PrintWarning WARNING: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO)
/home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php, line 120 (Array) PrintWarning, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0000]PrintError ERROR: Connect: Access denied for user 'root'@'localhost' (using password: NO) PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0000]SelectDatabase master SelectDatabase, line 161 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
[0.0000]PrintError ERROR: Existing database connection not found PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0000]Query $SQL_CURRENT_CONNECTION is not the expected object. Query, line 210 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
[0.0005]PrintError ERROR: Existing database connection not found PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0000]Query $SQL_CURRENT_CONNECTION is not the expected object. Query, line 210 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
[0.0000]ErrorHandler mysql_num_rows(): supplied argument is not a valid MySQL result resource
/home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php, line 354 (Array) ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0000]JumpToRow jumping to row 0 JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
[0.0001]LoadData LoadData() called when data was already loaded! You dummy!! LoadData, line 302 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
[0.0000]DrawTopPart outputTable -
1. [0.0001]JumpToRow jumping to row 0 JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
2. [0.0002]DrawBottomPart cached: /tmp/object2QaEkrJ DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
3. [0.0000]DrawBottomPart End
outputTable - DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
[0.0002]PrintError ERROR: Existing database connection not found PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0000]Query $SQL_CURRENT_CONNECTION is not the expected object. Query, line 210 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
[0.0000]ErrorHandler mysql_num_rows(): supplied argument is not a valid MySQL result resource
/home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php, line 354 (Array) ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0000]JumpToRow jumping to row 0 JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
[0.0000]__destruct __destruct, line 181 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
[0.0000]LoadData LoadData() called when data was already loaded! You dummy!! LoadData, line 302 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
[0.0001]LoadData LoadData() called when data was already loaded! You dummy!! LoadData, line 302 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
[0.0000]DrawTopPart outputTable -
1. [0.0001]JumpToRow jumping to row 0 JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
2. [0.0002]DrawBottomPart cached: /tmp/object3ZuCr2e DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
3. [0.0000]DrawBottomPart End
outputTable - DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
[0.0000]Connect mysql://peak10:peakmeup@localhost/peak10 Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
[0.0002]PrintWarning WARNING: mysql_connect() [function.mysql-connect]: Access denied for user 'peak10'@'localhost' (using password: YES)
/home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php, line 120 (Array) PrintWarning, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0000]PrintError ERROR: Connect: Access denied for user 'peak10'@'localhost' (using password: YES) PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0031]PrintError ERROR: Existing database connection not found PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0000]Query $SQL_CURRENT_CONNECTION is not the expected object. Query, line 210 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
[0.0000]ErrorHandler mysql_num_rows(): supplied argument is not a valid MySQL result resource
/home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php, line 354 (Array) ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0000]JumpToRow jumping to row 0 JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
[0.0000]__destruct __destruct, line 181 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
[0.0000]LoadData LoadData() called when data was already loaded! You dummy!! LoadData, line 302 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
[0.0000]LoadData LoadData() called when data was already loaded! You dummy!! LoadData, line 302 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
[0.0000]DrawTopPart outputTable -
1. [0.0001]JumpToRow jumping to row 0 JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
2. [0.0002]DrawBottomPart cached: /tmp/object4q5NfFK DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
3. [0.0000]DrawBottomPart End
outputTable - DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
[0.0097]__destruct __destruct, line 181 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
[0.0000]__destruct __destruct, line 181 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
[0.0000]LoadData LoadData() called when data was already loaded! You dummy!! LoadData, line 302 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
[0.0000]DrawTopPart outputTable - a simple array
1. [0.0000]DrawTopPart AJAX enabled DrawTopPart, line 206 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
2. [0.0003]DrawBottomPart cached: /tmp/asimplearrayoMQemg DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
3. [0.0000]DrawBottomPart End
outputTable - a simple array DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
[0.0001]PrintError ERROR: Existing database connection not found PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0000]Query $SQL_CURRENT_CONNECTION is not the expected object. Query, line 210 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
[0.0000]ErrorHandler mysql_num_rows(): supplied argument is not a valid MySQL result resource
/home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php, line 354 (Array) ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0000]JumpToRow jumping to row 0 JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
[0.0000]__destruct __destruct, line 181 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
[0.0000]LoadData LoadData() called when data was already loaded! You dummy!! LoadData, line 302 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
[0.0000]DrawTopPart outputTable - Bad Data
1. [0.0001]JumpToRow jumping to row 0 JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
2. [0.0002]DrawBottomPart cached: /tmp/baddatat2ly3L DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
3. [0.0000]DrawBottomPart End
outputTable - Bad Data DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
[0.0001]include Begin foot.php include, line 10 home/bartniedner_com/core.bartniedner.com/htdocs/examples/foot.php
[0.0005]DrawTopPart outputFreeText - Source code
1. [0.1522]DrawBottomPart cached: /tmp/sourcecodea0kTKi DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
2. [0.0000]DrawBottomPart End
outputFreeText - Source code DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php