CORE Revision 1.1.45

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

HOME | Coredoc | accordian | single | tile | form | expandytable | gantt | tickets-xml | nest | chart | tabs | prefs | misc | data | table | bandwidth | css | state | database | csv | free | texttable | tickets | multicell | refresh | gauge | cypher | jquery | tableform
original
A neutron walks into a bar and orders a drink.  Bartender says "For you?  No charge!" 

cyphered
3OXoQ?$yrHal#YZ͚>Z^ō-סZ1DoTa`עtcZ22@

decyphered
A neutron walks into a bar and orders a drink.  Bartender says "For you?  No charge!" 

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

Error:
    Existing database connection not found

Click to drag Click to collapse Resize Table with database connection
There is no data to display

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

serialized (passwd visible)
O:11:"outputTable":43:{s:10:"hyperlinks";a:0:{}s:5:"extra";a:0:{}s:7:"perpage";N;s:9:"is_header";a:0:{}s:5:"Types";N;s:6:"Format";a:0:{}s:11:"ColumnTitle";a:0:{}s:17:"HideColumnHeaders";b:0;s:17:"HideRepeatingData";b:1;s:18:"AlternateRowColors";b:1;s:12:"HoverHilight";b:1;s:7:"Summary";a:0:{}s:17:"ColumnHeaderExtra";a:0:{}s:11:"ColumnExtra";a:0:{}s:5:"Style";a:0:{}s:11:"FancyLayout";b:0;s:11:"EnablePager";b:1;s:13:"HilightByTime";a:1:{s:5:"class";s:13:"hilightbytime";}s:15:"*summary_data";a:0:{}s:11:"*colnames";a:0:{}s:11:"*rowcount";i:0;s:4:"data";O:9:"dataTable":20:{s:8:"Database";N;s:6:"Tables";s:15:"legend_customer";s:6:"Fields";a:5:{i:0;s:12:"roa_id as id";i:1;s:13:"'edit' as cmd";i:2;s:37:"concat(city, ', ', state) as location";i:3;s:7:"company";i:4;s:16:"rand() as random";}s:8:"LeftJoin";N;s:5:"Where";a:2:{i:0;s:10:"state='FL'";i:1;s:40:"(city='Clearwater' or city='Cape Coral')";}s:7:"GroupBy";N;s:7:"OrderBy";a:2:{i:0;s:13:"location desc";i:1;s:7:"company";}s:10:"Datasource";N;s:5:"Limit";i:5;s:4:"Mods";a:5:{s:4:"sort";N;s:6:"letter";N;s:3:"via";N;s:7:"perpage";N;s:4:"page";N;}s:4:"type";s:3:"SQL";s:6:"source";s:250:"SELECT DISTINCT  SQL_CACHE roa_id as id, 'edit' as cmd, concat(city, ', ', state) as location, company, rand() as random
 FROM legend_customer
 WHERE (state='FL' and (city='Clearwater' or city='Cape Coral')) 
 ORDER BY location desc, company  LIMIT 5";s:4:"data";b:0;s:5:"error";N;s:3:"row";b:0;s:5:"count";i:0;s:16:"dataDataLoaded";b:1;s:3:"SQL";N;s:5:"query";s:250:"SELECT DISTINCT  SQL_CACHE roa_id as id, 'edit' as cmd, concat(city, ', ', state) as location, company, rand() as random
 FROM legend_customer
 WHERE (state='FL' and (city='Clearwater' or city='Cape Coral')) 
 ORDER BY location desc, company  LIMIT 5";s:8:"Data_URL";N;}s:5:"Title";s:30:"Table with database connection";s:11:"Description";N;s:6:"Footer";N;s:4:"AJAX";b:0;s:18:"AJAX_is_javascript";s:5:"false";s:11:"Maximizable";b:1;s:8:"Poppable";b:0;s:8:"Hideable";b:1;s:6:"Filter";b:0;s:10:"HideBorder";b:0;s:17:"outputCacheName";N;s:5:"Width";N;s:6:"Height";N;s:5:"Class";s:6:"output";s:2:"ID";s:27:"tablewithdatabaseconnection";s:13:"NoDataMessage";s:27:"There is no data to display";s:14:"ExtendedBorder";b:0;s:11:"RefreshTime";b:0;s:5:"Glyph";a:7:{s:4:"main";s:58:"http://core.bartniedner.com/include/images/outputTable.gif";s:8:"maximize";s:61:"http://core.bartniedner.com/include/images/glyph_maximize.gif";s:3:"pop";s:56:"http://core.bartniedner.com/include/images/glyph_pop.gif";s:6:"resize";s:59:"http://core.bartniedner.com/include/images/glyph_resize.gif";s:4:"hide";s:57:"http://core.bartniedner.com/include/images/glyph_hide.gif";s:7:"working";s:54:"http://core.bartniedner.com/include/images/working.gif";s:7:"refresh";s:60:"http://core.bartniedner.com/include/images/glyph_refresh.gif";}s:11:"no_overflow";N;s:4:"incl";a:7:{i:0;s:35:"$BASEDIR/include/core_functions.php";i:1;s:27:"$BASEDIR/include/db.inc.php";i:2;s:35:"$BASEDIR/include/html_functions.php";i:3;s:38:"$BASEDIR/include/classes/dataTable.php";i:4;s:33:"$BASEDIR/include/classes/data.php";i:5;s:40:"$BASEDIR/include/classes/outputTable.php";i:6;s:35:"$BASEDIR/include/classes/output.php";}}

cyphered
n29L\
|Wi*[+R7d'A0~eJ\#?S'8r=᝕ TѨk7d'A0*,.z%PU[F	7aڹz]^
	&T׽SfrAd]('qB壭W8!1<S}*7op|DB|Mh~L0k%]m|'ryl8[\Ӂ8XKeɫ?z4lb
ǪfJkM,䳈V\StH,'/dXO3/;Gq޳95u+ة3,o7d'A0/&Ş"ny2)W8!1si9~hŸx(rϞ4JiEñ^/4H긒O88e	ncEOE
2o)v"Gپ?gO[	Mh˖gi~[*Ȩ G4Ey7d'A0;2
/V`b72c~>ob֍"hi	 3w:<f1;89S!{A!J܍HiIe6ʣ҇_ItZG	ϛ0F>`M}LεN7~!)xX~:SbL3FtFۿ.([4mԬm:{?unwjHF(2G0> pz2,
H%۱u	|*҄=q+$5OHENm'GCw3d|]J+㫨{񡝒#w$r3@Pv֗\JOĥ72o'p>:r
"CWc>9\VCbkB	m`(&Tq+$8 z@$\^ct+lG{$Yw&a`8(0Uqqޒ*r5z=nutnK6p7ĩ_~O:}vz=_`$?Mc(fP`/R`+b#T/ZN*t-賶kl<ȡ^\m|TFB>jfCtlŢ
+"CUnN)`E&D7+C-6uϜ]3Mz_^?M5eYNzG|k=urR$Afc,gP+^opbNÄupYg;l
7AlB\VC|?g՗V8=v\uj	P$ہEtpotmLL$\ /Hg`Ŗ/tOhOKM> .H@sS($Rqģ?۩i`ͪK28\Jcc7]zLUW%fc$Gh0]Q#R#gi}"rߖW:LJNYLFtWv(vCbŽV\?} WU1*Ƌ6D9q_JP-˿[*OCUnlڥV_%Iە~)65mf
.0jW)jg
duY*Eh(4}uڡG0ĩGڴ]l8b\¼*3TrlBw7׉dS/Alr{$t6n:kc4}\
0(s_QE0"v>ȈS2-$RЁ.uM&gOW	zX"|Bs kN-ANǖ"43 t#4alLhaȁ%g俗V7G^22/B)\ /Hρ&{"e7:eC'ˬf	7'pTlEa4~\NNLQ7Wc\BYSepYzHw0_O
@\46YA&M#3mg%&m!04NkwwVž#Q0fxگ`>%EG%k5:/.Ɂ-1T3-JVw	3$]h;dDNZHjy,9ܽ
,[Ʒ։̒f-㏋lu
ֈKw^g&kZj_1$i{ei#(iƴoD2/w
@N5BPq(	W߈Ĭ'Z34f&ݻX+a5-
ࣕUr^6Mkgl'N|b!#oYD7{@s8>^)(L 2BqxUH	̀UƓX.:n7a.E13wX{՛7~_ɽ/9o[` Hva>
SNte(pH$RkD'['Γ'prP\'Xt}fHq.rJvnI 9E]ph٪nAPK6;̈NZ3u6I=̏@ɝ0[ɪ#3Ȟ*ZEzwWrb%ƏX`	j0gԋT [jQUk@6W
aPIG-$Jp`7oߟL#@dgS:>{UvI0rzwW*{YF

decyphered
O:11:"outputTable":43:{s:10:"hyperlinks";a:0:{}s:5:"extra";a:0:{}s:7:"perpage";N;s:9:"is_header";a:0:{}s:5:"Types";N;s:6:"Format";a:0:{}s:11:"ColumnTitle";a:0:{}s:17:"HideColumnHeaders";b:0;s:17:"HideRepeatingData";b:1;s:18:"AlternateRowColors";b:1;s:12:"HoverHilight";b:1;s:7:"Summary";a:0:{}s:17:"ColumnHeaderExtra";a:0:{}s:11:"ColumnExtra";a:0:{}s:5:"Style";a:0:{}s:11:"FancyLayout";b:0;s:11:"EnablePager";b:1;s:13:"HilightByTime";a:1:{s:5:"class";s:13:"hilightbytime";}s:15:"*summary_data";a:0:{}s:11:"*colnames";a:0:{}s:11:"*rowcount";i:0;s:4:"data";O:9:"dataTable":20:{s:8:"Database";N;s:6:"Tables";s:15:"legend_customer";s:6:"Fields";a:5:{i:0;s:12:"roa_id as id";i:1;s:13:"'edit' as cmd";i:2;s:37:"concat(city, ', ', state) as location";i:3;s:7:"company";i:4;s:16:"rand() as random";}s:8:"LeftJoin";N;s:5:"Where";a:2:{i:0;s:10:"state='FL'";i:1;s:40:"(city='Clearwater' or city='Cape Coral')";}s:7:"GroupBy";N;s:7:"OrderBy";a:2:{i:0;s:13:"location desc";i:1;s:7:"company";}s:10:"Datasource";N;s:5:"Limit";i:5;s:4:"Mods";a:5:{s:4:"sort";N;s:6:"letter";N;s:3:"via";N;s:7:"perpage";N;s:4:"page";N;}s:4:"type";s:3:"SQL";s:6:"source";s:250:"SELECT DISTINCT  SQL_CACHE roa_id as id, 'edit' as cmd, concat(city, ', ', state) as location, company, rand() as random
 FROM legend_customer
 WHERE (state='FL' and (city='Clearwater' or city='Cape Coral')) 
 ORDER BY location desc, company  LIMIT 5";s:4:"data";b:0;s:5:"error";N;s:3:"row";b:0;s:5:"count";i:0;s:16:"dataDataLoaded";b:1;s:3:"SQL";N;s:5:"query";s:250:"SELECT DISTINCT  SQL_CACHE roa_id as id, 'edit' as cmd, concat(city, ', ', state) as location, company, rand() as random
 FROM legend_customer
 WHERE (state='FL' and (city='Clearwater' or city='Cape Coral')) 
 ORDER BY location desc, company  LIMIT 5";s:8:"Data_URL";N;}s:5:"Title";s:30:"Table with database connection";s:11:"Description";N;s:6:"Footer";N;s:4:"AJAX";b:0;s:18:"AJAX_is_javascript";s:5:"false";s:11:"Maximizable";b:1;s:8:"Poppable";b:0;s:8:"Hideable";b:1;s:6:"Filter";b:0;s:10:"HideBorder";b:0;s:17:"outputCacheName";N;s:5:"Width";N;s:6:"Height";N;s:5:"Class";s:6:"output";s:2:"ID";s:27:"tablewithdatabaseconnection";s:13:"NoDataMessage";s:27:"There is no data to display";s:14:"ExtendedBorder";b:0;s:11:"RefreshTime";b:0;s:5:"Glyph";a:7:{s:4:"main";s:58:"http://core.bartniedner.com/include/images/outputTable.gif";s:8:"maximize";s:61:"http://core.bartniedner.com/include/images/glyph_maximize.gif";s:3:"pop";s:56:"http://core.bartniedner.com/include/images/glyph_pop.gif";s:6:"resize";s:59:"http://core.bartniedner.com/include/images/glyph_resize.gif";s:4:"hide";s:57:"http://core.bartniedner.com/include/images/glyph_hide.gif";s:7:"working";s:54:"http://core.bartniedner.com/include/images/working.gif";s:7:"refresh";s:60:"http://core.bartniedner.com/include/images/glyph_refresh.gif";}s:11:"no_overflow";N;s:4:"incl";a:7:{i:0;s:35:"$BASEDIR/include/core_functions.php";i:1;s:27:"$BASEDIR/include/db.inc.php";i:2;s:35:"$BASEDIR/include/html_functions.php";i:3;s:38:"$BASEDIR/include/classes/dataTable.php";i:4;s:33:"$BASEDIR/include/classes/data.php";i:5;s:40:"$BASEDIR/include/classes/outputTable.php";i:6;s:35:"$BASEDIR/include/classes/output.php";}}

Error:
    Existing database connection not found

Click to drag Click to collapse Resize Table with database connection (after being cyphered and decyphered)
There is no data to display

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





Click to drag Click to collapse Resize Source code
/home/bartniedner_com/core.bartniedner.com/htdocs/examples/cypher.php
<?
/**
 * Core Example File
 *
 * @author Mark Young
 * @version $Id: cypher.php 153 2007-04-17 15:03:38Z mark.young $
 * @copyright MarkYoung, 19 February, 2007
 * @package examples
 **/

include("head.php");

$in = 'A neutron walks into a bar and orders a drink.  Bartender says "For you?  No charge!" ';
PrintR($in, "original");
$crypt = Cypher($in);
PrintR($crypt, "cyphered");
$out = Decypher($crypt);
PrintR($out, "decyphered");

Connect(DATA_EM7);
SelectDatabase("master");

$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
								"concat(city, ', ', state) as location", // sql functions
								"company",  // plain ol columns
								"rand() as random"
							);
 $d->OrderBy           = array("location desc", "company"); // these go right into the ORder By clause, so the 'desc' modifier is allowed  
 $d->Where             = array("state='FL'", "(city='Clearwater' or city='Cape Coral')"); // elements of this array are AND'd together. 
 $d->Limit             = 5;
 $d->LoadData();
$o  = new outputTable($d);
 $o->Title             = 'Table with database connection';
 $o->AJAX			   = false;
 $o->HideRepeatingData = true;
 $o->Display();

$o_s = serialize($o);
PrintR($o_s, "serialized (passwd visible)");

$o_c = Cypher($o_s);
PrintR($o_c, "cyphered");

$o_u = Decypher($o_c);
PrintR($o_u, "decyphered");

Debug("o decyphered");
$o = unserialize($o_u);
$o->data->LoadData(true);
$o->Title .= " (after being cyphered and decyphered)";
$o->Display();

include("foot.php");

?>

Debug Log:
Memory Usage: 741.68k, Number of Queries: 0
  1. [0.0000]db.inc.php File included   include_once, line 21 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
  2. [0.0613]include End head.php   include, line 52 home/bartniedner_com/core.bartniedner.com/htdocs/examples/head.php
  3. [0.0001]PrintR A neutron walks into['original']   PrintR, line 449 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
  4. [0.0325]PrintR 3OXoQ?$yr['cyphered']   PrintR, line 449 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
  5. [0.0005]PrintR A neutron walks into['decyphered']   PrintR, line 449 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
  6. [0.0001]Connect mysql://root:@localhost/master_data   Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
  7. [0.0006]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
  8. [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
  9. [0.0000]SelectDatabase master   SelectDatabase, line 161 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
  10. [0.0001]PrintError ERROR: Existing database connection not found   PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
  11. [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
  12. [0.0025]PrintError ERROR: Existing database connection not found   PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
  13. [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
  14. [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
  15. [0.0000]JumpToRow jumping to row 0   JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
  16. [0.0044]LoadData LoadData() called when data was already loaded! You dummy!!   LoadData, line 302 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
  17. [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
  18. [0.0000]DrawTopPart outputTable - Table with database connection
         DrawTopPart, line 205 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
    1. [0.0001]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.0002]JumpToRow jumping to row 0   JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
    5. [0.0004]DrawBottomPart cached: /tmp/tablewithdatabaseconnectionwEXhGQ   DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
    6. [0.0000]DrawBottomPart End
    outputTable - Table with database connection   DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
  19. [0.0002]PrintR O:11:"outputTable":4['serialized (passwd visible)']   PrintR, line 449 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
  20. [0.0007]PrintR n2 9L['cyphered']   PrintR, line 449 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
  21. [0.0007]PrintR O:11:"outputTable":4['decyphered']   PrintR, line 449 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
  22. [0.1251] o decyphered   , line 50 home/bartniedner_com/core.bartniedner.com/htdocs/examples/cypher.php
  23. [0.0003]PrintError ERROR: Existing database connection not found   PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
  24. [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
  25. [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
  26. [0.0000]JumpToRow jumping to row 0   JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
  27. [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
  28. [0.0001]DrawTopPart outputTable - Table with database connection (after being cyphered and decyphered)
         DrawTopPart, line 205 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
    1. [0.0002]JumpToRow jumping to row 0   JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
    2. [0.0004]DrawBottomPart cached: /tmp/tablewithdatabaseconnectionhw4wPl   DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
    3. [0.0000]DrawBottomPart End
    outputTable - Table with database connection (after being cyphered and decyphered)   DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
  29. [0.0003]include Begin foot.php   include, line 10 home/bartniedner_com/core.bartniedner.com/htdocs/examples/foot.php
  30. [0.0005]__destruct    __destruct, line 181 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
  31. [0.0001]DrawTopPart outputFreeText - Source code
         DrawTopPart, line 205 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
    1. [0.0005]DrawBottomPart cached: /tmp/sourcecodekqFrZQ   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