Codeigniter Active Record syntax for join $this->db->join(); Ex: $this->db->select(‘*’); $this->db->from(‘user’); $this->db->join(‘review’, ‘review.id = user.id’); $query = $this->db->get(); And it will generate following sql. SELECT * FROM user JOIN review ON review.id = user.id if you need several joins in one query, you have to call join function multiple times. If you need a specific type […]
Continue Reading →If you want to empty or truncate a mysql table using codeigniter active record, use the following code. 🙂 To empty $this->db->empty_table(); This will generate a delete SQL string and runs the query. // DELETE FROM mytable To truncate $this->db->from(‘mytable’); $this->db->truncate(); // or $this->db->truncate(‘mytable’); This will generate a truncate SQL string and runs the query. […]
Continue Reading →In CodeIgniter using active record, if you want to perform a not equal then, use following line. $this->db->where(‘name !=’, $name); $this->db->where(‘id
Continue Reading →