Databases
StackOverflow2013
Postsdbo
POi want to display all checkboxes value which are checked
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POi want to display all checkboxes value which are checked
    primarykey
    data
    text
    <p>I want to display all checked checkboxes in php.</p> <pre><code>&lt;script&gt; function RequestObject () { var ReturnValue = null; try { ReturnValue = new ActiveXObject("Microsoft.XMLHTTP"); } catch (Error) { try { ReturnValue = new ActiveXObject("MSXML2.HTTP"); } catch (Error) { try { ReturnValue = new XMLHttpRequest(); } catch (Error) { // failed return null; } } } return ReturnValue; } var requestObj = null; function coajax(sender) { requestObj = RequestObject(); if (requestObj) { sender.enabled = false; // so a user cannot change till request finished requestObj.open('get', '&lt;?php echo get_template_directory_uri(); ?&gt;/lunch_dinner.php?lid=' + sender.value, true); requestObj.onreadystatechange = coajax_finish; requestObj.send(null); } } function coajax_finish() { if (requestObj.readyState == 4) { document.getElementById('ldb_target').innerHTML = requestObj.responseText; document.getElementById('ldb').enabled = true; } } function getDays(select){ var selectedString = select.options[select.selectedIndex].value; if(selectedString == "Bespoke Days"){ document.getElementById("days_target").style.display = "block"; } else { document.getElementById("days_target").style.display = "none"; } } function validateForm() { var x=document.forms["form1"]["contract"].value; if (x==null || x=="" || x=="Select Contract") { alert("Oh, you forgot to select contract type! :)"); return false; } var x=document.forms["form1"]["days"].selectedIndex; if (x&lt;1) { alert("Please select days"); return false; } else if(x==4) { // fifth entry var checked = false, chk = document.forms["form1"]["day"]; for (var i = 0; i &lt; chk.length; i++) { if (chk[i].checked) { checked=true; break } } if (!checked) { alert("At least one day should be checked."); return false; } } var x=document.forms["form1"]["ldb"].value; if (x==null || x=="" || x=="Select") { alert("Oh, you forgot to select lunch-dinner! :)"); return false; } var x=document.forms["form1"]["ldb"].value; if(x=="Lunch" || x=="Both") { var y=document.forms["form1"]["lunch"].value; if(y=="Lunch") { alert("Oh, you forgot to select lunch time! :)"); return false; } } var x=document.forms["form1"]["ldb"].value; if(x=="Dinner" || x=="Both") { var y=document.forms["form1"]["dinner"].value; if(y=="Dinner") { alert("Oh, you forgot to select dinner time! :)"); return false; } } var x=document.forms["form1"]["phone"].value; if (x==null || x=="") { alert("Oh, you forgot to enter your Phone Number! :)"); return false; } var x = document.form1.phone.value; if(isNaN(x)||x.indexOf(" ")!=-1) { alert("Please enter Numaric value in contact number.") return false; } var x=document.forms["form1"]["meal"].value; if (x==null || x=="" || x=="Select Meal") { alert("Oh, you forgot to select meal preference! :)"); return false; } var x=document.forms["form1"]["fnm"].value; if (x==null || x=="") { alert("Oh, you forgot to enter your Full Name! :)"); return false; } var x=document.forms["form1"]["pcod"].value; if (x==null || x=="") { alert("Oh, you forgot to enter your Postal Code! :)"); return false; } var x=document.forms["form1"]["email"].value; if (x==null || x=="") { alert("Oh, you forgot to enter your Email Address! :)"); return false; } var x=document.forms["form1"]["email"].value; var atpos=x.indexOf("@"); var dotpos=x.lastIndexOf("."); if (atpos&lt;1 || dotpos&lt;atpos+2 || dotpos+2&gt;=x.length) { alert("Excuse me! Valid Email Address Please!"); return false; } var x=document.forms["form1"]["add"].value; if (x==null || x=="") { alert("Oh, you forgot to enter your Address! :)"); return false; } var x=document.forms["form1"]["rate"].value; if (x==null || x=="") { alert("Oh, you forgot to enter Rate! :)"); return false; } var x=document.forms["form1"]["rate"].value; if(isNaN(x)||x.indexOf(" ")!=-1) { alert("Please enter Numaric value in Rate.") return false; } var x=document.forms["form1"]["amount"].value; if (x==null || x=="") { alert("Oh, you forgot to enter Amount! :)"); return false; } var x=document.forms["form1"]["amount"].value; if(isNaN(x)||x.indexOf(" ")!=-1) { alert("Please enter Numaric value in Total Amount.") return false; } } function calculateTotal(rate) { var rate=(document.forms["form1"]["rate"].value) * 1.03; document.forms["form1"]["amount"].value = rate; } &lt;/script&gt; </code></pre> <p>HTML:</p> <pre><code>&lt;form method="POST" action="" name="form1" onsubmit="return validateForm();"&gt; &lt;table class="order-paypal" width="100%"&gt; &lt;tr&gt; &lt;td&gt;&lt;span&gt;Choose contract&lt;/span&gt;&lt;/td&gt; &lt;td&gt; &lt;select name="contract"&gt; &lt;option value="Select Contract" selected&gt;Select Contract&lt;/option&gt; &lt;option value="7 meal veg contract"&gt;7 meal veg contract&lt;/option&gt; &lt;option value="7 meal nonveg contract"&gt;7 meal nonveg contract&lt;/option&gt; &lt;option value="7 meal nonveg contract"&gt;7 meal nonveg contract&lt;/option&gt; &lt;option value="8 meal veg contract"&gt;8 meal veg contract&lt;/option&gt; &lt;option value="8 meal nonveg contract"&gt;8 meal nonveg contract&lt;/option&gt; &lt;option value="8 meal mix contract"&gt;8 meal mix contract&lt;/option&gt; &lt;option value="9 meal veg contract"&gt;9 meal veg contract&lt;/option&gt; &lt;option value="9 meal nonveg contract "&gt;9 meal nonveg contract &lt;/option&gt; &lt;option value="9 meal mix contract "&gt;9 meal mix contract &lt;/option&gt; &lt;option value="30 meal veg contract"&gt;30 meal veg contract&lt;/option&gt; &lt;option value="30 meal nonveg contract"&gt;30 meal nonveg contract&lt;/option&gt; &lt;option value="30 meal mix contract"&gt;30 meal mix contract&lt;/option&gt; &lt;option value="Book-a-cook service"&gt;Book-a-cook service&lt;/option&gt; &lt;option value="Extra roti/rice/dal/vegetable"&gt;Extra roti/rice/dal/vegetable&lt;/option&gt; &lt;/select&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;span&gt;Please enter days required&lt;/span&gt;&lt;/td&gt; &lt;td&gt; &lt;select name="days" id="days" onchange="getDays(this)"&gt; &lt;option value="Select Days" selected&gt;Select Days&lt;/option&gt; &lt;option value="Mon-Fri"&gt;Mon-Fri&lt;/option&gt; &lt;option value="Mon-Sat"&gt;Mon-Sat&lt;/option&gt; &lt;option value="Mon-Sun"&gt;Mon-Sun&lt;/option&gt; &lt;option value="Bespoke Days"&gt;Bespoke Days&lt;/option&gt; &lt;/select&gt; &lt;ul id="days_target" style="display:none;"&gt; &lt;span&gt;Select Days&lt;/span&gt; &lt;li&gt;&lt;input type="checkbox" name="day[]" value="mon"/&gt;Monday&lt;/li&gt; &lt;li&gt;&lt;input type="checkbox" name="day[]" value="tue"/&gt;Tueday&lt;/li&gt; &lt;li&gt;&lt;input type="checkbox" name="day[]" value="wed"/&gt;Wednesday&lt;/li&gt; &lt;li&gt;&lt;input type="checkbox" name="day[]" value="thr"/&gt;Thursday&lt;/li&gt; &lt;li&gt;&lt;input type="checkbox" name="day[]" value="fri"/&gt;Friday&lt;/li&gt; &lt;li&gt;&lt;input type="checkbox" name="day[]" value="sat"/&gt;Saturday&lt;/li&gt; &lt;li&gt;&lt;input type="checkbox" name="day[]" value="sun"/&gt;Sunday&lt;/li&gt; &lt;/ul&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;span&gt;Please mention Lunch or Dinner or both&lt;/span&gt;&lt;/td&gt; &lt;td&gt; &lt;select name="ldb" id="ldb" onchange="coajax(this);" &gt; &lt;option value="Select" selected&gt;Select&lt;/option&gt; &lt;option value="Lunch"&gt;Lunch&lt;/option&gt; &lt;option value="Dinner"&gt;Dinner&lt;/option&gt; &lt;option value="Both"&gt;Both&lt;/option&gt; &lt;/select&gt; &lt;span id="ldb_target"&gt;&lt;/span&gt;&lt;br/&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;span&gt;Please mention your contact number&lt;/span&gt;&lt;/td&gt; &lt;td&gt;&lt;input type="text" name="phone" /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;span&gt;Please mention your meal preference&lt;/span&gt;&lt;/td&gt; &lt;td&gt; &lt;select name="meal" &gt; &lt;option value="Select Meal" selected&gt;Select Meal&lt;/option&gt; &lt;option value="Punjabi"&gt;Punjabi&lt;/option&gt; &lt;option value="Gujarati"&gt;Gujarati&lt;/option&gt; &lt;/select&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td style="vertical-align:top;"&gt;&lt;span&gt;Please mention any dietary requirements&lt;/span&gt;&lt;/td&gt; &lt;td&gt;&lt;input type="text" name="req" &gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;span&gt;Full name&lt;/span&gt;&lt;/td&gt; &lt;td&gt;&lt;input type="text" name="fnm" &gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;span&gt;Address&lt;/span&gt;&lt;/td&gt; &lt;td&gt;&lt;textarea name="add" &gt;&lt;/textarea&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;span&gt;Postal code&lt;/span&gt;&lt;/td&gt; &lt;td&gt;&lt;input type="text" name="pcod" &gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;span&gt;Email&lt;/span&gt;&lt;/td&gt; &lt;td&gt;&lt;input type="text" name="email" &gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;span&gt;Enter amount to pay&lt;/span&gt;&lt;/td&gt; &lt;td&gt; &lt;input type="text" name="rate" &gt; &lt;br /&gt; (&lt;a target="_blank" href="http://www.infozzle.com/yatin/tifffin_planet/prices-and-offers-2/"&gt;Check the rate of your item and your zone&lt;/a&gt;) &lt;br/&gt; Card charge: 3% of the total amount &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;span&gt;Total Amount&lt;/span&gt;&lt;/td&gt; &lt;td&gt;&lt;input type="text" name="amount" value="Click here to see total amount" onclick="calculateTotal(this);"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&amp;nbsp;&lt;/td&gt; &lt;td&gt; &lt;table class="submit"&gt; &lt;tr&gt; &lt;td&gt;&lt;input type="submit" value="Submit" name="submitbtn" class="submit-payment"/&gt;&lt;/td&gt; &lt;td&gt;&lt;input type="reset" value="Reset" class="submit-reset"/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/form&gt; </code></pre> <p>I want to display all checked checkboxes of "day" on action page by this code:</p> <pre><code>&lt;?php foreach($day as $k) { echo $k.","; } ?&gt; </code></pre> <p>html Form and action page are in template page of wordpress. but it doesn't work.how to do?i have written this code.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USAvnee.Angel
    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
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POi want to display all checkboxes value which are checked
      1. USAvnee.Angel
      1. VTFavorite
    1. COdo you have the <form> tags in your html? please show the complete code.
      singulars
      1. POi want to display all checkboxes value which are checked
      1. USJibran K
    2. COAre you submitting your form ? Show your complete form ?
      singulars
      1. POi want to display all checkboxes value which are checked
      1. USRikesh
    3. COI did this with a submit button by submitting the form. It works cool
      singulars
      1. POi want to display all checkboxes value which are checked
      1. USEdwin Alex
 

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