DaniWeb Forum Index > Web Development > PHP

Add links to CSV

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2008

Posts: 2

Reputation: IceKnuckle45 is an unknown quantity at this point

Solved Threads: 0

IceKnuckle45 IceKnuckle45 is offline

Offline

Newbie Poster

Add links to CSV

Dec 28th, 2008

I'm displaying a list of tags on my site which are formatted as CSV for every post.

Example: RFID, robots, decluttering

The CSV tags are stored in the MySQL database as one long string. I would like to make each tag a link that goes to the search page.

Example: search.php?tag=RFID or
search.php?tag=robots

I've found that I can explode the CSV to split it up, then print out the list which basically gives me what I started with. What I'm having problems with is formatting the array to add the links. Also, I would like to get rid of the array formatting [0]=> and place the commas back in between the tags.

My code looks like this:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php print_r(explode(',',$string)); ?>
<?php print_r(explode(',',$string)); ?>

This is my first post, so if you need more info just ask. If there is a better way to proceed please tell.

Thanks.

•

Join Date: Dec 2008

Posts: 2

Reputation: IceKnuckle45 is an unknown quantity at this point

Solved Threads: 0

IceKnuckle45 IceKnuckle45 is offline

Offline

Newbie Poster

Re: Add links to CSV

Dec 30th, 2008

While browsing the implode manual on php.net I modified the following function.

http://us2.php.net/manual/en/function.implode.php#83464

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
function myImplode($before, $after, $glue, $array){
    $nbItem = count($array);
    $i = 1;
    foreach($array as $item){
        if($i < $nbItem){
            $output .= "$before$item$after$glue";
        }else $output .= "$before$item$after";
        $i++;
    }
    return $output;
}
 
$an_array = explode(', ',$stringofCSV);
print myImplode("<a href=\"search.php?tag=\">","</a>",", ", $an_array);
?>
<?php
function myImplode($before, $after, $glue, $array){
    $nbItem = count($array);
    $i = 1;
    foreach($array as $item){
        if($i < $nbItem){
            $output .= "$before$item$after$glue";
        }else $output .= "$before$item$after";
        $i++;
    }
    return $output;
}

$an_array = explode(', ',$stringofCSV);
print myImplode("<a href=\"search.php?tag=\">","</a>",", ", $an_array);
?>

So basically I exploded my CSV so I could implode them into links. Now I'm stuck on the link portion. I would like the search variable to equal the array item so the link will be: search.php?tag=$arrayItem

Any help would be appreciated. Thanks.