Обсуждение: Help, plz...
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...
--
respect, Andrey.
I don't see any generic errors. What I would do is insert debugging
statments after DB::connect, after the query, and inside the while loop
and see which one fails to show up. (Like "Connected", "Query
Returned", and "Looping While...") This should help you find out what
command is failing to complete.
Hope this helps..
Dave
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...
>
>
>
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