#29180 [Opn->Bgs]: Client crash
| From: | sniper@php.net | Date: | Sun, 06 Mar 2005 19:46:29 +0000 |
| Subject: | #29180 [Opn->Bgs]: Client crash | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-74959@lists.php.net to get a copy of this message | ||
ID: 29180
Updated by: sniper@php.net
Reported By: tila at home dot nl
-Status: Open
+Status: Bogus
Bug Type: PostgreSQL related
Operating System: Linux 2.4.24
PHP Version: 5.0.4-pre
New Comment:
No crash -> no bug. (and with give information impossible to reproduce
if there even was one.) Looks more like user error..
Previous Comments:
------------------------------------------------------------------------
[2004-12-30 18:10:19] tila at home dot nl
When I add a line in the script so that it reads:
<?php
$db = pg_connect("host=localhost user=apache password=apache
dbname=groupware");$QUERY = "SELECT o.* FROM personoverview o";
$result = pg_exec($QUERY);
$total = pg_numrows($result);
$offset = $_GET['id']?$_GET['id']:0;
$temp_offset = $offset
$perpage = 10;
for ($i = $offset; (($i < $total) && ($i < ($offset + $perpage)));
$i++)
{
$row = pg_fetch_row($result, $i);
}
echo $offset;
?>
The result will display 5. Strange
------------------------------------------------------------------------
[2004-12-29 23:54:25] tila at home dot nl
php5-STABLE-200412231730
tried this one, it still returns 42, can I do something else to help
you solve it, with some debugger or so?
------------------------------------------------------------------------
[2004-07-18 00:33:45] tila at home dot nl
42 by the way is the number of records in the database. So $offset
takes the value of $total
------------------------------------------------------------------------
[2004-07-16 10:34:23] tila at home dot nl
No, When I remove the PEAR::DB class and the code that's using it, it
will display '5' just as expected.
When I use pg_exec and pg_fetch_row etc.. the result displays '42' ????
<?php
$db = pg_connect("host=localhost user=apache password=apache
dbname=groupware");$QUERY = "SELECT o.* FROM personoverview o";
$result = pg_exec($QUERY);
$total = pg_numrows($result);
$offset = $_GET['id']?$_GET['id']:0;
$perpage = 10;
for ($i = $offset; (($i < $total) && ($i < ($offset + $perpage)));
$i++) {
$row = pg_fetch_row($result, $i);
}
echo $offset;
?>
------------------------------------------------------------------------
[2004-07-16 00:59:04] tularis@php.net
does it also crash when NOT using the PEAR::DB class?
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/29180
--
Edit this bug report at http://bugs.php.net/?id=29180&edit=1