Welcome Guest, Not a member yet? Register   Sign In
Search Results
    Thread: DATE_SUB gives 0 results
Post: DATE_SUB gives 0 results

Hi guys, I know this question isn't specifically CI related, but I hope you'll endulge me a little. I have two tables: evenementen: evenement_id INT (Primary, A_I) evenement_begindatum DATE even...
615 Views
1 Replies
07-12-2022, 04:25 AM
BFlokstra
    Thread: SQL Query with SUM()
Post: SQL Query with SUM()

Hi guys, Here is some background: I am building a claim system for our volunteers. Any time a volunteer uses their own car to get to a shift, they get €0,19 per kilometer to go towards gas. If they ...
880 Views
0 Replies
03-01-2022, 04:54 AM
BFlokstra
    Thread: Unique customer
Post: RE: Unique customer

Thanks insiteFX!
1,577 Views
3 Replies
08-27-2021, 03:18 AM
BFlokstra
    Thread: Unique customer
Post: Unique customer

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 something internal if it’s available.  I have a...
1,577 Views
3 Replies
08-27-2021, 01:21 AM
BFlokstra
    Thread: Insert return false but inserts succesfully
Post: Insert return false but inserts succesfully

I'm wreaking my brain, unable to figure this one out.  I have the folowing code: PHP Code: -- if ($klantenModel->insert([                         'id' => $this->request->getPost('id'),         ...
1,356 Views
1 Replies
08-13-2021, 01:43 AM
BFlokstra
    Thread: Form validation is_unique: valid if value is in current row, invalid on any other row
Post: RE: Form validation is_unique: valid if value is i...

I know it is in the documentation. You never completely read over something when being stuck on a problem for a while?
5,282 Views
7 Replies
05-09-2021, 10:26 PM
BFlokstra
    Thread: Email smtp: mail not send - no error
Post: RE: Email smtp: mail not send - no error

that’s what I did originally but I got extreme timeouts. (Way over 180 seconds). The webhost advised to use localhost as the smtp server host name but then I get no errors but the mail isn’t send. It ...
5,883 Views
7 Replies
05-09-2021, 10:09 AM
BFlokstra
    Thread: Email smtp: mail not send - no error
Post: RE: Email smtp: mail not send - no error

That's okay demyr. I'll keep looking. I rather not install a third party library if I don't have to for two simple reasons. I found that (when not sending via smtp) the build in Email class of CI4 i...
5,883 Views
7 Replies
05-09-2021, 06:53 AM
BFlokstra
    Thread: Form validation is_unique: valid if value is in current row, invalid on any other row
Post: RE: Form validation is_unique: valid if value is i...

You're welcome! It's so irritating when people don't do that. It's like they thing "I had to look for days, let others do the same"
5,282 Views
7 Replies
05-09-2021, 06:40 AM
BFlokstra
    Thread: Form validation is_unique: valid if value is in current row, invalid on any other row
Post: Form validation is_unique: valid if value is in cu...

I have a form where I edit customer information. There are two fields that have to be unique: - organisatie_naam, - contactpersoon_email When inserting the customer the is_unique validation works...
5,282 Views
7 Replies
05-09-2021, 05:10 AM
BFlokstra
    Thread: Email smtp: mail not send - no error
Post: RE: Email smtp: mail not send - no error

Thanks demyr, for your reply. Is there any way of doing this without using a third party library? The way I understand the documentation is that the build in Email class of Codeigniter 4 should be abl...
5,883 Views
7 Replies
05-09-2021, 04:58 AM
BFlokstra
    Thread: Email smtp: mail not send - no error
Post: Email smtp: mail not send - no error

I'm trying to send an e-mail from my website using the build in e-mail class and smtp. When using the mail protocol, the mail is send without incident. With smtp the mail is not send but printDebugger...
5,883 Views
7 Replies
05-08-2021, 04:03 AM
BFlokstra
    Thread: form POST to same page, request method remains GET
Post: RE: form POST to same page, request method remains...

Yeah! I tried CI a while back because of it's ease of use and the fact that it's not filled with "everything you ever might, maybe, someday, perhaps might want to use. It does what you need it to do. ...
2,014 Views
4 Replies
04-17-2021, 03:46 PM
BFlokstra
    Thread: form validation is_unique using array
Post: RE: form validation is_unique using array

That was exactly what I needed! Thanks!
2,997 Views
6 Replies
04-17-2021, 03:43 PM
BFlokstra
    Thread: form POST to same page, request method remains GET
Post: RE: form POST to same page, request method remains...

Thanks! I have been working at this problem for the better part of a day and couldn't figure it out. And one removing little slash was all it took! One this is for sure..... I'm not going to forget th...
2,014 Views
4 Replies
04-17-2021, 03:24 PM
BFlokstra
    Thread: form validation is_unique using array
Post: form validation is_unique using array

I have a for that inputs a batch of data into the database. The form has one field where the barcodes for a product are inserter, seperated by comma's. Using explode I make an array out of it.  Wha...
2,997 Views
6 Replies
04-17-2021, 02:51 PM
BFlokstra
    Thread: form POST to same page, request method remains GET
Post: form POST to same page, request method remains GET

I'm trying to post a form to the current page and process it there. To this end I addes a matched route to Routes.php: PHP Code: -- $routes->match(['get', 'post'], 'klanten/(:segment)', 'Klanten::bew...
2,014 Views
4 Replies
04-17-2021, 08:40 AM
BFlokstra
    Thread: Redirect - pass message to next page
Post: RE: Redirect - pass message to next page

Thanks! This worked perfectly. And with a little tweaking I even managed to pas along different types of messages (errors and success messages)
1,933 Views
2 Replies
12-25-2020, 02:54 AM
BFlokstra
    Thread: Redirect - pass message to next page
Post: Redirect - pass message to next page

Not sure if this is in the right place.... I need to perform a redirect after a database action (delete). I have added the folowing line:  return redirect()->to('/evenementen/' . url_title($evenem...
1,933 Views
2 Replies
12-22-2020, 11:57 AM
BFlokstra
    Thread: CI4 JOIN gives duplicate (and more) results
Post: RE: CI4 JOIN gives duplicate (and more) results

Managed to solve the problem with some help elsewhere. I removed the from line and changes ->table to: $builder = $db->table('eenheden as e'); Not is works as expected. Sometimes one works on ...
1,767 Views
1 Replies
06-21-2020, 05:10 AM
BFlokstra

Theme © iAndrew 2016 - Forum software by © MyBB