Loop within PHP Table

0

Good morning !!! I'm trying to create a student grade report using PHP, the fact is that I created a table to list the vertical notes inside a loop, but for each student a table is generated, I'm not able to tabulate the result side by side. I also need every time I change the instructor repeat the header, ie every 8 lines ...

Follow the code:

<?php include_once "con_odbc.php" ?>
<div class="hidden-print"><b style=color:#ff0000><h4>Selecione o curso</h4></b>   <form method="get" >
 <select name="data" id="data">

<?php           

$tal=0;
$total =0;
$res=0;
$x=0;

$sqlquery=("SELECT apde.CadCrs.idCadCrs,
  apde.CadCrs.Abrev as Data,
  apde.CadCrs.Per,
  apde.CadCrs.DtIni,
  apde.CadCrs.DtFin,
  apde.CadCrs.Flag
FROM apde.CadCrs");
$res = odbc_exec($connect, $sqlquery); 

while ($dados =odbc_fetch_array($res)) {
echo("<option value='".$dados['Data']."'>".$dados['Data']."</option>");
}
?>
</select>
       </tr>
        <tr>
       </tr>
</table>
<td> <input type="submit" name="OK" value="Mostrar"><td><a class="btn btn-default ewExportLink ewPrint" onclick="window.print();" title=""  >
<span  class="icon-print ewIcon"></a></div><br>
<bgcolor='#FFFFCC'><div class="hidden-print"><a href="#abaixo" name="topo"><input type='button'   value="IR PARA O FIM"></a></div>

<div class="modal-content" width="600px">
 <div class="modal-content" >
  <div class="modal-header">
<span id=layer1 class=a1></span>
<span id=layer1 class=a1></span>
</td>
</tr>
<tr>

<br>

</form>

<br>

<table width="950" border="0" align="center" cellpadding="2" cellspacing="2">
<thead>
<TR bgcolor="<?php echo ($ac_sw1++%2==0)?"#E4E4E4":"#FFFFFF"; ?>" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor=''">
    <TD COLSPAN="40"><CENTER><b><font color="red" face="Times New Roman">Relatório de Notas </font> </b></CENTER></TD>
    </TR>
    <tr bgcolor="<?php echo ($ac_sw1++%2==0)?"#E4E4E4":"#FFFFFF"; ?>" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor=''">
    <td>Id</td>
    <td>Curso</td>
    <td>Instrutor</td>
    <td>Critério</td>
    <td>1</td>
    <td>2</td>
    <td>3</td>
    <td>4</td>
    <td>5</td>
    <td>6</td>
    <td>7</td>
    <td>8</td>
    <td>9</td>
    <td>10</td>
    <td>11</td>
    <td>12</td>
    <td>13</td>
    <td>14</td>
    <td>15</td>
    <td>16</td>
    <td>17</td>
    <td>18</td>
    <td>19</td>
    <td>20</td>
    <td>21</td>
    <td>22</td>
    <td>23</td>
    <td>24</td>
    <td>25</td>
    <td>26</td>
    <td>27</td>
    <td>28</td>
    <td>29</td>
    <td>30</td>
    <td>31</td>
    <td>32</td>
    <td>33</td>
    <td>34</td>
    <td>35</td>
    <td>36</td>

    </tr></thead><tbody>

<?php

if(isset($_GET["OK"])){
     $Data= $_GET["data"];

$contador = 0;

 $sqlquery=("SELECT Abrev, NomGue, TipAval, Aluno_1, Aluno_2, Aluno_3, Aluno_4, Aluno_5, Aluno_6, Aluno_7, Aluno_8, Aluno_9, Aluno_10, Aluno_11, Aluno_12, Aluno_13, Aluno_14, Aluno_15, Aluno_16, Aluno_17, Aluno_18, Aluno_19, Aluno_20, Aluno_21, Aluno_22, Aluno_23, Aluno_24, Aluno_25, Aluno_26, Aluno_27, Aluno_28, Aluno_29, Aluno_30, Aluno_31, Aluno_32, Aluno_33, Aluno_34, Aluno_35, Aluno_36 FROM APDE.apde.V_AvInstru  where Abrev = '$Data'  order by NomGue asc");
$res = odbc_exec($connect, $sqlquery);

while ($dados =odbc_fetch_array($res) )
{

    if($contador == 8)
    {
?></tr>
<br>
<br>
<br>
<br>

    <table border="1" align="center" cellpadding="2" cellspacing="2">
        <tr bgcolor="<?php echo ($ac_sw1++%2==0)?"#E4E4E4":"#FFFFFF"; ?>" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor=''">
            <td width="35" height="22" align="center">ID</td>

            <td width="500" align="center">Curso</td>

            <td width="500" align="center">
               Instrutor</td>


            <td width="400">Critério
            </td>
    <td  width="50">1</td>
    <td  width="50">2</td>
    <td width="50">3</td>
    <td width="50">4</td>
    <td width="50">5</td>
    <td width="50">6</td>
    <td width="50">7</td>
    <td width="50">8</td>
    <td width="50">9</td>
    <td width="50">10</td>
    <td width="50">11</td>
    <td width="50">12</td>
    <td width="50">13</td>
    <td width="50">14</td>
    <td width="50">15</td>
    <td width="50">16</td>
    <td width="50">17</td>
    <td width="50">18</td>
    <td width="50">19</td>
    <td width="50">20</td>
    <td width="50">21</td>
    <td width="50">22</td>
    <td width="50">23</td>
    <td width="50">24</td>
    <td width="50">25</td>
    <td width="50">26</td>
    <td width="50">27</td>
    <td width="50">28</td>
    <td width="50">29</td>
    <td width="50">30</td>
    <td width="50">31</td>
    <td width="50">32</td>
    <td width="50">33</td>
    <td width="50">34</td>
    <td width="50">35</td>
    <td width="50">36</td>


    </tr></thead><tr>

<?php    
        $contador = 0;
    }

?>

        <tr bgcolor="<?php echo ($ac_sw1++%2==0)?"#E4E4E4":"#FFFFFF"; ?>" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor=''">
            <td width="35" height="22" align="center"><?php echo $contador; ?></td>

            <td width="500" align="center"><?php echo $dados['Abrev']; ?></td>

            <td width="133" align="center">
               <?php echo $dados['NomGue']; ?></td>

            <td width="400"><?php echo $dados['TipAval']; ?>
            </td>

            <td width="50"><?php echo $dados['Aluno_1']; ?></td>        
            <td width="50"><?php echo $dados['Aluno_2']; ?></td>
            <td width="50"><?php echo $dados['Aluno_3']; ?></td>
            <td width="50"><?php echo $dados['Aluno_4']; ?></td>
            <td width="50"><?php echo $dados['Aluno_5']; ?></td>
            <td width="50"><?php echo $dados['Aluno_6']; ?></td>
            <td width="50"><?php echo $dados['Aluno_7']; ?></td>
            <td width="50"><?php echo $dados['Aluno_8']; ?></td>
            <td width="50"><?php echo $dados['Aluno_9']; ?></td>
            <td width="50"><?php echo $dados['Aluno_10']; ?></td>
            <td width="50"><?php echo $dados['Aluno_11']; ?></td>
            <td width="50"><?php echo $dados['Aluno_12']; ?></td>
            <td width="50"><?php echo $dados['Aluno_13']; ?></td>
            <td width="50"><?php echo $dados['Aluno_14']; ?></td>
            <td width="50"><?php echo $dados['Aluno_15']; ?></td>
            <td width="50"><?php echo $dados['Aluno_16']; ?></td>
            <td width="50"><?php echo $dados['Aluno_17']; ?></td>
            <td width="50"><?php echo $dados['Aluno_18']; ?></td>
            <td width="50"><?php echo $dados['Aluno_19']; ?></td>
            <td width="50"><?php echo $dados['Aluno_20']; ?></td>
            <td width="50"><?php echo $dados['Aluno_21']; ?></td>
            <td width="50"><?php echo $dados['Aluno_22']; ?></td>
            <td width="50"><?php echo $dados['Aluno_23']; ?></td>
            <td width="50"><?php echo $dados['Aluno_24']; ?></td>
            <td width="50"><?php echo $dados['Aluno_25']; ?></td>
            <td width="50"><?php echo $dados['Aluno_26']; ?></td>
            <td width="50"><?php echo $dados['Aluno_27']; ?></td>
            <td width="50"><?php echo $dados['Aluno_28']; ?></td>
            <td width="50"><?php echo $dados['Aluno_29']; ?></td>
            <td width="50"><?php echo $dados['Aluno_30']; ?></td>
            <td width="50"><?php echo $dados['Aluno_31']; ?></td>
            <td width="50"><?php echo $dados['Aluno_32']; ?></td>
            <td width="50"><?php echo $dados['Aluno_33']; ?></td>
            <td width="50"><?php echo $dados['Aluno_34']; ?></td>
            <td width="50"><?php echo $dados['Aluno_35']; ?></td>
            <td width="50"><?php echo $dados['Aluno_36']; ?></td>

        </tr>

<?php
    $contador++;
}} 
?>
</table>  
    
asked by anonymous 06.03.2018 / 15:16

1 answer

0

Hello ... I can not verify if it was right ... I did my best. I know it's fairly easy to get lost when working on a file like this, with PHP and HTML mixed in. Here's what I've been able to do .. please make sure it's correct. And try to take better care of the structure of your code. It had cross-tags, and three's lost and opening of tables more ..

<?php include_once "con_odbc.php" ?>
<div class="hidden-print"><b style=color:#ff0000>
   <h4>Selecione o curso</h4>
</b>

<form method="get">
    <select name="data" id="data">
        <?php           

            $tal=0;
            $total =0;
            $res=0;
            $x=0;

            $sqlquery=("SELECT apde.CadCrs.idCadCrs,
            apde.CadCrs.Abrev as Data,
            apde.CadCrs.Per,
            apde.CadCrs.DtIni,
            apde.CadCrs.DtFin,
            apde.CadCrs.Flag
            FROM apde.CadCrs");
            $res = odbc_exec($connect, $sqlquery); 
        ?>
        <?php  while ($dados =odbc_fetch_array($res)): ?>
        <option value='".$dados[' Data ']."'>
            <?= $dados['Data'] ?>
        </option>
        <?php endwhile; ?>
    </select>
    <input type="submit" name="OK" value="Mostrar">
    <a class="btn btn-default ewExportLink ewPrint" onclick="window.print();" title="">
        <span class="icon-print ewIcon">
    </a>
</form>

 <bgcolor='#FFFFCC'><div class="hidden-print"><a href="#abaixo" name="topo"><input type='button' value="IR PARA O FIM"></a></div>

<div class="modal-content" width="600px">
    <div class="modal-content">
        <div class="modal-header">
            <span id=layer1 class=a1></span>
            <span id=layer1 class=a1></span>
            <br>
            <br>

            <table width="950" border="0" align="center" cellpadding="2" cellspacing="2">
                <thead>
                    <TR bgcolor="<?php echo ($ac_sw1++%2==0)?" #E4E4E4 ":"#FFFFFF "; ?>" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor=''">
                        <TD COLSPAN="40">
                            <CENTER>
                                <b>
                                    <font color="red" face="Times New Roman">Relatório de Notas </font>
                                </b>
                            </CENTER>
                        </TD>
                    </TR>
                    <tr bgcolor="<?php echo ($ac_sw1++%2==0)?" #E4E4E4 ":"#FFFFFF "; ?>" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor=''">
                        <td>Id</td>
                        <td>Curso</td>
                        <td>Instrutor</td>
                        <td>Critério</td>
                        <td>1</td>
                        <td>2</td>
                        <td>3</td>
                        <td>4</td>
                        <td>5</td>
                        <td>6</td>
                        <td>7</td>
                        <td>8</td>
                        <td>9</td>
                        <td>10</td>
                        <td>11</td>
                        <td>12</td>
                        <td>13</td>
                        <td>14</td>
                        <td>15</td>
                        <td>16</td>
                        <td>17</td>
                        <td>18</td>
                        <td>19</td>
                        <td>20</td>
                        <td>21</td>
                        <td>22</td>
                        <td>23</td>
                        <td>24</td>
                        <td>25</td>
                        <td>26</td>
                        <td>27</td>
                        <td>28</td>
                        <td>29</td>
                        <td>30</td>
                        <td>31</td>
                        <td>32</td>
                        <td>33</td>
                        <td>34</td>
                        <td>35</td>
                        <td>36</td>

                    </tr>
                </thead>
                <tbody>

                    <?php if(isset($_GET["OK"])): ?>

                    <?php
                            $Data= $_GET["data"];

                            $contador = 0;

                            $sqlquery=("SELECT Abrev, NomGue, TipAval, Aluno_1, Aluno_2, Aluno_3, Aluno_4, Aluno_5, Aluno_6, Aluno_7, Aluno_8, Aluno_9, Aluno_10, Aluno_11, Aluno_12, Aluno_13, Aluno_14, Aluno_15, Aluno_16, Aluno_17, Aluno_18, Aluno_19, Aluno_20, Aluno_21, Aluno_22, Aluno_23, Aluno_24, Aluno_25, Aluno_26, Aluno_27, Aluno_28, Aluno_29, Aluno_30, Aluno_31, Aluno_32, Aluno_33, Aluno_34, Aluno_35, Aluno_36 FROM APDE.apde.V_AvInstru  where Abrev = '$Data'  order by NomGue asc");
                            $res = odbc_exec($connect, $sqlquery);
                    ?>
                        <?php while ($dados =odbc_fetch_array($res) ): ?>
                        <?php if($contador == 8): ?>

                        <tr bgcolor="<?php echo ($ac_sw1++%2==0)?" #E4E4E4 ":"#FFFFFF "; ?>" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor=''">
                            <td width="35" height="22" align="center">ID</td>
                            <td width="500" align="center">Curso</td>
                            <td width="500" align="center">Instrutor</td>
                            <td width="400">Critério</td>
                            <td width="50">1</td>
                            <td width="50">2</td>
                            <td width="50">3</td>
                            <td width="50">4</td>
                            <td width="50">5</td>
                            <td width="50">6</td>
                            <td width="50">7</td>
                            <td width="50">8</td>
                            <td width="50">9</td>
                            <td width="50">10</td>
                            <td width="50">11</td>
                            <td width="50">12</td>
                            <td width="50">13</td>
                            <td width="50">14</td>
                            <td width="50">15</td>
                            <td width="50">16</td>
                            <td width="50">17</td>
                            <td width="50">18</td>
                            <td width="50">19</td>
                            <td width="50">20</td>
                            <td width="50">21</td>
                            <td width="50">22</td>
                            <td width="50">23</td>
                            <td width="50">24</td>
                            <td width="50">25</td>
                            <td width="50">26</td>
                            <td width="50">27</td>
                            <td width="50">28</td>
                            <td width="50">29</td>
                            <td width="50">30</td>
                            <td width="50">31</td>
                            <td width="50">32</td>
                            <td width="50">33</td>
                            <td width="50">34</td>
                            <td width="50">35</td>
                            <td width="50">36</td>
                        </tr>
                        <?php $contador = 0; endif; ?>

                        <tr bgcolor="<?php echo ($ac_sw1++%2==0)?" #E4E4E4 ":"#FFFFFF "; ?>" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor=''">

                            <td width="35" height="22" align="center"><?= $contador; ?></td>
                            <td width="500" align="center"><?= $dados['Abrev']; ?></td>
                            <td width="133" align="center"><?= $dados['NomGue']; ?></td>
                            <td width="400"><?= $dados['TipAval']; ?></td>
                            <td width="50"><?= $dados['Aluno_1']; ?></td>
                            <td width="50"><?= $dados['Aluno_2']; ?></td>
                            <td width="50"><?= $dados['Aluno_3']; ?></td>
                            <td width="50"><?= $dados['Aluno_4']; ?></td>
                            <td width="50"><?= $dados['Aluno_5']; ?></td>
                            <td width="50"><?= $dados['Aluno_6']; ?></td>
                            <td width="50"><?= $dados['Aluno_7']; ?></td>
                            <td width="50"><?= $dados['Aluno_8']; ?></td>
                            <td width="50"><?= $dados['Aluno_9']; ?></td>
                            <td width="50"><?= $dados['Aluno_10']; ?></td>
                            <td width="50"><?= $dados['Aluno_11']; ?></td>
                            <td width="50"><?= $dados['Aluno_12']; ?></td>
                            <td width="50"><?= $dados['Aluno_13']; ?></td>
                            <td width="50"><?= $dados['Aluno_14']; ?></td>
                            <td width="50"><?= $dados['Aluno_15']; ?></td>
                            <td width="50"><?= $dados['Aluno_16']; ?></td>
                            <td width="50"><?= $dados['Aluno_17']; ?></td>
                            <td width="50"><?= $dados['Aluno_18']; ?></td>
                            <td width="50"><?= $dados['Aluno_19']; ?></td>
                            <td width="50"><?= $dados['Aluno_20']; ?></td>
                            <td width="50"><?= $dados['Aluno_21']; ?></td>
                            <td width="50"><?= $dados['Aluno_22']; ?></td>
                            <td width="50"><?= $dados['Aluno_23']; ?></td>
                            <td width="50"><?= $dados['Aluno_24']; ?></td>
                            <td width="50"><?= $dados['Aluno_25']; ?></td>
                            <td width="50"><?= $dados['Aluno_26']; ?></td>
                            <td width="50"><?= $dados['Aluno_27']; ?></td>
                            <td width="50"><?= $dados['Aluno_28']; ?></td>
                            <td width="50"><?= $dados['Aluno_29']; ?></td>
                            <td width="50"><?= $dados['Aluno_30']; ?></td>
                            <td width="50"><?= $dados['Aluno_31']; ?></td>
                            <td width="50"><?= $dados['Aluno_32']; ?></td>
                            <td width="50"><?= $dados['Aluno_33']; ?></td>
                            <td width="50"><?= $dados['Aluno_34']; ?></td>
                            <td width="50"><?= $dados['Aluno_35']; ?></td>
                            <td width="50"><?= $dados['Aluno_36']; ?></td>
                        </tr>
                        <?php $contador++; endwhile; endif; ?>
            </table>
    
06.03.2018 / 19:37