[PHP] Re: postgresql database access failure

2011-05-02 Thread Matt Graham
Florin Jurcovici wrote: > My personal recommendation, however, is to drop old-style procedural > drivers and switch to PDO - it's much more convenient to use, IMO. Just be careful. PDO's implementation of MySQL doesn't implement the mysql_set_charset() function, or at least it didn't a while back

Re: [PHP] Re: postgresql database access failure

2011-05-02 Thread Tim Streater
On 02 May 2011 at 11:05, e-letter wrote: >> >> Here's the URL of the relevant manual page: >> http://www.php.net/manual/en/function.pg-fetch-result.php >> > > The manual page did not explain the purpose of the text 'die', so was > ignored (;)). What, you mean this? $db = pg_connect("dbnam

[PHP] Re: postgresql database access failure

2011-05-02 Thread e-letter
> >Here's the URL of the relevant manual page: >http://www.php.net/manual/en/function.pg-fetch-result.php > The manual page did not explain the purpose of the text 'die', so was ignored (;)). Anyway, the php code was amended as follows: The result is a web page which shows: list of fil

[PHP] Re: postgresql database access failure

2011-05-02 Thread Florin Jurcovici
Hi.                $db = pg_connect('dbname=webcuttings user=httpd'); >                $query = 'SELECT * FROM articles'; >                $value=pg_fetch_result($query); >                echo 'all files' $value; >        ?> Maybe a password is set on your database for the user httpd? You have

[PHP] Re: PostgreSQL/PHP: transactions: how-to abstract out?

2003-01-09 Thread Jean-Christian Imbeault
To all who replied to my initial question ... I actually did *not* have problems with transactions in the way I first implemented my abstraction layer. In the case of PHP "If a second call is made to pg_connect() with the same connection_string, no new connection will be established, but instea

Re: [PHP] Re: PostgreSQL

2002-07-29 Thread Danny Shepherd
AIL PROTECTED]> Sent: Monday, July 29, 2002 2:24 PM Subject: Re: [PHP] Re: PostgreSQL > > I don't *think* PostgreSQL runs under Windows, really... > > > > You can maybe install the CygWin stuff (a Linux emulator under Windows) > and > > get that to "work", b

Re: [PHP] Re: PostgreSQL

2002-07-29 Thread 1LT John W. Holmes
> I don't *think* PostgreSQL runs under Windows, really... > > You can maybe install the CygWin stuff (a Linux emulator under Windows) and > get that to "work", but: Can anyone confirm that PG will run under CygWin? Will it communicate with PHP running on Windows, too? I'm just looking for a way

[PHP] Re: PostgreSQL

2002-07-29 Thread Richard Lynch
>How can i enable PostgreSQL module? >I have installed PHP 4 on IIS5, Windows 2000 I don't *think* PostgreSQL runs under Windows, really... You can maybe install the CygWin stuff (a Linux emulator under Windows) and get that to "work", but: 1. Don't expect good performance. CygWin ain't a Ferr

[PHP] Re: PostgreSQL

2002-07-18 Thread Richard Lynch
>PHP is compiled with PostgreSQL support but I can not connect. I get >this error message What does it mean and what do I need to do to fix >it > >Warning: pg_connect() unable to connect to PostgreSQL server: connectDB() >-- connect() failed: Connection refused Is the postmaster running (with -i)

[PHP] Re: PostgreSQL connection problems

2001-10-02 Thread Richard Lynch
You also can get rid of all those .'s pg_connect("host=$dbHost port=$dbPuerto dbname=$dbDB user=$dbLogin password=$dbPassword"); -- WARNING [EMAIL PROTECTED] address is an endangered species -- Use [EMAIL PROTECTED] Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Voluntee

[PHP] Re: Postgresql large objects.

2001-08-13 Thread Richard Lynch
> Does using pg_loread or any other php functions for postgresql large > objects modify the size of the file? I'm seeing a size increase in a few > bytes when I receive the file back to my hard drive. The file still seems > to run ok, but I'm wondering what is doing this? Under Un*x, compare the

[PHP] Re: Postgresql + Sessions + Large objects.

2001-08-08 Thread Richard Lynch
> I am having trouble with the following function working _with_ > sessions. If I turn off my session checking function it enables you to > download the file flawlessly, if sessions are turned on then Internet > Explorer displays an error: Not sure what is going on, but try viewing the output of

Re: [PHP] Re: Postgresql + Sessions + Large objects.

2001-08-04 Thread speedboy
> Do you have session db and your data db on the same db? No, the sessions are php sessions with data stored in flat files. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list admini

[PHP] Re: Postgresql + Sessions + Large objects.

2001-08-04 Thread Yasuo Ohgaki
Do you have session db and your data db on the same db? If you do, most likely, transaction is started in session open handler. You cannot nest transaction and lo_read/open etc fails. If you have situation like this, create dedicated database for session db. Regards, -- Yasuo Ohgaki "Speedbo