<td> not filling all the dynamic table HTML PHP MySQL

Question

My table is not filling all the data i need. Is missing some columns be filled with form multiple. The column where the th is Renault need to be the same for all the rest are empty.

In next picture, you can see when i select options in dynamic selectbox multiple and submit, is only filling in the first column when the expectable is fill all the columns selected.

Next is the code where is giving the value of the select box multiple.

if ($consulta !=0) {
}//
else{
    echo "";
}

@$s1= $_POST['s1'];
if( is_array($s1)){
    while (list ($key, $val) = each ($s1)) {

    }
}//
else{
    echo "";
}
/////////////////
@$s2= $_POST['s2'];
if( is_array($s2)){

?>

Next is the code where data is filled in the html table. That line of code<td align=\"center\" bgcolor='FFFFFF'> need to be associate the result of: <?php echo "$key => $val1\n";?> to which form:

The result of <?php echo "$key => $val1\n";?>

0 => Renault 1 => Opel 2 => Mercedes 3 => Audi 

The expected output is missing.

Renault

<form onsubmit=\"return validate();\" id=\"teste\" method=\"post\" action=\"teste.php\">

Opel

<form onsubmit=\"return validate();\" id=\"teste\" method=\"post\" action=\"teste.php\">

Mercedes

<form onsubmit=\"return validate();\" id=\"teste\" method=\"post\" action=\"teste.php\">

Audi

<form onsubmit=\"return validate();\" id=\"teste\" method=\"post\" action=\"teste.php\">

That is dynamic, will get the values from mysql database and i can select which i want.

There is all the table where is filled the data. Static and dynamic.

    <table>
     <tbody>
        <tr>
            <th>Parametro:</th>

    <?php 
        while (list($key, $val1) = each ($s2)) { 
    ?>

            <th><?= htmlspecialchars($val1, ENT_HTML5 | ENT_COMPAT, 'UTF-8') ?></th>
    <?php 
            echo "$key => $val1\n";
    ?>
    <?php 
        } 
    ?>

The values down of the Parametro:

    {
        echo("<tr>
        <td align=\"center\" bgcolor='FFFFFF'>$utilizador</td>

     <td align=\"center\" bgcolor='FFFFFF'>

    <form onsubmit=\"return validate();\" id=\"teste\" method=\"post\" action=\"teste.php\">


    ");

Code from the form:

$con = mysqli_connect( "localhost","root","","teste" ); // ◄■ CONNECT TO DATABASE.
$dat_menuid = mysqli_query( $con,"SELECT * FROM menu WHERE menuId = '".$menuId."'"  ) // ◄■ MENUIDs.
                      or die( mysqli_error($con) );
        $con1 = mysqli_connect( "localhost","root","","teste" ); // ◄■ CONNECT TO DATABASE.           
            $idtem = mysqli_query($con1, "SELECT MAX(id_tem) as id_tem FROM tem")        
                       or die( mysqli_error($con) );


// Print out result
while($row = $idtem->fetch_assoc())
   $toEcho = $row["id_tem"];

//echo $toEcho;

$toEchosave = $toEcho + 1;
$_SESSION['myvar'] = $toEchosave;




$options = array( "0.00","0.05","0.10","0.15","0.20","0.25","0.30","0.35","0.40","0.45","0.50","0.55","0.60","0.65","0.70","0.75","0.80","0.85","0.90","0.95","1" ); // ◄■■ OPTIONS ARE STATIC (ALWAYS THE SAME).
while ( $row_menuid = mysqli_fetch_array( $dat_menuid ) ) // ◄■ DISPLAY <SELECT>s.


{ echo "<select class='sumselect' name='corp_resp&{$row_menuid['menuId']}&{$_SESSION['UtilizadorID']}&{$dateTime}&{$toEchosave}' multiple>"; // ◄■■ CORP_RESP&1,CORP_RESP&2.

    foreach ($options as $opt)
                echo "<option value='$opt'>$opt</option>\n";
            echo "</select>\n";
        } ?>
    </form>
    </td>

  </tr>
  <?php } ?>


 <?php }
   }
   }

   ?>
 <div id='sum'></div>
 <br><br><br>


</tbody>
</table>

Answer 1

follow this code

<?php
$sql = "SELECT * FROM menu WHERE $id = menuIdPai  ORDER BY menuId ";

$consulta = mysql_query($sql);

    while ($mostrar = mysql_fetch_array($consulta)) {

    $id = $mostrar['menuId'];
    $utilizador = $mostrar['menuNome'];
    ?>

    <tr>
        <td align=\"center\" bgcolor='FFFFFF'>Test1</td>

        <td align=\"center\" bgcolor='FFFFFF'>Test2</td>
        <td align=\"center\" bgcolor='FFFFFF'>Test3</td>

        <td align=\"center\" bgcolor='FFFFFF'>Test4</td>
    </tr>
    <?php
}

?>

this is main format if work then update your code . you add 2 td but your main th 4 so need 4 td

your this tag not close

 <td align="center" bgcolor='FFFFFF'>

<form onsubmit="return validate();" id="teste" method="post" action="teste.php">

so close this in your script

    <div id='sum'></div>
   <br><br><br>


 </form>
</td>

 </tr>

move this code before end loop

      foreach ($options as $opt)
                echo "<option value='$opt'>$opt</option>\n";
            echo "</select>\n";
        } ?>
    </form>
    </td>

  </tr>
  <?php } ?>


 <?php }
   }
   }

   ?>
 <div id='sum'></div>
 <br><br><br>


</tbody>
</table>