MySQL’s REPLACE() Is PHP’s STR_REPLACE()
The PHP function that I use the most could be str_replace(). If you aren't familiar with the function, here's what it does:
$string = 'Hello_My_Friend';
$result = str_replace('_', '-', $string); //becomes Hello-My-Friend
Over the past months, I've grown to realize that I oftentimes use the function as a quick fix. I've been using MySQL's version of str_replace() a lot lately in an effort to cleanse the sins of my programming past. Here's a basic usage of MySQL's REPLACE function:
UPDATE website_content_pages SET content = REPLACE(content, 'b>', 'strong>');
The above code changes all
</B> tags to
</STRONG> tags. Using MySQL's function allows me to fix the problem once instead of "re-fixing" it every time the page loads.
My team mate Edna Piranha is not only an awesome hacker; she's also a fantastic philosopher! Communication and online interactions is a subject that has kept her mind busy for a long time, and it has also resulted in a bunch of interesting experimental projects...
We've all inherited rubbish websites from webmasters that couldn't master valid HTML. You know the horrid markup: paragraph tags with align attributes and body tags with background attributes. It's almost a sin what they do. That's where dwMarkupMarine comes in.