[FX.php List] Re: Re: Mysterious asterisks appearing in fields

[Chris Bisgard]

I wondered the same thing, but I turned off 'magic quotes' in php.ini,
and now they're not appearing. 

In my case, I have to have visually 'clean' data in FMP, as I have users
here who use the FMP client to view and report data entered by visitors
to the website. So, leaving the slashes in the data would be a problem
for those folks.

Chris


> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org 
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of 
> Dale Bengston
> Sent: Wednesday, March 14, 2007 12:45 PM
> To: adenman at tmea.org; FX.php Discussion List
> Subject: Re: [FX.php List] Re: Re: Mysterious asterisks 
> appearing in fields
> 
> Is this true? I have never changed the magic quotes settings in php.  
> Coming from publishing, I understand magic quotes to be the 
> curly quotes used in typesetting.
> 
> I do not get \\' in my FMP database unless I fail to strip 
> slashes for data coming *out* of FMP which is going to be 
> returned to the db.  
> For example:
> 
> User creates new record, enters the name Digital O'Clock Data 
> is stored in FMP as Digital O\'Clock User edits record, 
> stripslashes() is applied to show Digital O'Clock in the text input.
> Data is stored in FMP as Digital O'Clock
> 
> Dale
> 
> 
> On Mar 14, 2007, at 2:26 PM, Andrew Denman wrote:
> 
> > Addendum: if you control your PHP install, you could also 
> turn 'magic 
> > quotes' off in php.ini.
> >
> > 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 Andrew 
> > Denman
> > Sent: Wednesday, March 14, 2007 2:25 PM
> > To: 'FX.php Discussion List'
> > Subject: RE: [FX.php List] Re: Re: Mysterious asterisks 
> appearing in 
> > fields
> >
> > The default PHP install has the 'magic quotes' setting turned on (in
> > php.ini), which will automatically escape ", ', and \ characters.   
> > Since
> > Filemaker doesn't require these fields to be escaped to 
> write to the 
> > database, you will get \", \' and \\ written to your 
> database unless 
> > you use stripslashes().
> >
> > http://us3.php.net/manual/en/function.stripslashes.php
> >
> > 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 Chris 
> > Bisgard
> > Sent: Wednesday, March 14, 2007 2:17 PM
> > To: FX.php Discussion List
> > Subject: RE: [FX.php List] Re: Re: Mysterious asterisks 
> appearing in 
> > fields
> >
> > Dale,
> >
> > I understand that code coming BACK from FMP gets the quotes 
> escaped, I 
> > just don't quite get why the data going INTO FMP is getting escaped 
> > quotes. This means, if I understand you correctly, that I need to 
> > enclose all strings of data going from the web INTO my FMP 
> databases 
> > in stripslashes(), like this:
> >
> >   $q->AddDBParam( 'OrgName', stripslashes($OrgName) );
> >
> > Is that correct? This is the first I've heard this, but I am new to 
> > using FX.php to enter data (been using it only to search 
> and display 
> > before this).
> >
> > Chris
> >
> >> -----Original Message-----
> >> From: fx.php_list-bounces at mail.iviking.org
> >> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Dale 
> >> Bengston
> >> Sent: Wednesday, March 14, 2007 12:11 PM
> >> To: FX.php Discussion List
> >> Subject: Re: [FX.php List] Re: Re: Mysterious asterisks 
> appearing in 
> >> fields
> >>
> >> Chris,
> >>
> >> Yes, that is expected. It's actually a good thing, because 
> un-escaped 
> >> single and double quotes could cause havoc with your code 
> coming back 
> >> in from FMP.
> >>
> >> My two best friends for formatting strings from FMP are 
> stripslashes
> >> () and nl2br(). Often used in conjunction!
> >>
> >> Dale
> >>
> >> On Mar 14, 2007, at 2:02 PM, Chris Bisgard wrote:
> >>
> >>> Dale, just to be clear, the slashes are also appearing in the 
> >>> FileMaker database, not just when displaying data back to
> >> the web. Is
> >>> that expected?
> >>>
> >>> Chris
> >>>
> >>>> Darn, that's expected behavior, and not a clue to the asterisks.
> >>>> You'll need to use stripslashes() to address display of 
> such data 
> >>>> back to the web.
> >>>>
> >>>> http://us2.php.net/manual/en/function.stripslashes.php
> >>>>
> >>>> Dale
> >>>>
> >>>> On Mar 12, 2007, at 8:39 PM, Chris Bisgard wrote:
> >>>>
> >>>>> A possible clue... if I enter single or double quotes 
> in a field,
> >>> each
> >>>>> one ends up with a backslash in front of it in the data.
> >> Looks like
> >>> an
> >>>>> escape character. Page encoding to blame?
> >>>>>
> >>>>> Chris
> >>>
> >>>
> >>>
> >>> _______________________________________________
> >>> 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
> 
>