Question : cideigniter orLike()
Answered by : sameh-shahin
$this->db->like('title', 'match'); $this->db->or_like('body', $match);
// WHERE `title` LIKE '%match%' ESCAPE '!' OR `body` LIKE '%match%' ESCAPE '!'
Source : https://codeigniter.com/userguide3/database/query_builder.html | Last Update : Tue, 27 Oct 20
Question : insert data in db - codeigniter
Answered by : santhosh-sivan-s
use CodeIgniter\Database\Query;
$pQuery = $db->prepare(function ($db) { $sql = "INSERT INTO user (name, email, country) VALUES (?, ?, ?)"; return (new Query($db))->setQuery($sql);
});
Source : https://codeigniter.com/user_guide/database/queries.html | Last Update : Fri, 15 Apr 22