I'm having a drawback problem pulling values that are within two tables different to some inputs. When you click on a tr of table the script created pulls its values and it sends to some Inputs that are on the same page, doing this with only one table the code works perfectly.
Here is the code I used in the first Table
<form action ="evento.php?reserva=true" method = "post">
<div class="col-md-12 form-group form-group-lg">
<center> <h2>Equipamentos
</h2></center>
</div>
<table border="2" id='table'>
<thead>
<tr>
<th>Id</th>
<th>Equipamento</th>
<th>Cor</th>
<th>Marca</th>
<th>Categoria</th>
</tr>
<style type="text/css">
tbody tr:hover{background-color:#555}
</style>
</thead>
<tfoot>
<tr>
<td colspan="7"><center><script language=javascript type="text/javascript">
dayName = new Array ("domingo", "segunda", "terça", "quarta", "quinta", "sexta", "sábado")
monName = new Array ("janeiro", "fevereiro", "março", "abril", "maio", "junho", "agosto", "outubro", "novembro", "dezembro")
now = new Date
document.write (" Hoje é " + dayName[now.getDay() ] + ", " + now.getDate () + " de " + monName [now.getMonth() ] + " de " + now.getFullYear () + " ")
document.write ( + now.getHours() + ":" + now.getMinutes() + ":" + now.getSeconds() )
</script></center></td>
</tr>
</tfoot>
<center>
<?php
//include_once "conexao.php";
$sql = "select * from equipamentos";
$result = mysql_query($sql,$con);
if($result){
while($linha1 = mysql_fetch_array($result)){
?>
<tbody>
<tr id="<?php echo $linha1['id_equipamento']; ?>">
<td data-target="id_equipamento"> <?php echo $linha1['id_equipamento'];?></td>
<td data-target="nomeequip1"> <?php echo $linha1['nomeequip'];?></td>
<td data-target="corequip1"> <?php echo $linha1['corequip'];?></td>
<td data-target="marcaequip1"> <?php echo $linha1['marcaequip'];?></td>
<td data-target="categoriaequip1"> <?php echo $linha1['categoriaequip'];?></td>
</tr>
<?php
}//fim do while
}//fim do if
?>
</tbody>
</table> And Script
<script type="text/javascript">
$('tbody tr').click(function(){
var id = $(this).attr('id');
$.each($('#'+id+" td"),function(){
var target = $(this).data('target');
$("input[name='"+target+"']").val($(this).html());
});
});
</script> And it is for these% of% to which the data of the first Inputs are directed
<div class="form-group your-id">
<input class="wpcf7-form-control wpcf7-text wpcf7-validates-as-required form-control form-control" name="id_equipamento" style="display: none">
</div>
<div class="col-md-4 col-sm-9 col-xs-9 form-group form-group-lg">
Nome Do Equipamento:<br/>
<div class="form-group your-equip">
<input class="wpcf7-form-control wpcf7-text wpcf7-validates-as-required form-control form-control" name="nomeequip1" disabled required>
</div>
</div>
<div class="col-md-5 form-group form-group-lg"> Marca:<br/>
<div class="form-group marca">
<input class="wpcf7-form-control wpcf7-text wpcf7-validates-as-required form-control form-control" name="marcaequip1" disabled required>
</div>
</div>
<div class="col-md-5 col-sm-10 col-xs-10 form-group form-group-lg">
Cor:<br/>
<div class="form-group cor">
<input class="wpcf7-form-control wpcf7-text wpcf7-validates-as-required form-control form-control" name="corequip1" disabled required>
</div>
</div>
<div class="col-md-5 form-group form-group-lg"> Categoria<br/>
<div class="form-group Categoria">
<input class="wpcf7-form-control wpcf7-text wpcf7-validates-as-required form-control form-control" name="categoriaequip1" disabled required>
</div>
</div>
<br>
<div class="col-md-3 form-group form-group-lg"> Data da Reserva<br/>
<div class="form-group Categoria">
<input class="wpcf7-form-control wpcf7-data wpcf7-validates-as-required form-control form-control" type="date" name="data" required>
</div>
</div> I recently had the need to add another Table with different data and I wish it could do the same thing as the first Table . I created new table and tried to direct the values of this second inputs to these new table , but then I got the problem that I am currently facing. When you click on the second inputs it simply pulls the wrong data to the wrong fields, instead of picking up the data from the second table and leading to the table targeted, it takes the data from the first inputs e simply update the data then in the first% w / o of%.
Code and Table of Second Inputs
<table border="2">
<div class="col-md-12 form-group form-group-lg">
<center> <h2>Professores
</h2></center>
</div>
<thead>
<tr>
<th>Id</th>
<th>Professor</th>
</tr>
</thead>
<?php
$sql = "select * from professor";
$result = mysql_query($sql,$con);
if($result){
while($linha1 = mysql_fetch_array($result)){
?>
<tbody>
<tr id="<?php echo $linha1['id_professor']; ?>">
<td data-target="id_professor"> <?php echo $linha1['id_professor'];?></td>
<td data-target="nomepro1"> <?php echo $linha1['nomepro'];?></td>
</tr>
</tbody>
<?php
}//fim do while
}//fim do if
mysql_close($con);
?>
</table>
<div >
<input class="wpcf7-form-control wpcf7-text wpcf7-validates-as-required form-control form-control" name="id_professor" >
</div>
<div class="col-md-3 form-group form-group-lg"> Professor<br/>
<div >
<input class="wpcf7-form-control wpcf7-data wpcf7-validates-as-required form-control form-control" name="nomepro1">
</div>
</div> the Inputs I use for both is exactly the same.