Databases
StackOverflow2013
Postsdbo
POcodeigniter extract stdClass Object
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POcodeigniter extract stdClass Object
    text
    copied!<p>i'm using codeigniter, here's my view :</p> <pre><code> &lt;select name="kode_promo_air" id="kode_promo_air" class="span3 input2"&gt; &lt;option value=""&gt;-PILIH-&lt;/option&gt; &lt;?php $data = $this-&gt;app_model-&gt;get_promo_air(); foreach($data-&gt;result() as $t){ ?&gt; &lt;option value="&lt;?php echo $t-&gt;PRO_PRICE_CODE;?&gt;"&gt;&lt;?php echo $t-&gt;PRO_MST_NM;?&gt; - &lt;?php echo $t-&gt;PRO_AMT_CUST;?&gt;&lt;/option&gt; &lt;?php } ?&gt; &lt;/select&gt; </code></pre> <p>and here's app_model -> get_promo_air()</p> <pre><code>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-&gt;db-&gt;query($sql); } </code></pre> <p>the problem is i can't get $data->result() in my view, when i debug :</p> <pre><code>&lt;?php $data = $this-&gt;app_model-&gt;get_promo_air(); echo "&lt;pre&gt;"; print_r($data-&gt;result()); die(); ?&gt; &lt;select name="kode_promo_air" id="kode_promo_air" class="span3 input2"&gt; &lt;option value=""&gt;-PILIH-&lt;/option&gt; &lt;?php $data = $this-&gt;app_model-&gt;get_promo_air(); foreach($data-&gt;result() as $t){ ?&gt; &lt;option value="&lt;?php echo $t-&gt;PRO_PRICE_CODE;?&gt;"&gt;&lt;?php echo $t-&gt;PRO_MST_NM;?&gt; - &lt;?php echo $t-&gt;PRO_AMT_CUST;?&gt;&lt;/option&gt; &lt;?php } ?&gt; &lt;/select&gt; </code></pre> <p>i've got :</p> <pre><code>Array ( [0] =&gt; stdClass Object ( [PRO_PRICE_CODE] =&gt; AAA001001 [PRO_MST_NM] =&gt; Promo Air Asia [PRO_AMT_CUST] =&gt; 65000.00 ) [1] =&gt; stdClass Object ( [PRO_PRICE_CODE] =&gt; AGI001001 [PRO_MST_NM] =&gt; Promo Garuda [PRO_AMT_CUST] =&gt; 40000.00 ) ) </code></pre> <p>how to get the value ? coz i try with <code>foreach($data-&gt;result() as $t)</code> it's can't get the data... any solution would be appreciated..</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload