Re: How to parse data type array columns?

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Janning Vygen <vygen(at)gmx(dot)de>
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: How to parse data type array columns?
Date: 2005-08-16 08:42:53
Message-ID: 4301A70D.5010507@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

Look at phpArray() in lib/classes/ADODB_base.pclass in the phpPgAdmin
3.5 source distribution.

It's not recursive - just parsed 1-d arrays.

Also doesn't support leading dimension indication.

Chris

Janning Vygen wrote:
> Hi,
>
> if you use array data type in your database design and query your tables with
> PHP you get a string which represents the array. It can look something like
> this:
>
> [1:2]{{"Hallo", "Te\"st},"},{"Hallo", "Test"}}
>
> It can even have another delimiter than "," if you change the type delimiter.
>
> Has anybody already written a function to parse this array into an php array
> structure? A simple explode doesn't work of course. The list offers a too
> simple explode(",", ereg_replace("{[-]}", $string)). this works only with one
> level and numeric types.
>
> Has anybody already written a recursive function to parse the array string?
>
> kind regards,
> Janning
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq

In response to

Browse pgsql-php by date

  From Date Subject
Next Message Greg Stark 2005-08-16 15:04:20 Re: How to parse data type array columns?
Previous Message Janning Vygen 2005-08-16 08:04:07 How to parse data type array columns?