Re: SQL query to a file - Mailing list pgsql-php

From dan radom
Subject Re: SQL query to a file
Date
Msg-id 20020701125820.GT25268@lunar.radom.org
Whole thread Raw
In response to SQL query to a file  (Marcelo Pereira <gandalf@sum.desktop.com.br>)
Responses Re: SQL query to a file
List pgsql-php
you can use the PHP touch and fopen functions and then write the rows to the file using a for loop.

dan

* Marcelo Pereira (gandalf@sum.desktop.com.br) wrote:
> Hi All,
>
> I have a connection to a PostgreSQL database, and I would to write a query
> result to a file.
>
> Example:
> # ----8<----------------------------------------------
> $conection = pgconnect(...
> $sql = "select * from mytable";
> $result = pg_exec($conection, $sql);
> # -----8<---------------------------------------------
>
> So, the results are stored in $result, how can I write this to a file?



pgsql-php by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: PHP + bash script
Next
From: Marcelo Pereira
Date:
Subject: Re: PHP + bash script