Log message #4199367

# At Username Text
# Aug 22nd 2019, 09:54 neon1024 https://book.cakephp.org/3.0/en/controllers/middleware.html#csrf-protection-and-ajax-requests
# Aug 22nd 2019, 09:54 challgren @neon1024 my option was to skip CSRF on those actions
# Aug 22nd 2019, 09:53 neon1024 As PHP will not have access to any of the form fields
# Aug 22nd 2019, 09:53 neon1024 When working in Javascript to build a form, how can I submit the correct CSRF Token? I am dynamically adding fields to the form using Javascript. So I assume the token needs to update every time a form field is added or removed? Or can I just skip the middleware for these few controller actions?
# Aug 22nd 2019, 09:49 alexdd55976 @neon1024 the paying decision is not on my... i will recommend buying a nice one, instead of hacking through some half assed free one
# Aug 22nd 2019, 09:48 neon1024 @alexdd55976 If you’re not interested in paying, there are some free ones here https://w3layouts.com/
# Aug 22nd 2019, 09:48 alexdd55976 @challgren thx
# Aug 22nd 2019, 09:46 neon1024 @alexdd55976 We use Inspinia here http://webapplayers.com/inspinia_admin-v2.9.2/ with our own bake theme and https://github.com/friendsofcake/bootstrap-ui
# Aug 22nd 2019, 09:45 challgren @alexdd55976 I use https://github.com/BlackrockDigital/startbootstrap-sb-admin-2 but you gotta chop it up
# Aug 22nd 2019, 09:44 alexdd55976 does anyone have any expereince with some nice admin theme, based on bootstrap which works great with cake?
# Aug 22nd 2019, 09:43 challgren There is one instance where select on multiple indexes will be slow with very large datasets
# Aug 22nd 2019, 09:33 conehead Yes I have to admit I suck at databases as well. Just never thought this could have such an impact. Right now I am going through my whole database and check if I am missing some keys haha
# Aug 22nd 2019, 09:30 neon1024 These days I tend to build my initial database in MySQL Workbench, so that it adds those things for me :slightly_smiling_face:
# Aug 22nd 2019, 09:30 neon1024 My database skills are pretty lame. I always forget constraints and indexes
# Aug 22nd 2019, 09:27 conehead Sometimes the missing key caused a timeout...and I was loading just a single entity? :S
# Aug 22nd 2019, 09:25 neon1024 :thumbsup:
# Aug 22nd 2019, 09:23 conehead But as usual you hinted me into the right direction @neon1024 Thanks
# Aug 22nd 2019, 09:23 conehead How does this speed up things like 50 times?
# Aug 22nd 2019, 09:23 conehead Actually there was an (unique) index missing
# Aug 22nd 2019, 09:22 conehead Still strange that this one association sometimes slows evrything down
# Aug 22nd 2019, 09:21 conehead Ah...seems to be one association.
# Aug 22nd 2019, 09:20 conehead Yes
# Aug 22nd 2019, 09:20 neon1024 I presume it does if it’s a primary key
# Aug 22nd 2019, 09:20 neon1024 Does the column have an index?
# Aug 22nd 2019, 09:17 conehead This is really confusing me. If I just select the `Documents.id` it takes like 10 seconds to load. When I remove the select statement, the data is loading within like a second (which is as well still really slow)
# Aug 22nd 2019, 09:16 conehead Hmm anyone got an idea why my query slows really down as soon as I add an `select` to it?
# Aug 22nd 2019, 09:09 neon1024 At least for me, I don’t use the profiler. I just use XDebug for the pretty var_dump :P
# Aug 22nd 2019, 09:08 neon1024 https://php.ug/slackinvite
# Aug 22nd 2019, 09:08 neon1024 I would ask in the phpug slack
# Aug 22nd 2019, 09:06 slackebot2 xdebug.remote_port="9009" xdebug.remote_autostart=1 xdebug.remote_log="/Users/sebastiankoller/Sites/logs/xdebug.log" xdebug.idekey="PHPSTORM" xdebug.remote_host="localhost" xdebug.profiler_enable=0 xdebug.collect_assignments=1 xdebug.collect_params=4 xdebug.var_display_max_data=-1 Maybe anyone has an idea?
# Aug 22nd 2019, 09:06 koeller Good morning, I have a new machine and setup my development envrionment from scratch. Now when I'm running xdebug 2.7.3 through PHPStorm I won't see the content of an entity object at a given breakpoint in variables section anymore. I always have to use the the evaluator to get the actual value of an entity object. Thats a bit annoying. Here is my xdebug config: [xdebug] zend_extension="xdebug.so" xdebug.remote_enable=1
# Aug 22nd 2019, 08:41 neon1024 @mehov It’s not a rule, but as @challgren said, this channel is linked to the IRC channel, and that doesn’t support threads, so you’re excluding all the IRC people who might help you
# Aug 22nd 2019, 08:06 spriz I guess it is pretty much what you want @mehov
# Aug 22nd 2019, 08:06 spriz I have this code working at least: `'summed_price' => $expenseLineData->func()->sum('ExpenseLines.buying_price * ExpenseLines.quantity'),`
# Aug 22nd 2019, 08:06 spriz `'avgPrice' => $query->func()->avg('Table.salesTotal / Table.salesQuantity')` rather actually
# Aug 22nd 2019, 08:04 spriz @mehov did you try `$query->newExpr('Table.salesTotal / Table.salesQuantity'),` ?
# Aug 22nd 2019, 08:01 jiri.sejhar my english is so bad :slightly_smiling_face: i need read js file ES6 class layout(){ const layout_one = {} const layoutt_wo = {} } can i read this in php file like $js _object=es6parse('../layout.js') foreach ($js_object as $obj){ ..... }
# Aug 22nd 2019, 07:34 mehov Got it, I will no longer use Replies here if that's the rule
# Aug 22nd 2019, 07:29 conehead Not a window, but a "window" ;)
# Aug 22nd 2019, 07:08 mehov This is what it looks like to me. No windows to go to, just another sidebar. Thought it's more clean, organised and convenient, but I guess your experience differs. Okay got it.
# Aug 22nd 2019, 06:58 challgren I know you’d think it would be like comments on FB