Hi,
I searched the web hours for this but now I have to ask.
How can I set values to NULL if there are empty? When I try to execute
$form->create();I get the error "Exception: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'heart_rate' at row 1" because heart_rate is an empty string. How can I set it automatically to NULL?
Just, for example,
$str = ''; echo (int)$str;
This will lead to zeros in my database. I need NULLs.
This is what I use for my custom models.
//removes all NULL, FALSE and empty strings but leaves 0 (zero) values
$buffer = array_filter($modelData, 'strlen'); //$modelData is an arrayThis is what I use for my custom models.
//removes all NULL, FALSE and empty strings but leaves 0 (zero) values $buffer = array_filter($modelData, 'strlen'); //$modelData is an array
That looks promising. Where do you get $modelData from?
It's out of scope of this topic (like I said, custom Models/ORM implementation).
You should focus on array_filter like I provided in example.