Split a comma separated string into multiple columns into db - php

Question

I need some help to insert comma separates strings into multiple columns into db.

My $_POST['search'] value output. [search] => schools,books,mobile

How do i make an foreach or for to insert those data into db? :S

is your question about the foreach loop or about the insertion in the db? — Ben
– Ben, Commented Mar 30, 2010 at 22:06
Are you looking for the explode function or do I misunderstand? — Wolph
– Wolph, Commented Mar 30, 2010 at 22:07
What does your table definition look like (z.e. which columns do you have)? — Felix Kling
– Felix Kling, Commented Mar 30, 2010 at 22:09
i've been looking the explode function. I just don't know how to use it to insert my separates $_POST['search'] values — william
– william, Commented Mar 30, 2010 at 22:11

Federico klez Culloca · Accepted Answer · 2010-03-30 22:17:03Z

1

You can use the explode function.

$queries=explode(',', $_POST['search']

Now $query is an array containing the separated values. Then you do your query, but without further informations about that, I have to stop here.

answered Mar 30, 2010 at 22:17

Federico klez Culloca

27.3k17 gold badges61 silver badges102 bronze badges

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

Comments

william · Accepted Answer · 2010-03-30 22:32:42Z

0

                    $post = $_POST['search'];
                $queries = explode( ',', $post );
                foreach( $queries as $query ) {
                    $db->Execute("INSERT INTO tags SET name = '".$query."'");
                }

This seems to worked for me..

I was using @klez's informations

answered Mar 30, 2010 at 22:32

william

6063 gold badges14 silver badges29 bronze badges

2 Comments

Alex Jasmin Over a year ago

That's multiple rows not multiple columns. Also you shouldn't put raw user input in an SQL query like that. What if the user types php', priority = '3000

NuclearDog Over a year ago

As mentioned by Alexandre, you'll want to look into mysql_escape_string/mysql_real_escape_string, or the similarly named functions for mysqli.

Collectives™ on Stack Overflow

Split a comma separated string into multiple columns into db - php

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related