$db_name = '';
$db_user = '';
$db_pass = '';
$table_prefix = '';
$nconnection = mysql_connect("localhost:3306", $db_user, $db_pass );
mysql_select_db($db_name, $nconnection);
$query = 'SELECT post_content FROM '.$table_prefix.'posts WHERE post_type ="post"';
$record=mysql_query($query);
$wipeout = array (0=>'"',',','.');
while ( $row = mysql_fetch_array($record, MYSQL_NUM)) {
$post = strtolower(strip_tags(trim($row[0])));
$post = str_replace($wipeout,'',$post);
$words = explode (' ',$post);
foreach ($words as $word) {
$wordslist[$word]++;
$total++;
}
}
arsort($wordslist);
echo 'Total :',$total,'
';
foreach ($wordslist as $key => $val) {
echo "$key = $val
";
}
?>