Slow script
Posted: Mon May 27, 2002 4:57 am
Hiya, I've written this script to check the spelling of text sent from a form as $texttocheck. It runs really slowly, taking about a quarter of a second to check each word. Can anyone spot anything slowing this down badly, or suggest any ways I could change it to make it faster? Apologies in advance for the incompetent coding....
Code: Select all
while (preg_match("/ /",$texttocheck)) {
$texttocheck=str_replace(" "," ",$texttocheck);
}
while (preg_match("/\n/",$texttocheck)) {
$texttocheck=str_replace("\n"," <br> ",$texttocheck);
}
$words_array=explode(" ",$texttocheck);
$wordnumber="0";
$link=@mysql_connect("localhost", "******", "*******");
@mysql_select_db("*******");
while ($words_arrayї$wordnumber]!="") {
$word=$words_arrayї$wordnumber];
if ($word=="<br>") {
echo " <br> ";
$wordnumber++;
continue;
}
if (preg_match("/-/",$word)) {
$words=explode("-",$word);
$number=0;
while ($wordsї$number]!="") {
$wordtocheck=eregi_replace("ї^a-z]","",$wordsї$number]);
$fromdb=@mysql_query("SELECT id FROM language WHERE word='$wordtocheck'");
$number2=@mysql_num_rows($fromdb);
if ($number2=="0") {
echo "<input type="text" size="8" STYLE="background:#ffffff; color:#000000; border-width:1px; border-color:#cc0000; border-style:ridge" value="$wordsї$number]" align="absmiddle">";
} else {
echo "$wordsї$number]";
}
$number++;
if ($wordsї$number]!="") { echo "-"; }
}
echo " ";
} else {
$wordtocheck=eregi_replace("ї^a-z]","",$word);
$fromdb=@mysql_query("SELECT id FROM language WHERE word='$wordtocheck'");
$number=@mysql_num_rows($fromdb);
if ($number=="0") {
echo "<input type="text" size="8" STYLE="background:#ffffff; color:#000000; border-width:1px; border-color:#cc0000; border-style:ridge" value="$word" align="absmiddle"> ";
} else {
echo "$word ";
}
}
$wordnumber++;
}
@mysql_close($link);