mardi 25 avril 2017

Get php checkbox data from multiple tables

First I will tell what I want to achieve, and then I will explain how I was trying to do it. I have two tables, one stores type of vessels with a description and their own Id. Then I have another table in wich the vessel type has been stored as text. My goal is to select each one (both records in both tables) with a checkbox in both and store in the table 2 the Id from the table 1. I will introduce data, to help. Table 1
1|Balandra|Some description 2|Bergantin|Some description 3|Whatever |Whatever.....

Table2 Balandra Bergantin Whatever

Then, I have created a php page that shows both tables with the checkbox I mentioned above. Checkboxes store the Table1 Id and Table2 vesseltypename.

<table class="table table-striped table-bordered table-list">
<thead>
<tr>
<th><em class="fa fa-cog"></em></th>
<th class="hidden-xs">idtiponavio</th>
<th>Tipo de Navío</th>
<th>Descripción</th>
<th>Agrupar</th>
</tr> 
</thead>
<tbody>

 <?php foreach ($naviosdyncoop as $key => $navio) { ?>
                  <tr>
                      <td align="center">
                        <a href=<?php echo '../vista/modificar.php?id=' . 
    $navio['idtiponavio'];  ?> class="btn btn-default"><em class="fa fa-
    pencil"></em></a>
                        <a href=<?php echo '../datos/borrar.php?id=' . 
    $navio['idtiponavio'];  ?> class="btn btn-default"><em class="fa fa-
    trash"></em></a>
    </td>
    <td class="hidden-xs"><?php echo 
    $navio['idtiponavio']; ?></td>
    <td><?php echo $navio['tiponavio']; ?></td>
    <td><?php echo $navio['descripcion']; ?></td>
    <td><input type="checkbox" name="agruparid" value=<?
    php echo $navio['idtiponavio']; ?> /></td>

                  </tr>
                <?php } ?>

            </tbody>
          </table>
        </div>

       </div>
       <div class="col-md-6">
<div class="panel-body paneltodo">
          <table class="table table-striped table-bordered table-list">
            <thead>
              <tr>
                <th><em class="fa fa-cog"></em></th>
                <th>Tipo de Navío</th>
                <th>Agrupar</th>
              </tr> 
            </thead>
            <tbody>

                <?php foreach ($naviosforsea as $key => $navio) { ?>
                  <tr>
                      <td align="center">
                        <a href=<?php echo $navio['typevessel']; ?> class="btn btn-default"><em class="fa fa-arrow-circle-o-left"></em></a>
                        </td>
                      <td><?php echo $navio['typevessel']; ?></td>
                      <td><input type="checkbox" name="agruparvessel" value=<?php echo $navio['typevessel']; ?> /></td>

                  </tr>
                <?php } ?>

            </tbody>
          </table>

So, I want to check both table records and store the table1 Id in the table2 idtypevessel field. I thought that a php file could store both items and call the update function with those parameters, like this:

<?php
require './modelo.php';
$idnavio = $_GET['agruparid'];
$vessel = $_GET['agruparvessel'];

Any suggestions, because I think I have to do a button to submit this parameters, but it must be working on both tables, and I don't know how to access both foreach loop at the same time. Thanks in advance.




Aucun commentaire:

Enregistrer un commentaire