php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #16855 PHP ignores the pg_query.
Submitted: 2002-04-26 11:49 UTC Modified: 2002-04-28 22:16 UTC
From: d-m at eudoramail dot com Assigned:
Status: Not a bug Package: PostgreSQL related
PHP Version: 4.2.0 OS: Slackware 8.0 Kerel 2.4.19.7
Private report: No CVE-ID: None
 [2002-04-26 11:49 UTC] d-m at eudoramail dot com
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);



Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-04-26 18:59 UTC] yohgaki@php.net
If you need portablility, please used old names mentioned in manual pages. (use 4.2.0 pgsql module with 4.1.2)


 [2002-04-26 19:19 UTC] yohgaki@php.net
I meant 
(or use 4.2.0's pgsql module with 4.1.2)
It should work.
 [2002-04-28 13:34 UTC] d-m at eudoramail dot com
I think you dont understand my problem.
I wanna make a simple select but PHP 4.2 do not returns the lines of the select after the $fetch = pg_fetch_row($result, 0); WHY? The php 4.2 changes the method of making a select ?!? is not more like $result=pg_exec($connection, "SELECT pass FROM adm WHERE login =
'$inLOGIN'")
    or die ("Somethig wrong at the Query");


Could you sent me a sample of select ?!?

Thanks in addvance 
Helio Ferenhof
 [2002-04-28 22:16 UTC] yohgaki@php.net
If you need sample scirpts, it's under ext/pgsql/test/.


 
PHP Copyright © 2001-2019 The PHP Group
All rights reserved.
Last updated: Sun Aug 25 20:01:27 2019 UTC