multiple query and foreach loop

multiple query and foreach loop - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: multiple query and foreach loop (/showthread.php?tid=60008)

multiple query and foreach loop - El Forum - 12-27-2013

[eluser]forzaferrari87[/eluser]
Hallo,
I am a newbie at CodeIgniter and want to know how does something.

I have two tables. One of the is a category table and the other a normal one for informations. In my case I want to print out first the category with a foreach loop. That works. But in my second query I want to print out the information with the correct category. Without a framework I did this by a second foreach loop.

My question. How I can print out the second table throught the id of the category table?

Also I am searching at Google too, but I don't found the correct solution till now.

multiple query and foreach loop - El Forum - 12-27-2013

[eluser]CroNiX[/eluser]
This is a SQL issue, not framework. Check out JOINs. You can get categories and information from separate tables with a single query.

multiple query and foreach loop - El Forum - 12-27-2013

[eluser]CroNiX[/eluser]
client
-id
-name

projects
-id
-client_id
-description

Code:
SELECT client.name, projects.description

FROM client

JOIN projects on client.id = projects.client_id

ORDER BY client.name

will list each client name along with all of their project descriptions

multiple query and foreach loop - El Forum - 12-27-2013

[eluser]forzaferrari87[/eluser]
[quote author="CroNiX" date="1388161737"]client
-id
-name

projects
-id
-client_id
-description

Code:
SELECT client.name, projects.description

FROM client

JOIN projects on client.id = projects.client_id

ORDER BY client.name

will list each client name along with all of their project descriptions[/quote]

Your SQL query is right, but I want it to do with where, because my target in the viewis this

Code:
&lt;?php foreach($cats as $cats_item): ?&gt;

<table class="table">

<tr><td>&lt;?php echo $cats_item['lcatname']; ?&gt;</td></tr>

&lt;?php foreach($links as $links_item): ?&gt;

<tr><td><a href="&lt;?php echo $links_item['linkurl']; ?&gt;" target="_blank">&lt;?php echo $links_item['linkname']; ?&gt;</a></td></tr>

&lt;?php endforeach; ?&gt;

</table>

&lt;?php endforeach; ?&gt;

i think this i can only make with where or there are another solution in codeigniter for printing out a category loop and into this one a link loop?

multiple query and foreach loop - El Forum - 12-27-2013

[eluser]CroNiX[/eluser]

Code:
$data = $this->db

  ->select('client.name, projects.description')

  ->join('projects', 'client.id = projects.client_id')

  //->where(where conditions, if needed)

  ->order_by('client.name')

  ->get('client')

  ->result_array();

View:

Code:
$last_client = null;

foreach($data as $d)

{

  //only list the client name once (category in your case)

  if ($last_client != $d['name'])

  {

    $last_client = $d['name'];

    echo $d['name'] . '<hr>';

  }

  //now list all of their project descriptions (linkurl in your case)

  echo $d['description'] . '<br>';

}