CORE Revision 1.1.45

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

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 Form Example 1

Browse by letter (indexed by company), limited to Florida

= | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z There is no data to display Access denied for user 'root'@'localhost' (using password: NO)

Neat, huh?

Source code

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

<? /** * Core Example File * * @author Mark Young * @version $Id$ * @copyright MarkYoung, 19 February, 2007 * @package examples **/ include("head.php"); if ($_REQUEST['_action']=="save") { PrintR($_POST); } 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( "'x' as sel", // a placeholder, which gets overwritten with a ->Format "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=10; $d->LoadData(); // create a "table" output using the above data object $o = new outputTableForm($d); $o->Title="Table Form Example 1"; // sets the title of the table $o->Description="Browse by letter (indexed by company), limited to Florida"; // set the descriptive header $o->Footer="Neat, huh?"; $o->PageByLetter='company'; // enable the by-letter pager, and index it on Company $o->Filter=true; // turn on the filter $o->Types['id']="header"; // set these columns as header $o->Types['cmd']="header"; $o->Types['sel']="header"; $o->Format['sel']='"<input value=\'$location\' type=\'checkbox\' name=\'select[$id]\' ".($_REQUEST[location][$id]?"checked":"").">"'; $o->Format['location']='"<input type=\"text\" name=\"location[$id]\" value=\"$location\" >"'; $o->hyperlinks['id']='/login.php?action=cheat&uid=$id'; // tell the "id" column to hyperlink to this. (note the single quotes, so $id isn't evaluated) $o->hyperlinks['cmd']='http://www.google.com?uid=$id'; // $o->Method="POST"; $o->Display(); // puke! include("foot.php"); ?>

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.0615]include End head.php   include, line 52 home/bartniedner_com/core.bartniedner.com/htdocs/examples/head.php
3. [0.0001]Connect mysql://root:@localhost/master_data   Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
4. [0.0005]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
5. [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
6. [0.0000]SelectDatabase master   SelectDatabase, line 161 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
7. [0.0000]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.0023]PrintError ERROR: Existing database connection not found   PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
10. [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
11. [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
12. [0.0000]JumpToRow jumping to row 0   JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
13. [0.0097]LoadData LoadData() called when data was already loaded! You dummy!!   LoadData, line 302 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
14. [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
15. [0.0000]DrawTopPart outputTable - Table Form Example 1
       DrawTopPart, line 205 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
    1. [0.0002]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.0015]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/tableformexample1aDx0Wi   DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
    6. [0.0000]DrawBottomPart End
    outputTable - Table Form Example 1   DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
16. [0.0002]include Begin foot.php   include, line 10 home/bartniedner_com/core.bartniedner.com/htdocs/examples/foot.php
17. [0.0006]DrawTopPart outputFreeText - Source code
       DrawTopPart, line 205 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
    1. [0.0005]DrawBottomPart cached: /tmp/sourcecode6HPkXD   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