Help with plugin issue and multiple items in parameter…

Hiya,

Hopefully a nice easy one this but I’ve been trying to get the answer all day and have been trying different things in a plugin all day long and nothing is working. I’m not going to attach the plugin code here as I think I’ve probably made a complete hash of it all now and there is simply way too much in there with all the extra lines I’ve been testing with so if I could possibly explain what I’m trying to do and see if someone can show me the error of my ways?

Let’s say I have a plugin called pi.mb_fetch_data.php. Let’s now say that I want to have three functions within that plugin called all_data, single_data and multiple_data so I would get three different plugin calls as per the following :

{exp:mb_fetch_data:all_data}

{/exp:mb_fetch_data:all_data}


{exp:mb_fetch_data:single_data group="1"}

{/exp:mb_fetch_data:single_data}


{exp:mb_fetch_data:multiple_data groups="1|2|3"}
Data ID - {data_id}

Data Name - {data_name}

Data Count - {data_count}

Count = {count}

{/exp:mb_fetch_data:multiple_data}

Above you can see that on the two plugin calls that need a parameter I have a group or groups parameter. The problem I’m having is with the multiple_groups plugin function (although I haven’t yet come to the all_data function yet 😉 I’m hoping that I won’t have a problem with that one though).

What I need to do here is to take each of the numbers in the parameter and then run a SQL query to see if any results are there for that ID. If there are then I want to replace each of the {data_id}, {data_name} and {data_count} ({data_count} is the amount of results returned each time) variables with some results from the SQL query.

This will loop for as many ID’s as there are in the plugin parameter.

The way I went about trying to do this was to first take the groups=”“ parameter values out and explode them on the | character so that I would end up with an array of values :

<?php

    // START
    class Mb_fetch_data
    {
    var $return_data = '';

        // Multiple Groups - START
        function multiple_groups()
        {
            global $TMPL, $DB, $FNS;
            $tagdata = $TMPL->tagdata;
            $groups = $TMPL->fetch_param('groups');
            $groups = explode("|", $groups);
            
            foreach($groups as $item)
            {
                $results = $DB->query("MY SELECT QUERY GOES HERE
                                        WHERE SOMETHING = '$item'");

                if ($results->num_rows == 0)
                {
                    $this->return_data .= $TMPL->no_results();
                }
                else
                {
                    $tagdata = $TMPL->swap_var_single('mb_group_count', $results->num_rows, $tagdata);
                    $tagdata = $TMPL->swap_var_single('mb_group_title', $results->row['mb_group_title'], $tagdata);
                    $tagdata = $TMPL->swap_var_single('mb_group_id', $results->row['mb_group_id'], $tagdata);
                }

                $this->return_data = $tagdata;
            }
                return $this->return_data;
        }


}
?>

Please note that the code above won’t work as a plugin as I’ve obviously taken a few things out of it, mostly the SQL query and a few other pertinent details but the actual lay of the code is the same so I’m thinking either my foreach code or perhaps the way I’m outputting the variables is somehow wrong?

When I run this code in a template though I only get the one set of results returned as though it’s not looping through all the IDs that were set in the plugin parameter.

I know that this is probably something really really silly that I’m doing here and so if anyone can see the error of my ways and and push me in the right direction then I’d much appreciate it, thanks.

Best wishes,

Mark