While in While PHP Pdo [closed]

Question

While in While PHP Pdo [closed]

Navigation

#1 by (-1 votes)

0

I would like to know how to do a while within another ... Ex. I have Categories and items within the category.

    Categoria 1
       | Item da categoria 1
       | Item da categoria 1
    Categoria 2
       | Item da categoria 2
       | Item da categoria 2
    Categoria 3
       | Item da categoria 3
       | Item da categoria 3

And so on ... how do I do this using PHP PDO ... Follow my code

       <? $pdo = db_connect();
       $listar = $pdo->prepare("SELECT * FROM arquivos WHERE cliente_id =".$_SESSION['user_id']." AND tipo =".$tipo);
       $listar->execute(); ?>
       <div>
           <ul>
             <? while ($dados = $listar->fetch(PDO::FETCH_OBJ)): ?>
             <li>
                 <? echo $dados->disciplinas; ?>
                 <? 
                   $listar2 = $pdo->prepare("SELECT * FROM arquivos WHERE cliente_id =".$_SESSION['user_id']." AND tipo =".$tipo);
                   $listar2->execute();
                 ?>
                 <ul>
                      <? while ($dados2 = $listar2->fetch(PDO::FETCH_OBJ)): ?>
                     <li><? echo $dados2->titulo; ?></li>
                     <? endwhile; ?>
                 </ul>
             </li>                 
           </ul>
       </div>
       <? endwhile; ?>

I hope you can help me: D

php mysql while pdo

asked by anonymous 28.04.2017 / 21:48

1 answer

Postgres-case when Redirect in javascript does not work with external script

score -1 · Accepted Answer

Using two while you can get the same result using just a while

HTML START

<div><ul>

1: before the while put $cont=0;

2: within the while

 //inicio while
 $OutraDisciplina = $dados["disciplinas"];

 if (($OutraDisciplina != $OutraDisciplinaOLD)&&($cont != 0)) {
    echo "</ul></li>\n";
 }

 if ($OutraDisciplina != $OutraDisciplinaOLD){
    echo "<li>\n";
    echo $dados["disciplinas"];
    echo "<ul>\n";
 }                       

 echo "<li>\n";
 echo $dados["titulo"];
 echo "</li>\n";

 $OutraDisciplinaOLD=$OutraDisciplina;
 $cont=$cont+1;
 //fim while

END HTML

</ul></div>