substr_count()

seby

Hi.

I am fetching some content (news) from mysql, How do i count the words that I am fetching? i prefer to count words and not letters, so how can i determine this?

These are the variables and queries i am using to display the news,

$result = $db->sql("SELECT * FROM $news WHERE active = '1' $showcat ORDER BY id DESC LIMIT $HTTP_GET_VARS[zg], $z1");
 while($row = mysql_fetch_row($result))
  {

then i am using $readmore[moretext] = $row[12]; to display the text on my page, and i want to use a variable $words to display the amount of words that the column contains. also, is it possible not to count some words that have any <br> <b> etc tags?

thanks for your time.

Weedpacket

I do like the search facility on this site...
counting the words and split text
word limiting
Expand/Contract Text
limiting word output

sarah

If you want to count it by word, you can just explode it on the space and print out the number of words you want...

$fullText="This is the full text that I am going to summarize so that it only prints out part of it, broken up by words.";
//
$allWords=explode(" ",$fullText);
$numberOfWords=5;
//
for($i=0;$i<$numberOfWords;$i++){
	print("$allWords[$i] ");
}

But, you might end up with some summaries that are waaaay longer than others because they have bigger words. I prefer to do it by the number of characters and then break it off at the word...

$fullText="This is the full text that I am going to summarize so that it only prints out part of it, broken up by words.";
//
$chars = 30;
$summary = ereg_replace("^(.{1,$chars})[ .,].*","\\1", $fullText);
//
print("$summary");

seby

That does work at all.. it returns no count.

seby

okay never mind. i made my own word counter, very simple and easier than I thought, and extremely accurate 🙂

sarah

Probably too late now, but for future reference I just figured out what was wrong with the code blurb above. There are supposed to be two backslashes before the 1 in "1"...When I put it inside the PHP code tags, it messed with the slashes... Add the slashes and it will work...

$summary = ereg_replace("^{(.{1,$chars})[} .,].*","\1", $fullText);