A Database Error Occurred[newbie user] |
I creating my school project. I'm reimplement my project using codeigniter.
I've encountered errors. This error was the result after executing this $this->db->get(); in model. A Database Error Occurred Error Number: SELECT "username", "pass" FROM "users", "users" WHERE UPPER(username) = 'POWERUSER' AND "pass" = '63a9f0ea7bb98050796b649e85481845' Filename: C:\Program Files (x86)\wamp\www\Database\system\database\DB_driver.php Line Number: 330 --------------------------------------------------------------------------------------------------------------------------- Model: Model_users <?php class Model_users extends CI_Model{ public function can_log_in($inputData){ echo '<script type = "text/javascript">alert("The result is: '.$inputData['username'].'");</script>'; $this->db->select('username, pass'); $this->db->from('users'); echo '<script type = "text/javascript">alert("The result 2 is: '.$inputData['username'].'");</script>'; $this->db->where('UPPER(username)',strtoupper($inputData['username'])); $this->db->where('pass', (md5('root'))); //$this->db->get('users'); echo '<script type = "text/javascript">alert("Waiting to be processed");</script>'; if($this->db->get('users')->num_rows() > 0){ echo '<script type = "text/javascript">alert("Query successfully executed");</script>'; return $this->db->get('users')->result(); }else{ return false; } } } ?> ------------------------------------------------------------------------------------------------------------------------- Controller: Login.php <?php class Login extends CI_Controller { public function view($page = 'login') { //Load the window for Login $this->load->helper('url'); $this->load->view($page); } public function transaction(){ $this->load->view('process/header'); $this->load->view('process/body'); } public function logout(){ $sess_array = array( 'username' => '' ); $this->session->unset_userdata('logged_in',$sess_array); // $data['message_display'] = 'Successfully Logout'; redirect('../database/index.php','refresh'); //$this->load->view('login',$data); } //validate details public function login_validation(){ $this->load->model('model_users'); echo '<script type = "text/javascript">alert("Loaded database");</script>'; $inputData['username'] = $this->input->post('username'); $inputData['password'] = $this->input->post('password'); echo '<script type = "text/javascript">alert("Passed value");</script>'; $result = $this->model_users->can_log_in($inputData); echo '<script type = "text/javascript">alert("The result is: '.$result.'");</script>'; if($result){ foreach($result as $row){ $sessionData = array('username' => $row->username); } $this->session->set_userdata($sessionData); $this->load->view('main\index\header'); //$this->load->view('main\index\body'); // $this->load->view('default\footer'); }else{ redirect('index.php/login/transaction','refresh'); } $this->load->view('default\footer'); } public function validate_credentials(){ $this->load->model('model_users'); if($this->model_users->can_log_in()){ return true; }else{ $this->form_validation->set_message('validate credentials','Incorrect username/password.'); return false; } } } ---------------------------------------------------------------------------------------------------------------------- View: login.php <html> <head> <title> Login </title> <?php $page = $_SERVER['PHP_SELF']; $sec = "72000"; ?> <meta http-equiv="refresh" content="<?php echo $sec?>;URL='<?php echo $page?>'"> <link href="<?php echo base_url("source_assets/css/bootstrap.css"); ?>" rel="stylesheet"> <link href="<?php echo base_url("source_assets/css/bootstrap.min.css"); ?>" rel="stylesheet"> <link href="<?php echo base_url("source_assets/css/prettyPhoto.css"); ?>" rel="stylesheet"> <link href="<?php echo base_url("source_assets/css/font-awesome.css"); ?>" rel="stylesheet"> <link href="<?php echo base_url("source_assets/css/main.css"); ?>" rel="stylesheet"> <link href="<?php echo base_url("source_assets/css/social.css"); ?>" rel="stylesheet"> <script src = "source_assets/js/jquery-1.11.1.js"></script> <script src = "source_assets/js/bootstrap.js"></script> <script src = "source_assets/js/ie10-viewport-bug-workaround.js"></script> <script src = "source_assets/js/ie-emulation-modes-warning.js"></script> <script src = "source_assets/js/bootstrap.min.js"></script> </head> <script src="settings/js/ie-emulation-modes-warning.js"></script> <body background = "../database/source_assets/img/bg-head.jpg"> <br/> <br/> <br/> <center> <a href = "../../../index.php"> <img height = "10%"src = "../../../source_assets/img/220 copy.png" title = "Click me to return home"/> </a> </center> <div style = "margin-left:32%"class = "col-md-12"> <?php //echo form_open('index.php/login/login_validation'); //echo form_close();?> <form action = "../../../index.php/login/login_validation" method = "post"> <div class = "col-md-4"> <div class = "form-group has-error"> <input type = "text" id = "username" name = "username" class = "form-control" placeholder = "username" value = "" required> </div> <div class = "form-group has-error"> <input type = "password" name = "password" class = "form-control" placeholder = "password" value = "" required | md5> </div> <button type = "submit" class = "btn btn-danger btn-block">Login</button> </div> </form> </div> </div><!-- /container --> </body> </html> ---------------------------------------------------------------------------------------------------------------------- Table: users ---------------------------------------------- | userid | username | password | ---------------------------------------------- | 1 | poweruser | root | ---------------------------------------------- I'm hoping for your respones. To all codeigniter users |
Messages In This Thread |
A Database Error Occurred[newbie user] - by wolfsyntax - 03-26-2015, 04:33 PM
RE: A Database Error Occurred[newbie user] - by mwhitney - 03-27-2015, 08:38 AM
|