| # |
Apr 26th 2019, 11:43 |
matr |
$searchValueArr = ["keyword1","keyword2"]; $customers = $customersTable->find() ->where(function (QueryExpression $exp) { $orConditions = $exp->or_(function ($or) { foreach($searchValueArr as $searchValue) { $or = $or ->eq('prename LIKE', "%".$searchValue."%") ->eq('name LIKE', "%".$searchValue."%"); } return $or; }); return $orConditions; }) ->all(); |
| # |
Apr 26th 2019, 11:42 |
matr |
or conditions in cakephp are quite tricky as i realised, my issue is that i have a list of searchwords in an array ["keyword1","keyword2",...] and i want to compare it to my customers pre- and lastname so i tried the following query |
| # |
Apr 26th 2019, 11:40 |
matr |
hi guys |
| # |
Apr 26th 2019, 10:56 |
 martin |
maybe sendmail fails and then email fials |
| # |
Apr 26th 2019, 10:56 |
martin |
an unknown error |
| # |
Apr 26th 2019, 10:56 |
martin |
Hmm yes that is validator, But I did code a piece that email to the owner of website so I just did $email->setTo(‘user@domain.com’) but that gives error |
| # |
Apr 26th 2019, 10:14 |
neon1024 |
More of a sidestep though |
| # |
Apr 26th 2019, 10:14 |
neon1024 |
As the second validation param checks the MX |
| # |
Apr 26th 2019, 10:13 |
neon1024 |
https://api.cakephp.org/3.7/class-Cake.Validation.Validator.html#_email |
| # |
Apr 26th 2019, 10:11 |
neon1024 |
@martin You could use the second param of the email validation to ensure there is a correct domain iirc |
| # |
Apr 26th 2019, 10:05 |
martin |
not direct an exception in cakephp |
| # |
Apr 26th 2019, 10:05 |
martin |
I see the domain does not have email configured yet (no mx records), so I think that is the problem, but I expect that it fails later |
| # |
Apr 26th 2019, 10:04 |
martin |
When emailadres does not exists the email class in cakephp gives unknown error? that is new for me :| |
| # |
Apr 26th 2019, 09:52 |
patox44 |
I tried run it without /stock, but with or without paterns I get Object not found. Maybe I have to set special option or something like that? |
| # |
Apr 26th 2019, 09:41 |
asdfgh |
:) he he ok |
| # |
Apr 26th 2019, 09:39 |
neon1024 |
Code which has never been written can never be refactored |
| # |
Apr 26th 2019, 09:39 |
neon1024 |
Have some self-confidence! |
| # |
Apr 26th 2019, 09:39 |
asdfgh |
ah ... ok :D |
| # |
Apr 26th 2019, 09:39 |
neon1024 |
If it works, then it is the correcy way |
| # |
Apr 26th 2019, 09:39 |
asdfgh |
it returns 'http://localhost:7895' |
| # |
Apr 26th 2019, 09:38 |
asdfgh |
neon1024, i have tried the code, it is working...i am just asking if this is the correct way |
| # |
Apr 26th 2019, 09:38 |
neon1024 |
I would suggesting trying some stuff by yourself rather than checking every keypress with Slack |
| # |
Apr 26th 2019, 09:37 |
neon1024 |
PHP can parse your code for you. You don’t need me to parse your code for you. |
| # |
Apr 26th 2019, 09:36 |
asdfgh |
this ?? |
| # |
Apr 26th 2019, 09:36 |
asdfgh |
neon1024 pardon just to be sure, $this->getRequest()->getUri()->getScheme() . "://" . $this->getRequest()->getUri()->getHost() . ":" . $this->getRequest()->getUri()->getPort() |
| # |
Apr 26th 2019, 09:32 |
asdfgh |
i should avoid adding :80 |
| # |
Apr 26th 2019, 09:32 |
asdfgh |
i should check when it will be in production |
| # |
Apr 26th 2019, 09:32 |
asdfgh |
so i have 8888 port |
| # |
Apr 26th 2019, 09:32 |
asdfgh |
however now i am testing in local server |
| # |
Apr 26th 2019, 09:32 |
asdfgh |
thanks |
| # |
Apr 26th 2019, 09:32 |
asdfgh |
i will concatenate host and port |
| # |
Apr 26th 2019, 09:32 |
asdfgh |
thanks |
| # |
Apr 26th 2019, 09:32 |
asdfgh |
ok |
| # |
Apr 26th 2019, 09:32 |
asdfgh |
neon1024 ok that was my doubt...i thought there was a method to get all the info with the port too |
| # |
Apr 26th 2019, 09:31 |
neon1024 |
You can use `$this->here` but it’s being deprecated, so implementing the PSR7 interface is preferred |
| # |
Apr 26th 2019, 09:31 |
neon1024 |
Yes |
| # |
Apr 26th 2019, 09:31 |
asdfgh |
neon1024 pardon i do not follow you, should i "compose" the url by getting getHost() and thne getPort() ? |
| # |
Apr 26th 2019, 09:31 |
neon1024 |
`->setPatterns(['code' => '[\w-\/]+'])` ? |
| # |
Apr 26th 2019, 09:30 |
neon1024 |
Could the pattern not be used to match a `/` ? |
| # |
Apr 26th 2019, 09:30 |
neon1024 |
Although in that instance I think `**` might include the `/stock` part :thinking_face: |
| # |
Apr 26th 2019, 09:29 |
neon1024 |
Might be worth checking the book, as I’m not 100% certain |