# |
Apr 13th 2021, 11:21 |
paolo.bragagni |
thanks so the best way is to create a plugin |
# |
Apr 13th 2021, 11:18 |
kevin.pfeifer |
i personally created a separate plugin for that where all my custom generated templates are gathered together |
# |
Apr 13th 2021, 11:18 |
kevin.pfeifer |
https://book.cakephp.org/bake/2/en/development.html#bake-template-syntax |
# |
Apr 13th 2021, 11:18 |
paolo.bragagni |
yep |
# |
Apr 13th 2021, 11:18 |
kevin.pfeifer |
you mean like bake templates? |
# |
Apr 13th 2021, 11:17 |
paolo.bragagni |
I'd like to change the generation |
# |
Apr 13th 2021, 11:17 |
paolo.bragagni |
I'd like to know where these templates are build |
# |
Apr 13th 2021, 11:17 |
paolo.bragagni |
thanks @kevin.pfeifer but these are the templates of the views |
# |
Apr 13th 2021, 11:12 |
kevin.pfeifer |
well the start of the DOM live in `templates/layout/default.php` and the rest lives in the corresponding `templates/<controller>/<method>.php` I would recommend you to use elements as much as possible since they are an easy way to re-use already defined template-parts |
# |
Apr 13th 2021, 11:08 |
paolo.bragagni |
(done years ago for cake 2) |
# |
Apr 13th 2021, 11:08 |
paolo.bragagni |
:) |
# |
Apr 13th 2021, 11:08 |
paolo.bragagni |
hi. trying to find a way to build my own template for cake4, but I dont know even how to start |
# |
Apr 13th 2021, 11:00 |
admad |
And use saveMany() for each batch |
# |
Apr 13th 2021, 10:55 |
neon1024 |
Thanks for the input :thumbsup: |
# |
Apr 13th 2021, 10:55 |
neon1024 |
Well that makes a lot of sense. So I am updating the database, re-creating indexes, closing the connection, and then repeating 80k times! So probably preparing batches in a transaction sounds like a good approach |
# |
Apr 13th 2021, 09:49 |
hmic |
ah, I am probably wrong. every *commited* save will. but I belive cake will commit every save individually be default. |
# |
Apr 13th 2021, 09:48 |
conehead |
Yes and depending on how time critical it is, you might also want to think about using less cake and more plain php/mysql to update that data. But in general I think it is enough to do batch calculations |
# |
Apr 13th 2021, 09:46 |
hmic |
every mysql save will recreate all indices, so that is slow! if you save x records at once, your speedup can be up to x times, depending on how heavy the index work is... it will be sped up by a lot, *if* not all the time is spend in php anyways, yes. but saving multiple records at once is generally a good strategy speedwise. |
# |
Apr 13th 2021, 09:44 |
conehead |
Of course it depends on your calculation. But usually calculations are fast and saving is slow. I would use limit and offset |
# |
Apr 13th 2021, 09:43 |
neon1024 |
@conehead @saeid Wouldn’t even batches still mean processing each record in the batch? I think the time might be in the PHP processing rather than the db, but it is an assumption. I’ll give it a try though to benchmark it. Would you find all records and use `->chunk()` or use `limit` and `offset` in the query? I don’t want to load 80k records into memory ideally |
# |
Apr 13th 2021, 09:20 |
nayakvradhit |
Ok sure thanks |
# |
Apr 13th 2021, 09:13 |
kevin.pfeifer |
if possible just set the docroot to `/www/html/appname/weboot` |
# |
Apr 13th 2021, 09:12 |
nayakvradhit |
Ok thanks |
# |
Apr 13th 2021, 09:11 |
nayakvradhit |
Yes @kevin.pfeifer I have set the document root to var/www/html/appname And calling ipaddress/appname If I set like this does it miss cakephp styles what I gave? |
# |
Apr 13th 2021, 09:03 |
conehead |
@neon1024 Yes, do it in batches. Get 1k rows, calculate the new field, save those 1k rows with one save and grab the next 1k rows and repeat |
# |
Apr 13th 2021, 08:53 |
kevin.pfeifer |
theoretically if your webroot is in the “root” of the cakephp/app folder (and without any special .htaccess/webserver rules) all your src files, config files including database user and password would be accessible via a URL which isn’t that great, right? ;) |
# |
Apr 13th 2021, 08:50 |
nayakvradhit |
Can anyone please tell me why we need to point the cakephp app into webroot in the document root of apache config? |
# |
Apr 13th 2021, 08:41 |
neon1024 |
Does anyone have any suggestions on how I can update 80k rows in my database, I need to transform the data using PHP and save it into a new field. I have written a command which processes each record but working out the timings, the total run would be 37 minutes! |
# |
Apr 13th 2021, 08:22 |
masa19951009 |
ok I'll check again thanks! |
# |
Apr 13th 2021, 08:21 |
kevin.pfeifer |
The https://github.com/cakephp/authentication plugin in the current version (2.6) is cake4 compatible, yes |
# |
Apr 13th 2021, 08:12 |
masa19951009 |
Thank ! Sorry I'm using CakePHP 4 and this way not work :,(. Does it work in cake4? Maybe another problem. |
# |
Apr 13th 2021, 08:10 |
kevin.pfeifer |
i was going to point that out admad :) ylj |
# |
Apr 13th 2021, 08:09 |
admad |
@masa19951009 helps to read the manual :) https://book.cakephp.org/authentication/2/en/identifiers.html#password |
# |
Apr 13th 2021, 08:07 |
masa19951009 |
Excuse me. I have a question. Does anyone know how to create multi column in authentication plugin? Like both name and email can login. |
# |
Apr 13th 2021, 05:40 |
nayakvradhit |
Thanks |
# |
Apr 12th 2021, 20:58 |
greg138 |
That's right. But there's *something* in the session that gets regenerated every page load now... |
# |
Apr 12th 2021, 20:58 |
kevin.pfeifer |
thats why you get a ID to tell PHP which data you already have |
# |
Apr 12th 2021, 20:58 |
kevin.pfeifer |
aren’t sessions the PHP native way to actually save data between requests? HTTP per se is stateless. |
# |
Apr 12th 2021, 20:54 |
greg138 |
I only have about 120 more important things than that to do right now... ;) |
# |
Apr 12th 2021, 20:54 |
greg138 |
I'm going to have to dig into this more at some point. Isn't the session ID regenerated on basically every page load now? If the session ID is included in the form tamper protection somehow, that would seem to mean you couldn't load a form in one tab, visit a different page, then come back to the form, but that works fine. |
# |
Apr 12th 2021, 20:52 |
kevin.pfeifer |
https://book.cakephp.org/4/en/controllers/components/security.html#disabling-form-tampering-for-specific-actions |