How to return a flat array from a query built using CodeIgniter's select_max() [duplicate]

Question

I am trying to get the max value from a database table via this CodeIgniter query:

$this->db->select_max('product_id');
$this->db->from('products');
$query = $this->db->get();
return $query->result();

But when I add this array of objects to to my next query, I get an error:

$this->db->insert('images', $product_id);

It show this error:

Error Number: 1054

Unknown column 'Array' in 'field list'

INSERT INTO images (product_id) VALUES (Array)

Filename: C:\wamp\www\system\database\DB_driver.php

Line Number: 330

When I did var_dump(), it showed:

array(1) {
    ["product_id"]=> array(1) {
        [0]=> object(stdClass)#21 (1) {
            ["product_id"]=> string(2) "26"
        }
    }
}

please post your controller and model code for better understand your problem — Saty
– Saty, Commented May 5, 2015 at 7:48
The error is pretty clear - you are inserting an Array instead of an actual value, so why don't you check $product_id before inserting? You are not showing us the code that gets $product_id from the result, and there's the issue. — trainoasis
– trainoasis, Commented May 5, 2015 at 7:48
php It's telling you that $product_id is an array, use print_r($product_id) to see which values it contains. — Pedro Lobito
– Pedro Lobito, Commented May 5, 2015 at 7:49
If you use $this->db->insert('images', $this->db->select_max('product_id')->get('products')->row_array()); this should provide a flat array. Although such practice seems vulnerable to race conditions. — mickmackusa
– mickmackusa ♦, Commented 22 hours ago

Narendrasingh Sisodia · Accepted Answer · 2015-05-05 09:16:12Z

1

You are applying an array within input here's I have updated your code

Model Code

$this->db->select_max('product_id');
$this->db->from('products');
$query=$this->db->get();
return $query->result_array();

Controller Code

$product_id = $this->Product_area_model->get_product_id();
$data['product_id'] = $product_id[0]['product_id'];
$result = $this->your_model->foo($data);

Model Code

function foo($data = ''){
   $this->db->insert('images',$data);
   return $this->db->insert_id();
}

answered May 5, 2015 at 9:16

Narendrasingh Sisodia

21.4k6 gold badges51 silver badges54 bronze badges

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

1 Comment

Bakht Over a year ago

would you please tell me the purpose of $data = '' in this line function foo($data = '')

Shravan Sharma · Accepted Answer · 2015-05-05 07:52:16Z

0

Hope it will work for you...

$this->db->insert('images',$product_id[0]['product_id']);

answered May 5, 2015 at 7:52

Shravan Sharma

9898 silver badges17 bronze badges

2 Comments

Saty Over a year ago

How you know the nature and type of array??

Shravan Sharma Over a year ago

@saty I think it always return array.

Carlton · Accepted Answer · 2015-05-05 08:00:46Z

0

Codeigniter allows you to specify an array of values as the data to insert, but I think your issue is that you're inserting an array of arrays.

If that's the case then use the batch function...

$data = array(
   array(
      'title' => 'My title' ,
      'name' => 'My Name' ,
      'date' => 'My date'
   ),
   array(
      'title' => 'Another title' ,
      'name' => 'Another Name' ,
      'date' => 'Another date'
   )
);

$this->db->insert_batch('mytable', $data); 

// Produces: INSERT INTO mytable (title, name, date) VALUES ('My title', 'My name', 'My date'), ('Another title', 'Another name', 'Another date')

answered May 5, 2015 at 8:00

Carlton

5,7414 gold badges56 silver badges77 bronze badges

Collectives™ on Stack Overflow

How to return a flat array from a query built using CodeIgniter's select_max() [duplicate]

3 Answers 3

1 Comment

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Linked

Related