• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Solved] Not getting column from database correct?

#1
I have created a set_language library where I can get the language code from my setting table and at the moment it is set as en.

So when I do this <?php echo $this->set_language->get_lang() ;?> it echos out en which is correct.

How ever when I try to get the directory value from my language table where code is en it does not return value. It should return directory name english.

What have I done wrong on my lang() function I have attached two images of database.


PHP Code:
<?php

class Set_language {

    public function __construct() {
        $this->ci =& get_instance();
        $this->ci->config->set_item('language'$this->lang());
    }

    public function lang() {
        $this->ci->db->select('*');
        $this->ci->db->from($this->ci->db->dbprefix 'language');
        $this->ci->db->where('code'$this->get_lang());
        $query $this->ci->db->get();

        $row $query->row();
        return $row->directory;
    }

    public function get_lang() {
        $this->ci->db->select('*');
        $this->ci->db->from($this->ci->db->dbprefix 'setting');
        $this->ci->db->where('item_name''admin_language');
        $query $this->ci->db->get();

        $row $query->row();
        return $row->item_value;
    }


Quote:Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM `language`, `setting` WHERE `item_name` = 'admin_language'' at line 1
SELECT *, * FROM `language`, `setting` WHERE `item_name` = 'admin_language'
Filename: C:/wamp/www/project/admin/application/libraries/Set_language.php
Line Number: 24


Any suggestions thanks in advance.


Attached Files Thumbnail(s)
       
There's only one rule - please don't tell anyone to go and read the manual.  Sometimes the manual just SUCKS!
Reply

#2
It did not work with the db select for some reason so just went with db get and where

PHP Code:
<?php

class Set_language {

    public function 
__construct() {
        
$this->ci =& get_instance();
        
//$this->ci->config->set_item('language', $this->lang());
    
}

    public function 
lang() {
        
$this->ci->db->where('code'$this->get_lang());
        
$query $this->ci->db->get($this->ci->db->dbprefix 'language');

        
$row $query->row();
        return 
$row->directory;
    }

    public function 
get_lang() {
        
$this->ci->db->where('item_name''admin_language');
        
$query $this->ci->db->get($this->ci->db->dbprefix 'setting');

        
$row $query->row();
        return 
$row->item_value;
    }

There's only one rule - please don't tell anyone to go and read the manual.  Sometimes the manual just SUCKS!
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.