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
RE: [PHP-DB] updating a column based on info from another coluimn? Desperate!
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
RE: [PHP-DB] updating a column based on info from another coluimn ? Desperate!
Sorry, I'm only reading half posts today. :) If you want to turn your + into - you'll probably have to go through one more step and do a preg_replace(). Like $new_url = preg_replace(+,-,$url); I think that'll work. Again, shooting from the hip and not testing. Yeah, baby, livin' on the wild side! Anyway, check out this page for additional info if you need it: http://us4.php.net/manual/en/function.preg-replace.php -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 4:03 PM To: 'Aaron Wolski'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] updating a column based on info from another coluimn ? Desperate! 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php