Dynamic php and html form with qty price and total JavaScript calculations

Question

So, I have form fields and a table that adjusts depending on how many results.

The form has name, qty, price and total price for each column.

The php and sql in a loop obviously this can make the list bigger or smaller depending on how many products are in the database at the time.

I am not sure how to go about this. I know how to calculate form fields that are static but what about ones that are in a php loop and i dont know how many form fields there will be everytime as this changes when products are added into the database or removed.

So my html and php is:

    
       
           
              
                    Product Ordering For 
               
               
               
                    ";
    $dbh = mysql_connect ("$dbhost", "$dbuser", "$dbpass") or die ('Database connection failed because: ' . mysql_error());
    mysql_select_db ("nfw_leads");
    $page = $_GET['page'];
    if(!$page || $page == 0 || !is_numeric($page)){
        $page = 1;
    }
    $limit = '600';
    class paginate{
        function init($limit, $page){
            $UserID1 = ($_SESSION['UserID']);
            $service_id = trim($_GET['service_id']);
            $query1 = mysql_query("SELECT * FROM nfw_inventory WHERE stoc_department_id = '$service_id'");
            $UserID1 = ($_SESSION['UserID']);
            $total_pages = ceil(mysql_num_rows($query1)/$limit);
            $prev = 'Prev   ';
            $next = 'Next   ';

            //Danger
            //                               

            if($page <= 1){
                $page = 1;
                $prev = '';
            }
            elseif($page >= $total_pages){
                $page = $total_pages;
                $next = '';
            }
            if($page > 2){
                $prev = 'First   ' . $prev;
            }
            if($page < ($total_pages - 1)){
                $next = $next . 'Last   ';
            }
            $start = ($limit*($page-1));
            $UserID1 = ($_SESSION['UserID']);
            $service_id = trim($_GET['service_id']);
            $query2 = mysql_query("SELECT * FROM nfw_inventory WHERE stoc_department_id = '$service_id'");
            $times_done=0;
            while($row = mysql_fetch_array($query2)) {
                if($times_done=='5'){
                    $content .= '';
                    $times_done=1;
                }
                else{
                    $times_done++;
                }
                $content .= "$activeallow";
            }
            return $content;
        }
    }
    $class = &new paginate;
    echo $class->init($limit, $page); 
?>

                    
                    
                       Franchise
                       QTY
                       Price Each
                       Price Total
                       
                    
                       
                       
                    
                    

 " . $row['stoc_desc'] . "

So where $content is down the bottom. thats where it loops out the form fields which has name, qty, price, total price.

Question is, how would i go about having it so they can add each other up.

after i work that part out, there will be a static "order total" field outside the loop down the bottom where all the total price columns add up and go into it.

Really got my stumped on how to do this.

Refugnic Eternium · Accepted Answer

Seeing how this question doesn't have any answer yet:

I suggest, giving the input fields an array-name. In a PHP loop, this looks like this:

for($i = 0; $i < 5; ++$i)
    echo "Field Nr $i
";

The important thing here is the [].

After submitting the form, you can fetch all dynamic fields by querying $_POST (or $_GET)

$dynamicFields = $_POST["DynamicField"];

This will give you all the fields, indexed in the order as they appeared in the original file. (So Field Nr. 0 has the index 0 etc.)

As for JS, you can use getElementsByName.

var dynamicFields = document.getElementsByName("DynamicField[]");

This will give you an array of references to the dynamic fields, ready for you to use. Please be advised that entering a specific index into the brackets will break the JS implementation.

Dynamic php and html form with qty price and total JavaScript calculations

Answers (1)

Related Questions