Insert checkboxes data

[Julian]

Hello guys.  I've been looking around and I did not find a solution for my current situation.  Here's my question,  I want to insert a new record for each checkbox that had been checked on a specific table. (`profile`)

 

Checkboxes are created dynamically from another table (`categories`).  Here's code example:

 

mysql_query("INSERT INTO profile (user_id, user_category) VALUES ($user_id, $(checked boxes);

//Checked boxes

<?php while ($row_cat = mysql_fetch_assoc($cat)) {
             echo '<td><input name="user_category" type="checkbox" id="user_category" value="1" /></td>';
      } ?>

[Adam]

Here's my question,  I want to insert a new record for each checkbox that had been checked on a specific table. (`profile`)

 

Checkboxes are created dynamically from another table (`categories`).

 

That's not a question...

[jxrd]

If you name them all user_category[] then they will be put into an array. So you can do

foreach($_POST['user_category'] as $key => $value)
{
//insert...do whatever etc.
}

 

And yeah lol nice observation MrAdam.

[Julian]

Here's my question,  I want to insert a new record for each checkbox that had been checked on a specific table. (`profile`)

 

Checkboxes are created dynamically from another table (`categories`).

 

That's not a question...

 

You're not helping sir.

 

Thanks jxrd for the help..

 

Can you `code` explain it.  How to break the array in order to insert each one as a new record...

 

Regards

[jxrd]

You put your insert query into that foreach loop, and refer to the posted data as $value.