Generate x number of html elements based on PHP/MySQL

Question

For every comma inside a certain MYSQL row,

I want to create x html elements, where x = number of commas inside a row.

So for example, if my mysql row looks like this:

dance, singing, drawing, acting,

That is 4 commas.

I want to create a html box (using a div) for every comma, and inside that box, show the hobby..

So like on the main.php page, show :

[ dance ]

[ singing ]

[ drawing ]

[ acting ]

How does one go about creating a certain number of html elements based on a certain number of commas in a mysql table, assuming that I will add more hobbies to the table?

BTW, I am using php as the server side languange.

Any help would be appreciated, thank you.

msigman · Accepted Answer · 2012-04-08 01:14:47Z

1

This is untested, so consider it psuedo-code. You may need to escape the square brackets. The other issue you could encounter is that there could be an empty div output at the very end. In that case, just check that $elem != ''.

$elements = explode(',', $mysql_data_column);
foreach($elements as $elem)
{
   echo "<div style=\"block\">[$elem]</div>";
}

answered Apr 8, 2012 at 1:14

msigman

4,5343 gold badges23 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

Generate x number of html elements based on PHP/MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related