PHP/MySQL Link Each Word

Question

I have a PHP script that pulls keywords from a MySQL database and I need help with figuring out how to link each word.

An example MySQL entry: cow moo white black

Need to output in link form:

<a href=word.php?word=cow>cow</a> <a href=word.php?word=moo>moo</a>, etc.

Thank you

All the keywords in the 1 MySQL row need to be turned into links upon output. — AZKyleP
– AZKyleP, Commented Oct 17, 2010 at 4:18
Sorry if I didn't answer your question. There is spaces in the MySQL rows. Everything between the spaces needs to be turned into a link. — AZKyleP
– AZKyleP, Commented Oct 17, 2010 at 4:21

Emil Orol · Accepted Answer · 2010-10-17 04:45:58Z

1

Try this:

$output = "";
$mysql_str = "cow moo white black";
$keywords = explode(" ", $mysql_str);

foreach ($keywords as $keyword) {
  $output .= "<a href=\"word.php?word=".$keyword."\">".$keyword."</a> ";
}

echo $output;

edited Oct 17, 2010 at 4:45

answered Oct 17, 2010 at 4:21

Emil Orol

5616 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

AZKyleP Over a year ago

Thank you redhatlab! Goat Master answered it before you so I have to give him the Answer. Sorry but thank you for taking the time to help me.

Emil Orol Over a year ago

No a problem. BTW split is a deprecated function on PHP 5.3, it might become an issue on the future: us.php.net/split Also Goat Master "foreach" loop print out the linked words twice.

AZKyleP Over a year ago

You got the answer. I tried his code first but ran into some issues with it. Your code worked like a charm! Thank you very much! :) If you can edit your post please add an "o" to explde incase someone else finds this post useful.

Maltronic · Accepted Answer · 2010-10-17 04:37:14Z

1

If $row["entry"] is the entry, then as follows:

   $fieldArray = split(" ", $row["entry"]);

    foreach($fieldArray as $item) {
      echo "<a href=\"word.php?word=" . $item . "\">" . $item . "</a>";
    }

edited Oct 17, 2010 at 4:37

answered Oct 17, 2010 at 4:20

Maltronic

1,81211 silver badges21 bronze badges

1 Comment

AZKyleP Over a year ago

Thats it! Thank you Goat Master! :)

Collectives™ on Stack Overflow

PHP/MySQL Link Each Word

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related