If you need to dump query result for debugging purpose, etc.
Try something like,
<?php
$db = pg_connect();
$result = pg_query($db, 'SELECT * FROM some_table');
echo "<pre>\n";
var_dump(pg_fetch_all($result));
echo "</pre>\n";
?>
You need PHP 4.3.0-dev or later for pg_fetch_all().
--
Yasuo Ohgaki
Yasuo Ohgaki wrote:
> Edwin Robertson wrote:
>
>>With psql you can get all your output in HTML format. Anyone know of a way
>>to do this in PHP?
>
>
> It's psql feature and there is no automatic HTML format
> in PHP's pgsql module.
>
> If really would like, you can use passthru() and psql.
>
> <?php
> passthru('/usr/local/pgsql/bin/psql -f select.sql -H -U yohgaki -d test');
> ?>
>
> where "select.sql" is query you need.
>
> --
> Yasuo Ohgaki
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
