CORE Revision 1.1.45

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


Name
Date of birth
One to ten *
Email *
Hobbies	Type some hobbies...
Pick a number
Upload

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

This form requires a valid us 5 or 9 digit zipcode as defined by the V_POSTAL constant

Warning:
Invalid argument supplied for foreach()
/home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/outputForm.php, line 297 (Array)

This example shows two form objects glued together into one larger form. Of course, in this example, it comes from the same datasource, but in real life, it probably wont. With this method, you could also embed this table into another already exisitng form.

Warning:
Invalid argument supplied for foreach()
/home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/outputForm.php, line 297 (Array)

This is the second part

Warning:
Invalid argument supplied for foreach()
/home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/outputForm.php, line 297 (Array)

Predefined Form Validation Constants ($o->Validate['zipcode']=V_POSTAL;):

Array
(
    [0] => V_REQUIRED
    [1] => V_DATE
    [2] => V_DATE_YMD
    [3] => V_DATE_MDY
    [4] => V_EMAIL
    [5] => V_DOMAIN
    [6] => V_URL
    [7] => V_POSTAL
    [8] => V_POSTAL_US5
    [9] => V_POSTAL_US9
    [10] => V_POSTAL_US
    [11] => V_POSTAL_CAN
)

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

<?
/**
 * Core Example File
 *
 * @author Mark Young
 * @version $Id: form.php 425 2007-06-11 12:49:02Z mark.young $
 * @copyright MarkYoung, 19 February, 2007
 * @package examples
 **/

include("head.php");
if ($_GET['_action']=="save" and outputForm::IsValidFormPoster())
{
 		$query = outputForm :: CreateSaveQueryString($_GET);
 		echo "<li>$query<hr>";
}

if ($_POST['_action']=="do_save" and outputForm::IsValidFormPoster())
{
 		$query = outputForm :: CreateSaveQueryString($_POST);
 		echo "<li>$query<hr>";
}

$fields=array("name"=>"", "date_of_birth"=>"", "one_to_ten"=>"","email"=>"", "hobbies"=>"Type some hobbies...", "pick_a_number"=>array(1,2,3,4,5), 'upload');
$d = new data($fields);
$o = new outputForm($d);
 $o->Title="Array-based form";
 $o->Types['date_of_birth']='date';
 $o->Types['hobbies']="textarea";
 $o->Types['upload']='file';
 $o->Table="some_table";
 $o->Method="GET";
 $o->Validate['email']=V_EMAIL;
 $o->Validate['one_to_ten']="10:20";
 $o->ValidateMsg['email']="A valid email address is required";
 $o->Display();

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 roa_id", // aliasing
 					"'edit' as cmd",  // fixed text
					"company",  // plain ol columns
					"city",
					"state", // 'state' is magic, and currently gets rendered as a DrawStatePopup
					"zip"
				);
 $d->OrderBy=array("company");
 $d->Where=array("state='FL'");
 $d->LoadData();


$o = new outputForm($d); 
 $o->Title="Simple Form with validation";
 $o->Description = "This form requires a valid us 5 or 9 digit zipcode as defined by the V_POSTAL constant";
 $o->Table="legend_customer"; // if you want it to generate a query, you have to tell it what table it's updating (dataTable passes the table name, so you can skip it for dataTable)
 $o->Key[]="roa_id"; // the Keys array lets you specify all the "where [xx]=val" stuff.  [xx] is a 'key'.  Without it, the query will be an INSERT vs UPDATE
 $o->Method="POST"; // or GET
 $o->Action="do_save"; // the value of the _action variable on the other side of the submite
 $o->SubmitLabel="Update Record";
 $o->ResetLabel=""; // hide it!
 $o->Validate['zip']=V_POSTAL;
 $o->Display();

echo "<hr>";

$o = new outputForm($d);
 $o->Title="Multiple Forms";
 $o->Description="This example shows two form objects glued together into one larger form.  Of course, in this example, it comes from the same datasource, but in real life, it probably wont.  With this method, you could also embed this table into another already exisitng form.";
 $o->Method="POST";
 $o->Action="do_save";
 $o->SubmitLabel="Update Record";
 $o->HideFormBottom=true;
 $o->Display();
$o = new outputForm($d);
 $o->Description="This is the second part";
 $o->Method="GET";
 $o->HideFormTop=true;
 $o->Action="do_save";
 $o->SubmitLabel="Update Record";
 $o->Display();

$const = get_defined_constants(true);
foreach($const['user'] as $c=>$val)
	if ($c[0]=='V')
		$defs[] = $c;
PrintR($defs, "Predefined Form Validation Constants (\$o->Validate['zipcode']=V_POSTAL;):");


include("foot.php");
?>

Debug Log:

Memory Usage: 860.23k, 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.0433]include End head.php include, line 52 home/bartniedner_com/core.bartniedner.com/htdocs/examples/head.php
[0.0013]__construct Incoming array is single-dimensional. Not that there's anything wrong with that. __construct, line 144 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
[0.0133]LoadJavascript Loaded http://core.bartniedner.com/include/javascript/jquery LoadJavascript, line 854 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0000]LoadJavascript Loaded http://core.bartniedner.com/include/javascript/outputform.js LoadJavascript, line 854 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0001]CreateRequiredField required field: email /^[^@]+@[^@]+.[a-z]{2,}$/i 'A valid email address is required' CreateRequiredField, line 525 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/outputForm.php
[0.0001]CreateRequiredField required field: one_to_ten 10:20 'This must be a number from 10 to 20' CreateRequiredField, line 525 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/outputForm.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]DrawTopPart outputForm - Array-based form
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.0004]LoadJavascript Loaded http://core.bartniedner.com/include/javascript/cal/calendar.js LoadJavascript, line 854 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
5. [0.0000]LoadJavascript Loaded http://core.bartniedner.com/include/javascript/cal/calendar-setup.js LoadJavascript, line 854 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
6. [0.0000]LoadJavascript Loaded http://core.bartniedner.com/include/javascript/cal/calendar-en.js LoadJavascript, line 854 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
7. [0.0003]ErrorHandler in_array() [function.in-array]: Wrong datatype for second argument
  /home/bartniedner_com/core.bartniedner.com/htdocs/include/html_functions.php, line 80 (Array) ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
8. [0.0000]ErrorHandler in_array() [function.in-array]: Wrong datatype for second argument
  /home/bartniedner_com/core.bartniedner.com/htdocs/include/html_functions.php, line 80 (Array) ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
9. [0.0000]ErrorHandler in_array() [function.in-array]: Wrong datatype for second argument
  /home/bartniedner_com/core.bartniedner.com/htdocs/include/html_functions.php, line 80 (Array) ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
10. [0.0000]ErrorHandler in_array() [function.in-array]: Wrong datatype for second argument
  /home/bartniedner_com/core.bartniedner.com/htdocs/include/html_functions.php, line 80 (Array) ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
11. [0.0001]DrawBottomPart End
outputForm - Array-based form 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.0004]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.0004]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]CreateRequiredField required field: zip /^(\d{5}((|-)-\d{4})?)|([A-Za-z]\d[A-Za-z][\s\.\-]?(|-)\d[A-Za-z]\d)|[A-Za-z]{1,2}\d{1,2}[A-Za-z]? \d[A-Za-z]{2}$/ '' CreateRequiredField, line 525 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/outputForm.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]ErrorHandler in_array() [function.in-array]: Wrong datatype for second argument
/home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/outputForm.php, line 262 (Array) ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0000]DrawTopPart outputForm - Simple Form with validation
1. [0.0001]PrintWarning WARNING: Invalid argument supplied for foreach()
  /home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/outputForm.php, line 297 (Array) PrintWarning, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
2. [0.0001]JumpToRow jumping to row 0 JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
3. [0.0000]DrawBottomPart End
outputForm - Simple Form with validation DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.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]ErrorHandler in_array() [function.in-array]: Wrong datatype for second argument
/home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/outputForm.php, line 262 (Array) ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0001]DrawTopPart outputForm - Multiple Forms
1. [0.0001]PrintWarning WARNING: Invalid argument supplied for foreach()
  /home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/outputForm.php, line 297 (Array) PrintWarning, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
2. [0.0000]JumpToRow jumping to row 0 JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
3. [0.0000]DrawBottomPart End
outputForm - Multiple Forms DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.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]ErrorHandler in_array() [function.in-array]: Wrong datatype for second argument
/home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/outputForm.php, line 262 (Array) ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0000]DrawTopPart outputForm -
1. [0.0001]PrintWarning WARNING: Invalid argument supplied for foreach()
  /home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/outputForm.php, line 297 (Array) PrintWarning, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
2. [0.0001]JumpToRow jumping to row 0 JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
3. [0.0000]DrawBottomPart End
outputForm - DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
[0.0007]PrintR Array['Predefined Form Validation Constants ($o->Validate['zipcode']=V_POSTAL;):'] PrintR, line 449 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
[0.0001]include Begin foot.php include, line 10 home/bartniedner_com/core.bartniedner.com/htdocs/examples/foot.php
[0.0004]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 outputFreeText - Source code
1. [0.0004]DrawBottomPart cached: /tmp/sourcecodetCOocz DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
2. [0.1635]DrawBottomPart End
outputFreeText - Source code DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php