count and select all words in a php file

[Scurvy]

Hi all,
I need some help with a new project.
I have several php pages that I want to perform a search and replace on. Essentially, I want to scan the page for all the words in it. Then compare that list to a list in my db and replace the matching words in the php page with links.
I know how to do it with a text file to get each line but I can't figure out how to get just the words alone.

I tried making the whole output of the page into a variable like:

$text_area = "
page text goes here";

$words = explode(" ", $text_area);
echo $words[0];
echo $words[1];
etc. but it only shows the first word which is the title of the page and it has a lot of trouble parsing the html code.
Any ideas?

[LordShryku]

Look at [man]str_word_count[/man]. Works great with regular files, but php code doesn't really contain a lot of regular words...

[planetsim]

Ok try this

$contents = file("thefilefor_reading");
$updateCode=implode("\n",$contents);
$update=preg_replace('#<([^>]|\n)*>#is', '',$update);

$update=explode(" ",$update);
//now you have only words that are outside the tags

[Scurvy]

That worked well. Now I just have to figure out how to compare the list with the list in the db.
I'll work on that for a while 🙂
Thanks folks,
Jeff

[Scurvy]

All right I need a hint 🙂
What do I use in the select query to match the listed words to the ones in the db?

<?
// Display the words in the file
// This part works except it shows unacceptable words (like tags) as a blank line
$contents = file("itinerary7.php"); 
$updateCode=implode("\n",$contents); 
$update=preg_replace('#<([^>]|\n)*>#is', '',$updateCode); 
$update=explode(" ",$update); 

// Loop through the array, show word number and words.
foreach ($update as $word_num => $word) {
echo "Word #<b>{$word_num}</b> : " . $word . "<br />\n";
}
echo "<hr>";


// End of display and working part


// Query the db for matching words
// This part doesn't work yet

// If the next line is uncommented then we get working results.
// The problem I have is I don't know what to use in the query for '$word'.
$word = "Yellowstone";

mysql_select_db("yellowstone");
$words_qry = "SELECT * FROM words WHERE word = '$word'";
$words_result = mysql_query($words_qry);
$num_results = mysql_num_rows($words_result);
if ($num_results == 0)
{
	echo "Sorry, no matches.<br>";
//	exit;
}
// Start Output


echo "<p>Number of words found: ".$num_results."<br>";
for ($i=0; $i <$num_results; $i++)
{
$link = str_replace($word, mysql_result($words_result,$i,"link"), $word);
echo "".($i+1).". ";
echo $link;
echo "<br>";
}
echo "<hr>";
?>

If I comment out the $word = "Yellowstone"; line then I get a reply of Sorry, no matches. If I uncomment it then the querry works fine but only for that word.
Thanks again,
Jeff