FUDforum: comp.lang.php » string to array

Home » Imported messages » comp.lang.php » string to array

Show: Today's Messages :: Polls :: Message Navigator

Re: string to array [message #177261 is a reply to message #177260]

Fri, 02 March 2012 17:03

M. Strobel
Messages: 386
Registered: December 2011

Karma:

Senior Member

Am 02.03.2012 15:46, schrieb Jerry Stuckle:
> On 3/2/2012 8:17 AM, M. Strobel wrote:
>> Hi,
>>
>> I am just testing with hstore in postgresql, this is a datatype providing a
>> key-value-store in one column (http://www.postgresql.org/docs/9.1/static/hstore.html).
>>
>> The php question is:
>>
>> A select from the table looks like this:
>>
>> trans1=> select * from testh;
>> Tabelle testh
>> n | h
>> ---------+-------------------------------------------------------------
>> Michael | "age"=>"89", "weight"=>"91", "haircolor"=>"braun"
>> Peter | "weight"=>"82", "haircolor"=>"rot", "has spaces"=>"is true"
>> (2 Zeilen)
>>
>> And a select gives me the h column back as a string:
>>
>> array(2) {
>> ["n"]=>
>> string(5) "Peter"
>> ["h"]=>
>> string(59) ""weight"=>"82", "haircolor"=>"rot", "has spaces"=>"is true""
>>
>> This looks like php source code. How could I just eval it to get a php array?
>>
>> /Str.
>
> Don't use it. It's a bad design and fails normalization (one value in a column). It
> also s not easily searchable nor can you modify values easily. You also don't run
> into problems like this.
>
> A much better way is to have a separate table with key and value columns and a
> reference column.

"bad design" and "fails normalization" is generally true, but I am just fed up with
yet another properties table. hstore is made for it, it is searchable and changeable,
but nonstandard.

I think it would be an elegant solution if I would not have to read in the properties
separately, but the whole class in one take, and "explode" this string into an array.

/Str

Report message to a moderator

[Message index]

		string to array By: M. Strobel on Fri, 02 March 2012 13:17
		Re: string to array By: Captain Paralytic on Fri, 02 March 2012 14:02
		Re: string to array By: M. Strobel on Fri, 02 March 2012 17:09
		Re: string to array By: Jerry Stuckle on Fri, 02 March 2012 18:07
		Re: string to array By: Jerry Stuckle on Fri, 02 March 2012 14:46
		Re: string to array By: M. Strobel on Fri, 02 March 2012 17:03
		Re: string to array By: Jerry Stuckle on Fri, 02 March 2012 18:09
		Re: string to array By: M. Strobel on Fri, 02 March 2012 18:38
		Re: string to array By: Jerry Stuckle on Fri, 02 March 2012 19:49
		Re: string to array By: M. Strobel on Fri, 02 March 2012 17:37

Previous Topic:	Name of page itself?
Next Topic:	How to place an image within another image at a certain position while retaining transparency using gd

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 04:04:26 GMT 2024

Total time taken to generate the page: 0.04522 seconds