CodeIgniter Forums - Search Results

Pages (2): 1 2 Next »

Search Results

Thread: Cors policy filter not work
Post: RE: Cors policy filter not work

kenjis Wrote: (03-15-2024, 03:28 AM) -- You need to set OPTIONS routes. If there is no route, control filters does not execute. Also, you should not send 'Access-Control-Allow-Origin: *'. You sh...

Thread: Cors policy filter not work
Post: Cors policy filter not work

I make a filter to fix CORS Policy errors: CorsFilter.php: PHP Code: -- namespace App\Filters; use CodeIgniter\Filters\FilterInterface; use CodeIgniter\HTTP\RequestInterface; use CodeIgnit...

Thread: Athurization Refresh Token in Shield
Post: Athurization Refresh Token in Shield

@"kilishan" : Firstly, Thanks for Useful Shield authentication package. Secondly, I work with JWT Token and handle authorization. This worked charming but I think for token expiration we need to add r...

Thread: Announcing: Bonfire - a drop-in admin area
Post: RE: Announcing: Bonfire - a drop-in admin area

kilishan Wrote: (10-29-2023, 08:37 PM) -- alakian Wrote: (10-29-2023, 03:49 AM) -- @"kilishan" What is the best structure for design frontend system in bonfire 2?! -- I'm not 100% sure what you're...

Thread: Announcing: Bonfire - a drop-in admin area
Post: RE: Announcing: Bonfire - a drop-in admin area

@"kilishan" What is the best structure for design frontend system in bonfire 2?!

Thread: Indexing JSON in MySQL
Post: RE: Indexing JSON in MySQL

@"InsiteFX" I reckon, we need to working easily with MySQL JSON Columns in codeigniter Query Builder. For the time being I use RawSql function, that's faced with lots of issues. For Instance: escape ...

Thread: Using MySQL JSON Columns in query builder class
Post: RE: Using MySQL JSON Columns in query builder clas...

@"InsiteFX" you right, I remove `` and my problem is fixed. thanks. PHP Code: -- $whereClause = "JSON_EXTRACT(artl.status , '$.\"1\".\"is_delete\"') > 0"; --

Thread: Using MySQL JSON Columns in query builder class
Post: RE: Using MySQL JSON Columns in query builder clas...

@"superior" Sure, I knew. But both of them have had a bug(table alias name) in CI4 +. I need to add mysql table name alias, after that, string or RawSQL doesn't work. For instance: PHP Code: -- ...

Thread: Using MySQL JSON Columns in query builder class
Post: Using MySQL JSON Columns in query builder class

I need to work with json data in mysql column. So,I've written the mysql query(for instance JSON_EXTRACT method) like this: PHP Code: -- $query = $this->db->query("select * FROM articles WHERE JSO...

Thread: Routes collection in modules config folder
Post: RE: Routes collection in modules config folder

iRedds Wrote: (07-21-2022, 07:43 AM) -- You can place modules in the root directory. As in the example from the documentation. In autoload, you need to specify the module namespace and its directory...

Thread: Routes collection in modules config folder
Post: RE: Routes collection in modules config folder

iRedds Wrote: (07-21-2022, 06:58 AM) -- 1. Placing modules in the app directory is a bad idea. 2. Controllers need to specify a namespace. 3. Have you registered the module in the autoload config? ...

Thread: Routes collection in modules config folder
Post: Routes collection in modules config folder

I've added Modules folder in parent of app, like that: PHP Code: -- app ----Modules ---------Contact --------------------Controllers ----------------------------ContactController.php -----------...

Thread: Build json_replace query
Post: RE: Build json_replace query

I've solved my problem use this: Code: -- $builder->where('id', $id)->set('information', "JSON_REPLACE(information, '$.settings.\"social-enable\"', $data)", false); --

Thread: Build json_replace query
Post: RE: Build json_replace query

@"kenjis" : I think my problem not related to the query method. I'v created my query use $db->query() like this: Code: -- $this->db->query('UPDATE users SET information = JSON_REPLACE(information,...

Thread: Build json_replace query
Post: RE: Build json_replace query

iRedds Wrote: (03-06-2022, 02:46 AM) -- $.settings[0].social-enable = {"settings" : [ { "social-enable" : 1} ]} -- @"iRedds" : I change to this but I see same error: Code: -- { "socialne...

Thread: Build json_replace query
Post: RE: Build json_replace query

@"iRedds" : Thanks for your reply. My Json is: Code: -- { "socialnetwork": { "twitter": "tw-u" }, "information": { "country": "Cuba", "state": "Sanct...

Thread: Build json_replace query
Post: Build json_replace query

I need to build JSON_REPLACE query like this: Code: -- UPDATE table_name SET subjectcombination = JSON_REPLACE(subjectcombination, '$.subjectcombination[0].college', 'ABC') WHERE id = 10; -- H...

Thread: Get Last Record In Each MySQL Group
Post: RE: Get Last Record In Each MySQL Group

Use Subqueries (https://www.codeigniter.com/user_guide/database/query_builder.html) method. ie: PHP Code: -- $builder = $this->db->table('posts'); $builder->select('id, category_i...

Thread: [SOLVED]Error: A non-numeric value encountered
Post: RE: Error: A non-numeric value encountered

kenjis Wrote: (02-09-2021, 01:38 AM) -- Not `$html += '';` But `$html .= '';` -- Thanks Fix it.

Thread: [SOLVED]Error: A non-numeric value encountered
Post: RE: Error: A non-numeric value encountered

kenjis Wrote: (02-09-2021, 01:34 AM) -- See Line 395 in C:\\MAMP\\htdocs\\ci4\\app\\Controllers\\ProductController.php. -- Line 395: Code: -- $html = ''; // Line 395 --