After the server PHP upgrade, getting the following error with PHP Version 5.6.2 on Apache 2.0 A PHP Error was encountered Severity: Notice Message: Only variable references should be returned by reference Filename: core/Common.php Line Number: 257 To fix this issue Edit filename: core/Common.php, line number: 257 Before: return $_config[0] =& $config; After: $_config[0] =& […]
Continue Reading →Think, you have multiple sub domains and you need to share sessions across all sub domains on Codeigniter (CI). http://example.com http://subdomain1.example.com http://subdomain2.example.com You need to edit config.php as following. $config[‘sess_cookie_name’] = ‘ci_session’; $config[‘sess_expiration’] = 0; $config[‘sess_expire_on_close’] = TRUE; $config[‘sess_encrypt_cookie’] = TRUE; $config[‘sess_use_database’] = TRUE; $config[‘sess_table_name’] = ‘ci_sessions’; $config[‘sess_match_ip’] = TRUE; $config[‘sess_match_useragent’] = FALSE; $config[‘sess_time_to_update’] = […]
Continue Reading →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 →