mysql - PHP - List pulled from one field exploding commas

Solution:

Here's explode:

$activities = explode(',', $activities);  
Copy code

Filter to trim the values of the array (so there's no whitespace on them) using array_map:

$activities = array_map('trim', $activities);
Copy code

Then glue it back up with implode:

$activities = '<li>' . implode('</li><li>' . $activities) . '</li>';
Copy code

Put it all together, with a bit of defensive programming:

$activities = explode(',', $activities);
if ( $activities ) {
    $activities = array_map('trim', $activities);
    $activities = '<li>' . implode('</li><li>' . $activities) . '</li>';
}
Copy code

Solution:

You could use :

$skills = "Cycling, Driving, Running";
echo '<ul><li>' . str_replace(", ", "</li><li>", $skills) . '</li></ul>';
Copy code

This can be achieved withexplode (php documentation).

$activities = 'Cycling, Driving, Running';
$exploded = explode(', ', $activities);
foreach ($exploded as $activity) {
    echo '<li>' . $activity . '</li>';
}
Copy code

Solution:

$list = "Cycling, Driving, Running";
$elements = explode(", ",$list);

echo "<ul>";
foreach($elements as $element){
    echo "<li>$element</li>";
}
echo "</ul>";
Copy code

Solution:

I've got it working now! :)

Thanks to who contributed.

Code I used:

<ul >
  <?php
  $activities_q = "SELECT skills FROM users WHERE uid='".$row['uid']."'";
  $activities = $row['skills'];
  $exploded = explode(',', $activities);
  foreach ($exploded as $activity) {
    echo '<li >' . $activity . '</li>';
  }
?>
</ul>
Copy code