add array to a field in mysql

Question

I have array : $ids=[123,234,567,8910,11324,1];

how to add this to one field in mysql.

After adding check if this id exists if it does not then add it to the same field.

I am looking at something like this.How do I do that .I really appreciate any help .Thanks in Advance.:

  --------------------- 
  | all_blocked_users |
  ---------------------
  |  123,234,567      |
  ---------------------

Don't go down this road. Only madness and despair lie at the end. — cHao
– cHao, Commented Jan 9, 2014 at 20:10
This is, as @cHao suggested, a really poor design, and will only serve to make your life miserable. Instead you should have a table of blocked users with a primary key. — Brian A. Henning
– Brian A. Henning, Commented Jan 9, 2014 at 20:11
create table blocked_users (blocker_id int references users (id), blockee_id int references users (id));. Now, to get a list of users that user A has blocked, select blockee_id from blocked_users where blocker_id = A. To see if a user A has blocked user B, select count(*) from blocked_users where blockee_id = B and blocker_id = A. To find a list of most-blocked users (possible troublemakers), select blockee_id, count(blocker_id) blockers from blocked_users group by blockee_id order by blockers desc. Try doing that with a comma-separated list in a reasonable amount of time... :) — cHao
– cHao, Commented Jan 9, 2014 at 20:50
The MySQL manual has a bunch of info on references, keys, and all that fun stuff. Also, google "1NF" and "sql anti-patterns". — cHao
– cHao, Commented Jan 9, 2014 at 21:21
That last search will actually find you a PDF of a book listing common missteps in database design. What you're doing here is the very first one. :) — cHao
– cHao, Commented Jan 9, 2014 at 21:27

Community · Accepted Answer · 2023-11-17 20:24:57Z

3

Right off the bat, let me tell you that storing CSV values in a database is almost never a good idea! It demonstrates poor database design and bad data integrity. It'll likely cause issues further down the line and make working with the data later much more difficult.

Anyway, that having been said, if you still wish to do this, you can use implode() to conver the array into a string, that can then be inserted into your MySQL database:

$dbString = implode(',', $ids);

It would be much better to store the blocked users in another link table.

edited Nov 17, 2023 at 20:24

CommunityBot

11 silver badge

answered Jan 9, 2014 at 20:11

BenM

53.3k26 gold badges116 silver badges172 bronze badges

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

Collectives™ on Stack Overflow

add array to a field in mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related