<div>
Here is what I'm currently doing<br />
<br />
$thriceText = $_POST['thriceText'];<br />
$sql = 'SELECT * FROM translate ORDER BY fromText';<br />
$result = mysql_query($sql) or die(mysql_error());<br />
while ($row = mysql_fetch_assoc($result)<wbr />)<br />
{<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$thriceText = str_replace(' ' . $row['fromText'] . ' ', ' ' . $row['toText'] . ' ', $thriceText);<br />
}
</div>


<div>
TeRReF your solution almost works but throws a preg error.
</div>


<div>
<div class="content wysiwyg-content">
I have a table that contains a fromText and a toText so that I can &quot;translate&quot; some words submitted in a textarea. I was doing a select on the translate table and in the while I was running a str_replace on the textarea variable $sampleText and replacing phrases. Now, I ran into a few problems. Some of the text that needs to be replaced can be small - for example ur changed to your. However, it would also change four to foyour. So I changed the str_replace to add a space before and after the fromText and that would mostly work unless it followed a newline or was surrouned in quotes.<br />
<br />
So I'm wondering what the best way to handle this is...
</div>
</div>


I have a table that contains a fromText and a toText so that I can "translate" some words submitted in a textarea. I was doing a select on the translate table and in the while I was running a str_replace on the textarea variable $sampleText and replacing phrases. Now, I ran into a few problems. Some of the text that needs to be replaced can be small - for example ur changed to your. However, it would also change four to foyour. So I changed the str_replace to add a space before and after the fromText and that would mostly work unless it followed a newline or was surrouned in quotes.

So I'm wondering what the best way to handle this is...

Here is what I&#39;m currently doing

$thriceText = $_POST[&#39;thriceText&#39;];
$sql = &#39;SELECT * FROM translate ORDER BY fromText&#39;;
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	$thriceText = str_replace(&#39; &#39; . $row[&#39;fromText&#39;] . &#39; &#39;, &#39; &#39; . $row[&#39;toText&#39;] . &#39; &#39;, $thriceText);
}

TeRReF your solution almost works but throws a preg error.

Replacing text in a large string

I have a table that contains a fromText and a toText so that I can &quot;translate&quot; some words submitted in a textarea. I was doing a select on the translate table and in the while I was running a str_replace on the textarea variable $sampleText and replacing phrases. Now, I ran into a few problems. Some of the text that needs to be replaced can be small - for example ur changed to your. However, it would also change four to foyour. So I changed the str_replace to add a space before and after the fromText and that would mostly work unless it followed a newline or was surrouned in quotes.

So I&#39;m wondering what the best way to handle this is...

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.