i have two function below:
1.
PHP Code:
public function vlChos(){
$query = "SELECT id, name FROM categories WHERE parent_id = '429' ";
$query=$this->db->query($query);
return $query->getResultArray();
}
function 1 working in codeigniter 4
function 2
PHP Code:
public function vlDemo(){
$this->db->select('id,name');
$this->db->where('parent_id','429');
$q=$this->db->get('categories');
$rs=$q->getResult();
return $rs;
}
function 2 dont working in codeigniter 4,
can someone help me rewrite function 2 to working in codeigniter 4 ?
thank you in a advance
note for newbaby to start learn codeigniter 4 like me
we use builder to connect to database
PHP Code:
public function vlDemos(){
$builder = $this->db->table("categories");
$builder->select('id,name');
$builder->where('parent_id','429');
$query = $builder->get();
return $query->getResult();
}
i write this function , code perfect in codeigniter
stop help thank you very much