Hi, I am retrieving a data which I will select all data WHERE Password is equals to my POST value. I am using codeigniter. here’s my code:
model:
<?php
class Patient_db extends CI_Model {
function __construct() {
parent::__construct(); // Call the Model Constructor
}
function getUsers(){
// grab user input
// Prep the query
//
$results = array();
$pasword = $this->input->post('password');
$this->db->from('patient_account');
$this->db->where('Password',$pasword );
$query = $this->db->get();
if($query->num_rows() > 0) {
$results = $query->result();
}
return $results;
/*$loggedUser = $this->session->userdata('username');
$username = $loggedUser;
$query = $this->db->query('SELECT * FROM patient_account WHERE Lastname = "'. $username .'" ');
if ($query->num_rows() > 0){
return $query->result();
} else {
return NULL;
}*/
}
}
My VIEWS:
<?php if($loggedIn): ?>
<?php
if( !empty($users) ) {
foreach($users as $row) {
echo '<tr>';
echo '<td>'.$row->Firstname.'</td>';
echo '<td>'.$row->Lastname.'</td>';
echo '</tr>';
}
}
?>
<?php else: ?>
Please login to view this page...
<?php endif; ?>
and CONTROLLER:
function view( $page = 'home'){
if ( ! file_exists(APPPATH.'/views/pages/'.$page.'.php')){
show_404();
}
if( $this->session->userdata('validated') ) {
$this->load->helper(array('form'));
$this->load->helper('url');
$this->load->model('patient_db');
$loggedIn = $this->session->userdata('validated');
$loggedUser = $this->session->userdata('username');
$data['loggedUser'] = $loggedUser;
$data['loggedIn'] = $loggedIn;
$data['title'] = $page;
$data['users'] = $this->patient_db->getUsers();
$this->load->view('templates/header', $data);
$this->load->view('templates/nav', $data);
$this->load->view('pages/'.$page, $data);
$this->load->view('templates/footer');
} else {
$this->load->helper(array('form'));
$this->load->helper('url');
$loggedIn = $this->session->userdata('validated');
$loggedUser = $this->session->userdata('username');
$data['loggedUser'] = $loggedUser;
$data['loggedIn'] = $loggedIn;
$data['title'] = $page;
$this->load->view('templates/header', $data);
$this->load->view('templates/nav', $data);
$this->load->view('pages/'.$page, $data);
$this->load->view('templates/footer');
//$this->show_login(false);
}
}
Please help me.