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)); }