<div>
You can have multiple loops. If you have two series of checkboxes &quot;created[]&quot; and &quot;foo[]&quot;, you can do like this: 

<pre><code class="code-10 nolinks" id="code-265556">$create = $_POST['create'];
foreach ($create as $id) {
 $query = &quot;INSERT INTO gradings (grading_id, id, date) VALUES ('', '$id', '')&quot;;
 $result = mysql_query($query) or die (mysql_error());
}
 
$foo = $_POST['foo'];
foreach ($foo as $id) {
 $query = &quot;INSERT INTO foo (some_id, id, date) VALUES ($some_id, '$id', now())&quot;;
 $result = mysql_query($query) or die (mysql_error());
}
</code></pre>
</div>

<div>
its not a good practice to call insert statement in a loop. you should only build the statement in a loop and pass it to the database server only once after the loop. like this: 

<pre><code class="code-10 nolinks" id="code-265832">$create = $_POST['create'];
$query = array();
foreach ($create as $id) {
 $query[] = &quot;('', '$id', '')&quot;;
}
$sql = &quot;INSERT INTO gradings VALUES &quot;.implode(&quot;,&quot;, $query);
$result = mysql_query($sql) or die (mysql_error());
 
$foo = $_POST['foo'];
$query = array();
foreach ($foo as $id) {
 $query[] = &quot;($some_id, '$id', now())&quot;;
}
$sql = &quot;INSERT INTO foo VALUES&quot;.implode(&quot;,&quot;, $query);
$result = mysql_query($sql) or die (mysql_error());
</code></pre>
</div>

<div>
Hi Experts, many thanks for the comments. Not sure I fully understand. 
 
Currently, my form looks like this: 
&lt;form action=&quot;/admin/zones/gradings/actions.php?action=edit&quot; method=&quot;post&quot; name=&quot;edit&quot;&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;table width=&quot;100%&quot; border=&quot;0&quot; cellpadding=&quot;2&quot; cellspacing=&quot;3&quot; class=&quot;mainTable&quot; id=&quot;student_list&quot;&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php do { ?&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;19%&quot; align=&quot;center&quot;&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;input name=&quot;student_id[]&quot; type=&quot;hidden&quot; value=&quot;&lt;?php echo $row_rsGraders['student_id']; ?&gt;&quot; /&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;5%&quot; align=&quot;left&quot;&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;input name=&quot;grading[&lt;?php echo $row_rsGraders['student_id']; ?&gt;]&quot; type=&quot;checkbox&quot; value=&quot;1&quot; /&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td colspan=&quot;3&quot; align=&quot;center&quot;&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;input type=&quot;submit&quot; name=&quot;Submit&quot; id=&quot;Submit&quot; value=&quot;Submit&quot;&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php } while ($row_rsGraders = mysql_fetch_assoc($rsGraders)); ?&gt; 
&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/table&gt; 
&lt;/form&gt; 
 
And my PHP looks like this: 
 
&lt;?php 
$grading = array_keys($_POST['grading']); 
 
foreach ($grading as $id) { 
&nbsp; &nbsp; mysql_select_db($database_connEACKDK); 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$query &nbsp;= &quot;INSERT INTO gradings (grading_id, id, date, timestamp, current, new) VALUES ('', '$id', '', '', '', '')&quot;; 
&nbsp; &nbsp; $result = mysql_query($query) or die (mysql_error()); 
?&gt; 
 
If I change my form to include new fields like this: 
 
&lt;form action=&quot;/admin/zones/gradings/actions.php?action=edit&quot; method=&quot;post&quot; name=&quot;edit&quot;&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;table width=&quot;100%&quot; border=&quot;0&quot; cellpadding=&quot;2&quot; cellspacing=&quot;3&quot; class=&quot;mainTable&quot; id=&quot;student_list&quot;&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php do { ?&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;19%&quot; align=&quot;center&quot;&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;input name=&quot;student_id[]&quot; type=&quot;hidden&quot; value=&quot;&lt;?php echo $row_rsGraders['student_id']; ?&gt;&quot; /&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &lt;input name=&quot;current[]&quot; type=&quot;hidden&quot; value=&quot;&lt;?php echo $row_rsGraders['rank']; ?&gt;&quot; /&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;19%&quot; align=&quot;center&quot;&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;input name=&quot;new[]&quot; type=&quot;hidden&quot; value=&quot;&lt;?php echo $row_rsGraders['new']; ?&gt;&quot; /&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;5%&quot; align=&quot;left&quot;&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;input name=&quot;grading[&lt;?php echo $row_rsGraders['student_id']; ?&gt;]&quot; type=&quot;checkbox&quot; value=&quot;1&quot; /&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td colspan=&quot;3&quot; align=&quot;center&quot;&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;input type=&quot;submit&quot; name=&quot;Submit&quot; id=&quot;Submit&quot; value=&quot;Submit&quot;&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php } while ($row_rsGraders = mysql_fetch_assoc($rsGraders)); ?&gt; 
&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/table&gt; 
&lt;/form&gt; 
 
What do I need to do to make the PHP work something like this? 
 
&lt;?php 
$grading = array_keys($_POST['grading']); 
 
foreach ($grading as $id) { 
&nbsp; &nbsp; mysql_select_db($database_connEACKDK); 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$query &nbsp;= &quot;INSERT INTO gradings (grading_id, id, date, timestamp, current, new) VALUES ('', '$id', '', '', '$current', '$new')&quot;; 
&nbsp; &nbsp; $result = mysql_query($query) or die (mysql_error()); 
?&gt; 
 
Not sure how to reference the additional posted values ($current and $new) from the array for posting into the table. 
 
Many thanks for your help experts.
</div>

<div>
Many Thanks cxr 
 
Another step closer to understanding than before!!
</div>

<div>
<div class="content wysiwyg-content">
Hi Experts 
 
I am using prd00's solution to my original question which I have referenced as related. Still trying to get used to loops and arrays and how they interact so would really appreciate a littel guidance. 
 
Prd00's solution is working very well as it is but I am now extending the original form to include a few more repeating fields that also need to be entered into the table. How would I include additinal array values in the query? 
 
Sincere thanks 
 

</div>
</div>

Hi Experts

I am using prd00's solution to my original question which I have referenced as related. Still trying to get used to loops and arrays and how they interact so would really appreciate a littel guidance.

Prd00's solution is working very well as it is but I am now extending the original form to include a few more repeating fields that also need to be entered into the table. How would I include additinal array values in the query?

Sincere thanks



PHP, MYSQL - Insert multiple records using checkbox - Extending

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Web applications are systems that run in browsers that perform functions normally associated with other client-based programs. One of the most commonly used web applications is email; instead of downloading individual emails to a local machine, the data is shown through a website. Other examples of web applications are collaborative systems like a wiki or an online game.