[FX.php List] Basic help
Bob Patin
bob at patin.com
Wed May 28 09:48:26 MDT 2008
John,
Here's how I always search for an email; this works flawlessly, and
I've used it on dozens of sites:
If you're searching for an email address, which of course has the @
sign in it, use this;
$email = bob at domain.com;
$query->AddDBParam('email','=='.$email);
The equal signs force a search for an exact match. Also, as GGT said,
using UTF-8 will save you lots of headaches in the future.
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 10:41 AM, CSInfo wrote:
> Oh, I see, @ sign..... how do I declare that field unicode in php?
> John
>
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Gjermund
> Gusland
> Thorsen
> Sent: Wednesday, May 28, 2008 1:17 AM
> To: FX.php Discussion List
> Subject: Re: [FX.php List] Basic help
>
> Make sure you use Unicode for storage option on the email field, it
> will
> save you alot of trouble.
>
> g
> g
> t
>
> 2008/5/28 CSInfo <CSinfo at comcast.net>:
>> All your comments help thanks. I feel I am a dunce though.
>> So page 1, I get, normal HTML form with post data.
>> Page 2 needs to be a fmfind using the post data correct? Do I pass
>> the
>> recid to the next page using hidden form fields?
>> Page 3 an html form filled out with the data from page 2. correct?
>> Page 4 fmedit to send data to fm.
>>
>> I have tried Dreamweaver with FMStudio, FXForge and hand coding only
>> to circle around a few times, maybe I am just confusing myself.
>> Anybody have sample code for these 4 files? I learn better by looking
>> at existing code.
>>
>> Thank you.
>> John
>>
>>
>>
>> -----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> </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
>>
> _______________________________________________
> 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