mysql php implode row for links?

Question

Not sure if there a way of doing this, but I can insert multiple categories into MYSQL, using :

GetSQLValueString(implode($_POST['r_category'],", "), "text"),

So then when I echo:

<?php echo $row_Recordset1['r_category']; ?>

It is fine, like this: Cat 1, Cat 2, Cat 3

I am trying to find a way to link each category for easy navigation purposes!!

Like this:

<a href="/page/results.php?r_category=<?php echo $row_Recordset1['r_category']; ?>"><?php echo $row_Recordset1['r_category']; ?></a>

This works great for One Cat, but if I have multiple Cats, then it is one big link.... not what I want.

I need to use implode or explode, but not sure how ? Thanks in advance!!!

This is what I would love:

Cat 1, Cat 2, Cat 3 (these are all separated links pulling from one row!)

two13 · Accepted Answer · 2011-06-13 20:30:41Z

2

If $row_Recordset1['r_category'] is the string "Cat 1, Cat 2, Cat 3", then you can explode that into an array like this:

$arr = explode(",", $row_Recordset1['r_category']);

then step through your array to create the links:

$links = array();
foreach ($arr as $value)
{
    $links[] = "<a href='/page/results.php?r_category=". trim($value) ."'>". trim($value) ."</a>";
}
$links_str = implode(", ", $links);
echo $links_str;

edited Jun 13, 2011 at 20:30

answered Jun 13, 2011 at 20:04

two13

3451 gold badge3 silver badges11 bronze badges

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

3 Comments

eberswine Over a year ago

hmm.. great let me try. Does this work if i just have one Cat in the string, like Cat 1 only.. ?

eberswine Over a year ago

EXCELLENT!! It worked, but now I am having problems echoing the result with a comma. If there is just one Cat, then their shouldn't be any comma, but if multiple, like Cat 1 and Cat 2, then there should be a comma separating them?? 'echo "<a href='/page/results.php?r_category=". trim($value) ."'>". trim($value) ."</a>, ";'

two13 Over a year ago

@eberswine see my edit for how to handle that properly. We'll store each link in an array and re-implode.

Collectives™ on Stack Overflow

mysql php implode row for links?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related