Re: Bug #1382 Updated: PHP3 does not return full pages on database-access
| From: | Knut Bueltemann | Date: | Mon, 28 Jun 1999 15:20:14 +0000 |
| Subject: | Re: Bug #1382 Updated: PHP3 does not return full pages on database-access | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-7684@lists.php.net to get a copy of this message | ||
Bug Database wrote:
> ID: 1382
> Updated by: jim
> Reported By: bueltemann@adinfo.de
> Status: Analyzed
> Bug Type: PostgreSQL related
> Assigned To:
> Comments:
>
> We need a sample script.
<?php
$QUERY = "SELECT * FROM my_table";
$conn = pg_connect($HOST,$PORT,"","",$DATABASE);
if($conn) {
$result = pg_exec($conn,$QUERY);
if($result) {
$nr = pg_num_rows($result);
if($nr) {
for($i=0;$i<$nr;$i++)
$dataset[$i]=pg_fetch_array($result,$i);
}
flush();
pg_free_result($result);
}
pg_close($conn);
}
?>
I run a SMP (2 P90, 128 MB RAM, SNI PCD 5T, Adaptec 2940, 3Com 905
TX-NIC).
Apache 1.3.6, PHP 3.0.7
The Script connect to a RDBMS over the network, not over
localhost/Unix-Socket.
With Kernel 2.0.36 / 2.0.37 the data from the select-statement was not
fully retrieved, I tried with Postgres 6.3.2, MySQL 3.2.2, mSQL 2 and
Interbase 4.
Now I run Kernel 2.2.10, recompiled everything an the problem persists
with Postgres 6.3.2, but with MySQL 3.2.2 and mSQL 2 everything's now
fine.
Knut Bültemann
Advanced Systemhaus
EMail: bueltemann@adinfo.de
Tel.: 040 - 25 30 50 - 43
Fax : 040 - 25 30 50 - 543