public function processLoginAction(Request $request)
{
$username = $request->get('username');
echo '$username='******'<br/>';
$password = $request->get('password');
echo '$password='******'<br/>';
$query = "\n select\n user_id\n from\n aca_user\n where\n username = '******'\n and password = '******';";
$db = new Database();
$data = $db->fetchRows($query);
print_r($data);
die;
// $username = $_POST['username'];
// $password = $_POST['password'];
// Run a query against the DB
// Check for the record that exists or not
// If you find a record, its a valid user
// If you dont, they are not valid.
// If they are valid, set things to session
// Make the login boxes go away!
}
/**
* @param Request $request
* @return \Symfony\Component\HttpFoundation\Response
*/
public function loginFormAction(Request $request)
{
$msg = null;
$session = $this->getSession();
$username = $request->get('username');
$password = $request->get('password');
if (!empty($username) && !empty($password)) {
$query = '
select
*
from
aca_user
where
username = "******"
and password = "******"';
$db = new Database();
$data = $db->fetchRowMany($query);
if (empty($data) && $request->getMethod() == 'POST') {
// Invalid login
$msg = 'Please check your credentials';
$session->set('loggedIn', false);
} else {
// Valid login
$row = array_pop($data);
$name = $row['name'];
// person's name
$session->set('loggedIn', true);
$session->set('name', $name);
$session->set('user_id', $row['user_id']);
}
}
$session->save();
$loggedIn = $session->get('loggedIn');
$name = $session->get('name');
return $this->render('AcaShopBundle:LoginForm:login.form.alex.html.twig', array('loggedIn' => $loggedIn, 'name' => $name, 'msg' => $msg, 'username' => $username, 'password' => $password));
}
