PHP/MySQL replacing letters in text

freeflow · 07-27-2010, 02:26 PM

Hi everyone. I need some help again with PHP and MySQL.

Here is what I would like to do:

// Example retrieved text from DB = Axxxax xaxx. Cxxax xbxxx. Bxxx ....

$text = All letters in $text have been replaced where A=&nnn; a=&mmm; B=&uuu; etc.

mysql_query("UPDATE Ads1 SET Text ='$text' WHERE ID = '$id' ");

baxter · 07-27-2010, 06:07 PM

looks like you want to use string replace, if your altering every letter in a sentence/text then you would probably want to traverse the string as an array and make the new string like this:

PHP Code:

  $newString = '';

        $string = 'aAb';        

????: NamePros.com http://www.namepros.com/programming/669125-php-mysql-replacing-letters-in-text.html
        

        foreach (str_split($string) as $char)

????: NamePros.com http://www.namepros.com/showthread.php?t=669125
        {            

            switch ($char)

            {

                case 'a':

                    $newString .= '&mmm';

                    break;

                case 'A':

                    $newString .= '&nnn';

                    break;

                case 'b':

                    $newString .= '&uuu';

                    break;

            }

        }

 
        echo $newString;

converting it back from the new string won't be nearly as easy though you would need to add a ending character to each element and the explode off that element and do the reverse mapping.

Cheers,

Jay

freeflow · 07-28-2010, 03:03 PM

Thanks baxter for your reply. I am still having some problems making it work.

Can you help me with this code:

The code below works fine until I change "Hällo World of PHP" to “$text”
with the same text from the DB. when I echo the variable the text appears
without the changed characters. What am I doing wrong?

This works:

$vowels = array("ä");
$onlyconsonants = str_replace($vowels, "ä", "Hällo World of PHP");

This doesn’t work:

$vowels = array("ä");
$onlyconsonants = str_replace($vowels, "ä", “$text”);

musicplace.co.nr · 07-28-2010, 04:28 PM

Originally Posted by freeflow

$vowels = array("ä");
$onlyconsonants = str_replace($vowels, "ä", “$text”);

$text shouldn't be in quotes. It should be like this:
$onlyconsonants = str_replace($vowels, "ä", $text);

If you are just trying to change those funny letters to their html encoded equivalent (e.g. ä to &auml), you could try the htmlentities() php function - PHP: htmlentities - Manual

freeflow · 07-31-2010, 07:00 AM

Originally Posted by musicplace.co.nr

If you are just trying to change those funny letters to their html encoded equivalent (e.g. ä to &auml), you could try the htmlentities() php function - PHP: htmlentities - Manual

Thanks for the advice!

This code does everything I wanted and more.
????: NamePros.com http://www.namepros.com/showthread.php?t=669125
$text=htmlentities($text);

musicplace.co.nr · 07-31-2010, 05:55 PM

No worries. Glad I could help!

07-27-2010, 02:26 PM	THREAD STARTER #1 (permalink)
freeflow NamePros Regular Join Date: Dec 2006 Posts: 236	PHP/MySQL replacing letters in text Hi everyone. I need some help again with PHP and MySQL. Here is what I would like to do: // Example retrieved text from DB = Axxxax xaxx. Cxxax xbxxx. Bxxx .... $text = All letters in $text have been replaced where A=&nnn; a=&mmm; B=&uuu; etc. mysql_query("UPDATE Ads1 SET Text ='$text' WHERE ID = '$id' ");

07-27-2010, 06:07 PM	#2 (permalink)
baxter NamePros Regular Join Date: Apr 2006 Posts: 360	looks like you want to use string replace, if your altering every letter in a sentence/text then you would probably want to traverse the string as an array and make the new string like this: PHP Code: $newString = ''; $string = 'aAb'; ????: NamePros.com http://www.namepros.com/programming/669125-php-mysql-replacing-letters-in-text.html foreach (str_split($string) as $char) ????: NamePros.com http://www.namepros.com/showthread.php?t=669125 { switch ($char) { case 'a': $newString .= '&mmm'; break; case 'A': $newString .= '&nnn'; break; case 'b': $newString .= '&uuu'; break; } } echo $newString; converting it back from the new string won't be nearly as easy though you would need to add a ending character to each element and the explode off that element and do the reverse mapping. Cheers, Jay __________________ Canadian Domain Registrar Ready.ca

07-31-2010, 05:55 PM	#6 (permalink)
musicplace.co.nr Senior Member Join Date: Oct 2007 Location: Sydney, Australia Posts: 1,022 Follow @music_whiz	No worries. Glad I could help! __________________ juegosjuegos Your Hotel in Austria Matratzen Music Database - iTunes Music Chart Archive and Analysis - iTunes App Chart Archive and Analysis - iTunes Book Charts

07-28-2010, 03:03 PM	THREAD STARTER #3 (permalink)
freeflow NamePros Regular Join Date: Dec 2006 Posts: 236	Thanks baxter for your reply. I am still having some problems making it work. Can you help me with this code: The code below works fine until I change "Hällo World of PHP" to “$text” with the same text from the DB. when I echo the variable the text appears without the changed characters. What am I doing wrong? This works: $vowels = array("ä"); $onlyconsonants = str_replace($vowels, "ä", "Hällo World of PHP"); This doesn’t work: $vowels = array("ä"); $onlyconsonants = str_replace($vowels, "ä", “$text”);

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)