Welcome Guest, Not a member yet? Register   Sign In
Search Results
    Thread: How get null result if not found in Mysql
Post: RE: How get null result if not found in Mysql

SELECT * FROM tbl_order WHERE DATE(order_date) IN ('2021-01-01','2021-01-02','2021-01-03','2021-01-04','2021-01-05') OR order_date IS NULL GROUP BY DATE(order_date)
246 Views
6 Replies
01-13-2022, 02:01 AM
nfaiz
    Thread: Codeigniter 4 and Inertia JS
Post: RE: Codeigniter 4 and Inertia JS

No package release. Use dev-master or dev-main Code: -- composer require amirami/inertia-codeigniter-4:dev-master --
772 Views
1 Replies
11-22-2021, 09:16 AM
nfaiz
    Thread: mpdf class not fount error CI 4.1.5
Post: RE: mpdf class not fount error CI 4.1.5

Are you sure the installation is in ci4-mpdf directory?
1,016 Views
10 Replies
11-21-2021, 04:18 AM
nfaiz
    Thread: retrieving data from a database and re-retrieving from another database
Post: RE: retrieving data from a database and re-retriev...

Please avoid N+1 query (unless you have a different DBGroup connection)
684 Views
7 Replies
10-26-2021, 04:27 AM
nfaiz
    Thread: retrieving data from a database and re-retrieving from another database
Post: RE: retrieving data from a database and re-retriev...

Join table using SQL?
684 Views
7 Replies
10-25-2021, 07:26 AM
nfaiz
    Thread: insert/update null instead of blank (spaces) in ci4
Post: RE: insert/update null instead of blank (spaces) i...

Halim Wrote: (10-24-2021, 06:10 PM) -- Is there a better way to clean up the data before insert/update, what I mean by clean up is: if the posted value is blank (or composed of many spaces) then inse...
746 Views
1 Replies
10-25-2021, 05:56 AM
nfaiz
    Thread: How to activate debugging role wise?
Post: RE: How to activate debugging role wise?

sr13579 Wrote: (10-16-2021, 04:47 PM) -- For a live project how can I hide debugging feature for normal user? I just want to show it only for developers. Please give me a solution. -- app/Config...
509 Views
4 Replies
10-16-2021, 11:44 PM
nfaiz
    Thread: How to debug ajax requests?
Post: RE: How to debug ajax requests?

DrSiemer Wrote: (10-06-2021, 07:22 AM) -- Hi! New CI user here. Pretty happy with it so far, but the things that puzzles me is debugging failed ajax requests. So far I've been able to figure out w...
758 Views
4 Replies
10-09-2021, 08:55 PM
nfaiz
    Thread: convert sql
Post: RE: convert sql

Tajar_Dobro Wrote: (09-20-2021, 04:19 AM) -- Hi guys how can I convert the value of integer to text, example if it is 0 to display not paid and 1 to display paid On model //get chart public functi...
1,321 Views
5 Replies
09-20-2021, 05:44 AM
nfaiz
    Thread: Removing session data too quickly after updating to CI 4.1.3
Post: RE: Removing session data too quickly after updati...

ciddict Wrote: (09-04-2021, 09:15 PM) -- Can you please let me know where should I check? -- This (https://www.codeigniter.com/user_guide/libraries/sessions.html#session-preferences)?
814 Views
8 Replies
09-05-2021, 01:45 AM
nfaiz
    Thread: Unique customer
Post: RE: Unique customer

BFlokstra Wrote: (08-27-2021, 01:21 AM) -- I’m facing a small problem and hope CodeIgniter 4 has some build in way to handle this. I’m more then willing to write something myself, but rather use some...
513 Views
3 Replies
08-27-2021, 05:00 AM
nfaiz
    Thread: Ci4 orderBy Float Value
Post: RE: Ci4 orderBy Float Value

hieuhiti Wrote: (08-22-2021, 07:27 AM) -- Hi All, I have a little problem with sort values (Float type) from database mysql. I use -> orderBy("FieldFloat","desc"),  But incorrect result, Please helpm...
681 Views
4 Replies
08-22-2021, 08:26 PM
nfaiz
    Thread: JS and CSS URL change
Post: RE: JS and CSS URL change

eddoh Wrote: (08-21-2021, 03:37 AM) -- Hello, I have a problem with a methohe from a controller. Indeed, when I call it the js and css loading path changes and they fail to load. correct path :...
446 Views
1 Replies
08-22-2021, 12:05 AM
nfaiz
    Thread: updated_at is not updating
Post: RE: updated_at is not updating

nneves Wrote: (08-18-2021, 04:50 PM) -- Hi In my model I have this settings and when I insert a record, both created_at and updated_at are updated Code: -- protected $table = 'strings'; prote...
1,288 Views
11 Replies
08-19-2021, 04:59 AM
nfaiz
    Thread: Problem in accessing query in construct
Post: RE: Problem in accessing query in construct

neto737 Wrote: (08-08-2021, 03:18 PM) -- InsiteFX Wrote: (08-08-2021, 01:18 AM) -- Add a method in your BaseController to get the settings. Example: PHP Code: -- protected function getSettings() ...
860 Views
5 Replies
08-08-2021, 08:49 PM
nfaiz
    Thread: sending profiler data to disk?
Post: RE: sending profiler data to disk?

I'm not sure if this can help. You can try to use this library (https://github.com/nfaiz/dbtoolbar). Configure the library by setting $logger (https://github.com/nfaiz/dbtoolbar#2-library-config...
631 Views
2 Replies
08-06-2021, 07:24 AM
nfaiz
    Thread: Form Action URL Question
Post: RE: Form Action URL Question

Charles Luck Wrote: (08-02-2021, 09:04 AM) -- Hi, I'm new to Codeigniter4. And I have a question about something that I don't understand. First let me say that the tool bar above is difficult to ...
605 Views
3 Replies
08-03-2021, 04:36 AM
nfaiz
    Thread: Class not found for elFinder(Open-source file manager for web) in Codeigniter 4
Post: RE: Class not found for elFinder(Open-source file ...

mrkzs Wrote: (08-02-2021, 01:55 PM) -- Thanks you brother @"nfaiz" it's already solved by @"paulbalandan" on this post subject  :)  but facing a new problem. I also test with your code but have a pro...
954 Views
4 Replies
08-02-2021, 09:53 PM
nfaiz
    Thread: Model not using DBGroup
Post: RE: Model not using DBGroup

Do you have any other folder in app/Models? how do you call the model in controller? PHP Code: -- $model = new App\Models\FiscalYears(); -- or PHP Code: -- $model = model(FiscalYears::cla...
896 Views
7 Replies
07-30-2021, 07:46 PM
nfaiz
    Thread: Class not found for elFinder(Open-source file manager for web) in Codeigniter 4
Post: RE: Class not found for elFinder(Open-source file ...

mrkzs Wrote: (07-28-2021, 05:16 AM) -- Hi, I'm using elFinder(Open-source file manager for web) in Codeigniter 3, works fine but in Codeigniter 4.1.3 i can not integrate it and show me some error. I ...
954 Views
4 Replies
07-29-2021, 06:59 AM
nfaiz

Theme © iAndrew 2016 - Forum software by © MyBB