Thank you @texnixe for the Database demo : [image] Content from a database Create pages from a database and edit, add or delete entries in the Panel I am using it and it works very well but I would like to use it in a multilanguage setup. What are the best pra…

I think the notation is different in multilang: getkirby/kirby/blob/master/tests/Cms/Pages/PageTranslationsTest.php#L34-L50 'slug' => 'child', 'translations' => [ [ 'code' => 'en', 'content' => [ 'title' => 'Child', ] …

Hey @tristantbg , I was going to update the guide with a multilanguage example but haven’t got round to it yet nor even made my own tests. Doesn’t the code you posted above work?

@tristantbg Did you actually work it out? I wonder if it really makes sense to use different fields for different languages or whether or not it would make more sense to add a language code column in the database and have one entry per language. Otherwise we would end up with a lot of duplicate fie…

For comments the suggestion to use a separate language code column and only one column for the text is probably the way to go. Multiple columns for each language only make sense if you are planning to translate the comments between the languages – not very common for comments (for other types of con…

@tristantbg : Think for https://en.wikipedia.org/wiki/Database_normalization of your database! This is important, if you want to use your database for a long term! Or ask your database architect…

Thanks a lot @distantnative it works perfectly ! Actually I just need to get some data from a database and then I merge the data with what I have in Kirby’s content. For example the title of the page is coming from the SQL DB but the images of the page are inside Kirby. What would be the best app…

Check out this section of the guide: https://getkirby.com/docs/guide/virtual-pages/merging-virtual-and-local-content

Thanks ! I didn’t know this inventory method ! :fire:

Thank you for the inventory tip, but now that I have a lot of page items the panel is now very slow… I guess it is a bit like the index() method, the more you have the slower you get. I switched back to my hack of getting the specific txt text file directly and it goes fast again but it is not very…

Whats the right way how to read single page content from database in multi language context? Content from a database | Kirby CMS mentions readContent() but the kirby/ModelWithContent.php at 9ea05e38dbeb471657e3066651568fc29763ef06 · getkirby/kirby · GitHub function content() that seems to be respon…

Database demo, multi-language setup?

The CMS Questions

texnixe March 7, 2022, 7:59pm 12

You would define the content and translations in the children() method of the parent page, see for example: Multilang page restrict structur field - #21 by texnixe

Topic		Replies	Views
Newbie-Question: Complex datamodeling and multi-language Questions	1	426	May 14, 2022
Multilang content stored in a database and editable in the panel Questions v3	2	312	December 16, 2022
Merge multilingual content from database and files Questions v3	5	234	July 27, 2021
Change languages with API endpoints in headless Kirby setup Questions v3	4	467	November 27, 2020
Using the JSON content api in combination with multilanguage sites Questions v2	2	1214	April 6, 2016

Database demo, multi-language setup?

Related topics