[FX.php List] Basic help

Bob Patin bob at patin.com
Wed May 28 08:25:31 MDT 2008 

You don't HAVE to use separate pages; here's how you can do it:

(this is your 2nd page)

STEP ONE: find the record

$mySearchVariable = $_POST['myName']; <- or whatever you want to  
search for

$find = new FX('64.62.67.186','80','FMPro7');
$find->SetDBData('BG_Clients','BGDB Export');
$find->SetDBUserPass('Admin', 'iona');
$find->AddDBParam('field_that_you_are_searching', $mySearchVariable);
$findResult = $find->FMFind();

// here you should put some sort of error-checking to make sure you're  
finding something
if ($requestResult['errorCode']==0){
	foreach($findResult['data'] as $key=>$findData);
	// retrieve the recordID for the record you just found
	// several ways to do this: I just create a field in my database  
called "recid", and it's a calc field equal to get(recordid)
	// you can also get the id another way, but I like this way better
	$recid = $findData['recid'][0]; // we retrieve the recid of the  
record we just found

	// now that you got the recid you can now edit the record
	$myNewFieldValue = "the new value that I am going to store";
	
	// NOW we edit the record
	$edit = new FX('64.62.67.186','80','FMPro7');
	$edit->SetDBData('BG_Clients','BGDB Export');
	$edit->SetDBUserPass('Admin', 'iona');
	$edit->AddDBParam('-recid',$recid);
	$edit->AddDBParam('field_that_you_are_editing', $myNewFieldValue); //  
write the new value for the field you're editing
	$editResult = $edit->FMEdit();
}else{
	include_once('your_error_page.htm'); // go to an error page
}

That's it in a nutshell... :)

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
FileMaker 9 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet

   CONTACT US VIA INSTANT MESSAGING:
      AIM or iChat: longterm1954
      Yahoo: longterm_solutions
      MSN: tech at longtermsolutions.com
      ICQ: 159333060

--------------------------
Contact us for FileMaker hosting and programming for all versions of  
FileMaker
PHP • CDML • Full email services • Free DNS hosting • Colocation •  
Consulting


On May 28, 2008, at 9:10 AM, CSInfo wrote:

> OK, I made some changes to my "page 2", it returns the correct data  
> and now
> I need to pass it to "page 3" and assign it to $recid. How?
>
> Please see my snippet of "page 3" code below:
>
> $recid = '10'; // hard coded but need to get id from post?
>
> $request = new FX('64.62.67.186','80','FMPro7');
> $request->SetDBData('BG_Clients','BGDB Export');
> $request->SetDBUserPass('Admin', 'iona');
> $request->AddDBParam('-recid', $recid);
> $result = $request->FMEdit();
>
>
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Jonathan  
> Schwartz
> Sent: Tuesday, May 27, 2008 10:55 PM
> To: FX.php Discussion List
> Subject: Re: [FX.php List] Basic help
>
> Sometimes very basic...isn't.
>
> This process involves 4 primary steps on three pages.
> 1) Log in Form (post method) PAGE 1
> 2) Log in Form Processing (FMFind) PAGE 2
> 3) Display Edit Form  (Post method) PAGE 2
> 4) Edit From Processing (FMEdit) PAGE 3
>
> First issue I see in your code is an attempt to use $_GET to process  
> the
> login. Shoudn't it be $_POST?
>
> Next, the Edit code below belongs on the last page. Page 2 is for  
> doing the
> query and then displaying the result to edit in a form.
>
> Also, here needs to addl code at the top of Page 2 to handle  
> unsuccesfull
> logins.
>
> Finally, Aas Alex states, you HAVE To have the -recid to edit the  
> record.
> You get that from the result of the query.
>
> Hope that helps.
>
> jonathan
>
>
> At 8:54 PM -0500 5/27/08, CSInfo wrote:
>> I am creating a very basic site to login by email and password, then
>> edit or display the users info from their FM record. I am having a
>> rough time getting the edit portion to work.I know the connection is
>> valid, the display.php works fine. Below is my code for the edit.php
>> page. Anybody care to debug? Sometime a second set of eyes help.
>> I can send the details.php if needed.
>> Thanks,
>> John Funk
>>
>>
>> <?php
>> include_once('FX/FX.php');
>> $Bride_Email=$_GET['Bride_Email']; // from the index page
>> $Bride_Password=$_GET['Bride_Password'];
>>
>> //$Bride_Email='username'; //hard coded for testing as stand alone
>> //$Bride_Password='pass'; //hard coded for testing as stand alone
>>
>> $groupSize='1';
>> $edit_account=new FX('64.62.67.186','80','FMPro7'); //this ip is only
>> open to the website $edit_account->SetDBData('BG_Clients.fp7','BGDB
>> Export',$groupSize); $edit_account->SetDBPassword('iona','Admin');
>> $edit_account->AddDBParam( Bride_Email, $Bride_Email);
>> $edit_account->AddDBParam( Bride_Password, $Bride_Password);
>> $edit_accountResult=$edit_account->FMEdit();
>>
>> foreach($edit_accountResult['data'] as $key=>$edit_accountData);
>>
>> ?>
>> <html>
>> <head>
>>
>> </head>
>> <body>
>> <table>
>> <tr>
>> <td>Bride_Email</td></tr>
>> <tr><td><?php echo $edit_accountData['Bride_Last_Name'][0];
>> ?></td></tr> </table> <form name="edit" method="post"
>> action="details.php">
>>  <table>
>>    <tr>
>>      <th>Bride_Email</th>
>>      <td> <input type="text" name="Bride_Last_Name" value= <?php echo
>> $edit_accountData['Bride_Last_Name'][0]; ?> /> </td>
>>    </tr>
>>    <tr>
>>      <th>&nbsp;</th>
>>      <td> <input type="submit" name="edit_submit" value="Submit" />  
>> </td>
>>    </tr>
>>  </table>
>> </form>
>> <br>
>> </body>
>> </html>
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
> --
> Jonathan Schwartz
> Exit 445 Group
> jonathan at exit445.com
> http://www.exit445.com
> 415-381-1852
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
> _______________________________________________
> 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