Databases
StackOverflow2013
Postsdbo
POFetching the particular values from a table onclick of checkbox in php
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POFetching the particular values from a table onclick of checkbox in php
    text
    copied!<p>My table has the following structure <img src="https://i.stack.imgur.com/xe9vw.png" alt="enter image description here"></p> <p>When i click the particular checkbox.Its should be able to fetch the value of all the contents in the selected checkbox ..It can be n number of products the user selects.How to achieve this .... Thanks for ur time</p> <p>Source code</p> <pre><code> &lt;?$this-&gt;load-&gt;view('admin/header');?&gt; &lt;script type="text/javascript"&gt; function go() { var frm = document.frm; var status = inwardProductList['status']; var statusList = []; for ( i = 0; i &lt; status.length; i++ ) { if ( status[i].checked ) { statusList.push('status=' + status[i].value); } } document.getElementById('test').innerHTML = 'ajaxUrl?' + statusList.join('&amp;'); } &lt;/script&gt; &lt;script src="&lt;?=base_url();?&gt;js/calendar.js" type="text/javascript"&gt;&lt;/script&gt; &lt;form name="inwardProductList" action="" method="post" &gt; &lt;table width="100%" border="0" cellpadding="0" cellspacing="0" align="center" class="formtable"&gt; &lt;tr&gt; &lt;td height="23" colspan="8" align="center" valign="middle" bgcolor="#FFFFFF" class="rows"&gt;&lt;b&gt;Cart Display&lt;/b&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td height="66" align="left" valign="top"&gt;&lt;table width="99%" id="suppliedtable" border="0" align="center" cellpadding="0" cellspacing="0"&gt; &lt;tr&gt; &lt;td width="4%" height="43" align="center" valign="middle" bgcolor="#e7e6e6" class="rows"&gt;&lt;strong&gt;Sl.no&lt;/strong&gt;&lt;/td&gt; &lt;td width="20%" align="center" valign="middle" bgcolor="#e7e6e6" class="rows"&gt;&lt;strong&gt;Product Name&lt;/strong&gt;&lt;/strong&gt;&lt;/td&gt; &lt;td width="20%" align="center" valign="middle" bgcolor="#e7e6e6" class="rows"&gt;&lt;strong&gt;Barcode&lt;/strong&gt;&lt;/td&gt; &lt;td width="8%" align="center" valign="middle" bgcolor="#e7e6e6" class="rows"&gt;&lt;strong&gt;Selection&lt;/strong&gt;&lt;/strong&gt;&lt;/td&gt; &lt;td width="8%" align="center" valign="middle" bgcolor="#e7e6e6" class="rows"&gt;&lt;strong&gt;Quantity&lt;/strong&gt;&lt;/strong&gt;&lt;/td&gt; &lt;/tr&gt; &lt;? $i=0; if($productName-&gt;num_rows() &gt;0){ foreach($productName-&gt;result() as $row ){ $i++; ?&gt; &lt;tr&gt; &lt;td align="left" valign="middle" bgcolor="#FFFFFF" class="rows"&gt;&lt;?=$i;?&gt;&lt;/td&gt; &lt;td align="left" valign="middle" bgcolor="#FFFFFF" class="rows"&gt;&lt;?=$row-&gt;product_name?&gt;&lt;/td&gt; &lt;td align="left" valign="middle" bgcolor="#FFFFFF" class="rows"&gt;&lt;?=$row-&gt;barcode?&gt;&lt;/td&gt; &lt;td align="left" valign="middle" bgcolor="#FFFFFF" class="rows"&gt;&lt;form&gt; &lt;input type="checkbox" name="status" value="yes" /&gt; Yes&lt;br /&gt;&lt;/form&gt;&lt;/td&gt; &lt;td align="left" valign="middle" bgcolor="#FFFFFF" class="rows"&gt;&lt;form&gt;Quantity: &lt;input type="text" name="Qunatity" /&gt;&lt;/form&gt;&lt;/td&gt; &lt;/tr&gt; &lt;? }}else{?&gt; &lt;tr&gt; &lt;td height="23" colspan="8" align="center" valign="middle" bgcolor="#FFFFFF" class="rows"&gt;&lt;b&gt;Selected product has not been processed yet&lt;/b&gt;&lt;/td&gt; &lt;/tr&gt; &lt;?}?&gt; &lt;/table&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;form&gt;&lt;tr&gt;&lt;td align="center" &gt; &lt;button onclick="go()"&gt;go&lt;/button&gt;&lt;/td&gt; &lt;/tr&gt; &lt;div id="test"&gt;&lt;/div&gt; &lt;/form&gt;&lt;/form&gt; &lt;/form&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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