How can I split a string by ; and store in mysql using php

Question

I have 2 tables

tbl_patient 
pid       sample_id    fullname             test_ivd
 1        AA01         John Vick            test 1; test 2; test 3

and

tbl_test
tid         sample_id    name_test
 1          AA01         test 1
 2          AA01         test 2
 3          AA01         test 3     

When I add a new record (new patient) into tbl_patient, I stored one string separated by ; (list of test names) in test_ivd field. And in same time, I want to split the test_ivd by ; and add to the 3 new records in tbl_test. So please give me some suggestion.

Thank for any suggestion.

Answer 1

use explode: explode ( string $delimiter , string $string [, int $limit = PHP_INT_MAX ] ) http://php.net/manual/es/function.explode.php

Answer 2

I would suggest handling that with php.

1. Insert patient into database
2. retrieve inserted id
3. Insert tests into test table for retrieved id (you can write your query to insert sample_id of your patient instead of its id)

Answer 3

Example :

$string = "chicken;lamb;beef";
$stuff = explode(";", $string);
print_r($stuff);

//access by $stuff[0], $stuff[1] etc

Answer 4

You can do this using PHP explode function.

$ivdString = 'test 1; test 2; test 3';
$strArr = explode(";", $ivdString);

For insert record.

foreach ($strArr as $key => $value) {
      $sql = INSERT into table(sample_id,name_test)values('', '$value');
      Your insert here ...
      ......
}