push data in an array using codeigniter php

Question

I have user_sport_tbl,sport_tbl tables. in user_sport_tbl i have sport_id but not have sport name.Sport name is in sport_tbl.

i have a function of getUserSport() of Model.

my query :-

$query = $this->db->get_where('user_sport_tbl',array('username' => $username));

i want sport_name for every sport_id and want to merge sport_name in array.

my code :-

    public function getUserSport()
{
    $username = $this->session->userdata('username');
    $query = $this->db->get_where('user_sport_tbl',array('username' => $username));
    if($query->num_rows > 0)
    {
        foreach($query->result() as $item)
        {
            $query1 = $this->db->query("select sport_name from sport_tbl where sport_id=$item->sport_name order by sport_id limit 1");
            $sql1 = $query1->row();

            $data[] = array_push($item, $sql1->sport_name);
        }
        return $data;
    }
}

my present return data:-

 [user_match_id] => 7 [sport_id] => 2 [match_id] => 3 [username] => admin

i want to add [sport_name] => cricket.

I want to return an array with sportname

msvairam · Accepted Answer · 2016-01-07 13:51:57Z

1

Try this coding

public function getUserSport()
{
   $data = array();
    $username = $this->session->userdata('username');
    $query = $this->db->get_where('user_sport_tbl',array('username' => $username));
    if($query->num_rows > 0)
    {
        foreach($query->result() as $key=>$item)
        {
            $query1 = $this->db->query("select sport_name from sport_tbl where sport_id=$item->sport_name order by sport_id limit 1");
            $sql1 = $query1->row();

            $item[$key]['sport_name']  = $sql1->sport_name;

            $data[] = $item;
        }
        return $data;
    }
}

answered Jan 7, 2016 at 13:51

msvairam

8725 silver badges12 bronze badges

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

14 Comments

Manish Tiwari Over a year ago

i have got this error: Fatal error: Cannot use object of type stdClass as array in /Applications/XAMPP/xamppfiles/htdocs/game/application/models/user_model.php on line 166

msvairam Over a year ago

what is 166 line ? result() replace to result_array(); and $item->sport_name replace to $item['sport_name']; then working fine

Manish Tiwari Over a year ago

166 line is : $item[$key]['sport_name'] = $sql1->sport_name;

msvairam Over a year ago

result() replace to result_array(); and $item->sport_name replace to $item['sport_name']; then working fine

Manish Tiwari Over a year ago

i am getting this error Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in /Applications/XAMPP/xamppfiles/htdocs/game/application/models/user_model.php on line 147 on Line 147 code: $query1 = $this->db->query("select sport_name from sport_tbl where sport_id=$item['sport_name'] order by sport_id limit 1");

|

Abdulla Nilam · Accepted Answer · 2016-01-07 14:04:11Z

0

Try This

public function getUserSport()
{
    $username = $this->session->userdata('username');
    $query = $this->db->get_where('user_sport_tbl',array('username' => $username));
    if(empty($query))
    {
        foreach($query->result_array() as $item)
        {
            $sportsId = $item[0]['sport_name'];
            $query1 = $this->db->query("SELECT sport_name FROM sport_tbl WHERE sport_id = $sportsId ORDER BY sport_id LIMIT 1");
            $result = $query1->result_array();

            $data[] = array_push($item, $result[0]['sport_name']);
        }
        return $data;
    }
}

Or can do with join query too (Not tested. If any error fix it. or post the message her)

public function getUserSport()
{
    $username = $this->session->userdata('username');
    $query = $this->db->query(
        "SELECT user_sport_tbl.sport_name, sport_tbl.sport_name
        FROM user_sport_tbl 
        INNER JOIN sport_tbl 
        ON user_sport_tbl.username = sport_tbl.sport_name
        WHERE user_sport_tbl.username = '$username' ORDER BY sport_tbl.sport_id LIMIT 1");
    $result = $query->result_array();

    return $data;
}

edited Jan 7, 2016 at 14:04

answered Jan 7, 2016 at 13:55

Abdulla Nilam

39.6k18 gold badges85 silver badges114 bronze badges

2 Comments

Abdulla Nilam Over a year ago

@ManishTiwari check this out

Abdulla Nilam Over a year ago

print_r($query->result_array()) and check

Collectives™ on Stack Overflow

push data in an array using codeigniter php

2 Answers 2

14 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

14 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related