From: | "dr_sad(surguttel)" <dr_sad(at)surguttel(dot)ru> |
---|---|
To: | "David C(dot) Brown" <dbrown(at)centennialwines(dot)com> |
Cc: | pgsql-php(at)postgresql(dot)org |
Subject: | Re: Help, plz... |
Date: | 2002-09-05 05:09:50 |
Message-ID: | 511466863357.20020905110950@surguttel.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
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(at)$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(at)$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(at)postgresql(dot)org so that your
DCB> message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Zhidian Du | 2002-09-05 05:39:31 | transactions? |
Previous Message | David C. Brown | 2002-09-04 14:23:21 | Re: Help, plz... |