Welcome Guest, Not a member yet? Register   Sign In
Search Results
    Thread: localize databases with working searching and ordering?
Post: RE: localize databases with working searching and ...

Ok, rewrote the query myself using CTE (which is unfortunatelly not supported by QueryBuilder) Code: -- 'with translated as ( select id, CASE WHEN colors.name = "Colors.black" THEN "' . lang('C...
561 Views
12 Replies
06-12-2024, 12:19 AM
Kimotu
    Thread: localize databases with working searching and ordering?
Post: RE: localize databases with working searching and ...

I tried something like this. All predefined standard colors would get translated, user defined ones in the language what they used during naming. Then I could use translated_name as search and order ...
561 Views
12 Replies
06-11-2024, 02:13 AM
Kimotu
    Thread: localize databases with working searching and ordering?
Post: RE: localize databases with working searching and ...

JustJohnQ Wrote: (06-10-2024, 01:02 PM) -- We're talking about a colors table, right? What garbage do you mean? -- You have one additional column per language and if you do no restrict SELECT to on...
561 Views
12 Replies
06-11-2024, 01:52 AM
Kimotu
    Thread: localize databases with working searching and ordering?
Post: RE: localize databases with working searching and ...

It is not so easy. It is a search input, that is not restricted to one database column. You can search a term and it is looked up in serveral columns and all matching ones are shown. You can try he...
561 Views
12 Replies
06-10-2024, 07:16 AM
Kimotu
    Thread: localize databases with working searching and ordering?
Post: localize databases with working searching and orde...

Hello, I try to implement an application that can be localized. Text in php and views is no problem, since I can use 'lang()', but now I have a database table that holds colors and their name. I...
561 Views
12 Replies
06-10-2024, 12:57 AM
Kimotu
    Thread: Do CodeIgniter 4 model instances already have Query Builder methods loaded?
Post: RE: Do CodeIgniter 4 model instances already have ...

You usually do not have to load them manually. No matter whether I use Code: -- $model = model('App\Model\MyModel::class); $model->find($id); $model->where('id>',100)->get()->getResult(); -- or...
168 Views
2 Replies
06-10-2024, 12:10 AM
Kimotu
    Thread: Shield: validFields includes username but does not pass validation
Post: RE: Shield: validFields includes username but does...

datamweb Wrote: (11-03-2022, 03:06 PM) -- Hi, Login username see: https://github.com/codeigniter4/shield/discussions/323 Is Shield ready for production or still beta? https://forum.codei...
3,109 Views
2 Replies
11-08-2022, 03:54 AM
Kimotu
    Thread: How to make it a "Framework with a small footprint" again?
Post: RE: How to make it a "Framework with a small footp...

[quote pid="402590" dateline="1667603944"] Code: -- composer install --no-dev -- [/quote] Thanks for the hint. This is what I was looking for. But I still have a question: I did: Code: -- compos...
5,614 Views
11 Replies
11-07-2022, 01:24 AM
Kimotu
    Thread: How to make it a "Framework with a small footprint" again?
Post: How to make it a "Framework with a small footprint...

Hi all, CodeIgniter is advertised as a Quote: -- Framework with a small footprint -- But this is only true if you manually clean up all those test, vendor, contribution directories. If you ha...
5,614 Views
11 Replies
11-03-2022, 11:53 PM
Kimotu
    Thread: Shield: validFields includes username but does not pass validation
Post: Shield: validFields includes username but does not...

Hi all, currently I am migrating from Myth\Auth to Shield and have issues to allow username additional to mail as login credential. Auth.php: PHP Code: -- public array $validFields = [        ...
3,109 Views
2 Replies
11-03-2022, 06:47 AM
Kimotu

Theme © iAndrew 2016 - Forum software by © MyBB