How to use where condition when get data from database in codeigniter

Hi, I can help you with that, you can use conditions and statements when you want to compare or perform any function between two values. Programming is a bit difficult for everyone especially for beginners who don’t know anything about coding but this https://studyclerk.com/help-with-research-paper article also very helpful in this case. Thank you for writing an attractive post.

Thank you because you have been willing to share information with us. we will always appreciate all you have done here because I know you are very concerned with our. clash royale kostenlose gems

Hi, I can help you with that, you can use conditions and statements when you want to compare or perform any function between two values. Programming is a bit difficult for everyone especially for beginners who don’t know anything about coding. Thank you for writing an attractive post.

That’s so useful. Thanks fireboy and watergirl

Simple you can use WHERE clause to get resulr from database in Codeigniter. Follow this example.
$this->db->select(‘*’)->from(‘gallery’);
$this->db->where(‘column name’,$value);
$this->db->get();
If you want to get result using WHERE and LIKE in codeigniter then follow below example.
$this->db->select(‘*’)->from(‘gallery’);
$this->db->where(“column name LIKE ‘%$search_name%'”);
$this->db->get();
If you want to select records BETWEEN two dates then you need to follow this example code.
$this->db->select(‘*’)->from(‘Table Name’);
$this->db->where(“DATE_FORMAT(add_date,’%m’) BETWEEN ‘$start_month’ AND ‘$end_month’ “)
$this->db->get()->result();