php code to insert series of strings into database

Question

I have one string, it is given below,

$str = '1, test1, 22, 2, test2, 44, 3, test4, 55, 4, test7, 12...';

The string contains id, name, age, I have to insert into database like this,

 id | name | age  
  1 | test1| 22    
  2 | test2| 44

Please let me know, How can I achieve this one?

Thanks In advance

What you gave is a string..

Eddie
– Eddie

2014-05-23 07:01:39 +00:00
Commented May 23, 2014 at 7:01 — Eddie
– Eddie, Commented May 23, 2014 at 7:01
@Ugly Eddie...it is string

bhai
– bhai

2014-05-23 07:03:21 +00:00
Commented May 23, 2014 at 7:03 — bhai
– bhai, Commented May 23, 2014 at 7:03

Rikesh · Accepted Answer · 2014-05-23 07:14:00Z

3

You can do something like....

$str = '1, test1, 22, 2, test2, 44, 3, test4, 55, 4, test7, 12';  
$array = explode(", ",$str);
$result_array = array_chunk($array, 3);

I guess you can take ahead from this to insert that into your db.

DEMO.

edited May 23, 2014 at 7:14

answered May 23, 2014 at 7:04

Rikesh

26.5k14 gold badges82 silver badges90 bronze badges

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

3 Comments

bhai Over a year ago

@Rikesh..this will work..but if the string length is 100000, then we have to write too many queries for this..Is there any other method, so that we can insert it in one query?

Rikesh Over a year ago

You can create a single query too.

bhai Over a year ago

@Rikesh..How can I acheive this one?..can you give any demo??

user1978142 · Accepted Answer · 2014-05-23 07:13:25Z

0

Alternatively, you can just build a multi insert query on this one. Consider this example:

$str = '1, test1, 22, 2, test2, 44, 3, test4, 55, 4, test7, 12';
$str = explode(',', $str);
$str = array_map('trim', $str);
$data = array_chunk($str, 3);
$values = array();
foreach($data as $key => $value) {
    $values[] = '("'.implode('", "', $value).'")';
}
$statement = "INSERT INTO `table` (column1, column2, column3) VALUES ". implode(',', $values);

// this produces:
// INSERT INTO `table` (column1, column2, column3) VALUES ("1", "test1", "22"),("2", "test2", "44"),("3", "test4", "55"),("4", "test7", "12")

answered May 23, 2014 at 7:13

user1978142

7,9683 gold badges19 silver badges20 bronze badges

Collectives™ on Stack Overflow

php code to insert series of strings into database

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related