Welcome Guest, Not a member yet? Register   Sign In
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...
5,423 Views
10 Replies
11-12-2019, 03:49 PM
acebay
    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 ...
5,423 Views
10 Replies
11-12-2019, 04:43 AM
acebay
    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...
5,423 Views
10 Replies
11-11-2019, 08:04 PM
acebay
    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 ...
5,423 Views
10 Replies
11-11-2019, 06:12 PM
acebay
    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...
2,266 Views
3 Replies
07-09-2019, 07:12 PM
acebay
    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...
5,274 Views
8 Replies
01-28-2019, 05:56 PM
acebay
    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 ). -- ...
5,274 Views
8 Replies
01-28-2019, 02:10 PM
acebay
    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...
5,274 Views
8 Replies
01-27-2019, 02:11 PM
acebay
    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...
5,274 Views
8 Replies
01-27-2019, 02:00 PM
acebay
    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_...
5,274 Views
8 Replies
01-26-2019, 11:22 PM
acebay

Theme © iAndrew 2016 - Forum software by © MyBB