[FX.php List] Basic help

Andrew Denman adenman at tmea.org
Wed May 28 12:56:25 MDT 2008 

Putting the email in double quotes should solve the wildcard issue without
having to use preg.  This does a field content match (==) on the literal
text ("").

$query->AddDBParam('email','=="'.$email.'"');

Andrew Denman


-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Troy Meyers
Sent: Wednesday, May 28, 2008 11:10 AM
To: FX.php Discussion List
Subject: Re: [FX.php List] Basic help

John,

If I recall correctly, you ought to use this:

$query->AddDBParam('email','=='.preg_replace('/([@*#?!=<>"])/','\\\${1}',$em
ail));

...in order to prevent people from using FileMaker search wild cards or
symbols, either on purpose or by accident.

-Troy


> 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>&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 >> >
> _______________________________________________ > 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