Gentilissimi, vorrei creare due tabelle correlate fra di loro la seconda dipendente dalla prima. Mi spiego, ad ogni riga della prima tabella, vorrei collegare una o più righe della seconda tabella e poi salvare il tutto in DB. Lo script che allego aggiunge o rimuove le righe nelle singole tabelle ma non come serve al mio specifico scopo. qualcuno può darmi una dritta
	
	
	
		
				
			
		Codice:
	
	<script>
   $(document).ready(function() {
       var i = 1;
       var ii = 1;
       var html='';
       var html1='';
       $('#add').click(function() {
           i++;
           html='<tr id="row'+i+'">';
           html += '<td><select name="um_c_id[]"> <option value="">Sel.</option><?php echo um_list(); ?></select></td>';
           html += '<td><input type="text" name="qt_c[]" id="name" placeholder="Qt" class="form-control name_list" /></td>';
           html += '<td><input type="text" name="costo[]" id="name" placeholder="Costo" class="form-control name_list" /></td>';
           html += '<td><input type="text" name="rif[]" id="name" placeholder="Rif." class="form-control name_list" /></td>';
           html += '<td><button name="btn_remove" id="'+i+'" class="btn btn-danger btn_remove">X</button></td>';
           html += '</tr>';
           $('#dynamic_field').append(html);
      
       });
  
       $('#add1').click(function() {
           ii++;
           html1='<tr id="row'+ii+'">';
           html1 += '<td><select name="um_c_id[]"> <option value="">Sel.</option><?php echo um_list(); ?></select></td>';
           html1 += '<td><input type="text" name="qt[]" id="qt" placeholder="Qt" class="form-control name_list" /></td>';
           html1 += '<td><input type="text" name="lung[]" id="lung" placeholder="Lung." class="form-control name_list" /></td>';
           html1 += '<td><input type="text" name="largh[]" id="largh" placeholder="Largh." class="form-control name_list" /></td>';
           html1 += '<td><input type="text" name="alt[]" id="alt" placeholder="Alt." class="form-control name_list" /></td>';
           html1 += '<td><input type="text" name="peso[]" id="peso" placeholder="Peso" class="form-control name_list" /></td>';
            html1 += '<td><select name="destina[]"> <option value="">Sel.</option><?php echo clienti_list(); ?></select></td>';
           html1 += '<td><input type="text" name="consegna[]" id="consegna" placeholder="Consegna" class="form-control name_list" /></td>';
           html1 += '<td><input type="text" name="contr[]" id="contr" placeholder="Entra" class="form-control name_list" /></td>';
           html1 += '<td><input type="text" name="note[]" id="note" placeholder="Entra" class="form-control name_list" /></td>';
           html1 += '<td><button name="btn_remove1" id="'+ii+'" class="btn btn-danger btn_remove1">X</button></td>';
           html1 += '</tr>';
           $('#dynamic_field2').append(html1);
           });  
      
       $(document).on('click', '.btn_remove', function(){
           var button_id = $(this).attr("id");
           $('#row'+button_id+'').remove();
       });
       $(document).on('click', '.btn_remove1', function(){
           var button_id = $(this).attr("id");
           $('#row'+button_id+'').remove();
       });
  
       $('#submit').click(function(){
           $.ajax({
               url:"salva_dati.php",
               method:"POST",
               data:$('#add_name').serialize(),
               success:function(data)
               {  alert(data);
                   $('#add_name')[0].reset();
               }
           });
       });
   });
	
			
				Ultima modifica: