Add up values and then INSERT into db

[K0108788]

Hi All,

I have the following form:

<form name="ALLOCATION" action="modassess.php?action=addALLOCATION" method="post">
<input type="hidden" name="hidden_project_id" value=<?php echo $projectid; ?>>
<input type="hidden" name="hidden_assess_id" value=<?php echo $assessid; ?>>
  <tr bgcolor="#9AB6F8">
    <td width="26%" bgcolor="#9AB6F8" class="style2"><div align="center"><strong>Project Report Sub-Section </strong></div></td>
    <td width="26%" bgcolor="#9AB6F8" class="style2"><div align="center"><strong>Allocation</strong></div></td>
    <td width="26%" bgcolor="#9AB6F8" class="style2"><div align="center"><strong>Current Allocation </strong></div></td>
  </tr>
  <tr>
    <td width="26%" bgcolor="#E2E2F2" class="style2"><div align="center"><strong>Analysis </strong></div></td>
    <td width="26%" bgcolor="#F2F2FF" class="style2"><div align="center">
      <input name="report_analysis_allocation" type="text" id="report_analysis_allocation" size="4" maxlength="2">
        <span class="style2">%</span></div></td>
    <td width="26%" bgcolor="#F2F2FF" class="style2"><div align="center"><?php echo $rs['report_analysis_allocation']; ?>%</div></td>    

  </tr>
  <tr>
    <td width="26%" bgcolor="#E2E2F2" class="style2"><div align="center"><strong>Design</strong></div></td>
    <td width="26%" bgcolor="#F2F2FF" class="style2"><div align="center">
      <input name="report_design_allocation" type="text" id="report_design_allocation" size="4" maxlength="2">
        <span class="style2">%</span></div></td>
    <td width="26%" bgcolor="#F2F2FF" class="style2"><div align="center"><?php echo $rs['report_design_allocation']; ?>%</div></td>
    </tr>
  <tr>
    <td width="26%" bgcolor="#E2E2F2" class="style2"><div align="center"><strong>Impl/Eval</strong></div></td>
    <td width="26%" bgcolor="#F2F2FF" class="style2"><div align="center">
      <input name="report_impl_eval_allocation" type="text" id="report_impl_eval_allocation" size="4" maxlength="2">
        <span class="style2">%</span></div></td>
    <td width="26%" bgcolor="#F2F2FF" class="style2"><div align="center"><?php echo $rs['report_impl_eval_allocation']; ?>%</div></td>
     <td width="10%" colspan="3" bgcolor="#F2F2FF" class="style2">
      <div align="center"><input name="Add Allocation" type="submit" id="Add Allocation" value="Add"></div>
       </td>
      </form>
     <td width="10%" colspan="3" bgcolor="#F2F2FF" class="style2"><form name="REMOVE ALLOCATION" action="modassess.php?action=removeALLOCATION" method="post">
         <div align="center" class="style2"><input name="Remove Allocation" align="middle" type="submit" id="Remove Allocation" value="Remove"></div>
         <input type="hidden" name="hidden_project_id" value=<?php echo $projectid; ?>>
         <input type="hidden" name="hidden_assess_id" value=<?php echo $assessid; ?>></form>
		 </td>
    </tr>
</table>

I want to add the following values in this form:

$rs['report_analysis_allocation'] + $rs['report_design_allocation'] + $rs['report_impl_eval_allocation']

and then assign a variable to the total so that it will POST.

Any help appreciated.

[zac1333]

I'm no expert by any means, but I'm assuming you could do something like this on the page that the data is posted to:

$rs1=$_POST['report_analysis_allocation'];
$rs2=$_POST['report_design_allocation'];
$rs3=$_POST['report_impl_eval_allocation'];
$rscalc=$rs1+rs2+rs3

Someone please correct me if I'm wrong. Just trying to help out any way I can. 🙂

[bpat1434]

<?php $total = $rs['report_analysis_allocation'] + $rs['report_design_allocation'] + $rs['report_impl_eval_allocation']; ?>
<input type="hidden" name="total" value="<?php echo $total; ?>">

Zac, you were on the right track...