How to get a single element in sql query?

Question

I want to get user ip address based on users id. I don't get why it doesn't work.

In the controller:

function block_user($name,$user_id)
{
    $ip = $this->m_db->get_ips($user_id);
     $data = array(
    'username' => $name ,
    'ip' => $ip ,
    );
$this->db->insert('blacklist', $data);

$this->db->where('user_id',$user_id);
$this->db->delete('comments');
$this->index();
}

In the model:

function get_ips($user_id)
{
    $this->db->select('ip');
    $this->db->from('users');
    $this->db->where('user_id',$user_id);
    $query = $this->db->get();
    return $query;
}

score 1 · Accepted Answer · edited May 23 '17 at 12:07

1

CodeIgniter - return only one row?

What you should do is return a row

function get_ips($user_id)
{
    $this->db->select('ip');
    $this->db->from('users');
    $this->db->where('user_id',$user_id);
    $query = $this->db->get();
    $ret = $query->row();
    return $ret->ip;
}

edited May 23 '17 at 12:07

Community

1
1

answered Apr 17 '16 at 12:27

user3506027

42
3

score 0 · Answer 2 · answered Apr 18 '16 at 15:36

First, you have to make all transaction database in your model, then you need to use

$this->db->get();

The correct way is: controller.php

function block_user($name,$user_id){
    $re = $this->m_db->get_ips($user_id, $name);

    echo $re;
}

model.php

function insert_data($ip, $name){
    $data = array(
                  'username' => $name ,
                  'ip'       => $ip ,
                  );

    $this->db->insert('blacklist', $data);

    $this->db->where('user_id',$user_id);
    $this->db->delete('comments');

    return $this->db->affected_rows();
}

function get_ips($user_id, $name){
    $this->db->select('ip');
    $this->db->from('users');
    $this->db->where('user_id',$user_id);
    $query = $this->db->get()->row();

    $resp = $this->insert_data($query, $name);

    return $resp;
}

How to get a single element in sql query?

2 Answers2