CodeIgniter Forums - Search Results

Pages (4): 1 2 3 4 Next »

Search Results

Thread: migration: change field type in FK
Post: migration: change field type in FK

I want to change a bunch of fieldtypes (from smallint to mediumint). But most of them are foreign keys, so updating them results in "Cannot change column 'X': used in a foreign key constraint 'Y'... I...

Thread: SQL query with 1 fixed and 2 OR conditions
Post: SQL query with 1 fixed and 2 OR conditions

Hi all, I am trying to find a clean way (without using raw SQL) to do this: SELECT * FROM table WHERE user_id = 123 AND (role_id IN (1,2,3,4) OR role_id IS NULL) So I always need to check the user_...

Thread: DataException: There is no data to update after using save()
Post: RE: DataException: There is no data to update afte...

I was wondering if there is already a solution for this (unwanted) behaviour? I am facing the same issues. My users often just click save without actually saving anything. I don't want to 'Whoops'...

Thread: restrict query in callback
Post: RE: restrict query in callback

I've looked into that.... But how would I fit that into a callback function in the Model? I don't want to use the WHEN method on every insert query, I would like to centralize it in the model

Thread: restrict query in callback
Post: restrict query in callback

Hi, I want to do some checks prior to some queries in the model. In the $beforeUpdate and $beforeDelete callback I append the query by PHP Code: -- $this->builder()->where('id', null); -- when the...

Thread: Append all SELECT queries with an extra WHERE in model
Post: RE: Append all SELECT queries with an extra WHERE ...

Yes, got it... What is, in your opinion, the best way to get the USER_ID into this method... PHP Code: -- protected $beforeFind = ['userSpecific']; protected function userSpecific()...

Thread: Append all SELECT queries with an extra WHERE in model
Post: RE: Append all SELECT queries with an extra WHERE ...

Thanks. I will probably need beforefind then. I see how I can alter the query data, but not the query itself. Does the manuals have an example for that as well?

Thread: Append all SELECT queries with an extra WHERE in model
Post: Append all SELECT queries with an extra WHERE in m...

Hi, Is there a way in CI 4 to have ALL the SELECT (find/findall) queries done by a specific model to append by an extra WHERE condition? In this case I want 3 models to do an extra: WHERE user_id = 12...

Thread: connect to database mid-script
Post: RE: connect to database mid-script

Can I run another cli command from this cli command. Then I can put this migration in the second one. Then the .env should be loaded when runnning the second one.

Thread: connect to database mid-script
Post: RE: connect to database mid-script

In this particular case the password should be empty, it's a local XAMP install. I have tried it with another user and pass, results are the same.

Thread: connect to database mid-script
Post: RE: connect to database mid-script

I'm afraid that doesn't work. Here's what I did... PHP Code: -- $config = [ 'hostname' => $dbHost, 'username' => $dbUser, 'password' => $dbPass, ...

Thread: custom validation rule fails
Post: RE: custom validation rule fails

I have placed it in \Custom\CustomValidationRules.php And added that class in The validation config as well

Thread: connect to database mid-script
Post: connect to database mid-script

Hi, I have created a CLI command which sets up the database. The user is asked for DB credentials. PHP Code: -- $dbHost = CLI::prompt('Database host', 'localhost'); $dbName = CLI:...

Thread: custom validation rule fails
Post: RE: custom validation rule fails

I think I already know why this is failing.... Can this be the case because the validator only has access to the primary key and CHANGED values? In this case the PARENT_ID is not changed, so it might...

Thread: custom validation rule fails
Post: custom validation rule fails

Hi all, I have this strange behaviour in my custom validation rule. In my model I have this validation: PHP Code: -- protected $validationRules = [ 'name' => 'is_double_unique[categori...

Thread: Programmaticaly clear webpage cache
Post: RE: Programmaticaly clear webpage cache

Thanks, Solved it by doing: PHP Code: -- @unlink(WRITEPATH.'/cache/'.md5(base_url($slug))); -- Whenever I update a page

Thread: External redirects
Post: External redirects

Hi, I would like to have an external redirect to my payment provider. So I tried using: PHP Code: -- $this->response->setHeader('Location', $payment->getCheckoutUrl()); -- This doesn't work. Just a ...

Thread: Programmaticaly clear webpage cache
Post: RE: Programmaticaly clear webpage cache

I understand. But how does CI knows which file to render? The filenames are random.

Thread: Programmaticaly clear webpage cache
Post: RE: Programmaticaly clear webpage cache

Thanks. One last question. Is there some sort of table somewhere which matches the cache file with the right url? I assume CI doesnt loop through all the cached files to see which one to use.

Thread: Programmaticaly clear webpage cache
Post: RE: Programmaticaly clear webpage cache

For when the content changes before cache expiry