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
Table with database connection
There is no data to display
Access denied for user 'root'@'localhost' (using password: NO)
Error: Existing database connection not found
Table with database connection (after being cyphered and decyphered)
There is no data to display
Access denied for user 'root'@'localhost' (using password: NO)
<?
/**
* 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
[0.0000]db.inc.php File included include_once, line 21 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
[0.0613]include End head.php include, line 52 home/bartniedner_com/core.bartniedner.com/htdocs/examples/head.php
[0.0001]PrintR A neutron walks into['original'] PrintR, line 449 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0325]PrintR 3OXoQ?$yr['cyphered'] PrintR, line 449 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0005]PrintR A neutron walks into['decyphered'] PrintR, line 449 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0001]Connect mysql://root:@localhost/master_data Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
[0.0006]PrintWarningWARNING: 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]PrintErrorERROR: 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.0001]PrintErrorERROR: 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.0025]PrintErrorERROR: 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]ErrorHandlermysql_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.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
[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]DrawTopPartoutputTable - Table with database connection DrawTopPart, line 205 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
[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
[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
[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
[0.0002]JumpToRow jumping to row 0 JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
[0.0004]DrawBottomPart cached: /tmp/tablewithdatabaseconnectionwEXhGQ DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
[0.0000]DrawBottomPart End
outputTable - Table with database connection DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
[0.0002]PrintR O:11:"outputTable":4['serialized (passwd visible)'] PrintR, line 449 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0007]PrintR n29L['cyphered'] PrintR, line 449 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0007]PrintR O:11:"outputTable":4['decyphered'] PrintR, line 449 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.1251] o decyphered , line 50 home/bartniedner_com/core.bartniedner.com/htdocs/examples/cypher.php
[0.0003]PrintErrorERROR: 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]ErrorHandlermysql_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.0001]DrawTopPartoutputTable - Table with database connection (after being cyphered and decyphered) DrawTopPart, line 205 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
[0.0002]JumpToRow jumping to row 0 JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
[0.0004]DrawBottomPart cached: /tmp/tablewithdatabaseconnectionhw4wPl DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
[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
[0.0003]include Begin foot.php include, line 10 home/bartniedner_com/core.bartniedner.com/htdocs/examples/foot.php
[0.0005]__destruct __destruct, line 181 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
[0.0001]DrawTopPartoutputFreeText - Source code DrawTopPart, line 205 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
[0.0005]DrawBottomPart cached: /tmp/sourcecodekqFrZQ DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
[0.0000]DrawBottomPart End
outputFreeText - Source code DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php