codeigniter extract stdClass Object

Question

i'm using codeigniter, here's my view :

        <select name="kode_promo_air" id="kode_promo_air" class="span3 input2">
            <option value="">-PILIH-</option>
            <?php
            $data = $this->app_model->get_promo_air();  

            foreach($data->result() as $t){
            ?>
                <option value="<?php echo $t->PRO_PRICE_CODE;?>"><?php echo $t->PRO_MST_NM;?> - <?php echo $t->PRO_AMT_CUST;?></option>
            <?php
            }
            ?>
        </select>

and here's app_model -> get_promo_air()

function get_promo_air()
{
    $sql = "
                SELECT
                    c.PRO_PRICE_CODE,
                    a.PRO_MST_NM,
                    c.PRO_AMT_CUST
                FROM
                    promo_master a
                inner join  promo_type b on a.pro_type_id = b.pro_type_id
                inner join  promo_price c on a.PRO_MST_ID = c.PRO_MST_ID 
                WHERE sysdate() BETWEEN a.PRO_PRICE_DATE_FROM
                AND a.PRO_PRICE_DATE_TO
                AND b.PRO_TYPE_ID = 1       
            ";

    return $this->db->query($sql);  

}

the problem is i can't get $data->result() in my view, when i debug :

<?php
                    $data = $this->app_model->get_promo_air();  

                    echo "<pre>";
                    print_r($data->result());
                    die();

?>              

                <select name="kode_promo_air" id="kode_promo_air" class="span3 input2">
                    <option value="">-PILIH-</option>
                    <?php
                    $data = $this->app_model->get_promo_air();  

                    foreach($data->result() as $t){
                    ?>
                        <option value="<?php echo $t->PRO_PRICE_CODE;?>"><?php echo $t->PRO_MST_NM;?> - <?php echo $t->PRO_AMT_CUST;?></option>
                    <?php
                    }
                    ?>
                </select>

i've got :

Array
(
    [0] => stdClass Object
        (
            [PRO_PRICE_CODE] => AAA001001
            [PRO_MST_NM] => Promo Air Asia
            [PRO_AMT_CUST] => 65000.00
        )

    [1] => stdClass Object
        (
            [PRO_PRICE_CODE] => AGI001001
            [PRO_MST_NM] => Promo Garuda
            [PRO_AMT_CUST] => 40000.00
        )

)

how to get the value ? coz i try with foreach($data->result() as $t) it's can't get the data... any solution would be appreciated..

Have provided with a solution for the request that you have asked the question. Have a try and share thoughts. — Naresh Kumar P
– Naresh Kumar P, Commented Oct 7, 2016 at 5:29

GautamD31 · Accepted Answer · 2013-11-14 07:26:39Z

5

Try to return result array like

return $this->db->query($sql)->result_array();

Or in foreach loop try like

foreach ($data->result_array() as $t) {
    // Do the stuff
}

edited Nov 14, 2013 at 7:26

answered Nov 14, 2013 at 7:20

GautamD31

28.8k10 gold badges66 silver badges86 bronze badges

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

4 Comments

GautamD31 Over a year ago

just print the $data and tell me

Aldi Aryanto Over a year ago

just like above sir, here's Array ( [0] => stdClass Object ( [PRO_PRICE_CODE] => AAA001001 [PRO_MST_NM] => Promo Air Asia [PRO_AMT_CUST] => 65000.00 ) [1] => stdClass Object ( [PRO_PRICE_CODE] => AGI001001 [PRO_MST_NM] => Promo Garuda [PRO_AMT_CUST] => 40000.00 ) )

GautamD31 Over a year ago

Then try with my second answer

Aldi Aryanto Over a year ago

i'll try again, it's get error : Trying to get property of non-object

atif shaikh · Accepted Answer · 2017-02-05 18:33:09Z

3

return result_array(); this will solve the problem.

output

Array ( [0] => Array ( [id] => 1 [name] => Jared Leto )

[1] => Array
    (
        [id] => 2
        [name] => Scott Eastwood
    )

[2] => Array
    (
        [id] => 3
        [name] => Kate Mara
    )

[3] => Array
    (
        [id] => 4
        [name] => Holland Roden
    )

)

answered Feb 5, 2017 at 18:33

atif shaikh

1273 silver badges11 bronze badges

Comments

christianleroy · Accepted Answer · 2013-11-14 07:30:09Z

Try this:

$sql = "SELECT
             c.PRO_PRICE_CODE
             a.PRO_MST_NM,
             c.PRO_AMT_CUST
                FROM
                    promo_master a
                inner join  promo_type b on a.pro_type_id = b.pro_type_id
                inner join  promo_price c on a.PRO_MST_ID = c.PRO_MST_ID 
                WHERE sysdate() BETWEEN a.PRO_PRICE_DATE_FROM
                AND a.PRO_PRICE_DATE_TO
                AND b.PRO_TYPE_ID = 1       
            ";

$query = $this->db-query($sql);
return $query;

or

return $query->result();

If you use return $query->result(), you would only need the variable name in foreach.

$data = $this->app_model->get_promo_air(); 

foreach($data as $t){

//Your code here

}

Antonio · Accepted Answer · 2014-08-26 08:38:13Z

0

$query->result();=$t=

Array
(
    [0] => stdClass Object
        (
            [PRO_PRICE_CODE] => AAA001001
            [PRO_MST_NM] => Promo Air Asia
            [PRO_AMT_CUST] => 65000.00
        )

   [1].........
------------------------------------------------------------------------------------

$t[0]=stdClass Object
        (
            [PRO_PRICE_CODE] => AAA001001
            [PRO_MST_NM] => Promo Air Asia
            [PRO_AMT_CUST] => 65000.00
        )
-------------------------------------------------------------------------------------------
$t[0]->PRO_PRICE_CODE; = AAA001001
----------------------------------------------------------------------------------------

edited Aug 26, 2014 at 8:38

Antonio

9,89215 gold badges63 silver badges91 bronze badges

answered Aug 26, 2014 at 8:33

tom

11 bronze badge

Comments

4444 · Accepted Answer · 2014-11-18 18:08:06Z

0

I have an alternative solution.

When executed, the row_array is returns twice as many desired results. For example, if content is the input, the output is content content. Then I put the | in the $lastone, to remove with the explosion and separate the two.

if ($query->num_rows() > 0)
    {
        $row = $query->row_array(); 

        $lastone= $row['column']."|";
    }

    list ($last, $before) = explode ("|", $lastone);

return $last;

edited Nov 18, 2014 at 18:08

4444

3,73010 gold badges35 silver badges47 bronze badges

answered Nov 18, 2014 at 17:30

Vernon

11 bronze badge

Comments

Thejan Ranathunge · Accepted Answer · 2015-05-17 20:27:55Z

0

model --> in app_model, return result like this.

return $this->db->query($sql)->result();

View --> then you can get data like this.

<?php foreach($data as $key): ?>

           <p>PRO_PRICE_CODE : <?php echo $key->PRO_PRICE_CODE; ?></p>

<?php endforeach; ?>

edited May 17, 2015 at 20:27

answered May 17, 2015 at 20:20

Thejan Ranathunge

415 bronze badges

Comments

Oufi · Accepted Answer · 2018-09-28 09:30:22Z

0

Array ( [0] => stdClass Object ( [PRO_PRICE_CODE] => AAA001001 [PRO_MST_NM] => Promo Air Asia [PRO_AMT_CUST] => 65000.00 )

[1] => stdClass Object
    (
        [PRO_PRICE_CODE] => AGI001001
        [PRO_MST_NM] => Promo Garuda
        [PRO_AMT_CUST] => 40000.00
    )

)

You can print individually using print($data_stdClass[0]->PRO_PRICE_CODE);

answered Sep 28, 2018 at 9:30

Oufi

1

Comments

Sumit · Accepted Answer · 2019-09-24 08:14:58Z

0

print_r($data['0']->PRO_PRICE_CODE);  //you will get AAA001001
print_r($data['0']->PRO_PRICE_CODE);  //you will get AAA001001
print_r($data['0']->PRO_MST_NM);      //you will get Promo Air Asia
print_r($data['0']->PRO_AMT_CUST);    //you will get 65000.00

Similarly,

print_r($data['1']->PRO_PRICE_CODE);  //you will get AGI001001

answered Sep 24, 2019 at 8:14

Sumit

701 gold badge1 silver badge9 bronze badges

Collectives™ on Stack Overflow

codeigniter extract stdClass Object

8 Answers 8

4 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

4 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related