pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: dr_sad(surguttel) <dr_sad@surguttel.ru>
To: David C. Brown <dbrown@centennialwines.com>
Cc: pgsql-php@postgresql.org
Subject: Re: Help, plz...
Date: Thu, 5 Sep 2002 11:09:50 +0600
Message-ID: <511466863357.20020905110950@surguttel.ru> (raw)
In-Reply-To: <3D761759.3020908@centennialwines.com>
References: <171398422475.20020904160909@surguttel.ru>
	<3D761759.3020908@centennialwines.com>

Hi, Dave.
Thanx. I've made follow changes:
----------------
1. printf("BEGIN<br>");
2. require_once('DB.php');
3. printf("point 1<br>");
4. $userid='mrtg';
5. $password='';
6. $dbhost='dbserv';
7. $database='ll';
8. printf("point 2<br>");
9. $db = DB::connect("pgsql://$userid:$password@$dbhost/$database");
10. printf("point 3<br>");
----------------
text "point 3" Not printed :( so error inside line 10, however on
postgreSQL console no error messages and PHP is silent...

-- 
respect, Andrey.

Wednesday, September 04, 2002, 8:23:21 PM, you wrote:
DCB> I don't see any generic errors.  What I would do is insert debugging 
DCB> statments after DB::connect, after the query, and inside the while loop 
DCB> and see which one fails to show up.  (Like "Connected", "Query 
DCB> Returned", and "Looping While...") This should help you find out what 
DCB> command is failing to complete.

DCB> Hope this helps..

DCB> Dave

DCB> dr_sad(surguttel) wrote:

>>use:
>>Linux SuSE 8.0 Pro
>>PostgreSQL 7.2
>>PHP 4.2.2
>>Apache 2.0.39
>>
>>All posible deb messages in php.ini are enabled, but follow code:
>>-------------------------------------------------------------------------------
>><html>
>>    <head>
>>        <title>PostgreSQL PHP Test</title>
>>    </head>
>>    <body>
>>        <table>
>>            <?
>>                printf("BEGIN<br>");
>>                require_once('DB.php');
>>                $userid='postgres';
>>                $password='gecnzr';
>>                $dbhost='dbserv';
>>                $database='ll';
>>
>>                $db = DB::connect("pgsql://$userid:$password@$dbhost/$database");
>>                if ( DB::iserror( $db ))
>>                    {
>>                        die("DB.connect " . $db->getMessage());
>>                    }
>>
>>                $sql = "select * from agreements";
>>                $q = $db->query( $sql );
>>                if ( DB::iserror( $q ))
>>                    {
>>                        die("Query  " . $q->getMessage());
>>                    }
>>
>>                while ( $row = $q->fetchRow() )
>>                    {
>>                        ?>
>>                        <tr><td><?=$row[0] ?> </td>
>>                            <td><?=$row[1] ?> </td>
>>                            <td><?=$row[2] ?> </td>
>>                            <td><?=$row[3] ?> </td>
>>                        </tr>
>>                        <?
>>                    }
>>                printf("END.<br>");
>>            ?>
>>        </table>
>>    </body>
>></html>
>>-------------------------------------------------------------------------------
>>return follow html:
>>------------------------------
>><html>
>>    <head>
>>        <title>PostgreSQL PHP Test</title>
>>    </head>
>>    <body>
>>        <table>
>>            BEGIN<br>
>>------------------------------
>>
>>can anybody help me? I don't see any error messages both apache and
>>php logs... :( If I change sitax of command, of course i see error
>>messages... Heh...
>>
>>  
>>



DCB> ---------------------------(end of broadcast)---------------------------
DCB> TIP 3: if posting/reading through Usenet, please send an appropriate
DCB> subscribe-nomail command to majordomo@postgresql.org so that your
DCB> message can get through to the mailing list cleanly




view thread (3+ messages)

Message-ID: <511466863357.20020905110950@surguttel.ru>
Permalink:  ../511466863357.20020905110950@surguttel.ru/
Also on:    postgresql.org/message-id/511466863357.20020905110950@surguttel.ru

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: dr_sad@surguttel.ru, dbrown@centennialwines.com
  Subject: Re: Help, plz...
  In-Reply-To: <511466863357.20020905110950@surguttel.ru>
  References: <171398422475.20020904160909@surguttel.ru> <3D761759.3020908@centennialwines.com> <511466863357.20020905110950@surguttel.ru>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox