Updating SQL with multiple categories and checkbox (PHP)

Question

I have table of category like this

Table Name : personality

 id | Category
  1 | cute
  2 | rich
  3 | stupid
  4 | funny
  5 | famous

All i want to do is make to check box option with php for this personality table and update other table with multiple category

and my form:

  <form>
    Name : <input name="user" type="text" id="user" value="<?php echo $line['user'];?>" />
    Personality : <?php $personality=mysql_query("select * from personality");
                  while($data=mysql_fetch_array($personality)){
                  $check = ($line['usr_char']==$data['category'])?"checked" : "";
                  <label for='$data[kategori]'>
                  <input type='checkbox' id='usr_char' checked value='$data[category]'>
                  <span class='custom checkbox $check'></span> $data[category]</label><br>}?>

How do I post the category of personality table into other table with multiple category?

Here is example for the result : Table Name : people

  name | usr_char
  abby | cute,rich,funny
  andy | famous,funny

Orangepill · Accepted Answer · 2013-06-16 05:15:03Z

0

For one you are missing a name on the input element.

<input type='checkbox' id='usr_char' name='attribute[]' checked value='$data[category]'>

After that on the to get the value to update your people table with you would just use

$attributes = implode(",", $_POST["attribute"]);

answered Jun 16, 2013 at 5:15

Orangepill

24.7k3 gold badges44 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Deden Bangkit Over a year ago

works greattt, thank you very much, can you give me example for "for each command" to explode $attributes and post it to checked checkbox?

Burhan Khalid · Accepted Answer · 2013-06-16 05:12:39Z

0

Create another table called people_personality, with the following:

id <-- your primary key
person_id <-- your primary key from your "People" table
personality_id <-- your primary key from your "Personality" table

Suppose you have in your People table:

id - name
1  - abby
2  - andy

Now you want to assign abby cute, rich, and funny:

INSERT INTO people_personality VALUES ('',1,1),('',1,2),('',1,3)

answered Jun 16, 2013 at 5:12

Burhan Khalid

175k20 gold badges255 silver badges292 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:19:17Z

0

My suggestion is don't try to store multiple comma separated values in an SQL field. It has many disadvantages including,

Retrieving the individual values is a tedious process
It is not readable
Becomes difficult to maintain

So, instead use a many-to-many link table. For example, you can have tables this way:

Table 1:

Id | Category

 1 | cute
 2 | rich
 3 | stupid
 4 | funny
 5 | famous

Table 2:

Name | Usr_char

abby | cute
abby | rich
abby | funny
andy | famous
andy | funny

Having this way makes it easier for example, to add characters later and remove them and even to select them.

To retrieve:

SELECT * FROM table_name WHERE Name = 'abby';

To add:

INSERT INTO table_name (Name, Usr_char) VALUES ('abby', 'cute');

edited May 23, 2017 at 12:19

CommunityBot

11 silver badge

answered Jun 16, 2013 at 5:18

Kevin

6,7336 gold badges47 silver badges55 bronze badges

3 Comments

M Khalid Junaid Over a year ago

where is the answer of How do I post the category of personality table into other table with multiple category?

Kevin Over a year ago

@dianuj It is not a good idea to store multiple values in a single field. I don't think the OP's main problem is to find out a way to store multiple categories in the same field. Her problem is to get the job done in an efficient and easy way. Have a look at these answers : stackoverflow.com/questions/4804841/… stackoverflow.com/questions/1973905/…

M Khalid Junaid Over a year ago

I agree its not a good idea to store comma separated values but she is asking for how to get these values for each user after form submits

Collectives™ on Stack Overflow

Updating SQL with multiple categories and checkbox (PHP)

3 Answers 3

1 Comment

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related