+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Support (https://forum.codeigniter.com/forumdisplay.php?fid=30)
+--- Thread: SQL join codeigniter 4 (/showthread.php?tid=84803)
SQL join codeigniter 4 - SnowranCruzick - 11-11-2022
Codeigniter 4 is throwing the following error:
Argument 2 passed to view() must be of the type array, null given called in D:\xampp\htdocs\lordeCI\app\Controllers\Blog.php on line 35
That is about the block of code below:
public function post($post_id)
{
$model = new BlogModel();
$posts = $model->select('*')->select('c1.nome as categoria, c2.nome as categoria_2')
->join('categorias c1', 'c1.categoria_id = posts.categoria', 'inner')
->join('categorias c2', 'c2.categoria_id = posts.categoria_2', 'inner')
->find($post_id);
return view('posts/single_post',$posts);
}
I am very grateful to who echatspin echatrandom help me with that.
RE: SQL join codeigniter 4 - kenjis - 11-11-2022
Check you SQL statement is correct:
dd($model->db->getLastQuery());