如何使html表列<th> </ th>动态更改mysql中的选定列

Question

I have multiple select options. however, i want when i select 1 option or two or whatever to change the columns <th></th> of html dynamically and get data from database

Currently I have created the multiple select option and html table

<select class="selectpicker" id="sensor" name="sensor[]" multiple>
                                <option 
     value="temperature">Temperature</option>
                                <option value="humidity">Humidity</option>
                                <option value="presure">Presure</option>
                                <option 
     value="level">Level</option>
                                </select>

     $query = "SELECT ".$selectedSensorOption." from p1";       
                    $result = $db_handle->runQuery($query);
    foreach ($result as $key => $value) {
    <table>
    <tr>
    <th>$result</th>
    </tr> 
    <tr>
    <td>$result</td>

I want to get dynamic columns and fields as well from MySQL db based on multiple select options

Answer 1

first you have to get the headers, you can use explode to get the header keys. you'll use two loops, the first one to build the header and the second one to build the body. inside the body loop, you have to use another loop to get the correct value for each column

<select class="selectpicker" id="sensor" name="sensor[]" multiple>
    <option value="temperature">Temperature</option>
    <option value="humidity">Humidity</option>
    <option value="presure">Presure</option>
    <option value="level">Level</option>
</select>
<?php
$query = "SELECT ".$selectedSensorOption." from p1";
$results = $db_handle->runQuery($query);
//get the headers if $selectedSensorOption is not an array
$headers = explode(',', $selectedSensorOption)
?>
<table>
    <thead>
        <tr>
            <!-- loop and fill the header -->
            <?php foreach ($headers as $header) : ?>
                <th><?= ucfirst($header) ?></th>
            <?php endforeach; ?>
        </tr>
    </thead>
    <tbody>
        <!-- loop and fill the body-->
        <?php foreach ($results as $result) : ?>
               <tr>
                  <!-- loop and fill each column -->
                   <?php foreach ($headers as $header) : ?>
                     <th><?= $result[$header] ?></th>
                   <?php endforeach; ?>
               </tr>
        <?php endforeach; ?>
    </tbody>
</table>