Postgres Pro
Downloads
Home   >   mailing lists

Thread: script not working in php

script not working in php

From
Robert Buckley
Date:
Hi,

this works ok in pgadmin3

select name[i], kw[i]
from ( select generate_series(1,6) as i, 
              array['Biomasse', 'Deponiegas', 'Solar', 'Wasser', 'Wind','GESAMT'] as name, 
              array[biomasse_kw, deponiegas_kw, solar_kw,wasser_kw, wind_kw, kw] as kw
       from energie.tennet_auswertung_pivot_energie ) z
;

but in the php script I get error 500?


$result = pg_query($connection,'
select name[i], kw[i]
from ( select generate_series(1,6) as i, 
              array['Biomasse', 'Deponiegas', 'Solar', 'Wasser', 'Wind','GESAMT'] as name, 
              array[biomasse_kw, deponiegas_kw, solar_kw,wasser_kw, wind_kw, kw] as kw
       from energie.tennet_auswertung_pivot_energie ) z
;
'); 

$rows = array();
while($r = pg_fetch_assoc($result)) {
    $rows[] = $r;
}

print json_encode(array_values(pg_fetch_all($result)));


can anyone explain whythis is happening?

thanks,

Rob

Re: script not working in php

From
Raymond O'Donnell
Date:
On 06/10/2011 13:22, Robert Buckley wrote:
> Hi,
>
> this works ok in pgadmin3
>
> select name[i], kw[i]
> from ( select generate_series(1,6) as i,
>               array['Biomasse', 'Deponiegas', 'Solar', 'Wasser',
> 'Wind','GESAMT'] as name,
>               array[biomasse_kw, deponiegas_kw, solar_kw,wasser_kw,
> wind_kw, kw] as kw
>        from energie.tennet_auswertung_pivot_energie ) z
> ;
>
> but in the php script I get error 500?

What does it say in the PHP log?

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

Re: script not working in php

From
Rodrigo Gonzalez
Date:
On 10/06/2011 09:22 AM, Robert Buckley wrote:
Hi,

this works ok in pgadmin3

select name[i], kw[i]
from ( select generate_series(1,6) as i, 
              array['Biomasse', 'Deponiegas', 'Solar', 'Wasser', 'Wind','GESAMT'] as name, 
              array[biomasse_kw, deponiegas_kw, solar_kw,wasser_kw, wind_kw, kw] as kw
       from energie.tennet_auswertung_pivot_energie ) z
;

but in the php script I get error 500?


$result = pg_query($connection,'
select name[i], kw[i]
from ( select generate_series(1,6) as i, 
              array['Biomasse', 'Deponiegas', 'Solar', 'Wasser', 'Wind','GESAMT'] as name, 
              array[biomasse_kw, deponiegas_kw, solar_kw,wasser_kw, wind_kw, kw] as kw
       from energie.tennet_auswertung_pivot_energie ) z
;
');
You have single quotes inside the query and the complete string is defined with single quotes too.....use double quotes to define the string

Rodrigo

Re: script not working in php

From
Robert Buckley
Date:
Thanks....simple but important!

Von: Rodrigo Gonzalez <rjgonzale@estrads.com.ar>
An: Robert Buckley <robertdbuckley@yahoo.com>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Gesendet: 14:39 Donnerstag, 6.Oktober 2011
Betreff: Re: [GENERAL] script not working in php

On 10/06/2011 09:22 AM, Robert Buckley wrote:
Hi,

this works ok in pgadmin3

select name[i], kw[i]
from ( select generate_series(1,6) as i, 
              array['Biomasse', 'Deponiegas', 'Solar', 'Wasser', 'Wind','GESAMT'] as name, 
              array[biomasse_kw, deponiegas_kw, solar_kw,wasser_kw, wind_kw, kw] as kw
       from energie.tennet_auswertung_pivot_energie ) z
;

but in the php script I get error 500?


$result = pg_query($connection,'
select name[i], kw[i]
from ( select generate_series(1,6) as i, 
              array['Biomasse', 'Deponiegas', 'Solar', 'Wasser', 'Wind','GESAMT'] as name, 
              array[biomasse_kw, deponiegas_kw, solar_kw,wasser_kw, wind_kw, kw] as kw
       from energie.tennet_auswertung_pivot_energie ) z
;
');
You have single quotes inside the query and the complete string is defined with single quotes too.....use double quotes to define the string

Rodrigo