Welcome Guest, Not a member yet? Register   Sign In
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...
540 Views
4 Replies
03-15-2024, 05:01 AM
alakian
  Shocked 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...
540 Views
4 Replies
03-15-2024, 02:34 AM
alakian
    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...
416 Views
1 Replies
03-01-2024, 07:03 AM
alakian
    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...
9,745 Views
24 Replies
10-29-2023, 11:18 PM
alakian
    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?!
9,745 Views
24 Replies
10-29-2023, 03:49 AM
alakian
    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 ...
1,143 Views
1 Replies
10-06-2022, 02:15 AM
alakian
    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"; --
2,040 Views
4 Replies
09-25-2022, 04:36 AM
alakian
    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: -- ...
2,040 Views
4 Replies
09-24-2022, 11:03 AM
alakian
    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...
2,040 Views
4 Replies
09-23-2022, 04:02 AM
alakian
    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...
2,215 Views
6 Replies
07-22-2022, 12:20 AM
alakian
    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? ...
2,215 Views
6 Replies
07-21-2022, 07:19 AM
alakian
    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 -----------...
2,215 Views
6 Replies
07-21-2022, 05:57 AM
alakian
    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); --
2,896 Views
7 Replies
03-12-2022, 04:37 AM
alakian
    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,...
2,896 Views
7 Replies
03-07-2022, 02:31 AM
alakian
    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...
2,896 Views
7 Replies
03-07-2022, 01:12 AM
alakian
    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...
2,896 Views
7 Replies
03-07-2022, 12:18 AM
alakian
    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...
2,896 Views
7 Replies
03-06-2022, 12:46 AM
alakian
    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...
3,034 Views
1 Replies
02-09-2021, 08:25 AM
alakian
    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.
5,760 Views
4 Replies
02-09-2021, 01:40 AM
alakian
    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 --
5,760 Views
4 Replies
02-09-2021, 01:35 AM
alakian

Theme © iAndrew 2016 - Forum software by © MyBB