Codeigniter MySQL, как запрос не работает

Question

Codeigniter MySQL, как запрос не работает

У меня есть запрос codeigniter со следующими строками.

$userloc=$this->session->userdata('location');
$query=$this->db->query('select assettype,sum(status="In Stock")In_stock,sum(status = "Allocated")Allocated,sum(status = "Decommission")Decommission,sum(status = "In transit")In_Transit,location from assets group by assettype,location');

я хочу поставить подобное условие в $query где location like $userloc но это не работает, как ожидалось.

0

codeigniter mysql php

Решение

Другие решения

Попробуй это:

$userloc = $this->session->userdata('location');

$query = $this->db->query('select assettype, sum(status="In Stock") In_stock,
sum(status = "Allocated") Allocated,
sum(status = "Decommission") Decommission,
sum(status = "In transit") In_Transit,
location from assets where  location like "%'.$userloc.'%" group by assettype,location');

1

Попробуйте следующий запрос:

$query=$this->db->query('select assettype,sum(status="In Stock")In_stock,sum(status = "Allocated")Allocated,sum(status = "Decommission")Decommission,sum(status = "In transit")In_Transit,location from assets where location like %$userloc% group by assettype,location');

0

используйте следующий запрос

$userloc=$this->session->userdata('location');

$query=$this->db->query('select assettype,sum(status="In Stock")In_stock,sum(status = "Allocated")Allocated,sum(status = "Decommission")Decommission,sum(status = "In transit")In_Transit,location from assets where location like '%$userloc%' group by assettype,location');

0

Источник

Accepted Answer

Попробуйте использовать ниже

$this->db->select('assettype,sum(status="In Stock")In_stock,sum(status =  "Allocated")Allocated,sum(status = "Decommission") Decommission,sum(status = "In transit")In_Transit,location');
$this->db->from('assets');
$this->db->like('location', $userloc);
$this->db->group_by('assettype,location');
$query = $this->db->get();

0