CodeIgniter Forums - Search Results

Search Results

Thread: set sql variable before main query
Post: RE: set sql variable before main query

php_rocs Wrote: (02-13-2019, 09:27 PM) -- @ash-f, Documentation for future reference (of query results)... https://codeigniter.com/user_guide/database/results.html#generating-query-results -- Th...

Thread: set sql variable before main query
Post: RE: set sql variable before main query

Ok, I've used two successive $this->db->query() Code: -- $randomitem=array(); $valquery = "SELECT @rid := FLOOR(1+RAND()*item_id) FROM products ORDER BY item_id DESC LIMIT 1"; $this->db->query($v...

Thread: set sql variable before main query
Post: RE: set sql variable before main query

php_rocs Wrote: (02-08-2019, 05:46 PM) -- @ash-f, Yes, it is possible to set sql variable before other queries. The catch is...not the way you have it in your example. There are a couple of ways...

Thread: set sql variable before main query
Post: RE: set sql variable before main query

InsiteFX Wrote: (02-09-2019, 05:16 AM) -- PHP Code: -- $this->db->where('(item_id > @min_id',NULL,FALSE); -- Are you missing a parentheses / bracket here? -- That is a typo created when I copy&...

Thread: set sql variable before main query
Post: set sql variable before main query

Is it possible to set sql variable before other queries?(not $this->db->query()) I'd like to do something like this. PHP Code: -- $this->db->query("SET @min_id := (SELECT min_id FROM shop_par...

Thread: non-latin url routing
Post: RE: non-latin url routing

Yes it's escaping related. I'd like to make a rule using unescaped text but that's not possible on 3.x.

Thread: non-latin url routing
Post: non-latin url routing

I'd like to request an ability to handle non-latin url(such as Asian or Arabic language) on routing. on 3.x, it does not handle those correctly.

Thread: Getting real IP behind a Proxy
Post: RE: Getting real IP behind a Proxy

One way to retrieve real ip is to put this code on initialization(I used this for Cloudflare) if(isset($_SERVER['HTTP_X_FORWARDED_FOR'])) { $xffaddrs = explode(',',$_SERVER['HTTP_X_FORWARDED_FOR']...