log in error

deecee · Sep 9, 2002

Heres the error

Fatal error: Call to undefined function: execute() in /usr/local/psa/home/vhosts/brandsupplier.com/httpdocs/intelistaf/TMP2ixm026zit.php on line 22

heres the site

http://www.brandsupplier.com/intelistaf

and heres the code

<?php require_once('Connections/Intelistaf.php'); ?>
<?php require_once('includes/functions.inc.php'); ?>
<?php
// begin Recordset
$query_Intelistaf = "SELECT * FROM pass";
$Intelistaf = $Intelistaf->SelectLimit($query_Intelistaf) or die($Intelistaf->ErrorMsg());
$totalRows_Intelistaf = $Intelistaf->RecordCount();
// end Recordset

// *** Start the session
session_start();
// *** Validate request to log in to this site.
$KT_LoginAction = $HTTP_SERVER_VARS["REQUEST_URI"];
if (isset($HTTP_POST_VARS["user"])) {
$KT_valUsername = $HTTP_POST_VARS['user'];
$KT_fldUserAuthorization = "";
$KT_redirectLoginSuccess = "success.php";
$KT_redirectLoginFailed = "fail.php";
$KT_rsUser_Source = "SELECT username, password ";
if ($KT_fldUserAuthorization != "&quot

$KT_rsUser_Source .= "," . $KT_fldUserAuthorization;
$KT_rsUser_Source .= " FROM pass WHERE username='" . $KT_valUsername . "' AND password='" . $HTTP_POST_VARS['pass'] . "'";
$KT_rsUser=$Intelistaf->Execute($KT_rsUser_Source) or DIE($Intelistaf->ErrorMsg());
if (!$KT_rsUser->EOF) {
// username and password match - this is a valid user
$KT_Username=$KT_valUsername;
session_unregister("KT_Username&quot

;
session_register("KT_Username&quot

;
if ($KT_fldUserAuthorization != "&quot

{
$KT_userAuth=$KT_rsUser->Fields($KT_fldUserAuthorization);
} else {
$KT_userAuth="";
}
session_unregister("KT_userAuth&quot

;
session_register("KT_userAuth&quot

;
if (isset($HTTP_GET_VARS['accessdenied']) && false) {
$KT_redirectLoginSuccess = $HTTP_GET_VARS['accessdenied'];
}
$KT_rsUser->Close();
session_unregister("KT_login_failed&quot

;
session_register("KT_login_failed&quot

;
$KT_login_failed = false;
// Add code here if you want to do something if login succeded

KT_redir($KT_redirectLoginSuccess);
}
$KT_rsUser->Close();
$KT_login_failed = true;
session_unregister("KT_login_failed&quot

;
session_register("KT_login_failed&quot

;
// Add code here if you want to do something if login fails

KT_redir($KT_redirectLoginFailed);
}
//PHP ADODB document - made with PHAkt 2.0.60?>

<html>
<head>
<title>Intelistaf</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">

</style>
</head>

<body bgcolor="#CCCCCC" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" height="100%">
<tr>
<td align="CENTER" valign="MIDDLE"><form METHOD="post" action="<?php echo $KT_LoginAction?>" name="login" id="login">
<table width="300" border="0">
<tr align="CENTER" valign="MIDDLE">
<td>Username</td>
<td class="right"><input name="user" type="text" id="user"></td>
</tr>
<tr align="CENTER" valign="MIDDLE">
<td>Password</td>
<td class="right"><input name="pass" type="password" id="pass"></td>
</tr>
<tr align="CENTER" valign="MIDDLE">
<td colspan="2"><input name="login" type="submit" value="Log In" id="login"></td>
</tr>
</table>
</form></td>
</tr>
</table>
</body>
</html>
<?php
$Intelistaf->Close();
?>

Just one thing I'm an Econ major and have never done this before so Im learning as I go...Thanks [rockband]

whos that behind you?

sleipnir214 · Sep 9, 2002

To clarify.

Your file (the one you posted) is called "TMP2ixm026zit.php", right?

If so, which of all that you posted is line 22? ______________________________________________________________________
TANSTAAFL!

deecee · Sep 9, 2002

line 22
$KT_rsUser=$Intelistaf->Execute($KT_rsUser_Source) or DIE($Intelistaf->ErrorMsg());

and the file is index.php

so i dont know where the browser got TMP2ixm026zit.php from

the pass is intelistaf and user is medical by the way...

thanks [rockband]

whos that behind you?

sleipnir214 · Sep 9, 2002

The error I'm getting reads:

Fatal error: Call to undefined function: execute() in /usr/local/psa/home/vhosts/brandsupplier.com/httpdocs/intelistaf/index.php on line 22

which makes more sense to me.

I can at this time only suggest the simple stuff. PHP is case-specific. Could the function in line 22 be "execute" and not "Execute"? ______________________________________________________________________
TANSTAAFL!

AnakinPt · Sep 10, 2002

The problem is in this line ...
$Intelistaf = $Intelistaf->SelectLimit($query_Intelistaf) or die($Intelistaf->ErrorMsg());

here you are changing the type of the $Intelistaf var.

This is my guess as you don't provide us the class that makes the connections to the database bank.

It says that he doesn't know an execute function in that object. Asking you if the class has the Execute function could be stupid, but it's one way to check. Another is checking what's the return of the SelectLimit function i placed above. Anikin
Hugo Alexandre Dias
Web-Programmer
anikin_jedi@hotmail.com

deecee · Sep 10, 2002

heres the code from my php connection file intelistaf.php

<?php
# PHP ADODB document - made with PHAkt
# FileName="Connection_php_adodb.htm"
# Type="ADODB"
# HTTP="true"
# DBTYPE="mysql"

$MM_Intelistaf_HOSTNAME = "66.45.20.60";
$MM_Intelistaf_DATABASE = "mysql:intelistaf";
$MM_Intelistaf_DBTYPE = preg_replace("/:.*$/", "", $MM_Intelistaf_DATABASE);
$MM_Intelistaf_DATABASE = preg_replace("/^.*:/", "", $MM_Intelistaf_DATABASE);
$MM_Intelistaf_USERNAME = "dcooke";
$MM_Intelistaf_PASSWORD = "sf49ers1";
$MM_Intelistaf_LOCALE = "Us";
$MM_Intelistaf_MSGLOCALE = "En";
$MM_Intelistaf_CTYPE = "P";
$KT_locale = $MM_Intelistaf_MSGLOCALE;
$KT_dlocale = $MM_Intelistaf_LOCALE;
$KT_serverFormat = "%Y-%m-%d %H:%M:%S";
$QUB_Caching = "false";

switch (strtoupper ($MM_Intelistaf_LOCALE)) {
case 'EN':
$KT_localFormat = "%d-%m-%Y %H:%M:%S";
break;
case 'EUS':
$KT_localFormat = "%m-%d-%Y %H:%M:%S";
break;
case 'FR':
$KT_localFormat = "%d-%m-%Y %H:%M:%S";
break;
case 'RO':
$KT_localFormat = "%d-%m-%Y %H:%M:%S";
break;
case 'IT':
$KT_localFormat = "%d-%m-%Y %H:%M:%S";
break;
case 'GE':
$KT_localFormat = "%d-%m-%Y %H:%M:%S";
break;
case 'US':
$KT_localFormat = "%Y-%m-%d %H:%M:%S";
break;
default :
$KT_localFormat = "none";
}

if (!defined('CONN_DIR')) define('CONN_DIR',dirname(__FILE__));
require_once(CONN_DIR."/../adodb/adodb.inc.php&quot

;
ADOLoadCode($MM_Intelistaf_DBTYPE);
$Intelistaf=&ADONewConnection($MM_Intelistaf_DBTYPE);

if($MM_Intelistaf_DBTYPE == "access" || $MM_Intelistaf_DBTYPE == "odbc&quot

{
if($MM_Intelistaf_CTYPE == "P&quot

{
$Intelistaf->PConnect($MM_Intelistaf_DATABASE, $MM_Intelistaf_USERNAME,$MM_Intelistaf_PASSWORD,
$MM_Intelistaf_LOCALE);
} else $Intelistaf->Connect($MM_Intelistaf_DATABASE, $MM_Intelistaf_USERNAME,$MM_Intelistaf_PASSWORD,
$MM_Intelistaf_LOCALE);
} else if($MM_Intelistaf_DBTYPE == "ibase&quot

{
if($MM_Intelistaf_CTYPE == "P&quot

{
$Intelistaf->PConnect($MM_Intelistaf_HOSTNAME.":".$MM_Intelistaf_DATABASE,$MM_Intelistaf_USERNAME,$MM_Intelistaf_PASSWORD);
} else $Intelistaf->Connect($MM_Intelistaf_HOSTNAME.":".$MM_Intelistaf_DATABASE,$MM_Intelistaf_USERNAME,$MM_Intelistaf_PASSWORD);
}else {
if($MM_Intelistaf_CTYPE == "P&quot

{
$Intelistaf->PConnect($MM_Intelistaf_HOSTNAME,$MM_Intelistaf_USERNAME,$MM_Intelistaf_PASSWORD,
$MM_Intelistaf_DATABASE,$MM_Intelistaf_LOCALE);
} else $Intelistaf->Connect($MM_Intelistaf_HOSTNAME,$MM_Intelistaf_USERNAME,$MM_Intelistaf_PASSWORD,
$MM_Intelistaf_DATABASE,$MM_Intelistaf_LOCALE);
}

if (!function_exists("updateMagicQuotes&quot

) {
function updateMagicQuotes($HTTP_VARS){
if (is_array($HTTP_VARS)) {
foreach ($HTTP_VARS as $name=>$value) {
if (!is_array($value)) {
$HTTP_VARS[$name] = addslashes($value);
} else {
foreach ($value as $name1=>$value1) {
if (!is_array($value1)) {
$HTTP_VARS[$name1][$value1] = addslashes($value1);
}
}

}
global $$name;
$$name = &$HTTP_VARS[$name];
}
}
return $HTTP_VARS;
}

if (!get_magic_quotes_gpc()) {
$HTTP_GET_VARS = updateMagicQuotes($HTTP_GET_VARS);
$HTTP_POST_VARS = updateMagicQuotes($HTTP_POST_VARS);
$HTTP_COOKIE_VARS = updateMagicQuotes($HTTP_COOKIE_VARS);
}
}
?>

is this where the problem could be?? [rockband]

whos that behind you?

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

log in error

deecee

Technical User

sleipnir214

Programmer

deecee

Technical User

sleipnir214

Programmer

AnakinPt

Programmer

deecee

Technical User

Similar threads

Part and Inventory Search

Sponsor