Insert into sql database dynamic form fields added

Question

I have the following code, that inserts data into my sql database. :

setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            $sql = "INSERT INTO items (WID, model, description, cost, retail, qty) values(?, ?, ?, ?, ?, ?);";
            $q = $pdo->prepare($sql);
            $q->execute(array($wid,$Model, $Description, $Cost, $Retail, $Quantity));

            Database::disconnect();
            header("Location: index.php");
        }
    }
?>


  
    
    Workorder System

    
    
    
    
    

    
    

    
    
  

  


    
    
        
            
                Workorder System 
            
         
        
            
            
            
                
                    
                        
                            
                            ID
                            Model #
                            Description
                            Cost
                            Retail
                            Quantity
                        
                    
                    
                        
                            
                            
                            
                            
                            

                            
                                    
                                        
                                            
                                                
                                            
                                    
                            

                            
                            

                            
                                    
                                        
                                            
                                                
                                            
                                    
                            

                               
                            

                            
                                    
                                        
                                            
                                                
                                            
                                    
                            

                            
                            

                            
                                    
                            
                            
                                                
                                            
                                    
                            

                            
                            

                            
                                    
                            
                            
                                                
                                            
                                    
                            

                            
                        
                    
                
            
        
        
            
                
                
            
        
        Notes: 
        
            
                
                    
                
            
              
        
                          
                          Back

This code worked perfectly before it was altered. It used to only insert rows into the database one at a time, before I added this code :

and the ajax backend :

//adds extra table rows
var i=$('table tr').length;
$(".addmore").on('click',function(){
    html = '';
    html += '';
    html += '';
    html += '';
    html += '';
    html += '';
    html += '';
    html += '';
    html += '';
    $('table').append(html);
    i++;
});

//to check all checkboxes
$(document).on('change','#check_all',function(){
    $('input[class=case]:checkbox').prop("checked", $(this).is(':checked'));
});

//deletes the selected table rows
$(".delete").on('click', function() {
    $('.case:checkbox:checked').parents("tr").remove();
    $('#check_all').prop("checked", false); 
    calculateTotal();
});

//autocomplete script
$(document).on('focus','.autocomplete_txt',function(){
    type = $(this).data('type');

    if(type =='ID' )autoTypeNo=0;
    if(type =='model' )autoTypeNo=1;    

    $(this).autocomplete({
        source: function( request, response ) {
            $.ajax({
                url : 'ajax.php',
                dataType: "json",
                method: 'post',
                data: {
                   name_startsWith: request.term,
                   type: type
                },
                 success: function( data ) {
                     response( $.map( data, function( item ) {
                        var code = item.split("|");
                        return {
                            label: code[autoTypeNo],
                            value: code[autoTypeNo],
                            data : item
                        }
                    }));
                }
            });
        },
        autoFocus: true,            
        minLength: 0,
        select: function( event, ui ) {
            var names = ui.item.data.split("|");                        
            id_arr = $(this).attr('id');
            id = id_arr.split("_");
            $('#idNo_'+id[1]).val(names[0]);
            $('#model_'+id[1]).val(names[1]);
            $('#description_'+id[1]).val(names[2]);
            $('#cost_'+id[1]).val(names[3]);
            $('#retail_'+id[1]).val(names[4]);
            $('#quantity_'+id[1]).val(1);
            $('#total_'+id[1]).val( 1*names[4] );
            calculateTotal();
        }               
    });
});

//It restrict the non-numbers
var specialKeys = new Array();
specialKeys.push(8,46); //Backspace
function IsNumeric(e) {
    var keyCode = e.which ? e.which : e.keyCode;
    console.log( keyCode );
    var ret = ((keyCode >= 48 && keyCode <= 57) || specialKeys.indexOf(keyCode) != -1);
    return ret;
}

and



Now, I got help with the ajax section of the code, which works(adds the form fields properly), and the POST results work fine(screened firefox's web developer tab, and it posts all of my form field data properly), the only thing that I am having issues with is how to translate MULTIPLE submissions at a time.  Apparently the sql code that I have working with one submission does not work with multiple consecutive submissions, and I get the following error :


  Notice: Array to string conversion in C:\wamp\www\invoice\index.php on line 131 Call Stack #TimeMemoryFunctionLocation 10.0012276928{main}( )..\index.php:0 Array" class="form-control autocomplete_txt" autocomplete="off"> 


and for some odd reason :


  Notice: Undefined index: qty in C:\wamp\www\invoice\index.php on line 24


Any help with this matter would be GREATLY appreciated, have been troubleshooting for over a week now :P

Alex · Accepted Answer

I am not sure what you are asking for. But just to loop your arrays you can:

        $pdo = Database::connect();
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $sql = "INSERT INTO items (WID, model, description, cost, retail, qty) values(?, ?, ?, ?, ?, ?);";
        $q = $pdo->prepare($sql);
        $idx = 0;
        foraech ($Model as $model_idx) {
            $q->execute(array($wid,$model_idx, $Description[$idx], $Cost[$idx], $Retail[$idx], $Quantity[$idx]));
            $idx++;
        }

Insert into sql database dynamic form fields added

Answers (1)

Related Questions