Codeigniter SQL query return single value [duplicate]

Question

I am working with CodeIgniter and I want to get the highest ID out of a table. This i realize with a function in the Model. But I don't get the result, which is a single value, as value back.

Code:

 function get_highest_answer_id(){
   $this->db->query('SELECT MAX(id) AS answerid FROM pa_it_answer;');
    if ($query = $this->db->get()) {
        if ($query->num_rows() > 0) {
            return $query->result();
        } else {
            return array();
        }
    } else {
        return FALSE;
    }
}

How do I have to Change the code that when I call this function in my Controller I get the single value?

max returns single value if you dont group the query.

Badiparmagi
– Badiparmagi

2017-07-27 11:46:05 +00:00
Commented Jul 27, 2017 at 11:46 — Badiparmagi
– Badiparmagi, Commented Jul 27, 2017 at 11:46

Kartik Patel · Accepted Answer · 2017-07-27 11:49:34Z

3

Below code is works fine for me.

$MAXID = 0;
$row = $this->db->query('SELECT MAX(id) AS answerid FROM pa_it_answer')->row();
if ($row) {
    $MAXID = $row->answerid; 
}

answered Jul 27, 2017 at 11:49

Kartik Patel

3103 silver badges14 bronze badges

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

Comments

Bilal Ahmed · Accepted Answer · 2017-07-27 11:49:29Z

0

Change your query in codeigniter like this

function get_highest_answer_id(){
     $this->db->select('MAX(id) AS answerid');
        if ($query = $this->db->get('pa_it_answer')) {
            if ($query->num_rows() > 0) {
                return $query->result();
            } else {
                return array();
            }
        } else {
            return FALSE;
        }
    }

answered Jul 27, 2017 at 11:49

Bilal Ahmed

4,0663 gold badges25 silver badges42 bronze badges

Comments

B. Desai · Accepted Answer · 2017-07-27 11:54:24Z

0

You just have to simplify your method with row()

function get_highest_answer_id(){
        $record = $this->db->query('SELECT MAX(id) AS answerid FROM pa_it_answer;')->row();
        if ($record) {
            return $record->answerid;
        } 
        else {
            return FALSE;
        }
    }

answered Jul 27, 2017 at 11:54

B. Desai

16.4k5 gold badges28 silver badges48 bronze badges

Comments

MikeSouto · Accepted Answer · 2017-07-27 11:58:56Z

0

Try this:

function get_highest_answer_id(){
   $this->db->query('SELECT MAX(id) AS answerid FROM pa_it_answer;');
    if ($query = $this->db->get()) {
        if ($query->num_rows() > 0) {
            return $query->row(); // here!!!
        } else {
            return array();
        }
    } else {
        return FALSE;
    }
}

I recommended use the querybuilder of CI (EDITED)

$this->db->select_max('id', 'answerid');
$query = $this->db->get('pa_it_answer');

var_dump( $query );
var_dump( $query->answerid );
die();

edited Jul 27, 2017 at 11:58

answered Jul 27, 2017 at 11:47

MikeSouto

2401 silver badge7 bronze badges

2 Comments

Bryan Over a year ago

When I try MikeSoutos solution there Comes the message: A Database Error Occurred Error Number: 1096 No tables used SELECT * Filename: C:/..../application/models/Model.php Line Number: 825

MikeSouto Over a year ago

Hi! The recommended soluction? I edit the post to adapted the recommended solution.

Collectives™ on Stack Overflow

Codeigniter SQL query return single value [duplicate]

4 Answers 4

Comments

Comments

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

2 Comments

Linked

Related