[FX.php List] Spaces in Field Names...one more time with gusto

Jonathan Schwartz jschwartz at exit445.com
Tue Dec 9 10:53:05 MST 2008


Now how do I fix my problem?

The previous suggestions were to use str_replace, but there are a 
variety of places to do this, and I'm running out of combinations.

In the form?
In the fx.php AddDBParam?

Plus...what characters am I replacing with what?

For reference, the application here is my super duper search page 
engine that serves multiple db's and web sites simultaneously.  I 
need to get this right so that it works for everyone because I can no 
longer skirt the issue by requiring fieldnames with no spaces.

I'm not giving up until I crack this thing.


At 6:40 PM +0100 12/9/08, Gjermund Gusland Thorsen wrote:
>&20 is ascii value of the space character
>+ is urlencoding of the space character
>2008/12/9 Jonathan Schwartz <jschwartz at exit445.com>:
>>  Hi Folks,
>>  I still haven't 100% licked the spaces-in-field-names issue yet.  Now I
>>  realize why, and I'm just looking for a sanity check.
>>  It appears that spaces in file names produces different behavior depending
>>  whether the FMP query is a FIND parameter versus a SORT parameter.
>>  It boils down to this:
>>  FMP Field Definition:           Alpha Beta
>>  Alpha Beta Field Value: John Smith
>>  Browser POST:           Alpha_Beta (Apache Server replaces space with
>>  underline)
>>  FMP FIND URL:           Alpha+Beta (FX (?) replaces space with "+" in URL)
>>  FMP SORT FIELD URL:     Alpha%20Beta  (FX (?) replaces space with "%20" in
>>  URL)
>>  Here's an actual URL that shows the existence of both methods in the same
>>  URL:
>>  So...
>>  The html form displays the field name with the space.
>>  Apache POST  replaces the space with an underline.
>>  FX/PHP replaces the space in a FIELD NAMEwith a "+"
>>  FX/PHP replaces the space in a SORT NAMEwith a "%20"
>>  Argh.
>>  If this is correct, then a single remedy won't work.  A different remedy has
>>  to be applied to SEARCH fields versus SORT fields.
>>  I did get suggestions last time I posted this problem, but each time I
>>  applied the remedy, it broke the other half. Now I see why.
>>  Before I move forward....any comments?
>>  J
>>  --
>>  Jonathan Schwartz
>>  Exit 445 Group
>>  jonathan at exit445.com
>>  http://www.exit445.com
>>  415-370-5011
>>  _______________________________________________
>>  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

Jonathan Schwartz
Exit 445 Group
jonathan at exit445.com

More information about the FX.php_List mailing list