I have a setup like this: application system assets js imgs css I then have a helper function that simply returns the full path to this depending on my setup, something similar to: application/helpers/utility_helper.php: function asset_url(){ return base_url().’assets/’; } I will usually keep common routines similar to this in the same file and autoload it … Read more
What you need to do is set up a base controller that will look after the session for you and split your logged in controllers from your logged out ones via inheritance. My suggestion for you is to have a look at Phil Sturgeon’s post on Keeping It Dry. In his post, Phil explains the … Read more
RETURNING That’s possible with a single round-trip to the database: INSERT INTO tbl(filename) VALUES (‘my_filename’) RETURNING tbl_id; tbl_id would typically be a serial or IDENTITY (Postgres 10 or later) column. More in the manual. Explicitly fetch value If filename needs to include tbl_id (redundantly), you can still use a single query. Use lastval() or the … Read more
You can use sub query way of codeigniter to do this for this purpose you will have to hack codeigniter. like this Go to system/database/DB_active_rec.php Remove public or protected keyword from these functions public function _compile_select($select_override = FALSE) public function _reset_select() Now subquery writing in available And now here is your query with active record … Read more
I got it working by adding cbrandolino’s suggested mimetypes to the config/mimes.php (great tip jljohnstone). So the csv property of my $mimes looks like this now: ‘csv’ => array(‘application/vnd.ms-excel’, ‘text/anytext’, ‘text/plain’, ‘text/x-comma-separated-values’, ‘text/comma-separated-values’, ‘application/octet-stream’, ‘application/vnd.ms-excel’, ‘application/x-csv’, ‘text/x-csv’, ‘text/csv’, ‘application/csv’, ‘application/excel’, ‘application/vnd.msexcel’)
If you can identify the comment item by matching userid, name or comment — then you can remove that comment using update() command with $pull modifier along with the appropriate condition. If you cannot do as above, include an unique id in the comments (like UUID). To delete the comment, do the following: db.coll.update({<cond to … Read more
I believe you’ll want something like this: $this->db->select(‘user_id, COUNT(user_id) as total’); $this->db->group_by(‘user_id’); $this->db->order_by(‘total’, ‘desc’); $this->db->get(‘tablename’, 10); This will produce a result like | USER_ID | TOTAL | | 12 | 3 | | 15 | 2 | | 18 | 1 | UPDATE: As some pointed out in the comments the original query was summing … Read more
You shouldn’t load image_lib in foreach. Try to use code below $this->load->library(‘image_lib’); foreach($results as $row) { $config[‘image_library’] = ‘gd2’; $config[‘source_image’] = ‘/img/proizvodi/’.$row->proizvodid.’.jpg’; $config[‘create_thumb’] = TRUE; $config[‘maintain_ratio’] = TRUE; $config[‘width’] = 75; $config[‘height’] = 50; $this->image_lib->clear(); $this->image_lib->initialize($config); $this->image_lib->resize(); } If it wont work – check the upload folder permissions.
URLs Your URLs should typically be all lowercase letters. If you expect capital letters, there’s a chance you could accidentally exclude their lowercase counterparts, even though they’re the same URL. Example: www.example.com/controller/method/param Controllers Controller class names should be all lowercase, except the first letter. If your URL is www.example.com/gallery, the controller name is Gallery. If … Read more
The problem solved by this Solution: set $config[‘cookie_secure’] in config file to FALSE if you’re using HTTP.