DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)
-   PHP (http://www.daniweb.com/forums/forum17.html)
-   -   Add links to CSV (http://www.daniweb.com/forums/thread164647.html)

IceKnuckle45 Dec 28th, 2008 7:53 pm
Add links to CSV
 
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:

<?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.

IceKnuckle45 Dec 30th, 2008 7:39 am
Re: Add links to CSV
 
While browsing the implode manual on php.net I modified the following function.

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

<?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.


All times are GMT -4. The time now is 9:28 pm.

Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2009 DaniWeb® LLC