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 #177260 is a reply to message #177258]

Fri, 02 March 2012 14:46

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

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.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

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:07:03 GMT 2024

Total time taken to generate the page: 0.04186 seconds