sammligning af strenge PHP mod PostGresSQL
Jeg sidder og skal sammenligne noget data der er tastetind i en html formular med noget data hentet fra en PGSQL data base.
kode:
$loginName = $_REQUEST["loginName"];
$loginPass = $_REQUEST["loginPass"];
if ($loginName <> "" AND $loginPass <> "")
{
$testName = pg_query("SELECT username FROM users WHERE username = '$loginName'");
$testPass = pg_query("SELECT password FROM users WHERE username = '$loginName'");
$fetchName = pg_fetch_array($testName);
$fetchPass = pg_fetch_array($testPass);
if ($fetchName[username] <> "" AND $loginPass == $fetchPass[password]) <-- PROBLEMET!!!
{
echo 'logged on';
$_SESSION['loggedIn'] = ok;
}
