From:             [EMAIL PROTECTED]
Operating system: Slackware 8.0 Kerel 2.4.19.7
PHP version:      4.2.0
PHP Bug Type:     PostgreSQL related
Bug description:  PHP ignores the pg_query.

In php 4.2.0 the same php that I run at 4.1.2 do not return the values of
the select.

Anyone know why do not work at 4.2.0 ? Its a bug or something changes a
lot??!

SAMPLE (This code run at 4.1.2 and dono at 4.2.0)
VALIDADE LOGIN.php

   $connection = pg_connect("host=localhost port=5432 dbname=admins
user=myuser password=PASSWORD")
      or die ("I Could not connect to PostGres --> " .
pg_errormessage($conn));

  $result=pg_exec($connection, "SELECT pass FROM adm WHERE login =
'$inLOGIN'")
    or die ("Somethig wrong at the Query");
  $num = pg_numrows($result);
  if ($num != 0)
        $fetch = pg_fetch_row($result, 0);

  $TiTuLo = "DB Varilux Admin";
  $BaCk   = "index.html";

  if ($inPASS == "") {
      include('header.inc');
      echo "<font color=#FF9000> Oooooops!</font> User name or password no
valid<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Try
agin";
      include('footer.inc');
      pg_close ($connection);
      exit;
  }
  if ($inPASS == base64_decode($fetch[0])) {

    $to_cookie = base64_encode("OK");
    setcookie("admins",$to_cookie,NULL,NULL,NULL,0);
    $to_cookie2 = base64_encode($inLOGIN);
    setcookie("admin_login",$to_cookie2,NULL,NULL,NULL,0);
    include('menu.html');

  }
  else {
      include('header.inc');
      echo "<font color=#FF9000> Oooooops!</font>Username or password
invalid<BR>try agin";
      include('footer.inc');
  }
  pg_close ($connection);



-- 
Edit bug report at http://bugs.php.net/?id=16855&edit=1
-- 
Fixed in CVS:        http://bugs.php.net/fix.php?id=16855&r=fixedcvs
Fixed in release:    http://bugs.php.net/fix.php?id=16855&r=alreadyfixed
Need backtrace:      http://bugs.php.net/fix.php?id=16855&r=needtrace
Try newer version:   http://bugs.php.net/fix.php?id=16855&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=16855&r=support
Expected behavior:   http://bugs.php.net/fix.php?id=16855&r=notwrong
Not enough info:     http://bugs.php.net/fix.php?id=16855&r=notenoughinfo
Submitted twice:     http://bugs.php.net/fix.php?id=16855&r=submittedtwice

Reply via email to