| # |
Oct 8th 2018, 11:17 |
 rrd564 |
@neon1024 thanks |
| # |
Oct 8th 2018, 11:17 |
neon1024 |
Or convert to array and use `array_unique` |
| # |
Oct 8th 2018, 11:16 |
neon1024 |
https://book.cakephp.org/3.0/en/core-libraries/collections.html#Cake\Collection\Collection::groupBy |
| # |
Oct 8th 2018, 11:16 |
neon1024 |
Probably `groupBy` would be my first guess |
| # |
Oct 8th 2018, 10:52 |
rrd564 |
what is the best way to get uniqe elements from a collection? For example in a blog I want to get all the tags used by the listed posts. |
| # |
Oct 8th 2018, 10:26 |
neon1024 |
The guys over in the PHP UG channel suggesting using ZAP Proxy, and it’s done great at identifying a bunch of things I can fix to help secure my project. |
| # |
Oct 8th 2018, 10:25 |
neon1024 |
Thanks! |
| # |
Oct 8th 2018, 10:25 |
josbeir |
sorry for the late reply :slightly_smiling_face: |
| # |
Oct 8th 2018, 10:24 |
josbeir |
@neon1024 yes escaped, unless you use updateAll and deleteAll etc |
| # |
Oct 8th 2018, 09:51 |
rudy1976s |
I normally avoid using json fields when I need to translate info |
| # |
Oct 8th 2018, 09:51 |
rudy1976s |
that was I though too |
| # |
Oct 8th 2018, 09:50 |
edgaras.jan |
possible but pretty hard |
| # |
Oct 8th 2018, 09:50 |
rudy1976s |
is possible ? |
| # |
Oct 8th 2018, 09:49 |
rudy1976s |
last question: what can be the best way to use Translate Behavior in such field ? |
| # |
Oct 8th 2018, 09:48 |
edgaras.jan |
`JSON_EXTRACT(json_field, '$.color')` |
| # |
Oct 8th 2018, 09:48 |
rudy1976s |
thank you ! |
| # |
Oct 8th 2018, 09:47 |
edgaras.jan |
Read here first https://dev.mysql.com/doc/refman/5.7/en/json.html |
| # |
Oct 8th 2018, 09:44 |
rudy1976s |
for example in the json field I have a field called color : is possibile to use the ->where using the color json field? |
| # |
Oct 8th 2018, 09:42 |
rudy1976s |
but the query builder “knows” the fileds contained in the json ? |
| # |
Oct 8th 2018, 09:41 |
neon1024 |
The MySQL documentation shows you all the various sql you can use |
| # |
Oct 8th 2018, 09:41 |
neon1024 |
Sure you can |
| # |
Oct 8th 2018, 09:41 |
rudy1976s |
the column is used to store record parameters and sometimes I need to query against a value contained in that field |
| # |
Oct 8th 2018, 09:40 |
rudy1976s |
can I use the json fields in the query builder ? |
| # |
Oct 8th 2018, 09:39 |
rudy1976s |
I using a table with a columns used as json type |
| # |
Oct 8th 2018, 09:39 |
rudy1976s |
good morning |
| # |
Oct 8th 2018, 08:49 |
neon1024 |
I’m not convinced there are any, but need to test anyway |
| # |
Oct 8th 2018, 08:49 |
neon1024 |
I need to test my application for injections |
| # |
Oct 8th 2018, 08:47 |
neon1024 |
`->where(['example' => $escaped]);` |
| # |
Oct 8th 2018, 08:47 |
neon1024 |
Just to sanity check, the values in a condition array are already escaped right? |
| # |
Oct 8th 2018, 08:00 |
turkles |
gooday |
| # |
Oct 8th 2018, 07:56 |
josbeir |
goood morning cakephphphhhhh |
| # |
Oct 8th 2018, 07:54 |
neon1024 |
Morning all |
| # |
Oct 8th 2018, 07:15 |
turkles |
I don't see why you would want to lose all that lovely functionality by doing that |
| # |
Oct 8th 2018, 07:15 |
turkles |
start_date is an object, so is at that level |
| # |
Oct 7th 2018, 22:59 |
rightscoreanalysis |
[0] => [id => 103, start_date => 'xxxx', 'end_date' => 'xxxx', 'object' => [.........] ] |
| # |
Oct 7th 2018, 22:58 |
rightscoreanalysis |
it could even be of the format: |
| # |
Oct 7th 2018, 22:57 |
rightscoreanalysis |
but I would like start_and end_date extracted into the top level index |
| # |
Oct 7th 2018, 22:57 |
slackebot |
<rightscoreanalysis> |
| # |
Oct 7th 2018, 22:56 |
rightscoreanalysis |
for example this is my collection after groupby id |
| # |
Oct 7th 2018, 22:56 |
rightscoreanalysis |
@admad do you know if I can add other fields to the index I have grouped by |
| # |
Oct 7th 2018, 20:43 |
rightscoreanalysis |
perfect it works just as I need thank you |