CodeIgniter Forums - Search Results

Search Results

Thread: help me write this mysql query in codeigniter
Post: RE: help me write this mysql query in codeigniter

Piotr Wrote: (11-12-2019, 09:27 AM) -- PHP Code: -- Easiest way: $q = $this->db->query("SELECT *, ABS( post_code - 2015 ) AS distance FROM list_data WHERE business_name LIKE '%cash%' ESCAPE '!' O...

Thread: help me write this mysql query in codeigniter
Post: RE: help me write this mysql query in codeigniter

Chivinsdev Wrote: (11-12-2019, 03:12 AM) -- Try this one I hope it will help you get what you are looking for. in your controller. Either you autoload the database in autoload file or you load ...

Thread: help me write this mysql query in codeigniter
Post: RE: help me write this mysql query in codeigniter

php_rocs Wrote: (11-11-2019, 07:48 PM) -- @acebay, When you execute the query what messages are you seeing? What does the generated query look like? Have you tried query binding ( https://codeig...

Thread: help me write this mysql query in codeigniter
Post: help me write this mysql query in codeigniter

Hi All, I need help on writing this MySQL query in CodeIgniter Code: -- SELECT *, ABS( post_code - 2015 ) AS distance FROM list_data WHERE business_name LIKE '%cash%' ESCAPE '!' ORDER BY ...

Thread: ->result() not showing all rows/data
Post: ->result() not showing all rows/data

Hi all, I have a question Let say we have this 2 tables in our database first table : category_lists category_lists_id | category ============================ 1 | Ac...

Thread: conditional routing (shorten url)
Post: RE: conditional routing (shorten url)

kilishan Wrote: (01-28-2019, 02:58 PM) -- Here's one potential way to handle it, though it comes with a pretty big caveat: - In your routes config file do a "catch-all" route as the very last rou...

Thread: conditional routing (shorten url)
Post: RE: conditional routing (shorten url)

php_rocs Wrote: (01-28-2019, 09:49 AM) -- @acebay, This might be helpful to you ( https://codeigniter.com/user_guide/general/urls.html?highlight=remove%20index#removing-the-index-php-file ). -- ...

Thread: conditional routing (shorten url)
Post: RE: conditional routing (shorten url)

Pertti Wrote: (01-27-2019, 12:49 PM) -- Because it's config file, it doesn't have access to database. While it might feel a bit "hacky", you could set up 404 controller, and if route fails, you co...

Thread: conditional routing (shorten url)
Post: RE: conditional routing (shorten url)

Can I shorten my url with .htaccess? Is it possible in my case. Say I have these urls in my website http://www.example.com/locations http://www.example.com/locations/sydney http://www.exam...

Thread: conditional routing (shorten url)
Post: conditional routing (shorten url)

Hi, is it possible to have conditional in routes.php like below Code: -- $req = $this->uri->segment(1); require_once ( BASEPATH. 'database/DB.php'); $db =& DB(); if ($db->get_where('home_inner_...