Storing string in database in PHP

Question

My String in php is like 0:12,1:123,2:234 .... n times

I want to store it in database as -->

0:12 --- 0 as room_number 12 as value
1:12 --- 1 as room_number 12 as value

databse structure is like --

id(primary) room_number value

Thanks in advance

First explode(',',$string) then explde each array key of resulting array like this: explode(':',$result) — Hikaru-Shindo
– Hikaru-Shindo, Commented Jan 24, 2013 at 10:46
@user2001057 - if you've tried something and it hasn't worked, you should show us what you've tried; you might be really close to getting the answer yourself, but we can't tell from the question. If we don't know how far you've got we have to give much more detailed answers, which means people are less likely to want to help at all. — SDC
– SDC, Commented Jan 24, 2013 at 10:47

SDC · Accepted Answer · 2013-01-24 10:46:38Z

1

Use PHP's explode() function to split by commas to get a string for each room, then explode() each one of the room strings by colon to get the individual values you're after. Now you've got the values, you should be able to use the normal DB handling functions to save the records.

Or to do it directly in the database without needing any PHP code (assuming you're using MySQL), you could use MySQL's LOAD DATA INFILE command, specifying a comma as the record terminator and colon as the field terminator.

answered Jan 24, 2013 at 10:46

SDC

14.2k2 gold badges38 silver badges49 bronze badges

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

Comments

ajtrichards · Accepted Answer · 2013-01-24 10:46:46Z

0

$string = '0:12,1:123,2:234';

$elements = explode(',', $string);

foreach($elements as $value){

        $value = explode(':', $value);
        echo 'Room: '.$value[0].', Value: '.$value[1].'<br/>';

        // Write some code here to insert into your database.
}

answered Jan 24, 2013 at 10:46

ajtrichards

30.7k13 gold badges99 silver badges102 bronze badges

1 Comment

ajtrichards Over a year ago

@user2001057 Upvote and Accept if it's the correct answer :-)

Collectives™ on Stack Overflow

Storing string in database in PHP

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related