Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DAFC3476998 for ; Thu, 5 Sep 2002 01:10:27 -0400 (EDT) Received: from mail.surguttel.ru (unknown [217.106.46.1]) by postgresql.org (Postfix) with ESMTP id 78143475E13 for ; Thu, 5 Sep 2002 01:10:20 -0400 (EDT) Received: from dr_sad (oper.surguttel.ru [217.106.46.7] (may be forged)) by mail.surguttel.ru (8.12.2/8.12.2/SuSE Linux 0.6) with ESMTP id g85I8eCH016748; Thu, 5 Sep 2002 11:08:41 -0700 Date: Thu, 5 Sep 2002 11:09:50 +0600 From: "dr_sad(surguttel)" X-Mailer: The Bat! (v1.53d) Reply-To: "dr_sad(surguttel)" X-Priority: 3 (Normal) Message-ID: <511466863357.20020905110950@surguttel.ru> To: "David C. Brown" Cc: pgsql-php@postgresql.org Subject: Re: Help, plz... In-Reply-To: <3D761759.3020908@centennialwines.com> References: <171398422475.20020904160909@surguttel.ru> <3D761759.3020908@centennialwines.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavis-milter (http://amavis.org/) X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/15 X-Sequence-Number: 1470 Hi, Dave. Thanx. I've made follow changes: ---------------- 1. printf("BEGIN
"); 2. require_once('DB.php'); 3. printf("point 1
"); 4. $userid='mrtg'; 5. $password=''; 6. $dbhost='dbserv'; 7. $database='ll'; 8. printf("point 2
"); 9. $db = DB::connect("pgsql://$userid:$password@$dbhost/$database"); 10. printf("point 3
"); ---------------- 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: >>------------------------------------------------------------------------------- >> >> >> PostgreSQL PHP Test >> >> >> >> > printf("BEGIN
"); >> 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() ) >> { >> ?> >> >> >> >> >> >> > } >> printf("END.
"); >> ?> >>
>> >> >>------------------------------------------------------------------------------- >>return follow html: >>------------------------------ >> >> >> PostgreSQL PHP Test >> >> >> >> BEGIN
>>------------------------------ >> >>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