Hi,

How to access to data values in a selected row of an editable table?

Given a (paginated) table, filled by pgSql query, e.g.:

 <?php  
    $sql  = "SELECT * FROM uplink_data_message";
    $sql .= ' ORDER BY udm_azon DESC'; 
    $sql .= ' LIMIT 200'; 

    $result = pg_query($sql) or die( pg_last_error());
    $rows = pg_num_rows($result);

?>

      <div class="table-responsive">
      <!-- table-bordered -->
        <table 
          id="dtData" 
          class="table table-condensed table-striped table-sm text-nowrap" 
          cellspacing="0" 
          width="100%">

          <thead>
            <tr>
              <th>#</th>
              <th>Timestamp</th>
              <th>Seq.no.</th>
              <th>Port</th>
              <th>Freq. (MHz)</th>
              <th>RSSI</th>
              <th>SNR</th>
              <th>DR</th>
              <th>Bat.</th>
            </tr>
          </thead>

          <tbody>
            <?php       
            while($row = pg_fetch_assoc($result)){
              echo "<td>".$row['udm_azon']."</td>";
              echo "<td>".$row['udm_ts']."</td>";
              echo "<td>".$row['udm_seqno']."</td>";
              echo "<td>".$row['udm_port']."</td>"; // cd_timestamp
              echo "<td>".number_format( (float)$row['udm_freq']/1000000,2,',',' ') . "</td>";
              echo "<td>".$row['udm_rssi']."</td>";
              echo "<td>".$row['udm_snr']."</td>";
              echo "<td>".$row['udm_dr']."</td>";
              echo "<td>". $formatter->format($row['udm_bat']/255) ."</td>";
              echo "\n\t</tr>\n";
            } // while
            ?>
          </tbody>

      </table>

 <?php
   // Free resultset        
   pg_free_result($result);
   pg_close($connect); 
 ?>

Expected behavior

Selecting a row, data of selected row passed ("exported") to further usage, e.g. battery charging level (e.g. Bat = 100%) displayed by min-chart, frequency (in this example 868.50) displayed in a separate label, or any other component, etc.

Actual behavior

Resources (screenshots, code snippets etc.)

Resulted screen: