I thinks you dont have use the variable that should be in controller like $uses and $name which willl help to pick the table and controllers hops it will work
On Fri, Jul 17, 2009 at 4:54 PM, Dhileepen Chakravarthy < [email protected]> wrote: > Hi Everybody, > > *I. mysql db* > users table with id username and password field. > > *II. index.ctp* > <div class="login"> > <h2>Login</h2> > <?php echo $form->create('Post', array('action' => 'login'))?> > <?php echo $form->input('username');?> > <?php echo $form->input('password');?> > <?php echo $form->submit('Login');?> > <?php echo $form->button('Reset', array('type'=>'reset', > 'action'=>'clearLogin'));?> > <?php echo $form->end(); ?> > </div> > > *III. posts_controller.php* > function login() > { > if(empty($this->data) == false) > { > if(($user = > $this->Post->validateLogin($this->data['username'])) == true) > { > $this->Session->write('Post', $user); > $this->Session->setFlash('You\'ve successfully logged > in.'); > $this->redirect('main'); > exit(); > } > else > { > $this->Session->setFlash('Sorry, the information you\'ve > entered is incorrect.'); > exit(); > } > } > } > function clearLogin() > { > $this->data['Post']['username'] = ''; > $this->data['Post']['password'] = ''; > } > function logout() > { > $this->Session->destroy('user'); > $this->Session->setFlash('You\'ve successfully logged out.'); > $this->redirect('index'); > } > *IV. Model* > function validateLogin($data) > { > $user = $this->find(array('username' => $data['username'], > 'password' => $data['password']), array('id', 'username')); > if(empty($user) == false) > return $user['User']; > return false; > } > > > *Finally my error is,* > > > Notice (8): Undefined index: username > [APP\controllers\posts_controller.php, line 60] > > Code > > if(empty($this->data) == false) > > { > > > if(($user = $this->Post->validateLogin($this->data['username'])) > == true) > > PostsController::login() - APP\controllers\posts_controller.php, line 60 > Object::dispatchMethod() - CORE\cake\libs\object.php, line 115 > Dispatcher::_invoke() - CORE\cake\dispatcher.php, line 227 > Dispatcher::dispatch() - CORE\cake\dispatcher.php, line 194 > [main] - APP\webroot\index.php, line 88 > > Warning (512): SQL Error: 1054: Unknown column 'Post.username' in 'field > list' [CORE\cake\libs\model\datasources\dbo_source.php, line 525] > > Code | Context > > $sql = "SELECT `Post`.`id`, `Post`.`username` FROM `posts` AS `Post` > WHERE `username` IS NULL AND `password` IS NULL LIMIT 1" > $error = "1054: Unknown column 'Post.username' in 'field list'" > $out = null > > $out = null; > if ($error) { > > trigger_error("<span style = > \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", > E_USER_WARNING); > > DboSource::showQuery() - CORE\cake\libs\model\datasources\dbo_source.php, > line 525 > DboSource::execute() - CORE\cake\libs\model\datasources\dbo_source.php, > line 201 > DboSource::fetchAll() - CORE\cake\libs\model\datasources\dbo_source.php, > line 337 > DboSource::read() - CORE\cake\libs\model\datasources\dbo_source.php, line > 647 > Model::find() - CORE\cake\libs\model\model.php, line 1963 > Post::validateLogin() - APP\models\post.php, line 38 > PostsController::login() - APP\controllers\posts_controller.php, line 60 > Object::dispatchMethod() - CORE\cake\libs\object.php, line 115 > Dispatcher::_invoke() - CORE\cake\dispatcher.php, line 227 > Dispatcher::dispatch() - CORE\cake\dispatcher.php, line 194 > [main] - APP\webroot\index.php, line 88 > > Query: SELECT `Post`.`id`, `Post`.`username` FROM `posts` AS `Post` WHERE > `username` IS NULL AND `password` IS NULL LIMIT > > > > *Help me to solve this issue* > ** > *How do i change the sq query to my table.* > ** > *Regards,* > *Dhileepen* > > > > -- Best Regard Amjad Farooq Web developer Bramerz (Pvt)Ltd. 00923214239682 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
