This note from http://us4.php.net/manual/en/function.rawurldecode.php might
explain what you're seeing if you're using urldecode()
"Note: rawurldecode() does not decode plus symbols ('+') into spaces.
urldecode() does. "
If you start out with $url = "The+Man+On+The+Moon" and you urldecode($url)
then you should, predictably, end up with The Man On The Moon.
If plus signs are a problem, you may need to implement a little bit of code
just to check the string for + then use either urldecode() or rawurldecode()
to get the output you want. Something like:
$position = stripos($urlFromDB, "+");
if($position === FALSE){
rawurldecode($url);
}
else(
urldecode($url);
}
or something along those lines. I'm just shooting from the hip here.
stripos() returns a boolean false so be careful there. Not sure if my if()
statement is right.
> -----Original Message-----
> From: Aaron Wolski [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 31, 2003 3:49 PM
> To: 'Hutchins, Richard'; [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] updating a column based on info from another
> coluimn? Desperate!
>
>
> Hey hey,
>
> Works like a charm. I have have my urls looking like
> The+Man+on+The+Moon
>
> Seems weird, however, PHP automatically strips out the +'s?
> cause when I
> echo the variable I get The Man On The Moon.
>
> Idea's?
>
>
> Also.. ANYWAY to make the +'s into -'s (hyphens)???
>
> Thanks!!
>
> Aaron
>
> -----Original Message-----
> From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
> Sent: July 31, 2003 3:21 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] updating a column based on info from another
> coluimn? Desperate!
>
> Will urldecode() work for you on the PHP side or do you have
> to convert
> everything in the database?
>
> http://us4.php.net/manual/en/function.urldecode.php
>
> > -----Original Message-----
> > From: Aaron Wolski [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, July 31, 2003 3:14 PM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-DB] updating a column based on info from
> > another coluimn?
> > Desperate!
> >
> >
> > Hi All,
> >
> > This is OT but I am in need of serious help.
> >
> > I am rewriting URL's for a site and came across an issue with
> > spaces in
> > URLS having %20 applied to them. I can't seem to find a
> solution with
> > mod_rewrite to get rid of the %20 and replace with -
> (hyphen) so I am
> > hoping someone can help me here with an MySQL solution.
> >
> > I have over 4000 records in a table. I've added a new column in that
> > table called newUrl
> >
> > Is it possible with a QUERY to take from the 'designers' column and
> > write into the 'newUrl' column and replace spaces with - at the same
> > time?
> >
> > I'm probably talking out my a$$ here but I am a little
> desperate for a
> > solutions.
> >
> > Thanks in advance and again my apologies for the OT message.
> >
> > Aaron
> >
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
