[FX.php List] Simple form with fx.php
Troy Meyers
tcmeyers at troymeyers.com
Fri Jan 9 10:45:28 MST 2009
Patricia,
There are mismatched or crossed tags, so the form closing tag </form> isn't being recognized.
Check your tag balancing. Maybe there's just one missing or added.
-Troy
> Apparently, I've gone brain dead since I did my forms (that currently
> work fine) using fx.php! I suppose the holidays can do that to one!
> (FM9A on FMS9 on Win2000)
>
> I am trying to do a VERY simple form (6 fields) and cannot get it to
> work! I copied most of it from the working forms. When I submit, it
> creates a blank record in the database, and this is what I see for the
> confirmation page (I turned on display_errors in my php.ini file):
>
> Notice: Undefined index: EmployeeName in
>
> E:\inetpub\wwwroot\Forms\Repair\OTISconfirm.php on line 5
>
> Notice: Undefined index: Department in
>
> E:\inetpub\wwwroot\Forms\Repair\OTISconfirm.php on line 5
>
> Notice: Undefined index: Area in
>
> E:\inetpub\wwwroot\Forms\Repair\OTISconfirm.php on line 5
>
> Notice: Undefined index: Description in
>
> E:\inetpub\wwwroot\Forms\Repair\OTISconfirm.php on line 5
>
> Notice: Undefined index: Date in
>
> E:\inetpub\wwwroot\Forms\Repair\OTISconfirm.php on line 5
>
> Notice: Undefined index: Order_RepairNo in
>
> E:\inetpub\wwwroot\Forms\Repair\OTISconfirm.php on line 5
>
> Warning: Illegal offset type in isset or empty in
>
> E:\inetpub\wwwroot\Forms\Repair\OTISconfirm.php on line 22
>
> Your Time Has Been Submitted.
>
> Employee Name:
>
> Department:
>
> Area:
>
> Date:
>
> Description:
>
> Order/Repair #:
>
> Go Back and Enter More Time
>
> ------------------------------------------------------------------------
> -----------------------------
>
> Here is the form code:
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
> "http://www.w3.org/TR/html4/loose.dtd">
>
> <head>
>
> <META http-equiv="Content-Type" content="text/html; charset=UTF-8">
> <title>Online OTIS Time Tracking Ticket</title>
>
> <LINK href="repair.css" rel="stylesheet" type="text/css" /> <style
> type="text/css">
>
> <!--
>
> .style16 {font-size: 12px}
>
> .style20 {font-size: 11px; font-family: Verdana, Arial, Helvetica,
> sans-serif;}
>
> -->
>
> </style>
>
> </head>
>
> <BODY text=#000000 vLink=#666666 aLink=#cc0000 link=#990000
> bgColor=#ffffff>
>
> <form ACTION="OTISconfirm.php" METHOD="POST" name="form">
>
> <center>
>
> <P><font size="1" face="Verdana, Arial, Helvetica,
> sans-serif"><IMG src="/forms/images/OTISbanner.jpg" alt="banner"
> width="625" height="65" /></font></P>
>
> </center>
>
> <center>
>
> <table width="625" border=0 cellpadding=6
> bordercolor=#660000>
>
> <TBODY>
>
> <TR valign=middle align="center">
>
> <td width="286" align="right" valign="bottom"
> class="style20"><strong>Employee Name: </strong></td>
>
> <td width="309" align="left" valign="top">
>
> <select name="EmployeeName" id="EmployeeName"
> tabindex="1">
>
> <option selected>Select Name ...</option>
>
> <option value="Wayne Bell">Wayne Bell</option>
>
> <option value="Daniel Kane">Daniel
> Kane</option>
>
> <option value="Mike Little">Mike
> Little</option>
>
> <option value="Marty McClamma">Marty
> McClamma</option>
>
> <option value="Trish Van Buskirk">Trish Van
> Buskirk</option>
>
> </select></td>
>
> </tr>
>
> </TBODY>
>
> </table>
>
> <table width="625" border=1 cellpadding="3"
> cellspacing="0" borderColor=#660000 bgcolor="#660000"> <TBODY> <TR borderColor=#660000 bgColor=#dece9c> <td align=center bgcolor="#660000"><font
> color="#dece9c" face="Verdana, Arial, Helvetica, sans-serif"><font
> color="#FFFFCC"><span class="style16">DEPARTMENT /
>
> AREA</span></font></font><font color="#dece9c" size="1" face="Verdana,
> Arial, Helvetica, sans-serif"><font color="#FFFFCC"><br> WORK DONE FOR</font></font></td> </tr> </TBODY> </table>
>
> <table width="625" border="0" cellspacing="1"
> cellpadding="6">
>
> <tr valign="middle">
>
> <td height="89" colspan="3" align="center"
> bgcolor="#E8E8E8"><p align="center"><span class="style2"><font
> face="Verdana, Arial, Helvetica,
>
> sans-serif"><strong>Department:</strong> </font></span>
>
> <select size="1" name="Department" tabindex="2"
> maxlength="20">
>
> <option selected>TELECOMMUNICATIONS, OFFICE
> OF</option>
>
> <?php
>
> require_once('FX.php');
>
> require_once('server_data.php');
>
> ini_set('display_errors', 'on');
>
> // configure a connection to FileMaker Server Advanced $ordersQuery =
> new FX(FM_IP, FM_PORT, FM_VERSION);
>
> // set database and layout information
>
> $ordersQuery->SetDBData('WEB_Forms', 'SG_Sections', 'all'); // set
> database username and password
>
> $ordersQuery->SetDBUserPass(FM_USERNAME, FM_PASSWORD); // retrieve all
> records in this database available to the current user
> $ordersQuery->AddSortParam('SectionName', 'ascend'); $orders =
> $ordersQuery->DoFXAction(FX_ACTION_FINDALL);
>
> foreach ($orders as $contact) {
>
> // the substr function below will take the string between the start and
> stop numbers given within the commas (basically allows to 'crop' the
> field)
>
> echo substr ("<option>{$contact['SectionName']}\n", 0, 80); }
>
> ?>
>
> </select>
>
> <br>
>
> (Change
> using drop-down) </p>
>
> <p><span class="style2"><font face="Verdana, Arial,
> Helvetica, sans-serif">OTC Area:</font></span>
>
> <select size="1" name="Area" tabindex="3">
>
> <option selected> </option>
>
> <option value="ACT">ACT</option>
>
> <option value="ADM">ADM</option>
>
> <option value="CASS">CASS</option>
>
> <option value="CC">CC</option>
>
> <option value="CRM">CRM</option>
>
> <option value="ENG">ENG</option>
>
> <option value="HD">HD</option>
>
> <option value="IMR">IMR</option>
>
> <option value="NET">NET</option>
>
> <option value="OTIS">OTIS</option>
>
> <option value="PUR">PUR</option>
>
> </select>
>
> <span class="style20"> <span class="style13">(if
> applicable)</span></span></td>
>
> </tr>
>
> </table>
>
> <table bordercolor=#660000 cellpadding=6 width="625"
> border=0> <TBODY> <TR valign=middle align="center"> <td colspan="2" bgcolor="#630000"><font
> color="#FFFFFF" size="1"
>
> face="Verdana, Arial, Helvetica, sans-serif">Details of
> Work </font></td> </tr>
>
> <TR align="center" valign=middle>
>
> <td align="right" valign="top" class="style20"><span
> class="style2">Date:</span><br>
>
> <span class="style13">(If other than today)
> </span></td>
>
> <?php
>
> $month = date('n');
>
> $day = date('d');
>
> $year = date('Y');
>
> ?> <td align="left"
>
> valign="top"><input name="Date" type="text" id="Date" tabindex="4"
> value="<?php echo ("$month/$day/$year"); ?>">
>
> <span class="style2">Hours Worked:</span> <input
> name="Hours" type="text" size="7" tabindex="5"> </span></td>
>
> </tr>
>
> <TR align="center" valign=middle>
>
> <td width="147" align="right" valign="top"
> class="style20"><SPAN class="style2"><font face="Verdana, Arial,
> Helvetica, sans-serif">Work Description: </font></SPAN></td>
>
> <td width="448" align="left" valign="top"><TEXTAREA
> tabindex=6 name="Description" rows=7 wrap="physical"
> cols=70></TEXTAREA></td>
>
> </tr>
>
> <TR valign=middle align="center">
>
> <td align="right" valign="top" class="style20"><span
> class="style2">Order/Ticket Number:</span><br>
>
> <span class="style13">(if applicable)</span></td>
>
> <td align="left" valign="top"><input
> name="Order_RepairNo" type="text" id="Order_RepairNo" tabindex="7"></td>
>
> </tr>
>
> </TBODY> </table>
>
> <table width="625" border=0 cellpadding=10
> bordercolor=#660000>
>
> <TBODY>
>
> <TR valign=middle align="center">
>
> <td><SPAN class="style20">
>
> <input name="new_record" type="submit"
> id="new_record" tabindex="8" value="Submit Time"/>
>
> </SPAN> <font size="1"
>
> face="Verdana, Arial, Helvetica, sans-serif">
>
> <input name="reset" type="reset" id="reset"
> tabindex="9" value="Reset Form">
>
> </font></td></tr>
>
> </TBODY>
>
> </table>
>
> </center>
>
> </form> </table>
>
> </body>
>
> </html>
>
> ------------------------------------------------------------------------
> ------------------------------
>
> NOW THE CONFIRM PAGE:
>
> <?php
>
> require_once('FX.php');
>
> require_once('server_data.php');
>
> $newRecordArray = array('EmployeeName' =>
>
> $_POST['EmployeeName'],'Department' => $_POST['Department'],'Area' =>
> $_POST['Area'],'Description' => stripslashes($_POST['Description']),
> 'Date' => $_POST['Date'], 'Order_RepairNo' => $_POST['Order_RepairNo']);
>
>
>
> // configure a connection to FileMaker Server Advanced $ordersQuery =
> new FX(FM_IP, FM_PORT, FM_VERSION);
>
> // set database and layout information
>
> $ordersQuery->SetDBData('OTC_Time_Tracker.fp7', 'OTIS_Time'); // set
> database username and password
>
> $ordersQuery->SetDBUserPass(FM_USERNAME, FM_PASSWORD); // retrieve all
> records in this database available to the current user // add parameter
> array for new record
>
> $ordersQuery->AddDBParamArray($newRecordArray);
>
> // retrieve all checkbox info
>
> // add parameter array for new record
>
> // Add pararameters for the checkboxes. This allows some to be not
> checked without an error.
>
> $orders = $ordersQuery->DoFXAction(FX_ACTION_NEW);
>
> foreach($orders as $order) {
>
> if(isset($_POST[$order])) {
>
> $ordersQuery->AddDBParam($order, $_POST[$order]);
>
> }
>
> }
>
> ?>
>
> <!--THIS IS WHERE THE ON-SCREEN CONFIRMATION INFO BEGINS--> <html>
>
> <head>
>
> <META http-equiv="Content-Type" content="text/html; charset=UTF-8">
> <title>OTIS Time Tracking Confirmation</title>
>
> <style type="text/css">
>
> <!--
>
> .style1 {
>
> font-size: medium;
>
> font-weight: bold;
>
> font-family: Verdana, Arial, Helvetica, sans-serif; }
>
> .style2 {font-family: Verdana, Arial, Helvetica, sans-serif} .style3
> {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; }
>
> .style4 {
>
> font-size: 12px;
>
> font-weight: bold;
>
> }
>
> .style5 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size:
> 12px; font-weight: bold; }
>
> -->
>
> </style>
>
> </head>
>
> <BODY>
>
> <p class="style1">Your Time Has Been Submitted.</p> <table width="80%"
> border="0" cellspacing="0" cellpadding="6">
>
> <tr>
>
> <td width="36%" align="right" class="style5">Employee Name:</td>
>
> <td width="64%" class="style2"><span class="style4"><?php echo
> ($order['EmployeeName']); ?></span></td>
>
> </tr>
>
> <tr>
>
> <td align="right" class="style5">Department:</td>
>
> <td class="style3"><span class="style4"><?php echo
> ($order['Department']); ?></span></td>
>
> </tr>
>
> <tr>
>
> <td align="right" class="style5">Area:</td>
>
> <td class="style3"><span class="style4"><?php echo
> ($order['Area']); ?></span></td>
>
> </tr>
>
> <tr>
>
> <td align="right" class="style5">Date:</td>
>
> <td class="style3"><span class="style4"><?php echo
> ($order['Date']); ?></span></td>
>
> </tr>
>
> <tr>
>
> <td align="right" class="style5">Description:</td>
>
> <td class="style3"><span class="style4"><?php echo
> ($order['Description']); ?></span></td>
>
> </tr>
>
> <tr>
>
> <td align="right" class="style5">Order/Repair #: </td>
>
> <td class="style3"><span class="style4"><?php echo
> ($order['Order_RepairNo']); ?></span></td>
>
> </tr>
>
> <tr>
>
> <td height="46" colspan="2" align="center" valign="bottom"
> class="style5"><a href="OTIStime.php">Go Back and Enter More
> Time</a></td>
>
> </tr>
>
> </table>
>
> <p> </p>
>
> <p> </p>
>
> </body>
>
> </html>
>
> _______________________________________________
>
> FX.php_List mailing list
>
> FX.php_List at mail.iviking.org
>
> http://www.iviking.org/mailman/listinfo/fx.php_list
More information about the FX.php_List
mailing list