Welcome Guest, Not a member yet? Register   Sign In
Search Results
    Thread: JOIN tables from different databases (same server) - c14
Post: RE: JOIN tables from different databases (same ser...

iRedds Wrote: (07-11-2022, 06:23 PM) -- You must have an account with the privilege to grant privileges to other users. See the documentation for your DBMS for details. All manipulations with users ...
306 Views
4 Replies
07-12-2022, 11:38 AM
68thorby68
    Thread: JOIN tables from different databases (same server) - c14
Post: RE: JOIN tables from different databases (same ser...

iRedds Wrote: (07-11-2022, 04:15 AM) -- Set permissions for account1 to access db2. -- Thank you, but I'm not really sure how to achieve this! Would this be done on the database connection? ...
306 Views
4 Replies
07-11-2022, 03:02 PM
68thorby68
    Thread: JOIN tables from different databases (same server) - c14
Post: JOIN tables from different databases (same server)...

Hi all, Using Ci4, I have a need to run a query on two tables in different databases (table1 on db1, table2 on db2). I have 2 connections configured & working fine for everything else in //Config/Dat...
306 Views
4 Replies
07-11-2022, 03:15 AM
68thorby68
    Thread: Database Migration
Post: RE: Database Migration

kenjis Wrote: (01-27-2022, 04:16 AM) -- Maybe you are not aware of the distinction between DB Migrations and DBForge. https://codeigniter4.github.io/userguide/dbmgmt/forge.html -- OMG, I can't bel...
1,417 Views
9 Replies
01-27-2022, 04:27 AM
68thorby68
    Thread: Database Migration
Post: RE: Database Migration

iRedds Wrote: (01-22-2022, 09:33 AM) -- There is currently a problem with the default value. The key only supports a string value. You can define a database field as a string. Passing strings as fie...
1,417 Views
9 Replies
01-27-2022, 03:56 AM
68thorby68
    Thread: Database Migration
Post: RE: Database Migration

[quote pid="393220" dateline="1642861515"] After running numerous tests and trying to follow the documentation, I don't believe Migrations will work for me at this time. Not only is it very unclear h...
1,417 Views
9 Replies
01-22-2022, 07:29 AM
68thorby68
    Thread: Database Migration
Post: RE: Database Migration

Thank you BilltheCat and InsiteFX for your feedback, your comments are much appreciated. My development is an application that allows companies to track progress of their own jobs, quotes and ultimat...
1,417 Views
9 Replies
01-22-2022, 04:08 AM
68thorby68
    Thread: Database Migration
Post: Database Migration

Hi, I hope someone can help? I've spent an awful lot of time trying to  Database Migrations working, I've followed the user manual closely and eventually got a prototype working with latest() me...
1,417 Views
9 Replies
01-21-2022, 02:20 PM
68thorby68
    Thread: Validation Database Group Definition
Post: RE: Validation Database Group Definition

kenjis Wrote: (01-20-2022, 06:44 PM) -- Try to add 'DBGroup' key and its value in the data to validate. Try to use `Validation::run()` method with the third param DBGroup. PHP Code: -- run(?ar...
622 Views
2 Replies
01-21-2022, 04:10 AM
68thorby68
    Thread: Validation Database Group Definition
Post: Validation Database Group Definition

Hi, On my Ci4 app I have split my customers tables (prefixed per customer) accross a number of databases and therefore have a number of defined database groups. I control access to the correct databa...
622 Views
2 Replies
01-20-2022, 06:17 AM
68thorby68
    Thread: Database Connection Vars
Post: Database Connection Vars

Hi, Using Ci4, is there a way of sending Database Group variables with the connection statement? i.e. Could  do something like this? PHP Code: -- $db = db_connect('$databaseGroup',['DBPrefix' => s...
348 Views
0 Replies
01-19-2022, 04:17 AM
68thorby68
    Thread: Multiple Databases
Post: Multiple Databases

Hi, I've created my application with CI4 and have got to the point where I need to extend my database for multiple clients. My database has 20 tables (10 less than 100 rows, 10 with 100,000's rows). ...
214 Views
0 Replies
01-09-2022, 08:04 AM
68thorby68
    Thread: Ci4 as Single Page Application (SPA)
Post: RE: Ci4 as Single Page Application (SPA)

Many thanks seunex, My application is designed (mainly) for desktop use and is therefore 100% accessed via a browser atm. However, I think parts of the application will probably benefit being access ...
1,614 Views
4 Replies
12-15-2021, 06:33 AM
68thorby68
    Thread: Ci4 as Single Page Application (SPA)
Post: Ci4 as Single Page Application (SPA)

Hi, Has anyone used Ci4 to create a Single Page Application? My end game is to create a SPA for certain functions of my Ci4 development to use with Apache Cordova, so I can generate an App for the...
1,614 Views
4 Replies
12-07-2021, 03:04 AM
68thorby68
    Thread: Accessing Controller with CRON
Post: RE: Accessing Controller with CRON

Thank you everyone for your input and help, but I found the issue was nothing to do with Codeigniter at all. It is all to do with the setup on the hosting servoice and access the correct php. Codeign...
1,870 Views
8 Replies
12-07-2021, 02:55 AM
68thorby68
    Thread: Accessing Controller with CRON
Post: RE: Accessing Controller with CRON

kenjis Wrote: (11-21-2021, 05:41 AM) -- It should be /home/my-app/app/Controllers/Test.php. And its class name should be Test. And run: /usr/bin/php /home/my-app/mydonain.co.uk/index.php test >>...
1,870 Views
8 Replies
11-21-2021, 06:07 AM
68thorby68
    Thread: Accessing Controller with CRON
Post: RE: Accessing Controller with CRON

kenjis Wrote: (11-18-2021, 04:06 PM) -- Check your letter case of filename, folder name and classname. Tools.php class Tools -- Thank you all so much for you help. To ensure I have my paths, f...
1,870 Views
8 Replies
11-21-2021, 05:30 AM
68thorby68
    Thread: Accessing Controller with CRON
Post: RE: Accessing Controller with CRON

Thanks for pointing me in the right direction. But the reference in the Codigniter manual doesn't seen to work. I used the example line for line as in the manual (copy/paste the Tools controller and ...
1,870 Views
8 Replies
11-18-2021, 12:30 PM
68thorby68
    Thread: Accessing Controller with CRON
Post: Accessing Controller with CRON

Hi All, My Ci4 project is in a hosted environment where my Ci4 application is physically located in /home/my-app/ and served from my domain /home/my-app/mydomain.co.uk I am trying to run a CRON job ...
1,870 Views
8 Replies
11-17-2021, 10:37 AM
68thorby68
    Thread: form_dropdown()
Post: RE: form_dropdown()

Thank you includebeer. I toyed with this for quite a while, obviously with no luck and thought I was missing something. I will have to take a different approach, but isn't that half the fun? Aga...
956 Views
2 Replies
11-09-2021, 04:32 PM
68thorby68

Theme © iAndrew 2016 - Forum software by © MyBB