select-from-where query not working in codeigniter model

Question

I am trying to select the details of the users from a table in mysql database but it is not working. This is the code in my model :-

public function getuserdetails()
{
        $user_email = $this->input->post('email');
        $query_userdetails = $this->db->query("SELECT * 
                                               FROM users WHERE email = '$user_email' ");

        return $query_userdetails->result_array();
}

This is not working. But if I put the actual email id in the query instead of $user_email it works but not properly i.e if I use :-

$query_userdetails = $this->db->query("SELECT * FROM users WHERE 
                                       email = '[email protected]' ");

In this case it returns a result. My controller code to accept the result is :-

$data['details'] = $this->model_userdetails->getuserdetails();

But the problem is that when I access $details in view :-

echo $details['name']."<br />";

it does not recognize 'name'. name is the field in the database where the name of the users are stored. But if I try to retrieve it in a foreach loop it is working :-

foreach($details as $udetails)
{
     echo $udetails['name']."<br />";
}

no its post. my other model is working properly. i use $this->db->where('email',$this->input->post('email')); No problem here — Stacy J
– Stacy J, Commented Feb 23, 2013 at 6:23

Abhishek Kumar Srivastava · Accepted Answer · 2013-02-23 06:34:20Z

1

Run queries as per codeigniter suggestion

$query_userdetails = $this->db->query("SELECT * FROM users WHERE email = ?", array($user_email));

http://ellislab.com/codeigniter/user-guide/database/queries.html search for Query Bindings

answered Feb 23, 2013 at 6:34

Abhishek Kumar Srivastava

796 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Stacy J Over a year ago

this is just giving the first name in users

Dipesh Parmar · Accepted Answer · 2013-02-23 06:14:14Z

0

I would try:

$query_userdetails = $this->db->query("SELECT * FROM users WHERE email = '". $user_email ."'");

edited Feb 23, 2013 at 6:14

Dipesh Parmar

27.3k8 gold badges65 silver badges92 bronze badges

answered Feb 23, 2013 at 6:12

Staffan Wallin

11 bronze badge

2 Comments

Stacy J Over a year ago

do you think the problem is the following statement : - $user_email = $this->input->post('email');

Muhammad Raheel Over a year ago

@StacyJ pass $email from controller and test

Winston · Accepted Answer · 2013-02-23 09:26:28Z

0

You have to write like this

public function getuserdetails()
{
    $user_email = $this->input->post('email');
    $this->db->where('email', $user_email)
             ->get('users')
             ->result_array();
}

After this, in view, you must to write like this

foreach($details as $udetails)
{
     echo $udetails['name']."<br />";
}

answered Feb 23, 2013 at 9:26

Winston

1,8152 gold badges18 silver badges29 bronze badges

Comments

munaz · Accepted Answer · 2016-05-18 07:42:33Z

0

You can try like This:

[CONTROLLER]

$data = array();
$data['udetails'] = $this->UserModel->getuserdetails();
$this->load->view('welcome_message',$data);

[MODEL]

public function getuserdetails() {
    $user_email = 'webmaster';
    $userdetails = $this->db->query("SELECT * FROM users WHERE umail = '$user_email' ");
    return $userdetails->result();
}

[VIEW]

<?php 
 foreach($udetails as $row) 
 {
    echo($row->uname.'<br/>');
    echo($row->uname);
 }
?>

edited May 18, 2016 at 7:42

answered May 18, 2016 at 5:58

munaz

1662 silver badges14 bronze badges

1 Comment

munaz Over a year ago

Try $this->db->get_where()

Waseem shah · Accepted Answer · 2017-01-08 13:53:56Z

0

Try this please it will help you. Model

 public function getuserdetails()
    {
        $user_email = $this->input->post('email');
        $this->db->select("*");
        $this->db->from('users');
        $this->db->where('email',$user_email);
        $query = $this->db->get();
        $result= $query->result();
    }

Controller

$data['details'] = $this->model_userdetails->getuserdetails();

view

foreach($details as $detail)
{   
   echo $detail->name;
   echo $detail->email;
}

answered Jan 8, 2017 at 13:53

Waseem shah

4407 silver badges14 bronze badges

Collectives™ on Stack Overflow

select-from-where query not working in codeigniter model

5 Answers 5

1 Comment

2 Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

2 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related