[FX.php List] FW: FX.php problem ... Record Not Found

Gjermund Gusland Thorsen ggt667 at gmail.com
Sat Jun 6 06:50:47 MDT 2009


How about using pastebin.com?

ggt

2009/6/6 VanBuskirk, Patricia <pvanbuskirk at otc.fsu.edu>:
> I forgot to mark it as plain text, and I did not see it come through ... so, here we try again...
>
> From: VanBuskirk, Patricia
> Sent: Saturday, June 06, 2009 8:45 AM
> To: FX.php_List at mail.iviking.org
> Subject: FX.php problem ... Record Not Found
>
> Hi group .. this is driving me crazy.  I've managed to get all the records showing on one page, in a form to edit.  However, when I click the SAVE button, I receive a "Record Not Found" error.  Can someone see where I've gone wrong?  The first part is the form the user goes to after logging on, the second part is the response page.  Note: The delete buttons work, as well as the create-new form.  The Edit portion gives me the error.  Thanks in advance!
>
> <?php
> session_start();
> require_once('server_data3.php');
> require_once('FX.php');
> include_once('FMErrors.php');
>
> $userID = $_SESSION['UID'];
>
> // configure a connection to FileMaker Server Advanced
> $users=new FX(FM_IP, FM_PORT, FM_VERSION);
> // set database and layout information (uses info in included file 'server_data3.php)
> $users->SetDBData(FM_DATABASE, 'SG_Users');
> // set database username and password (uses info in included file 'server_data3.php)
> $users->SetDBPassword(FM_USERNAME, FM_PASSWORD);
> // specify the search criteria
> $users->AddDBParam ('_p_UserID', $userID, 'eq');
> // performs find
> $usersResult=$users->FMFind();
>
> $sectionName=new FX(FM_IP, FM_PORT, FM_VERSION);
> $sectionName->SetDBData(FM_DATABASE, 'SG_Sections', 'all');
> $sectionName->SetDBUserPass(FM_USERNAME, FM_PASSWORD);
> $sectionName->AddDBParam ('_UserID', $userID, 'eq');
> $sectionName->AddDBParam ('SectionIncorrect', "X", 'neq');
> $sectionName->AddSortParam('_SectionID','ascend');
> $sectionResult=$sectionName->FMFind();
>
> $deptListQuery=new FX(FM_IP, FM_PORT, FM_VERSION);
> $deptListQuery->SetDBData(FM_DATABASE, 'SeeAll', 'all');
> $deptListQuery->SetDBUserPass(FM_USERNAME, FM_PASSWORD);
> $deptListQuery->AddDBParam ('_UserID', $userID, 'eq');
> $deptListQuery->AddDBParam ('SG_Sections::SectionIncorrect', "X", 'neq');
> $deptListQuery->AddSortParam('SG_Sections::SectionName','ascend');
> $deptListQuery->AddSortParam('PrintOrder','ascend');
> $deptListQuery->AddSortParam('Main','descend');
> $deptListQuery->AddSortParam('PrintLine','ascend');
> $deptList = $deptListQuery->FMFind();
>
> include_once('SG_header.php');
> ?>
> <link href="../main.css" rel="stylesheet" type="text/css" />
> <table width="842" border="0" align="center" bgcolor="#FFFFFF">
>   <tr>
>     <td>
>       <table>
>         <tr class="SGtable">
>           <td colspan="9" align="center" valign="bottom" class="blue">You Have <?php echo $deptList['foundCount']; ?> LISTING(S)</td>
>         </tr>
>         <tr valign="bottom">
>           <td align="center" class="ColumnHeader">Delete</td>
>           <td nowrap="nowrap" class="ColumnHeader">Section Name</td>
>           <td align="center" class="ColumnHeader">Print<br />
>             Order</td>
>           <td align="center" class="ColumnHeader"><span class="style2">*<br />
>             </span>Main<br />
>             Listing?</td>
>           <td nowrap="nowrap" class="ColumnHeader">Listing</td>
>           <td class="ColumnHeader">Address<br /></td>
>           <td align="center" nowrap="nowrap" class="ColumnHeader" id="t_Phone">Phone # <br />
>             &nbsp;<span class="crumbs">XXX-XXXX</span></td>
>           <td align="center" class="ColumnHeader"><span class="style2">**</span><br />
>             Embarq?</td>
>           <td align="center" class="ColumnHeader">Save<br />
>           Changes</td>
>         </tr>
>         <tr valign="bottom">
>           <td colspan="9" align="right" class="crumbs"><strong> Address Format: Room number, Building abbreviation - i.e. 6100 UCC</strong></td>
>         </tr>
>         <?php
>                 foreach($deptList['data'] as $currentID=>$Listing){
>                 $recordDetails=explode('.',$currentID);
>                 $Record=$recordDetails[0];
>                 ?>
>         <form action='edit_response.php' method='post'>
>           <input type='hidden' name='_SectionID' value='<?php echo $Listing['_SectionID'][0]; ?>' />
>           <input type='hidden' name='recid' value='<?php $Record ?>' />
>           <tr>
>             <td align='center' valign='top'><a href="delete.php?recid=<?php echo $Record; ?>"><img src="images/delete.png" alt="delete" width="16" height="16" border="0" /></a></td>
>             <td valign="top" class='data'><?php echo $Listing['SG_Sections::SectionName'][0] ?></td>
>             <td valign="top"><input type='text' class='formfields' name='web_newsort' value='<?php echo $Listing['PrintOrder'][0] ?>' size='3' align='center' /></td>
>             <td valign="top"><input type='text' class='formfields' name='Main' value='<?php echo $Listing['Main'][0] ?>' size='2' /></td>
>             <td align='center' valign="top"><input type='text' class='formfields' name='PrintLine' value='<?php echo $Listing['PrintLine'][0] ?>' size='50' /></td>
>             <td valign="top"><input type='text' class='formfields' name='Address' value='<?php echo $Listing['Address'][0] ?>' size='15' /></td>
>             <td align='center' valign="top"><input type='text' class='formfields' name='Phone' value='<?php echo $Listing['Phone'][0] ?>' size='10' /></td>
>             <td align='center' valign="top"><input type='text' class='formfields' name='Embarq' value='<?php echo $Listing['Embarq'][0] ?>' size='2' /></td>
>             <td valign='top'><input name='update_record' type='submit' class='tiny' value='Save' />            </td>
>           </tr>
>                                   <?php
>                                   }
>                                   ?>
>         </form>
>       </table>
>       <table width="100%" align="center" class="SGtable" valign='top'>
>     <tr>
>       <td class="whitecaps" style="background-color:#999999">ADD NEW LINE:</td>
>   </tr>
> </table>
> <table width="100%" align="center" class="SGtable">
>   <tr class="SGtable">
>     <td align="center" valign="bottom" class="ColumnHeader">Section
>       Name</td>
>     <td align="center" valign="bottom" class="ColumnHeader">Print<br>
>       Order</td>
>     <td align="center" valign="bottom" class="ColumnHeader">Main</td>
>     <td align="center" valign="bottom" class="ColumnHeader">Listing</td>
>     <td align="center" valign="bottom" class="ColumnHeader">Address</td>
>     <td align="center" valign="bottom" class="ColumnHeader">Phone<br>
>       #</td>
>     <td align="center" valign="bottom" class="ColumnHeader">Embarq</td>
>     <td align="center" valign="bottom" class="ColumnHeader">&nbsp;</td>
>   </tr>
>     <form action="new_response.php" method="post" name="create_new_record">
>       <tr>
>         <td valign="bottom">
>           <select name="_tempText" class="formfields">
>             <?php
>                                                                                 foreach($sectionResult['data'] as $key=>$sectionData) {
>                                                                                                 echo "<option>".$sectionData['SectionNameCombined'][0]."</option> \n";
>                                                                                                 }
>                                                                                 ?>
>           </select>                                   </td>
>           <td align="center" valign="bottom"><input name="web_newsort" type="text" class="formfields" value="" size="5" /></td>
>           <td align="center" valign="bottom"><input name="Main" type="text" class="formfields" value="" size="3" maxlength="1" /></td>
>           <td align="left" valign="bottom"><input type="text" class="formfields" name="PrintLine" value="" /></td>
>           <td valign="bottom"><input type="text" class="formfields" name="Address" value="" size="20" /></td>
>           <td valign="bottom"><input type="text" class="formfields" name="Phone" value="" size="10" /></td>
>           <td align="center" valign="bottom"><input name="Embarq" type="text" class="formfields" value="" size="3" maxlength="1" /></td>
>           <td align="center"><span class="style13">
>             <input name="clear" type="reset" class="tiny" value="Clear Input">
>           </span></td>
>       </tr>
>       <tr>
>         <td colspan="8" align="center" valign="bottom">&nbsp;
>           <label>
>                                  <input type="hidden" name="Web" value="Y" />
>          <input name="new_record" type="submit" class="header" value="Submit NEW">
>           </label></td>
>         </tr>
>   </form>
> </table>
>                 </td>
>   </tr>
> </table>
> <br>
> <?php
> include_once('SG_footer.php');
> ?>
>
>
>
> Edit_response.php:
>
> <?php
> session_start(); // Turn on sessions
> include_once('FX.php');
> include_once('server_data3.php');
> include_once('FMErrors.php');
>
> if (!isset($_POST['recid'])) {
>                 include_once('SG_header.php');
>                 echo "<table width='845' class='SGtable' align='center' cellpadding='6' cellspacing='2' bgcolor='#FFFFFF'><tr><td>";
>                 echo "<p align='center' class='bold-red'>ERROR: You must be logged in to go to this page!</p>";
>                 echo "<p align='center'><a href='Login.php' class='SG_buttons'>Login</a></p><br></td></tr></table>";
>                 include_once('SG_footer2.php');
>                 exit();
>                 } else {
>
> $userID=$_SESSION['UID'];
> $recid=$_POST['recid'];
>
> function convert_smart_quotes($string)
> {
>      $search = array(chr(145),
>                                  chr(146),
>                                                                                  chr(147),
>                                                                                  chr(148),
>                                                                                  chr(150),
>                                                                                  chr(151),
>                                                                                  "-",
>                                                                                  "-",
>                                                                                  "#",
>                                                                                  ";",
>                                                                                  "[",
>                                                                                  "]",
>                                                                                  "{",
>                                                                                  "}",
>                                                                                  "<",
>                                                                                  ">",
>                                                                                  "=",
>                                                                                  "http://",
>                                                                                  "URL=http://");
>       $replace = array("'",
>                                    "'",
>                                                                                    '"',
>                                                                                    '"',
>                                                                                    "-",
>                                                                                    "-",
>                                                                                    "---",
>                                                                                    "--",
>                                                                                    "no.",
>                                                                                    ",",
>                                                                                    "",
>                                                                                    "",
>                                                                                    "",
>                                                                                    "",
>                                                                                    "",
>                                                                                    "",
>                                                                                    "-",
>                                                                                    "",
>                                                                                    "");
>       return str_replace($search, $replace, $string); }
>
> $printline = convert_smart_quotes($_POST['PrintLine']);
> $address = convert_smart_quotes($_POST['Address']);
>
> $editRecordArray = array('Main' => $_POST['Main'],'PrintLine' => stripslashes($printline), 'Address' => stripslashes($address),'Phone' => stripslashes($_POST['Phone']), 'Embarq' => $_POST['Embarq']);
>
> $edit=new FX(FM_IP, FM_PORT, FM_VERSION);
> $edit->SetDBData(FM_DATABASE, 'SeeAll');
> $edit->SetDBUserPass(FM_USERNAME, FM_PASSWORD);
> $edit->AddDBParam('-recid',$recid);
> $edit->AddDBParamArray($editRecordArray);
> $editResult=$edit->FMEdit();
>
> if ($editResult['errorCode']!=0) {
>                 echo "<br>Error Code:  ".$editResult['errorCode'];
>                 } else {
>                 echo "Thanks!";
>                 echo $recid;
>                 //header("Location: http://www2.otc.fsu.edu/Forms/DD_Test/show_all3.php");
>                 }
> }
> ?>
> _______________________________________________
> 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