Thread: Re: [HACKERS] How to print explain using PHP

Re: [HACKERS] How to print explain using PHP

From
Bruce Momjian
Date:
I think the issue here was that these functions don't make any sense for
PHP because you can't register C functions.


>
> On Tue, 9 Jan 2001, Martin A. Marques wrote:
>
> > I'm working with PHP and Postgres, and if I try to do an EXPLAIN query, with
> > PHP, to the postgres backend the output goes to the error_log file of apache
> > and I don't know how to redirect that output to the browser.
>
>
>  Good point, before some time somebody (Bruce?) ask if anything is
> needful add to PostgreSQL extension in PHP. You found that...
>
> PHP not support libpq's routine:
>
> PQnoticeProcessor
> PQsetNoticeProcessor(    PGconn *conn,
>             PQnoticeProcessor proc,
>             void *arg);
>
>
>
>     Karel
>
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: [HACKERS] How to print explain using PHP

From
Karel Zak
Date:
On Tue, 9 Jan 2001, Bruce Momjian wrote:

> I think the issue here was that these functions don't make any sense for
> PHP because you can't register C functions.

I mean (I know) that you can register some common (internal) PHP
function and this function can call your PHP function. It is some used in
XML Expat parser that use element handlers (functions).

It's very good resolvable in PHP... see php-4.0b3/ext/xml/xml.c as example

            Karel

>
>
> >
> > On Tue, 9 Jan 2001, Martin A. Marques wrote:
> >
> > > I'm working with PHP and Postgres, and if I try to do an EXPLAIN query, with
> > > PHP, to the postgres backend the output goes to the error_log file of apache
> > > and I don't know how to redirect that output to the browser.
> >
> >
> >  Good point, before some time somebody (Bruce?) ask if anything is
> > needful add to PostgreSQL extension in PHP. You found that...
> >
> > PHP not support libpq's routine:
> >
> > PQnoticeProcessor
> > PQsetNoticeProcessor(    PGconn *conn,
> >             PQnoticeProcessor proc,
> >             void *arg);
> >
> >
> >
> >     Karel
> >
> >
>
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
>