Calculate total number of row in a HTML form

Question

I have a form in which there is an ADD button(green plus symbol in the given form) used to adds row to the form using java script.After that this form is used to update the data in table.For updating the data in mysql table i have to run one loop depending upon the number of row added by the user. Problem is how to identify how many number of of times this loop will run. Presently I am manually inserting the value(Enter total number of item column is the given form) by one input box count.I want this value to be calculated automatically so that i can remove this input box.Someone suggested it to do with Ajax but I am not much aware about Ajax. the form looks like My code is-.

prepare($sql);
$query->bindParam(':txntype',$txntype,PDO::PARAM_STR);
$query->bindParam(':orderno',$orderno,PDO::PARAM_STR);
$query->bindParam(':orderdate',$orderdate,PDO::PARAM_STR);
$query->bindParam(':stationerytype',$stationerytype[$i],PDO::PARAM_STR);
$query->bindParam(':stationeryqtyrecd',$stationeryqtyrecd[$i],PDO::PARAM_STR);
$query->execute();
$lastInsertId = $dbh->lastInsertId();

if($lastInsertId)

{
$_SESSION['msg']="Stationery Added successfully";

echo "";

}
else 
{
$_SESSION['error']="Something went wrong. Please try again";
header('location:index.php');
}
}
}
}
?>


    
        
                
        
        
        Add Stationery Stock
        
        
        
    
                 
    
    
    
        

        
                
                
                
                    Add Stationery Stock

                    

                    
                    
                    
                    
                    
                    
                    
                     
                    
                     
                    Stationery Details

                     
                    
                        
                            
                            
                                
                                    Sl.No.
                                    Select Stationery Type
                                    Enter Quantity
                                    
                                
                                













                                
                                
                                Enter the Total Number of Items*
                                
                                
                                
                                
                                
                                                            
                            
                            
                        
                    
                

            

        
        
    


"?>
$(function(){
    $('#addMore').on('click', function() {
            if(count <= max ){
              var data = $("#tb tr:eq(1)").clone(true).appendTo("#tb");
              data.find("input").val('');
               debugger;
              data.find("input")[0].value=++count;
              
            }else{
             alert("Sorry!! Can't add more than fifteen row at a time !!");
           }
              
     });
     $(document).on('click', '.remove', function() {
         var trIndex = $(this).closest("tr").index();
            if(trIndex>1) {
             $(this).closest("tr").remove();
              count--;
             
             // get all the rows in table except header.
             $('#tb tr:not(.tr-header)').each(function(){
             $(this).find('td:first-child input').val(this.rowIndex);
             })
           } else {
             alert("Sorry!! Can't remove first row!");
           }
      });
});

Switi · Accepted Answer

in php all fields passed in $_POST method using you can count number of $_post variable you get when form is submitted

if you have 4 files to insert in database with form then you can count them by using count($_POST) if there is 2 duplicate fields that you want to insert through loop you can execute loop for two time which means count($_POST)/2 but first of all you need to subtract the number of variables that are note related to database like submit button

$count=count($_POST);
$count=($count-1)/2   // subtract 1 for the submit post button

Calculate total number of row in a HTML form

Answers (1)

Related Questions