Mysqli login
I get the following error when trying to run a page with the login mysqli behavior: Fatal error: Call to a member function getColumnVal() on a non-object in /home/acmeco5/public_html/AcmeComputingCart/login.php on line 10
I am able to pull up data from the table, so I know that mysqli is enabled.
Here is the code:
<?php require_once('Connections/AdminAndover_i.php'); ?>
<?php require_once('webassist/mysqli/rsobj.php'); ?>
<?php require_once('webassist/mysqli/authentication.php'); ?>
<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$Authenticate = new WA_MySQLi_Auth($AdminAndover_i);
$Authenticate->Action = "authenticate";
$Authenticate->Name = "UserID";
$Authenticate->Table = "users";
$Authenticate->addFilter("UserID", "=", "i", "".($Recordset1->getColumnVal("UserID")) ."");
$Authenticate->addFilter("Password", "=", "s", "".($Recordset1->getColumnVal("Password")) ."");
$Authenticate->storeResult("UserID", "UserID");
$Authenticate->AutoReturn = false;
$SuccessRedirect = "yes.php";
$FailedRedirect = "no.php";
if (function_exists("rel2abs")) $SuccessRedirect = $SuccessRedirect?rel2abs($SuccessRedirect,dirname(__FILE__)):"";
if (function_exists("rel2abs")) $FailedRedirect = $FailedRedirect?rel2abs($FailedRedirect,dirname(__FILE__)):"";
$Authenticate->SuccessRedirect = $SuccessRedirect;
$Authenticate->FailRedirect = $FailedRedirect;
$Authenticate->execute();
}
?>
<?php
$Recordset1 = new WA_MySQLi_RS("Recordset1",$AdminAndover_i,1);
$Recordset1->setQuery("SELECT * FROM users");
$Recordset1->execute();?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body>
<form name="form1" method="POST" >
<input id='UserID' type="text">
<input id='Password' type="password">
<input type="submit">
</form>
</body>
</html>