php nested while loop in smarty using foreach

Question

I have the following PHP code.

$stmt = $pdo->prepare("SELECT * FROM memberships WHERE mb_status = 'enabled'");
$stmt-> execute();

$mbData = array();
while($f = $stmt->fetch()){
  $mbData[] = $f;
  $mbsId = $f['mb_id'];

  $stmtUpg = $pdo->prepare("SELECT * FROM upgrade_validities WHERE upval_membership = :mbs");
  $stmtUpg-> bindValue(':mbs', $mbsId);
  $stmtUpg-> execute();

  $upgVal = array();
  while($uf = $stmtUpg->fetch()){
    $upgVal[] = $uf;
  }
}
$smarty->assign('mbData', $mbData);
$smarty->assign('upgVal', $upgVal);

Smarty code using foreach

{foreach from=$mbData key=k item=b}
  {$b.mb_name}
  <!-- Listing Item -->
  {foreach from=$upgVal key=k item=a}
      <h3>Member Id: {$a.upval_id}</h3> // doesn't get displayed
  {/foreach}
  <!-- Listing Item / End -->
{/foreach}

Here, the Member Id in the nested foreach loop isn't getting displayed. I don't know what is the error I am making.

Instead of using '{$a.upval_id}' try using '{$a["upval_id"]}'. — CharlesEF
– CharlesEF, Commented Dec 5, 2020 at 19:54
@CharlesEF before you recommend me that, are you familier enough with smarty? Plus, it didn't work. Also, please note that if the nested bit of for loop would seem to work, then even if I do not get the value to {$a.upval_id}, I will still get Member Id: as text appearing for number of counts. So here, it seems maybe my while loop logic has some issues. — RedStar Entertainment
– RedStar Entertainment, Commented Dec 5, 2020 at 20:21
It's usually a better approach to run database query inside a loop. In this case you can easily run one query to get the info you need. — Felippe Duarte
– Felippe Duarte, Commented Dec 5, 2020 at 20:37
@RedStar Entertainment Oh, sorry I didn't realize I was looking at smarty code. I guess I confused it with PHP. — CharlesEF
– CharlesEF, Commented Dec 6, 2020 at 1:23

r_a_f · Accepted Answer · 2020-12-06 00:48:34Z

1

PHP:

$stmt = $pdo->prepare("SELECT * FROM memberships WHERE mb_status = 'enabled'");
$stmt-> execute();

$mbData = array();
while($f = $stmt->fetch()){
  $mbData[] = $f;
  $mbsId = $f['mb_id'];

  $stmtUpg = $pdo->prepare("SELECT * FROM upgrade_validities WHERE upval_membership = :mbs");
  $stmtUpg-> bindValue(':mbs', $mbsId);
  $stmtUpg-> execute();

  // change begin
  $upgValTemp = array();
  while($uf = $stmtUpg->fetch()){
    $upgValTemp[] = $uf;
  }
  $upgVal[$mbsId] = $upgValTemp;

}
$smarty->assign('mbData', $mbData);
$smarty->assign('upgVal', $upgVal);

SMARTY:

{foreach from=$mbData key=k item=b}
  {$b.mb_name}
  <!-- Listing Item -->
  {foreach from=$upgVal[$b.mb_id] key=k item=a} {* changed here *}
      <h3>Member Id: {$a.upval_id}</h3>
  {/foreach}
  <!-- Listing Item / End -->
{/foreach}

answered Dec 6, 2020 at 0:48

r_a_f

6577 silver badges20 bronze badges

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

1 Comment

r_a_f Over a year ago

you welcome :) would me nice if you mark as accepted answer :)

Collectives™ on Stack Overflow

php nested while loop in smarty using foreach

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related