How to parse data type array columns? - Mailing list pgsql-php

From Janning Vygen
Subject How to parse data type array columns?
Date
Msg-id 200508161004.07400.vygen@gmx.de
Whole thread Raw
Responses Re: How to parse data type array columns?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Re: How to parse data type array columns?  (Greg Stark <gsstark@mit.edu>)
List pgsql-php
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

pgsql-php by date:

Previous
From:
Date:
Subject: Re: Problem about connecting PostgreSQL through TCP/IP
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: How to parse data type array columns?