How can I add variable value to a select query result in Codeigniter? [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed 6 months ago.

Improve this question

I have a select query which outputs several rows. Query is working but what I need is, I want to insert a custom column with value into the above result. I am using Codeigniter 3 with PostgreSQL. The query looks like,

SELECT * FROM tbl_name ORDER BY timestamp ASC LIMIT 6;

The result I got is something like,

Array
(
    [0] => Array
        (
            [id] => 1
            [title] => Adventure Honeymoon
            [nights] => 5
            [price] => ₹37,000.00
            [discount] => 0
        )
    [1] => Array
        (
            [id] => 2
            [title] => Wild Side Of Kerala
            [nights] => 4
            [price] => ₹24,000.00
            [discount] => 0
        )
...
)

I want to add a custom column named 'category' with the result, which should looke like the below,

Array
(
    [0] => Array
        (
            [id] => 1
            [title] => Adventure Honeymoon
            [nights] => 5
            [price] => ₹37,000.00
            [discount] => 0
            [category] => Honeymoon Tours                                                                                     
        )
    [1] => Array
        (
            [id] => 2
            [title] => Wild Side Of Kerala
            [nights] => 4
            [price] => ₹24,000.00
            [discount] => 0
            [category] => Wild Life Tours                                                                                     
        )
...
)

Quick help will be appreciated.

@jainvikram444 I have an array of customised category lists. — Jerry Jones
– Jerry Jones, Commented Apr 16, 2019 at 10:39

Danish Ali · Accepted Answer · 2019-04-16 10:59:43Z

1

Try this

Model

public function get_data(){
   $query = $this->db->select('*')
   ->from('tlb_name')
   ->order_by('timestamp', 'ASC')
   ->limit(6)
   ->get();
   return $query->result_array();  

}

Controller

public function custom_addition(){

   $data = $this->model_name->get_data();

   foreach($data as $row){
       $row['category'] = 'Value';
   }

   print_($data);

}

$data the result of query

edited Apr 16, 2019 at 10:59

answered Apr 16, 2019 at 10:35

Danish Ali

2,3513 gold badges18 silver badges26 bronze badges

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

5 Comments

Jerry Jones Over a year ago

This worked a bit, only producing the last result row while I return the result in model to controller. There are 6 rows in the query result.

Danish Ali Over a year ago

Only last row getting the value of $data['category'] ?

Jerry Jones Over a year ago

All I get is a single row while there are 6 rows if I run the query and return the same without looping with foreach.

Danish Ali Over a year ago

After the foreach loop check the data first print_r($data);

Jerry Jones Over a year ago

Let us continue this discussion in chat.

Vikram Jain · Accepted Answer · 2019-04-16 10:41:52Z

0

You will add column and add values as per condition using case or static or joining tables. You have to change ? to values/column_name as per requirement:

SELECT T1.*, (case when T1.column_name = ? then ? else ? end) as 'CutomColumnName'
FROM TableName T1
ORDER BY T1.timestamp ASC
 LIMIT 6;

Ex:

SELECT T1.*, 
   (case when T1.CategoyId=1 then 'Category-1'  
         when T1.CategoyId=2 then 'Category-2'
         else 'Not Found'
    end) as 'CutomColumnName'
    FROM TableName T1
    ORDER BY T1.timestamp ASC
     LIMIT 6;

Or

SELECT T1.*, C1.name 
FROM TableName T1
left outer join category C1 on C1.id=T1.category_id
ORDER BY T1.timestamp ASC
 LIMIT 6;

answered Apr 16, 2019 at 10:41

Vikram Jain

5,6081 gold badge22 silver badges31 bronze badges

Collectives™ on Stack Overflow

How can I add variable value to a select query result in Codeigniter? [closed]

2 Answers 2

5 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Related