+- 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: JOIN and variable (/showthread.php?tid=86174)
JOIN and variable - motoroller - 01-18-2023
Hello every one i need add external variarble to join safety, how to do it?
$builder->join('users AS u', 'u.id = a.owner AND a.name like $var', 'left');
RE: JOIN and variable - kenjis - 01-18-2023
See https://codeigniter4.github.io/CodeIgniter4/database/queries.html#db-escapelikestring
and https://codeigniter4.github.io/CodeIgniter4/database/query_builder.html#join