Pull all words from 'title' and put it in an array

curb

How am I able to put all the words I pulled out from a query and turn it into an array like the example below?

$result = mysql_query("SELECT `title` FROM `books`");
while($row = mysql_fetch_array($result)){
$words = ''.$row_tag['title'].' ';
$words= explode(" ",$words);
/*
Array
(
    [0] => the
    [1] => jumping
    [2] => frogs
    [3] => chapter
)

Array
(
    [0] => wheres
    [1] => waldo
)

Array
(
    [0] => the
    [1] => world
    [2] => chapter
)
*/
}

And I'm trying to put all the words (with duplicates) into a variable like below:

$all_the_words = array(
"the", "jumping", "frogs", "chapter", "wheres", "waldo", "the", "world", "chapter"
);

sid

if i understood you correctly, i think what you want is [man]array_merge/man.

curb

How would I apply array_merge from a 'while'?

sid

can you post your database structure?

curb

id,title,link

I'm trying to create a tagcloud from an example: http://www.lotsofcode.com/php/tutorials/tag-cloud

I want to pull all the titles and explode each word and apply it to:

$randomWords = array(
"webmasterworld", "Computer", "Skateboarding", "PC", "music", "music", "music", "music", "PHP", "C", "XHTML", "eminem", "programming", "forums", "webmasterworld",
"Chill out", "email", "forums", "Computer", "GTA", "css", "mysql", "sql", "css", "mysql", "sql",
"forums", "internet", "class", "object", "method", "music", "music", "music", "music", "gui", "encryption"
);

curb

Is there another function that could do this?

lotsofcode

I think this what you are looking for, you could optionally use array_merge and collect the words or assign them one by one.

<?php

  $cloud = new wordcloud();
  $getBooks = mysql_query('SELECT title FROM books');
  if ($getBooks)
  {
    while ($rowBooks = mysql_fetch_assoc($getBooks))
    {
      $getTags = explode(' ', $rowBooks['title']);
      foreach ($getTags as $key => $value)
      {
      	$value = trim($value);
      	$cloud->addWord($value);
      }
    }
  }

  $myCloud = $cloud->showCloud('array');
  if (is_array($myCloud))
  {
    foreach ($myCloud as $key => $value)
    {
    	 echo ' <a href="tags_url/'.urlencode($value['word']).'" style="font-size: 1.'.($value['range']).'em">'.$value['word'].'</a> &nbsp;';
    }
  }

?>

You should change tags_url to your personal directory.

If you need any assistance with the wordCloud class then please post on my forum and i will be able tohelp you directly, i hope this helps.

Mr. Lots of Code