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

Database connections

The 'mysql.php' file is used to abstract the database connection, add some functionality, and provide feedback in a series of global variables. See source of mysql.php for details. The point of this file, beyond the added functionality, is it makes it relatively easy to move to a new database engine, or even have several database engines functioning in the same project (which would make the 'mysql.php' name a bit of a misnomer)

Here are some useful database connection functions. Check the source for more details:

  • Connect() - given a connection string, a database name, or a (host,user,pw,database), makes a connection to MySQL. It caches all connection info, so it doesn't re-create any connections.
  • UnConnect() - Reverts to the previous connection. Useful if you have a function which needs to change the database connection. At the end of the function, it can UnConnect() and not affect the rest of the program, which likely expects to be connected to some other database
  • SelectDatabase() - A wrapper for mysql_select_db()
  • FetchArray() - Wrapper of mysql_fetch_array()
  • FetchObject() - Wrapper of mysql_fetch_object()
  • GrabData() - Given a query that targets a single cell, this returns that cell (select username from _ where __)
  • GrabRow() - Grabs an entire row and returns it in an array, keyed by column names (select * from _ where __)
  • GrabColumn() - Grabs an entire column and returns it into an unkeyed array (select username from _)
  • ModifyQueryString() - Takes a SQL query, and a query fragmant and intelligently rewrites the query. ('select username from users where uid=5' + 'where uid=7' = 'select username from users where uid=7')
  • Testing database connections. Should return data
    • DATA_EM7 => root:@localhost/master_data

        • 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

        Click to drag Click to collapse Resize Pop :
    • DATA_SHERPA => mysql://peak10:peakmeup@localhost/peak10

        • 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)

        Error:
            Existing database connection not found

        Click to drag Click to collapse Resize Pop :
    • DATA_LIBRARY => mysql://root:@localhost/datalibrary

        • 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

        Click to drag Click to collapse Resize Pop :
  • Testing Database Connection Reuse (shouldn't keep increasing resource count) (#98):
    • DATA_EM7 => root:@localhost/master_data

        • 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)

      • Number of connections: 0
    • DATA_SHERPA => mysql://peak10:peakmeup@localhost/peak10

        • 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)

      • Number of connections: 0
    • DATA_LIBRARY => mysql://root:@localhost/datalibrary

        • 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)

      • Number of connections: 0
    • DATA_EM7 => root:@localhost/master_data

        • 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)

      • Number of connections: 0
    • DATA_SHERPA => mysql://peak10:peakmeup@localhost/peak10

        • 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)

      • Number of connections: 0
    • DATA_LIBRARY => mysql://root:@localhost/datalibrary

        • 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)

      • Number of connections: 0
    • DATA_EM7 => root:@localhost/master_data

        • 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)

      • Number of connections: 0
    • DATA_SHERPA => mysql://peak10:peakmeup@localhost/peak10

        • 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)

      • Number of connections: 0
    • DATA_LIBRARY => mysql://root:@localhost/datalibrary

        • 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)

      • Number of connections: 0
  • Testing Stacking (Connect() and UnConnect())
    • EM7:

      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)

    • Sherpa:

      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)

    • UnConnect (back to EM7?):
  • Misc Connection Tests (check Debug log)
    • ModifyQueryString()
      • Original Query: select uid, username from users where uid=5
      • New uid: select uid, username from users where uid=12
      • change uid: select uid, username from users where uid=122
      • add username: select uid, username from users where uid=122 and username=\'mark\'
      • change username: select uid, username from users where uid=122 and username=\'young\'
      • Limit = 10: select uid, username from users where uid=122 and username=\'young\' limit 10
      • Limit = 20: select uid, username from users where uid=122 and username=\'young\' limit 20
      • Order: select uid, username from users where uid=122 and username=\'young\' order by username limit 20
      • Order desc: select uid, username from users where uid=122 and username=\'young\' order by username desc limit 20
      • Order by uid: select uid, username from users where uid=122 and username=\'young\' order by uid limit 20
      • Change uid again: select uid, username from users where uid=1 order by uid limit 20

      Click to drag Click to collapse Resize Source code
      /home/bartniedner_com/core.bartniedner.com/htdocs/examples/database.php 
      <?
/**
 * Core Example File
 *
 * @author Mark Young
 * @version $Id: database.php 212 2007-05-02 17:49:59Z mark.young $
 * @copyright MarkYoung, 19 February, 2007
 * @package examples
 **/

include("head.php");
//include("../include/core_functions.php");

?>
<h4>Database connections</h4>
<i>
<p>The 'mysql.php' file is used to abstract the database connection, add some functionality, and provide
feedback in a series of global variables.  See source of mysql.php for details.  The point of this file,
beyond the added functionality, is it makes it relatively easy to move to a new database engine, or even
have several database engines functioning in the same project (which would make the 'mysql.php' name a bit
of a misnomer)</p>
<p>Here are some useful database connection functions.  Check the source for more details:</p>
<ul>
	<li>Connect() - given a connection string, a database name, or a (host,user,pw,database), makes a connection to 
		MySQL.  It caches all connection info, so it doesn't re-create any connections.</li>
	<li>UnConnect() - Reverts to the previous connection.  Useful if you have a function which needs to change
		the database connection.  At the end of the function, it can UnConnect() and not affect the rest of
		the program, which likely expects to be connected to some other database
	<li>SelectDatabase() - A wrapper for mysql_select_db()
	<li>FetchArray() - Wrapper of mysql_fetch_array()
	<li>FetchObject() - Wrapper of mysql_fetch_object()
	<li>GrabData() - Given a query that targets a single cell, this returns that cell (select username from _ where __)</li>
	<li>GrabRow() - Grabs an entire row and returns it in an array, keyed by column names (select * from _ where __)</li>
	<li>GrabColumn() - Grabs an entire column and returns it into an unkeyed array (select username from _)</li>
	<li>ModifyQueryString() - Takes a SQL query, and a query fragmant and intelligently rewrites the query.  ('select username from users where uid=5' + 'where uid=7' = 'select username from users where uid=7')</li>
</ul>
</i>
<hr>
<?
$defs = get_defined_constants(true);
ob_implicit_flush();



Debug("TESTING DATABASE WORKINGNESS");
echo "<li>Testing database connections.  Should return data";
echo "<ul>";
foreach($defs['user'] as $key=>$val)
{
	if (substr($key, 0, 4)=="DATA")
	{
		echo "<li>$key => $val</li>";
		echo "<ul>";
		Connect($val);
		$d = new data("show tables");
		$o = new outputTable($d);
		 $o->Title = $SQL_CURRENT_CONNECTION_URL.":".$SQL_INFO['database'];
		 $o->AJAX=true;
		 $o->Height=100;
		 $o->Display();
		UnConnect();
		echo "</ul>";
	}
}
echo "</ul>";

// This shouldn't open a new connection to the database, but rather re-use an existing resource ID.  
// mysql_connect() claims to do this itself, yet the resource numbers increase with each mysql_connect();
Debug("TESTING DATABASE CONNECTION REUSE");
echo "<li>Testing Database Connection Reuse (shouldn't keep increasing resource count) (#98):</li>";

echo "<ul>";
for($i=0; $i<3; $i++)
foreach($defs['user'] as $key=>$val)
{
	if (substr($key, 0, 4)=="DATA")
	{
		echo "<li>$key => $val</li>";
		echo "<ul>";
		Connect($val);
		echo "<li>Number of connections: ".count($SQL_CONNECTION_LIST)."</li>";
		echo "</ul>";
	}
}
echo "</ul>";


// Stacking allows you to 'UnConnect()' to a database, restoring things to how they were when a
// particular function was called.  So, if your function needs to connect to a new database, it can
// unconnect at the end of the function, without altering the database info.  You should see
// EM7 connection info after the UnConnect() stataement.
Debug("TESTING STACKING");
echo "<li>Testing Stacking (Connect() and UnConnect())</li>";
echo "<ul>";
	echo "<li>EM7: ";
	echo Connect(DATA_EM7);
	echo "<ul><li>$SQL_CURRENT_CONNECTION_URL</li></ul>";
	echo "<li>Sherpa: ";
	echo Connect(DATA_SHERPA);
	echo "<ul><li>$SQL_CURRENT_CONNECTION_URL</li></ul>";
	echo "<li>UnConnect (back to EM7?): ";
	echo UnConnect();
	echo "<ul><li>$SQL_CURRENT_CONNECTION_URL</li></ul>";
echo "</ul>";

Debug("MISC CONNECTION TESTING");
echo "<li>Misc Connection Tests (check Debug log)</li><ul>";

DEBUG("MODIFYQUERYSTRING");
echo "<li>ModifyQueryString()</li><ul>";
$query = "select uid, username from users where uid=5 ";
echo "<li>Original Query: $query";
ModifyQueryString($query, "where uid=12");
echo "<li>New uid: $query";
ModifyQueryString($query, "where uid=122");
echo "<li>change uid: $query";
ModifyQueryString($query, "where username='mark'");
echo "<li>add username: $query";
ModifyQueryString($query, "where username='young'");
echo "<li>change username: $query";
ModifyQueryString($query, "limit 10");
echo "<li>Limit = 10: $query";
ModifyQueryString($query, "limit 20");
echo "<li>Limit = 20: $query";
ModifyQueryString($query, "order by username");
echo "<li>Order: $query";
ModifyQueryString($query, "order by username desc");
echo "<li>Order desc: $query";
ModifyQueryString($query, "order by uid");
echo "<li>Order by uid: $query";
ModifyQueryString($query, "where uid=1");
echo "<li>Change uid again: $query";
echo "</ul>";

include("foot.php");
?>
      Debug Log:
      Memory Usage: 900.61k, 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.0630]include End head.php   include, line 52 home/bartniedner_com/core.bartniedner.com/htdocs/examples/head.php
      3. [0.0012] TESTING DATABASE WORKINGNESS   , line 45 home/bartniedner_com/core.bartniedner.com/htdocs/examples/database.php
      4. [0.0000]Connect mysql://root:@localhost/master_data   Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      5. [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
      6. [0.0001]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
      7. [0.0021]PrintError ERROR: Existing database connection not found   PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
      8. [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
      9. [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
      10. [0.0000]JumpToRow jumping to row 0   JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      11. [0.0048]LoadData LoadData() called when data was already loaded! You dummy!!   LoadData, line 302 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
      12. [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
      13. [0.0001]DrawTopPart outputTable - :
             DrawTopPart, line 205 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
        1. [0.0000]DrawTopPart AJAX enabled   DrawTopPart, line 206 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
        2. [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
        3. [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
        4. [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
        5. [0.0004]JumpToRow jumping to row 0   JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
        6. [0.0004]DrawBottomPart cached: /tmp/object1mm3z4z   DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
        7. [0.0000]DrawBottomPart End
        outputTable - :   DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
      14. [0.0000]Connect mysql://peak10:peakmeup@localhost/peak10   Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      15. [0.0003]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
      16. [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
      17. [0.0002]PrintError ERROR: Existing database connection not found   PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
      18. [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
      19. [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
      20. [0.0000]JumpToRow jumping to row 0   JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      21. [0.0001]__destruct    __destruct, line 181 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
      22. [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
      23. [0.0001]DrawTopPart outputTable - :
             DrawTopPart, line 205 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
        1. [0.0000]DrawTopPart AJAX enabled   DrawTopPart, line 206 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
        2. [0.0002]JumpToRow jumping to row 0   JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
        3. [0.0003]DrawBottomPart cached: /tmp/object2ffibGm   DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
        4. [0.0000]DrawBottomPart End
        outputTable - :   DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
      24. [0.0000]Connect mysql://root:@localhost/datalibrary   Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      25. [0.0002]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
      26. [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
      27. [0.0002]PrintError ERROR: Existing database connection not found   PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
      28. [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
      29. [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
      30. [0.0001]JumpToRow jumping to row 0   JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      31. [0.0001]__destruct    __destruct, line 181 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
      32. [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
      33. [0.0001]DrawTopPart outputTable - :
             DrawTopPart, line 205 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
        1. [0.0000]DrawTopPart AJAX enabled   DrawTopPart, line 206 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
        2. [0.0002]JumpToRow jumping to row 0   JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
        3. [0.0003]DrawBottomPart cached: /tmp/object3isHsi9   DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
        4. [0.0000]DrawBottomPart End
        outputTable - :   DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
      34. [0.0001] TESTING DATABASE CONNECTION REUSE   , line 69 home/bartniedner_com/core.bartniedner.com/htdocs/examples/database.php
      35. [0.0000]Connect mysql://root:@localhost/master_data   Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      36. [0.0002]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
      37. [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
      38. [0.0000]Connect mysql://peak10:peakmeup@localhost/peak10   Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      39. [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
      40. [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
      41. [0.0000]Connect mysql://root:@localhost/datalibrary   Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      42. [0.0002]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
      43. [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
      44. [0.0000]Connect mysql://root:@localhost/master_data   Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      45. [0.0002]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
      46. [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
      47. [0.0000]Connect mysql://peak10:peakmeup@localhost/peak10   Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      48. [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
      49. [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
      50. [0.0000]Connect mysql://root:@localhost/datalibrary   Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      51. [0.0002]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
      52. [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
      53. [0.0000]Connect mysql://root:@localhost/master_data   Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      54. [0.0002]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
      55. [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
      56. [0.0000]Connect mysql://peak10:peakmeup@localhost/peak10   Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      57. [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
      58. [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
      59. [0.0001]Connect mysql://root:@localhost/datalibrary   Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      60. [0.0002]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
      61. [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
      62. [0.0001] TESTING STACKING   , line 92 home/bartniedner_com/core.bartniedner.com/htdocs/examples/database.php
      63. [0.0000]Connect mysql://root:@localhost/master_data   Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      64. [0.0002]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
      65. [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
      66. [0.0000]Connect mysql://peak10:peakmeup@localhost/peak10   Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      67. [0.1619]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
      68. [0.0001]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
      69. [0.0001] MISC CONNECTION TESTING   , line 106 home/bartniedner_com/core.bartniedner.com/htdocs/examples/database.php
      70. [0.0000] MODIFYQUERYSTRING   , line 109 home/bartniedner_com/core.bartniedner.com/htdocs/examples/database.php
      71. [0.0002]ModifyQueryString select uid, username from users where uid=5 -> [where uid=12]   ModifyQueryString, line 443 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      72. [0.0003]ModifyQueryString select uid, username from users where uid=12 -> [where uid=122]   ModifyQueryString, line 443 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      73. [0.0002]ModifyQueryString select uid, username from users where uid=122 -> [where username=\'mark\']   ModifyQueryString, line 443 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      74. [0.0002]ModifyQueryString select uid, username from users where uid=122 and username=\'mark\' -> [where username=\'young\']   ModifyQueryString, line 443 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      75. [0.0002]ModifyQueryString select uid, username from users where uid=122 and username=\'young\' -> [limit 10]   ModifyQueryString, line 443 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      76. [0.0003]ModifyQueryString select uid, username from users where uid=122 and username=\'young\' limit 10 -> [limit 20]   ModifyQueryString, line 443 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      77. [0.0002]ModifyQueryString select uid, username from users where uid=122 and username=\'young\' limit 20 -> [order by username]   ModifyQueryString, line 443 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      78. [0.0002]ModifyQueryString select uid, username from users where uid=122 and username=\'young\' order by username limit 20 -> [order by username desc]   ModifyQueryString, line 443 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      79. [0.0003]ModifyQueryString select uid, username from users where uid=122 and username=\'young\' order by username desc limit 20 -> [order by uid]   ModifyQueryString, line 443 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      80. [0.0002]ModifyQueryString select uid, username from users where uid=122 and username=\'young\' order by uid limit 20 -> [where uid=1]   ModifyQueryString, line 443 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
      81. [0.0005]include Begin foot.php   include, line 10 home/bartniedner_com/core.bartniedner.com/htdocs/examples/foot.php
      82. [0.0009]DrawTopPart outputFreeText - Source code
             DrawTopPart, line 205 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
        1. [0.0007]DrawBottomPart cached: /tmp/sourcecodezm6b2W   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