Databases
StackOverflow2013
Postsdbo
POSubmitting the values of two forms from one submit button
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSubmitting the values of two forms from one submit button
    primarykey
    data
    text
    <p>I have created three forms in html the first one is the simple forms and the other's adds table rows dynamically on a button click but I want to save both the form when I press the save button which is on the first form. Is it possible to do it using PHP? I searched Google and found something like jQuery but even that doesn't seems to work can anyone help? Here is my script:</p> <pre><code>&lt;script&gt; $(document).ready(function() { $("#submit").click(function() { $.post($("#form1").attr("action"), $("#form1").serialize(), function() { $.post($("#form2").attr("action"), $("#form1").serialize(), function() { $.post($("#form3").attr("action"), $("#form2").serialize(), function() { alert('Both forms submitted'); }); }); }); }); }); &lt;/script&gt; &lt;table border="1" align="right"&gt; &lt;tr&gt; &lt;td&gt; &lt;input class="cmdsave" type="submit" id="submit" name="save" value="Save" /&gt; &lt;/td&gt; &lt;td&gt; &lt;/td&gt; &lt;td&gt; &lt;input class="cmdexit" type="button" onClick="window.history.back()" value="Exit" /&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/nav&gt; &lt;body onLoad="document.machine.code.focus()"&gt; &lt;div id="content"&gt; &lt;section class="tab" id="home"&gt; &lt;!--&lt;center&gt;&lt;font size="5px" color="#6B6A68"&gt;&lt;strong&gt;Customer - Add&lt;/strong&gt;&lt;/font&gt;&lt;/center&gt; --&gt; &lt;form action="quotation.php" class="general2" align="left" name="quot" id="form1" method="POST"&gt; &lt;input type="hidden" name="vouchno" value="&lt;?php echo ($addflag == 0) ? $get['vouchno'] : ""; ?&gt;"&gt; &lt;table border="0px" width="100%"&gt; &lt;tr&gt; &lt;td&gt;&lt;br/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td width="200px" align="right"&gt;&lt;label for=""&gt;&lt;font color="0099FF" size="3px"&gt;Quotation No.&lt;/font&gt;&lt;span&gt;&lt;/span&gt;&lt;/label&gt;&lt;/td&gt; &lt;td align="left"&gt;&lt;input type="text" size="6" maxlength="6" id="code" maxlength="6" name="code" value="&lt;?php echo ($addflag == 0) ? $get['code'] : ""; ?&gt;" class="form-input-code" /&gt; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;label for=""&gt;&lt;font color="0099FF" size="3px"&gt; Date &lt;/font&gt;&lt;span&gt;&lt;/span&gt;&lt;/label&gt;&lt;input type="date" size="80" name="oildate" value="&lt;?php echo ($addflag == 0) ? $get['vouchdt'] : $today; ?&gt;"/&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td width="200px" align="right"&gt;&lt;label for=""&gt;&lt;font color="0099FF" size="3px"&gt;Party Name &lt;/font&gt;&lt;span&gt;&lt;/span&gt;&lt;/label&gt;&lt;/td&gt; &lt;td align="left"&gt;&lt;select data-placeholder="Party" style="width:332px;" name="cmbparty" class="chzn-select-deselect" onChange="showyear('party.php?code='+this.value);"&gt; &lt;option value="&lt;?php echo ($addflag == 0) ? $get['party'] : ""; ?&gt;"&gt;&lt;?php echo ($addflag == 0) ? $get['party'] : ""; ?&gt;&lt;/option&gt; &lt;?php $mown = mysql_query("SELECT accode, `name` FROM accmast WHERE grpcode='010'") or die(mysql_error()); while($trow = mysql_fetch_array($mown)){ echo "&lt;option value=$trow[accode]&gt;$trow[name]&lt;/option&gt;"; } ?&gt; &lt;/select&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td colspan="9"&gt; &lt;div id="parthint" style=""&gt;&lt;/div&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td width="200px" align="right"&gt;&lt;label for=""&gt;&lt;font color="" size="3px"&gt;Ref. No. &lt;/font&gt;&lt;span&gt;&lt;/span&gt;&lt;/label&gt;&lt;/td&gt; &lt;td align="left"&gt;&lt;input type="text" id="refno" size="20" maxlength="20" name="refno" value="&lt;?php echo ($addflag == 0) ? $get['refno'] : ""; ?&gt;" class="form-input-c20"/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td width="200px" align="right"&gt;&lt;label for=""&gt;&lt;font color="" size="3px"&gt;Kindly Attn. &lt;/font&gt;&lt;span&gt;&lt;/span&gt;&lt;/label&gt;&lt;/td&gt; &lt;td align="left"&gt;&lt;input type="text" id="refno" size="20" maxlength="80" name="attn" value="&lt;?php echo ($addflag == 0) ? $get['attn'] : ""; ?&gt;" class="form-input-add"/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td width="200px" align="right"&gt;&lt;label for=""&gt;&lt;font color="" size="3px"&gt;Subject. &lt;/font&gt;&lt;span&gt;&lt;/span&gt;&lt;/label&gt;&lt;/td&gt; &lt;td align="left"&gt;&lt;textarea name="subject" rows="3" cols="70" class="form-input-textarea"&gt;&lt;?php echo ($addflag == 0) ? $get['subject'] : ""; ?&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td colspan="9"&gt; &lt;hr /&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td width="200px" align="right"&gt;&lt;label for=""&gt;&lt;font color="0099FF" size="3px"&gt;Dear Sir / Madam, &lt;/font&gt;&lt;span&gt;&lt;/span&gt;&lt;/label&gt;&lt;/td&gt; &lt;td&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;/td&gt; &lt;td align="left"&gt;&lt;textarea name="msg" cols="70" class="form-input-textareaxl"&gt;&lt;?php echo ($addflag == 0) ? $get['message'] : ""; ?&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td width="200px" align="right"&gt;&lt;label for=""&gt;&lt;font color="0099FF" size="3px"&gt;Status&lt;/font&gt;&lt;span&gt;&lt;/span&gt;&lt;/label&gt;&lt;/td&gt; &lt;td align="left"&gt;&lt;select data-placeholder="Status" style="width:332px;" name="cmbstatus" class="chzn-select-deselect"&gt; &lt;option value="&lt;?php echo ($addflag == 0) ? $get['status'] : ""; ?&gt;"&gt;&lt;?php echo ($addflag == 0) ? $get['status'] : ""; ?&gt;&lt;/option&gt; &lt;option value="&lt;?php echo ($addflag == 0) ? $get['status'] : "Pending"; ?&gt;"&gt;&lt;?php echo ($addflag == 0) ? $get['status'] : "Pending"; ?&gt;&lt;/option&gt; &lt;option value="&lt;?php echo ($addflag == 0) ? $get['status'] : "Approved"; ?&gt;"&gt;&lt;?php echo ($addflag == 0) ? $get['status'] : "Approved"; ?&gt;&lt;/option&gt; &lt;option value="&lt;?php echo ($addflag == 0) ? $get['status'] : "Rejected"; ?&gt;"&gt;&lt;?php echo ($addflag == 0) ? $get['status'] : "Rejected"; ?&gt;&lt;/option&gt; &lt;/select&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td width="200px" align="right"&gt;&lt;label for=""&gt;&lt;font color="" size="3px"&gt;Remarks. &lt;/font&gt;&lt;span&gt;&lt;/span&gt;&lt;/label&gt;&lt;/td&gt; &lt;td align="left"&gt;&lt;textarea name="rem" rows="3" cols="70" class="form-input-textarea"&gt;&lt;?php echo ($addflag == 0) ? $get['subject'] : ""; ?&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;br/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;/td&gt;&lt;td&gt; &lt;/td&gt; &lt;td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/form&gt; &lt;/section&gt; &lt;section class="tab" id="company"&gt;&lt;/section&gt; &lt;section class="tab" id="portfolio"&gt; &lt;form action="quotation.php" class="general2" align="left" name="quot2" id="form2" method="POST"&gt; &lt;table border="1px" width="90%" id="data"&gt; &lt;tr&gt; &lt;td&gt;&lt;br /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;br /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td width="130px" align="center"&gt;&lt;label for=""&gt;&lt;font color="#0099FF" size="3px"&gt;Order&lt;/font&gt;&lt;span&gt;&lt;/span&gt;&lt;/label&gt;&lt;/td&gt; &lt;td width="130px" align="center"&gt;&lt;label for=""&gt;&lt;font color="#0099FF" size="3px"&gt;Sr No.&lt;/font&gt;&lt;span&gt;&lt;/span&gt;&lt;/label&gt;&lt;/td&gt; &lt;td width="580px" align="center"&gt;&lt;label for=""&gt;&lt;font color="#0099FF" size="3px"&gt;Description&lt;/font&gt;&lt;span&gt;&lt;/span&gt;&lt;/label&gt;&lt;/td&gt; &lt;td width="130px" align="center"&gt;&lt;label for=""&gt;&lt;font color="#0099FF" size="3px"&gt;Unit&lt;/font&gt;&lt;span&gt;&lt;/span&gt;&lt;/label&gt;&lt;/td&gt; &lt;td width="130px" align="center"&gt;&lt;label for=""&gt;&lt;font color="#0099FF" size="3px"&gt;Rate&lt;/font&gt;&lt;span&gt;&lt;/span&gt;&lt;/label&gt;&lt;/td&gt; &lt;/tr&gt; &lt;?php if($addflag==0){ $qry = mysql_query("SELECT * FROM `quotdtl` WHERE vouchno='$getvouch'") or die(mysql_error()); $ctr = 0; while ($row = mysql_fetch_array($qry)) { echo "&lt;td align=\"center\"&gt;&lt;input type=\"text\" size=\"6\" maxlength=\"6\" id=\"code\" maxlength=\"6\" name=\"ord_$ctr\" value=\"$row[orderby]\" class=\"form-input-oth\" /&gt;&lt;/td&gt;"; echo "&lt;td align=\"center\"&gt;&lt;input type=\"text\" size=\"6\" maxlength=\"6\" id=\"code\" maxlength=\"6\" name=\"srno_$ctr\" value=\"$row[srno]\" class=\"form-input-oth\" /&gt;&lt;/td&gt;"; echo "&lt;td align=\"center\"&gt;&lt;textarea name=\"descrip_1\" cols=\"70\" class=\"form-input-textarea\"&gt;$row[descrip]&lt;/textarea&gt;&lt;/td&gt;"; echo "&lt;td align=\"center\"&gt;&lt;input type=\"text\" size=\"6\" maxlength=\"9\" id=\"code\" maxlength=\"6\" name=\"unit_$ctr\" value=\"$row[unit]\" class=\"form-input-rate\"/&gt;&lt;/td&gt; "; echo "&lt;td align=\"center\"&gt;&lt;input type=\"text\" size=\"6\" maxlength=\"9\" id=\"code\" maxlength=\"6\" name=\"rate_$ctr\" value=\"$row[rate]\" class=\"form-input-rate\" /&gt;&lt;/td&gt;"; $ctr++; } }else{ ?&gt; &lt;tr&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="6" id="code" maxlength="6" name="ord_1" value="" class="form-input-oth" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="6" id="code" maxlength="6" name="srno_1" value="" class="form-input-oth" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;textarea name="descrip_1" cols="20" class="form-input-textarea"&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="9" id="code" maxlength="6" name="unit_1" value="" class="form-input-rate" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="9" id="code" maxlength="6" name="rate_1" value="" class="form-input-rate" /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="6" id="code" maxlength="6" name="ord_2" value="" class="form-input-oth" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="6" id="code" maxlength="6" name="srno_2" value="" class="form-input-oth" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;textarea name="descrip_2" cols="20" class="form-input-textarea"&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="9" id="code" maxlength="6" name="unit_2" value="" class="form-input-rate" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="9" id="code" maxlength="6" name="rate_2" value="" class="form-input-rate" /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="6" id="code" maxlength="6" name="ord_3" value="" class="form-input-oth" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="6" id="code" maxlength="6" name="srno_3" value="" class="form-input-oth" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;textarea name="descrip_3" cols="20" class="form-input-textarea"&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="9" id="code" maxlength="6" name="unit_3" value="" class="form-input-rate" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="9" id="code" maxlength="6" name="rate_3" value="" class="form-input-rate" /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="6" id="code" maxlength="6" name="ord_4" value="" class="form-input-oth" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="6" id="code" maxlength="6" name="srno_4" value="" class="form-input-oth" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;textarea name="descrip_4" cols="20" class="form-input-textarea"&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="9" id="code" maxlength="6" name="unit_4" value="" class="form-input-rate" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="9" id="code" maxlength="6" name="rate_4" value="" class="form-input-rate" /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="6" id="code" maxlength="6" name="ord_5" value="" class="form-input-oth" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="6" id="code" maxlength="6" name="srno_5" value="" class="form-input-oth" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;textarea name="descrip_5" cols="20" class="form-input-textarea"&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="9" id="code" maxlength="6" name="unit_5" value="" class="form-input-rate" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="9" id="code" maxlength="6" name="rate_5" value="" class="form-input-rate" /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="6" id="code" maxlength="6" name="ord_6" value="" class="form-input-oth" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="6" id="code" maxlength="6" name="srno_6" value="" class="form-input-oth" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;textarea name="descrip_6" cols="20" class="form-input-textarea"&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="9" id="code" maxlength="6" name="unit_6" value="" class="form-input-rate" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="9" id="code" maxlength="6" name="rate_6" value="" class="form-input-rate" /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="6" id="code" maxlength="6" name="ord_7" value="" class="form-input-oth" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="6" id="code" maxlength="6" name="srno_7" value="" class="form-input-oth" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;textarea name="descrip_7" cols="20" class="form-input-textarea"&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="9" id="code" maxlength="6" name="unit_7" value="" class="form-input-rate" /&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;input type="text" size="6" maxlength="9" id="code" maxlength="6" name="rate_7" value="" class="form-input-rate" /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;?php }?&gt; &lt;/table&gt; &amp;nbsp;&lt;input type="button" id="addnew" class="classname" name="addnew" value="+" /&gt; &lt;input type="hidden" id="items" name="items" value="&lt;?php echo ($addflag == 0) ? $ctr : 7; ?&gt;" /&gt; &lt;/form&gt; &lt;/section&gt; &lt;section class="tab" id="contact"&gt; &lt;form action="quotation.php" class="general2" align="left" name="quot2" id="form3" method="POST"&gt; &lt;table border="1px" width="90%" id="data2"&gt; &lt;tr&gt; &lt;td&gt;&lt;br /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td width="" align="left"&gt;&lt;label for=""&gt;&lt;font color="#0099FF" size="3px"&gt;Notes,&lt;/font&gt;&lt;span&gt;&lt;/span&gt;&lt;/label&gt;&lt;/td&gt; &lt;td&gt;&lt;/td&gt;&lt;td&gt;&lt;/td&gt; &lt;/tr&gt; &lt;?php if($addflag==0){ $qry = mysql_query("SELECT * FROM `quotnotes` WHERE vouchno='$getvouch'") or die(mysql_error()); $mctr = 0; while ($rownote = mysql_fetch_array($qry)) { echo "&lt;td align=\"left\"&gt;&lt;textarea name=\"note_1\" cols=\"80\" class=\"form-input-textareaxxl\"&gt;$rownote[notes]&lt;/textarea&gt;&lt;/td&gt;"; $mctr++; } }else{ ?&gt; &lt;tr&gt;&lt;/tr&gt; &lt;tr&gt; &lt;td align="left"&gt;&lt;textarea name="note_1" cols="80" class="form-input-textareaxxl"&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="left"&gt;&lt;textarea name="note_2" cols="80" class="form-input-textareaxxl"&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="left"&gt;&lt;textarea name="note_3" cols="80" class="form-input-textareaxxl"&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="left"&gt;&lt;textarea name="note_4" cols="80" class="form-input-textareaxxl"&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="left"&gt;&lt;textarea name="note_5" cols="80" class="form-input-textareaxxl"&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;/tr&gt; &lt;?php }?&gt; &lt;/table&gt; &amp;nbsp;&lt;input type="button" id="addnew2" class="classname" name="addnew" value="+" /&gt; &lt;input type="hidden" id="h" name="h" value="&lt;?php echo ($addflag == 0) ? $mctr : 5; ?&gt;" /&gt; &lt;/form&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USsuhail
    1. USsuhail
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSubmitting the values of two forms from one submit button
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COPlease show us your HTML code
      singulars
      1. POSubmitting the values of two forms from one submit button
      1. USRoger
    2. COcheck http://api.jquery.com/jQuery.when/
      singulars
      1. POSubmitting the values of two forms from one submit button
      1. USrab
    3. COPlease show full code with your forms
      singulars
      1. POSubmitting the values of two forms from one submit button
      1. USShijin
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload