MYSQL insert comma separated values into separate fields?

Question

I know its a strange question, but I have one input field that does a live search for locations. The final value is displayed like this:

State,Suburb,Post Code

NSW,Sydney,2210

What I need to do now is split the three values into single values and update them into my separate fields for one row.

I don't want to update multiple rows but just one.

e.g.:

fields ( state | suburb | postcode ) values ( NSW | sydney | 2210 )

What php commands would I use to split those commas off and create single $values for each item?

you can't split three values into single value. but you may split single value into three values. please consider rewriting your question. — mirza
– mirza, Commented Jan 18, 2012 at 1:58

novactown.com · Accepted Answer · 2012-01-18 01:59:52Z

2

Use explode on the string.

$values = 'A,B,C,D';
$values = explode(',', $values);

Each item can then be accessed from an array indexed from 0.

answered Jan 18, 2012 at 1:59

novactown.com

1258 bronze badges

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

Comments

Nick Rolando · Accepted Answer · 2012-01-18 02:00:05Z

1

$val = "NSW,Sydney,2210";
$valArr = explode(",", $val);
$query = "UPDATE MyTbl SET State = '$valArr[0]', Suburb = '$valArr[1]', Post_Code = '$valArr[2]' WHERE ...";

answered Jan 18, 2012 at 2:00

Nick Rolando

26.2k13 gold badges84 silver badges120 bronze badges

Comments

jeroen · Accepted Answer · 2012-01-18 01:59:25Z

0

The easiest way I think, see the manual for explode:

$result_array = explode(',', $your_variable);

answered Jan 18, 2012 at 1:59

jeroen

91.8k22 gold badges117 silver badges132 bronze badges

Comments

xdazz · Accepted Answer · 2012-01-18 02:00:29Z

0

list($state, $suburb, $postcode) = explode(',', $value);

answered Jan 18, 2012 at 2:00

xdazz

161k38 gold badges255 silver badges278 bronze badges

Comments

cctan · Accepted Answer · 2012-01-18 02:01:46Z

0

Would this work?

$header = "State,Suburb,Post Code"
$items = explode(",", $input)
$output = implode("|", $items)

so the output would become State|Suburb|Post Code

to access each value separately, you can use $items[0], $items[1] ..

$data = "NSW,Sydney,2210"
$items = explode(",", $input)
$output = implode("|", $items)

so the output would become NSW|Sydney|2210

answered Jan 18, 2012 at 2:01

cctan

2,0233 gold badges21 silver badges31 bronze badges

Collectives™ on Stack Overflow

MYSQL insert comma separated values into separate fields?

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related