Using where codition in foreach loop in php

Question

Hey guys i had an idea yesterday. Can you help me with this. Here is the code

foreach($categoriesDetail as $categories)
{
    foreach($subCategoriesDetail as $subCategories)
    {
        if($categories->id == $subCategories->cat_id)
        {
            foreach($teamsDetail as $team)
            {
                if($subCategories->id == $team->sub_cat_id)
                {
                    echo $team->name;
                }
            }
        }
    }
}

The will will run and produce the correcr result but i want extra iteratinos not to run. In other words

foreach($categoriesDetail as $categories)
{
    foreach($subCategoriesDetail as $subCategories where $categories->id == $subCategories->cat_id)
    {
        foreach($teamsDetail as $team where $subCategories->id == $team->sub_cat_id)
        {
            echo $team->name;
        }
    }
}

I know this is not possible in php or any other language but i want an alternative or may be in future they may add this to increase performance.

Need to reduce iterations to increase performance.

Muhammad Raheel
– Muhammad Raheel

2012-03-22 12:01:19 +00:00
Commented Mar 22, 2012 at 12:01 — Muhammad Raheel
– Muhammad Raheel, Commented Mar 22, 2012 at 12:01

Michael · Accepted Answer · 2012-03-22 06:05:17Z

1

You could change the way the arrays are structured so it's in the form:

$subCategoriesDetail[$cat_id] = array();

$teamsDetail[$sub_cat_id] = array();

Then you would use:

foreach($categoriesDetail as $categories)
{
    foreach($subCategoriesDetail[$categories->id] as $subCategories)
    {
        foreach($teamsDetail[$subCategories->id] as $team)
        {
            echo $team->name;
        }
    }
}

answered Mar 22, 2012 at 6:05

Michael

12.9k6 gold badges57 silver badges69 bronze badges

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

Comments

martinstoeckli · Accepted Answer · 2012-03-22 07:56:11Z

1

This would be only syntactic sugar, PHP would have to do exactly the same as you did with the if, it can't do some magic.

Some like such language features, others don't, i myself am reluctant because i think the more features a language has to do the same thing, the more difficult it is to learn the language.

answered Mar 22, 2012 at 7:56

martinstoeckli

24.2k7 gold badges63 silver badges92 bronze badges

1 Comment

Kamall A Joshi Over a year ago

+1 for "i think the more features a language has to do the same thing, the more difficult it is to learn the language."

Somnath Muluk · Accepted Answer · 2012-03-22 07:11:17Z

0

If you want do this by php then you have to wait for unrealistic time.

You can do this by sql joins. Take inner joins of tables and get result. It is possible through queries. That's why joins are made to increase performance. You can write your code if you fails to make join of them. We will definitely try to increase performance of your system.

answered Mar 22, 2012 at 7:11

Somnath Muluk

58.3k39 gold badges225 silver badges230 bronze badges

Collectives™ on Stack Overflow

Using where codition in foreach loop in php

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related