How can I display a user's username after successful login
I want it to say "Welcome [username]!"
<?php require_once('../Connections/rccon.php'); ?>
<?php require_once('../webassist/mysqli/rsobj.php'); ?>
<?php require_once('../webassist/mysqli/authentication.php'); ?>
<?php
if (isset($_POST["submit"]) || isset($_POST["submit_x"])) {
$Authenticate = new WA_MySQLi_Auth($rccon);
$Authenticate->Action = "authenticate";
$Authenticate->Name = "USER";
$Authenticate->Table = "login";
$Authenticate->addFilter("email", "=", "s", "".((isset($_POST["email"]))?$_POST["email"]:"") ."");
$Authenticate->addFilter("password", "=", "s", "".((isset($_POST["password"]))?$_POST["password"]:"") ."");
$Authenticate->storeResult("username", "username");
$Authenticate->AutoReturn = true;
$SuccessRedirect = "success.php";
$FailedRedirect = "failed.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
$loginres = new WA_MySQLi_RS("loginres",$rccon,1);
$loginres->setQuery("SELECT * FROM login");
$loginres->execute();
?>