PHP Classes

File: advanceUsage.php

Recommend this page to a friend!
  Classes of Javier Flores Ibarra   formAt   advanceUsage.php   Download  
File: advanceUsage.php
Role: Example script
Content type: text/plain
Description: Advanced Example
Class: formAt
Generate forms to edit data in MySQL tables
Author: By
Last change:
Date: 14 years ago
Size: 15,056 bytes
 

Contents

Class file image Download
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" /> <title>--:.formAt.:--</title> <style type="text/css"> <!-- a:link { text-decoration: none; } a:visited { text-decoration: none; } a:active { text-decoration: none; } a:hover { text-decoration: underline; } .style1 { font-family: Arial, Helvetica, sans-serif; color: #999999; font-size: 12px; } .fieldStyle { font-family: Arial, Helvetica, sans-serif; font-size:14px; color:#999999; border:solid 1px #CCCCCC; width:200px } .radioCheckStyle { font-family: Arial, Helvetica, sans-serif; font-size:14px; color:#999999; width:200px } .style2 { color: #FFFFFF; font-size: 18px; } .style4 {font-size: 24px} .style5 {color: #000066} --> </style> </head> <body> <p align="center"><a href="index.html"><img src="logo.gif" width="335" height="67" border="0" /></a></p> <? include("config.php"); // INCLUDE CLASS include("formAt.class.php"); // DECLARE AND INITIALIZE OBJECT mysql_connect($host,$login,$password); mysql_select_db($database); $formAt = new formAt(false); // I won't be connected by the object $formAt->defaults(false); // don't get the database default values if(isset($_GET["debug"])){ $formAt->startDebug(); } ?> <table width="100%" border="0" cellspacing="2" cellpadding="2"> <tr> <td width="78%" valign="top"><form id="formAt" name="formAt" method="post" action=""> <table width="529" border="0" align="center" cellpadding="2" cellspacing="2" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;color:#999999"> <tr> <td colspan="2" align="right" valign="top" bgcolor="#B4B4B4"><span class="style2"><a href="basicUsage.php" style="color:#333333">.Basic Usage</a> |<span class="style4"> .Advanced Usage</span> </span></td> </tr> <tr> <td align="right" valign="top">&nbsp;</td> <td> <? if(isset($_GET["debug"])){ echo '<a href="'.$_SERVER['PHP_SELF'].'" style="color:red;font-weight:bold">[ STOP DEBUG ]</a>'; } else{ echo '<a href="'.$_SERVER['PHP_SELF'].'?debug=1" style="color:red;font-weight:bold">[ DEBUG FORM ]</a>'; } ?> </td> </tr> <tr> <td width="199" align="right" valign="top">Customer Name </td> <td width="316"> <? // Generate textfield echo $formAt->genStrField("car_rental", // table "customer_name", // column "my Value", // default value "fieldStyle", // css style "text", // type 'onChange="alert(this.name+\' field value has changed\')"', // added javascript code "customer" // forced field name ); ?> <br /> <div align="left"> <pre style="font-size:9px">//Generate textfield<br />echo $formAt-&gt;genStrField( &quot;car_rental&quot;, // table<br /> &quot;customer_name&quot;, // column<br /> &quot;my Value&quot;, // default value <br /> &quot;fieldStyle&quot;, // css style<br /> &quot;text&quot;, // type<br /> 'onChange=&quot;alert(this.name+\' field value has changed\')&quot;',<br /> &quot;customer&quot;// forced field name<br />);</pre> </div></td> </tr> <tr> <td align="right" valign="top" bgcolor="#EAEAEA">Rent Mode </td> <td bgcolor="#EAEAEA"><? // Generate radio set from enum colum echo $formAt->genEnumSetField("car_rental", // table "rent_mode", // colum "radioCheckStyle", // css style "select", // object type array("daily"), // default value 'onChange="alert(\'Clicked \'+this.value)"' // added javascript ); ?> <br /> <div align="left"> <pre style="font-size:9px">// Generate radio-set from enum column <br />echo $formAt-&gt;genEnumSetField(<br /> &quot;car_rental&quot;, //table<br /> &quot;rent_mode&quot;, // column<br /> &quot;radioCheckStyle&quot;, // css style<br /> &quot;select&quot;, // object type<br /> array(&quot;daily&quot;), // default value <br /> 'onChange=&quot;alert(\'Clicked \'+this.value)&quot;'<br />);</pre> </div></td> </tr> <tr> <td align="right" valign="top">Credit Card </td> <td><? // Generate checkbos set from set colum echo $formAt->genEnumSetField("car_rental", // table "credit_card", // colum "radioCheckStyle", // css style "select", // object type array("visa","master card"), // values 'style="font-size:18px"', // added css style code 2, // select size true, // select-multiple "card" // forced name ); ?> <br /> <div align="left"> <pre style="font-size:9px">// Generate checkbox-set from set column <br />echo $formAt-&gt;genEnumSetField(<br /> &quot;car_rental&quot;, // table<br /> &quot;credit_card&quot;, // column<br /> &quot;radioCheckStyle&quot;,// css style<br /> &quot;select&quot;, // object type<br /> array(&quot;visa&quot;,&quot;master card&quot;), // values<br /> 'style=&quot;font-size:18px&quot;', // added css style code<br /> 2, // select size<br /> true, // select-multiple<br /> &quot;card&quot; //forced name<br />);</pre> </div></td> </tr> <tr> <td align="right" valign="top" bgcolor="#EAEAEA">Service Description </td> <td bgcolor="#EAEAEA"><? // Generate textarea echo $formAt->genStrField("car_rental", // table "service_description", // column "I need a ...", // default value "fieldStyle" // css style ); ?> <br /> <div align="left"> <pre style="font-size:9px">// Generate textarea<br />echo $formAt-&gt;genStrField(<br /> &quot;car_rental&quot;, //table<br /> &quot;service_description&quot;, // column<br /> &quot;I need a ...&quot;, // default value <br /> &quot;fieldStyle&quot; // css style<br />);</pre> </div></td> </tr> <tr> <td align="right" valign="top">Price</td> <td><? // Generate textfield echo $formAt->genStrField("car_rental", // table "price", // column "200.00", // default value "fieldStyle" , // css style "text", // type 'style="color:red"', // added javascript code "price" // forced field name ); ?> <br /> <div align="left"> <pre style="font-size:9px">// Generate textfield<br />echo $formAt-&gt;genStrField(<br /> &quot;car_rental&quot;, // table<br /> &quot;price&quot;, // column<br /> &quot;200.00&quot;, // default value <br /> &quot;fieldStyle&quot;, // css style<br /> &quot;text&quot;, // type<br /> 'style=&quot;color:red&quot;', //added style code<br /> &quot;price&quot; // forced field name<br />);</pre> </div></td> </tr> <tr> <td align="right" valign="top" bgcolor="#EAEAEA">Pick-up Time </td> <td bgcolor="#EAEAEA"><? // Generate textfield echo $formAt->genStrField("car_rental", // table "pickup_time", // column "", // default value "fieldStyle" // css style ); ?> <br /> <div align="left"> <pre style="font-size:9px">// Generate textfield <br />echo $formAt-&gt;genStrField( &quot;car_rental&quot;, //table<br /> &quot;pickup_time&quot;, // column<br /> &quot;&quot;, // default value <br /> &quot;fieldStyle&quot; //css style<br />);</pre> </div></td> </tr> <tr> <td align="right" valign="top">Drop-off Time </td> <td><? // Generate textfield echo $formAt->genStrField("car_rental", // table "dropoff_time", // column "", // default value "fieldStyle" // css style ); ?> <br /> <div align="left"> <pre style="font-size:9px">// Generate textfield <br />echo $formAt-&gt;genStrField( &quot;car_rental&quot;, // table<br /> &quot;dropoff_time&quot;, // column<br /> &quot;&quot;, // default value <br /> &quot;fieldStyle&quot; // css style<br />);</pre> </div></td> </tr> <tr> <td align="right" valign="top" bgcolor="#EAEAEA">Car</td> <td bgcolor="#EAEAEA"><? // Generate a select object based on a table $formAt->setSelectIniLabel("Select a Car"); // Set the first option label for information echo $formAt->genCatalogueField("cars", // table "car_id", // column for value "car", // column for label "fieldStyle" , // css style "checkbox", // set to checkbox-set 'WHERE car_id<4', // sql extra code array(1,3), // selected values 'onClick="alert(\'onClick event\')"' // javascript code ); ?> <br /> <div align="left"> <pre style="font-size:9px">// Generate a select object based on a table<br />$formAt-&gt;setSelectIniLabel(&quot;Select a Car&quot;); // Set the first option<br />echo $formAt-&gt;genCatalogueField(<br /> &quot;cars&quot;, //table<br /> &quot;car_id&quot;, // column for value<br /> &quot;car&quot;, // column for label<br /> &quot;fieldStyle&quot;, // css style<br /> &quot;checkbox&quot;, // set to checkbox-set<br /> 'WHERE car_id&lt;4', // sql extra code<br /> array(1,3), // selected values '<br /> 'onClick=&quot;alert(\'onClick event\')' // javascript code<br />);</pre> </div></td> </tr> <tr> <td colspan="2" align="center" valign="top" bgcolor="#FFFFCC"><span class="style5">STANDALONE FIELDS</span> <br /> (Not related to database)</td> </tr> <tr> <td align="right" valign="top">Field A </td> <td> <? // StandAlone password field echo $formAt->addTHPInput("Field_A", // Field Name "abcd123", // Value "password", // type "fieldStyle", // css style 30, // maxlength 'onChange="alert(\'The password is: \'+this.value)"' // javascript ); ?> <br /> <div align="left"> <pre style="font-size:9px">// StandAlone password field<br />echo $formAt-&gt;addTHPInput( &quot;Field_A&quot;, // Field Name<br /> &quot;abcd123&quot;, // Value<br /> &quot;password&quot;, // type<br /> &quot;fieldStyle&quot;, // css style<br /> 30, // maxlength<br /> 'onChange=&quot;alert(\'The password is: \'+this.value)&quot;' // javascript<br />);</pre> </div></td> </tr> <tr> <td align="right" valign="top" bgcolor="#EAEAEA">Field B </td> <td bgcolor="#EAEAEA"> <? // Standalone select field // Labels an Values $fieldBData = array( array("label"=>"b1","value"=>"1"), array("label"=>"b2","value"=>"2"), array("label"=>"b3","value"=>"3") ); echo $formAt->addSelectList("Field_B", // Name $fieldBData, // Data "fieldStyle", // Css Style array(1,3), // Selected 'style="background-color:#ccc"', // Added style 3, // Select size true // select-multiple ); ?> <br /> <div align="left"> <pre style="font-size:9px">// Standalone select field<br />// Labels an Values<br /> $fieldBData = array(<br /> array(&quot;label&quot;=&gt;&quot;b1&quot;,&quot;value&quot;=&gt;&quot;1&quot;), <br /> array(&quot;label&quot;=&gt;&quot;b2&quot;,&quot;value&quot;=&gt;&quot;2&quot;),<br /> array(&quot;label&quot;=&gt;&quot;b3&quot;,&quot;value&quot;=&gt;&quot;3&quot;) <br /> );<br /> <br />echo $formAt-&gt;addSelectList( &quot;Field_B&quot;, // Name $fieldBData, // Data<br /> &quot;fieldStyle&quot;, // Css Style<br /> array(1,3), // Selected <br /> 'style=&quot;background-color:#ccc&quot;', // Added style <br /> 3, // Select size<br /> true // select-multiple<br />);</pre> </div></td> </tr> <tr> <td align="right" valign="top">Field C </td> <td><? // Standalone checkboox-set // Labels an Values $fieldCData = array( array("label"=>"c1","value"=>"1"), array("label"=>"c2","value"=>"2"), array("label"=>"c3","value"=>"3") ); echo $formAt->addCheckBox("Field_C", // Name $fieldCData, // Data "fieldStyle", // Css Style array(2), // Checked 'onClick="alert(\'onClick Event\')"' // Javascript code ); ?> <br /> <div align="left"> <pre style="font-size:9px">// Standalone checkboox-set // Labels an Values $fieldCData = array( array("label"=>"c1","value"=>"1"), array("label"=>"c2","value"=>"2"), array("label"=>"c3","value"=>"3") ); echo $formAt->addCheckBox( "Field_C", // Name $fieldCData, //Data "fieldStyle", // Css Style array(2), // Checked 'onClick="alert(\'onClick Event\')"' // Javascript code );</pre> </div></td> </tr> <tr> <td align="right" valign="top" bgcolor="#EAEAEA">Field D </td> <td bgcolor="#EAEAEA"> <? // Labels an Values $fieldDData = array( array("label"=>"d1","value"=>"1"), array("label"=>"d2","value"=>"2"), array("label"=>"d3","value"=>"3") ); echo $formAt->addRadio("Field_C", // Name $fieldDData, // Data "radioCheckStyle", // Css Style "1", // Checked 'onClick="alert(this.value)"' // Javascript code ); ?> <br /> <div align="left"> <pre style="font-size:9px">// Standalone checkboox-set // Labels an Values $fieDdCData = array( array(&quot;label&quot;=&gt;&quot;c1&quot;,&quot;value&quot;=&gt;&quot;1&quot;), array(&quot;label&quot;=&gt;&quot;c2&quot;,&quot;value&quot;=&gt;&quot;2&quot;), array(&quot;label&quot;=&gt;&quot;c3&quot;,&quot;value&quot;=&gt;&quot;3&quot;) ); echo $formAt-&gt;addCheckBox( &quot;Field_D&quot;, // Name $fieldDData, //Data &quot;radioCheckStyle&quot;, // Css Style 1, // Checked 'onClick=&quot;alert(this.value)&quot;' // Javascript code );</pre> </div></td> </tr> <tr> <td align="right" valign="top">&nbsp;</td> <td><input name="Reset" type="reset" class="fieldStyle" style="width:100px" value="Reset" /> <label> <input name="Submit2" type="submit" class="fieldStyle" style="width:100px" value="Submit" disabled="disabled" /> </label></td> </tr> </table> </form> <p class="style1">&nbsp;</p> </td> </tr> </table> <p>&nbsp;</p> </body> </html>