PHP & MySQL how to display data question

Question

I want to be able to display my posts tags array [0] => grill [1] => meat [2] => hot-dogs with a comma separating each tag and was wondering how can I do this using PHP?

Stored in the database.

$page_tags = Array ( [0] => grill [1] => meat [2] => hot-dogs )

Desired output.

grill, meat, hot-dogs

Here is the PHP & MySQL code.

$page_tags = array();
$dbc = mysqli_query($mysqli,"SELECT tags.*, posts_tags.* 
                             FROM tags 
                             INNER JOIN posts_tags ON tags.id = posts_tags.tag_id
                             WHERE posts_tags.post_id= '" . $pageID . "'
                             AND posts_tags.user_id = '" . $userID . "'
                             GROUP BY tags.tag");

if (!$dbc) {
    print mysqli_error($mysqli);
} else {
    while($row = mysqli_fetch_array($dbc)){
        $page_tags[] = $row['tag'];
    }
}

Pekka · Accepted Answer · 2010-09-01 10:30:06Z

2

Seeing as you have an array $page_tags, you can use implode() to output it separated by commas:

echo implode(", ", $page_tags);

answered Sep 1, 2010 at 10:30

Pekka

451k150 gold badges990 silver badges1.1k bronze badges

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

4 Comments

fredley Over a year ago

<pedantry> echo implode(", ", $page_tags); </pedantry>

askIT Over a year ago

@fredley excuse my ignorance what is <pedantry>?

Pekka Over a year ago

@askIT yes. @fredley is referring to his suggesting a minor change (the additional space after the comma)

fredley Over a year ago

@askIT it's worth looking into similar tags, <irony> and <sarcasm> in particular, they can be very useful.

Collectives™ on Stack Overflow

PHP & MySQL how to display data question

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related