[phorm] [Phorm:] dbfetch problems

[webbbs@xxxxxxxxx]

The following new message has been posted on Phorm Support Forum at 
<http://www.phorm.com/support/>. 

*************************************************************************** 

  MESSAGE:  (#4077) dbfetch problems 
            <http://www.phorm.com/support/?rev=4077> 
  AUTHOR:   Mick Housel 
  DATE:     May 26, 2004 at 12:24 a.m. EST 

I'm having problems with dbfetch and I'm not sure why. 

I have a form which gets $username and $password 

Here's the relevant part of the config file : 

= = = = = = = = = = = = = = = = = = = = = = = 
$PHORM_ALERTTO = "mick@xxxxxxxxxxxxxx"; 
$ph_debug72="true"; 
$PHORM_PARSPHP = true; 
$preheader = implode("", file("preheader.php")); 
$header = implode("", file("header.php")); 
$menuout = implode("", file("menuout.php")); 
$menuin = implode("", file("menuin.php")); 
$footerout = implode("", file("footerout.php")); 
$footerin = implode("", file("footerin.php")); 
$PHORM_MYDBV = "houseldb.php"; 
$PHORM_VALDEFS = "loginrules.txt"; 
$PHORM_MYTABLE = "members"; 
$PHORM_DBFETCH = "userid, fname, lname, username, userlevel"; 
$PHORM_DBWHICH = "username='$username' AND password='$password'"; 
if ($PHORM_DBFNREC > 0){ 
$userid = $db_userid; 
$fname = $db_fname; 
$lname = $db_lname; 
$username = $db_username; 
$userlevel = $db_userlevel; 
if ($userlevel > 0){ 

include 'loggedin.html'; 
} else { 

include 'unconfirmed.html'; 
} 
} else { 
include 'loginerror.html'; 
} 
= = = = = = = = = = = = = = = = = = = = = = = 

I'm sure that the table and the info in houseldb.php are correct due to the 
fact that when folks register, all of the information submitted is logged to 
the database. 

I'm also sure that the submitted username and password are correct due to the 
fact that I can cut and paste the select statement below into PHPMyAdmin and 
it finds the correct record. 

Obviously I'm doing something wrong above but I'm not sure what it is. 

Another strange thing is that unlike all my other html pages the imploded 
files aren't parsed and I get the following on the generic "Phorm" page with 
the lines. Below is the "text" on that page (loginerror.html). 

= = = = = = = = = = = = = = = = = = = = = = = 
{{preheader}} {{header}} {{menuout}} 
Sorry, either your username and/or your password were incorrect. Please either 
Log In again or Register. If you have forgotten your username and/or password, 
please use the Lost Password page to have them sent to you. 

Updated May 11, 2004 9:20 AM 

{{footerin}} DBFETCH: select userid, fname, lname, username, userlevel from 
members where username='motomania' AND password='correctpassword' 

Thank you for your input. Your data has been received. 
= = = = = = = = = = = = = = = = = = = = = = = 

TIA for any help/advice offered. 

Mick Housel 

*************************************************************************** 

This is an automatically-generated notice.  If you'd like to be removed from 
the mailing list, please visit Phorm Support Forum at 
<http://www.phorm.com/support/>, or send your request to webbbs@xxxxxxxxxx  If 
you wish to respond to this message, please post your response directly to the 
board.  Thank you! 
-------------------------------------------------
You are receiving this message because you are subscribed to the Phorm mailing 
list. To send messages to the mailing list, simply send email to 
phorm@xxxxxxxxxxxxx from the address you have subscribed. You may unsubscribe 
from the list by sending email to phorm-request@xxxxxxxxxxxxx with 
'unsubscribe' in the SUBJECT field.

Other related posts:

[phorm] [Phorm:] dbfetch problems