Welcome Guest, Not a member yet? Register   Sign In
Undefined valuable
#8

(05-10-2017, 04:17 AM)kayinja.denis Wrote:
(05-10-2017, 03:48 AM)InsiteFX Wrote: Show a dump of the object or array that is returned from your query.
Quote:array(25) { [0]=> array(2) { ["fieldoption"]=> string(7) "address" ["value"]=> string(22) "p.o box 2 njeru uganda" } [1]=> array(2) { ["fieldoption"]=> string(10) "attendance" ["value"]=> string(3) "day" } [2]=> array(2) { ["fieldoption"]=> string(10) "automation" ["value"]=> string(1) "5" } [3]=> array(2) { ["fieldoption"]=> string(21) "auto_invoice_generate" ["value"]=> string(1) "0" } [4]=> array(2) { ["fieldoption"]=> string(13) "backend_theme" ["value"]=> string(5) "basic" } [5]=> array(2) { ["fieldoption"]=> string(13) "currency_code" ["value"]=> string(3) "UGX" } [6]=> array(2) { ["fieldoption"]=> string(15) "currency_symbol" ["value"]=> string(2) "/=" } [7]=> array(2) { ["fieldoption"]=> string(5) "email" ["value"]=> string(30) "[email protected]" } [8]=> array(2) { ["fieldoption"]=> string(16) "fontendorbackend" ["value"]=> string(1) "1" } [9]=> array(2) { ["fieldoption"]=> string(13) "fontend_theme" ["value"]=> string(5) "basic" } [10]=> array(2) { ["fieldoption"]=> string(13) "fontorbackend" ["value"]=> string(1) "0" } [11]=> array(2) { ["fieldoption"]=> string(6) "footer" ["value"]=> string(28) "Copyright ©florasjunior" } [12]=> array(2) { ["fieldoption"]=> string(16) "google_analytics" ["value"]=> string(0) "" } [13]=> array(2) { ["fieldoption"]=> string(8) "language" ["value"]=> string(7) "english" } [14]=> array(2) { ["fieldoption"]=> string(6) "mark_1" ["value"]=> string(1) "1" } [15]=> array(2) { ["fieldoption"]=> string(6) "mark_3" ["value"]=> string(1) "0" } [16]=> array(2) { ["fieldoption"]=> string(4) "note" ["value"]=> string(1) "1" } [17]=> array(2) { ["fieldoption"]=> string(5) "phone" ["value"]=> string(13) "+256789960188" } [18]=> array(2) { ["fieldoption"]=> string(5) "photo" ["value"]=> string(132) "a8240c1de32628b9ad6a2fae89c2eb4013da24573fd810e49248eae383bf15442178739622ae9f9f9ab93c3f329f6e284cb239942fc9225b24b6c1c1978700c5.png" } [19]=> array(2) { ["fieldoption"]=> string(13) "purchase_code" ["value"]=> string(36) "f541d688-9d40-40db-99fb-65e6f80692ab" } [20]=> array(2) { ["fieldoption"]=> string(11) "school_type" ["value"]=> string(9) "classbase" } [21]=> array(2) { ["fieldoption"]=> string(11) "school_year" ["value"]=> string(1) "1" } [22]=> array(2) { ["fieldoption"]=> string(5) "sname" ["value"]=> string(12) "florasjunior" } [23]=> array(2) { ["fieldoption"]=> string(17) "student_ID_format" ["value"]=> string(1) "1" } [24]=> array(2) { ["fieldoption"]=> string(13) "updateversion" ["value"]=> string(4) "3.00" } }

You dont have column with name "sname". Column names is fieldoption and value. So you need to create a function that will get the value of the column "valuae" for the line where the fieldoption equal to the value specified by you. Example:

PHP Code:
<?php
public function get_school() {
        return $this->get_setting("sname");
}
 
public function get_setting ($fieldoption){
    $this->db->where('fieldoption '$fieldoption );
        $data $this->db->get('setting');
        if($query){
        return $data->row()->value;
    }
    return false;
}
?>


AND render:

Code:
<h1><?=get_school()?</h1>
Reply


Messages In This Thread
Undefined valuable - by kayinja.denis - 05-09-2017, 12:54 AM
RE: Undefined valuable - by neuron - 05-09-2017, 01:07 AM
RE: Undefined valuable - by kayinja.denis - 05-11-2017, 06:29 AM
RE: Undefined valuable - by php_rocs - 05-09-2017, 08:13 AM
RE: Undefined valuable - by neuron - 05-10-2017, 02:41 AM
RE: Undefined valuable - by kayinja.denis - 05-10-2017, 03:30 AM
RE: Undefined valuable - by neuron - 05-11-2017, 06:48 AM
RE: Undefined valuable - by InsiteFX - 05-10-2017, 03:48 AM
RE: Undefined valuable - by kayinja.denis - 05-10-2017, 04:17 AM
RE: Undefined valuable - by mirivlad - 05-10-2017, 08:08 AM
RE: Undefined valuable - by InsiteFX - 05-10-2017, 12:06 PM
RE: Undefined valuable - by kayinja.denis - 05-11-2017, 04:28 AM
RE: Undefined valuable - by InsiteFX - 05-11-2017, 09:14 AM
RE: Undefined valuable - by xenomorph1030 - 05-11-2017, 08:17 AM
RE: Undefined valuable - by kayinja.denis - 05-11-2017, 10:21 PM



Theme © iAndrew 2016 - Forum software by © MyBB