+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: can someone help me change function to run codeigniter 4 ? (/showthread.php?tid=81107)
can someone help me change function to run codeigniter 4 ? - startup - 01-25-2022
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 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
RE: can someone help me change function to run codeigniter 4 ? - davis.lasis - 01-25-2022
Glad that you figured that out, but that's how i would write it
PHP Code:
public function vlDemos(int $parent_id = 429){
return $this->db->table('categories')
->select('id, name')
->where('parent_id', $parent_id)
->get()
->getResult();
}