Step 5

Blog view using database?table=content

Hereafter we list all articles directly from the database

Note: we could do the same with the Users table for example and allow Search on it. See https://github.com/joomlatools/joomlatools-pages/discussions/506

Title: This website is a step by step demo of what you can do with Joomlatools Pages

Published on: 23 Mar 2023

Category ID: 2

Introtext:

This demo website comes along with a detailed presentation

called 'Joomla, Custom Fields, external data and more ● powerful overrides made easy with Joomlatools Pages'
made for
- JoomlaDay USA #jdayusa on April 24, 2021
- JoomlaDay FR #jd21fr on June 18, 2021

See this full presentation on slides.woluweb.be See all my other presentations on slides.woluweb.be

Enjoy!

Note that Joomlatools Pages is free and open-source. Feel free to contribute and/or sponsor 😉

Marc Dechèvre
@woluweb

Want to play with JoomlaTools Pages and test it further for yourself?

Download a copy of the present demo site

Want to play with other examples ?

Option 1
- Install a standard Joomla website with the Joomla blog sample data
- Follow these short instructions: https://github.com/joomlatools/joomlatools-pages/pull/671
- Download the latest release package: http://files.joomlatools.xyz/pages/site-blog.zip
- And it will work out of the box!
Option 2
- See https://www.agrea.ph which is built with Pages
- The code is open sourced: https://github.com/johanjanssens/agrea.ph
  It shows how to use the Joomla extension with Pages to render articles with Pages and manage them using the Joomla article editor.

Although this demo site already covers many many things that Pages can do, there are other interesting features which are not covered here like:

adding a custom template function
adding a form processor
adding a event subscriber (equivalent of plugins in Joomla)

Title: Organization 1

windows

Published on: 23 Mar 2023

Category ID: 8

Introtext:

Introtext 1

Title: Organization 2

raindrops

Published on: 23 Mar 2023

Category ID: 8

Introtext:

Introtext 2

Title: Organization 3

walden pond

Published on: 23 Mar 2023

Category ID: 8

Introtext:

Introtext 3

Title: French

Published on: 23 Mar 2023

Category ID: 2

Introtext:

Title: Dutch

Published on: 23 Mar 2023

Category ID: 2

Introtext:

Title: English

Published on: 23 Mar 2023

Category ID: 2

Introtext:

And here is a little var_dump(collection()) so that you can see all what is immediately available in the array itself:

object(ComPagesModelEntityItems)#1806 (7) {
  [1]=>
  array(31) {
    ["id"]=>
    string(1) "1"
    ["asset_id"]=>
    string(2) "63"
    ["title"]=>
    string(77) "This website is a step by step demo of what you can do with Joomlatools Pages"
    ["alias"]=>
    string(46) "welcome-to-this-demo-site-of-joomlatools-pages"
    ["introtext"]=>
    string(3574) "This demo website comes along with a detailed presentation

called 'Joomla, Custom Fields, external data and more ● powerful overrides made easy with Joomlatools Pages'
made for

JoomlaDay USA #jdayusa on April 24, 2021
JoomlaDay FR #jd21fr on June 18, 2021



See this full presentation on slides.woluweb.be See all my other presentations on slides.woluweb.be
Enjoy!
Note that Joomlatools Pages is free and open-source. Feel free to contribute and/or sponsor 😉

Marc Dechèvre
@woluweb

Want to play with JoomlaTools Pages and test it further for yourself?
Download a copy of the present demo site

Want to play with other examples ?

Option 1

Install a standard Joomla website with the Joomla blog sample data
Follow these short instructions: https://github.com/joomlatools/joomlatools-pages/pull/671 
Download the latest release package: http://files.joomlatools.xyz/pages/site-blog.zip
And it will work out of the box!


Option 2

See https://www.agrea.ph which is built with Pages
The code is open sourced: https://github.com/johanjanssens/agrea.ph
It shows how to use the Joomla extension with Pages to render articles with Pages and manage them using the Joomla article editor.





Although this demo site already covers many many things that Pages can do, there are other interesting features which are not covered here like:

adding a custom template function
adding a form processor
adding a event subscriber (equivalent of plugins in Joomla)

"
    ["fulltext"]=>
    string(0) ""
    ["state"]=>
    string(1) "1"
    ["catid"]=>
    string(1) "2"
    ["created"]=>
    string(19) "2021-04-19 13:43:30"
    ["created_by"]=>
    string(3) "844"
    ["created_by_alias"]=>
    string(0) ""
    ["modified"]=>
    string(19) "2021-06-17 07:44:56"
    ["modified_by"]=>
    string(3) "844"
    ["checked_out"]=>
    string(1) "0"
    ["checked_out_time"]=>
    string(19) "0000-00-00 00:00:00"
    ["publish_up"]=>
    string(19) "2021-04-19 13:43:30"
    ["publish_down"]=>
    string(19) "0000-00-00 00:00:00"
    ["images"]=>
    string(173) "{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}"
    ["urls"]=>
    string(121) "{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}"
    ["attribs"]=>
    string(667) "{"article_layout":"","show_title":"","link_titles":"","show_tags":"","show_intro":"","info_block_position":"","info_block_show_title":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_associations":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_page_title":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}"
    ["version"]=>
    string(2) "54"
    ["ordering"]=>
    int(1)
    ["metakey"]=>
    string(0) ""
    ["metadesc"]=>
    string(0) ""
    ["access"]=>
    string(1) "1"
    ["hits"]=>
    string(1) "0"
    ["metadata"]=>
    string(53) "{"robots":"","author":"","rights":"","xreference":""}"
    ["featured"]=>
    string(1) "1"
    ["language"]=>
    string(1) "*"
    ["xreference"]=>
    string(0) ""
    ["note"]=>
    string(0) ""
  }
  [2]=>
  array(31) {
    ["id"]=>
    string(1) "2"
    ["asset_id"]=>
    string(2) "69"
    ["title"]=>
    string(14) "Organization 1"
    ["alias"]=>
    string(14) "organization-1"
    ["introtext"]=>
    string(20) "Introtext 1
"
    ["fulltext"]=>
    string(19) "
Fulltext 1"
    ["state"]=>
    string(1) "1"
    ["catid"]=>
    string(1) "8"
    ["created"]=>
    string(19) "2021-04-20 08:38:13"
    ["created_by"]=>
    string(3) "844"
    ["created_by_alias"]=>
    string(0) ""
    ["modified"]=>
    string(19) "2021-07-05 15:53:31"
    ["modified_by"]=>
    string(3) "844"
    ["checked_out"]=>
    string(3) "844"
    ["checked_out_time"]=>
    string(19) "2022-03-23 10:03:09"
    ["publish_up"]=>
    string(19) "2021-04-20 08:38:13"
    ["publish_down"]=>
    string(19) "0000-00-00 00:00:00"
    ["images"]=>
    string(251) "{"image_intro":"images\/headers\/windows.jpg","float_intro":"","image_intro_alt":"windows","image_intro_caption":"windows","image_fulltext":"images\/headers\/maple.jpg","float_fulltext":"","image_fulltext_alt":"maple","image_fulltext_caption":"maple"}"
    ["urls"]=>
    string(121) "{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}"
    ["attribs"]=>
    string(667) "{"article_layout":"","show_title":"","link_titles":"","show_tags":"","show_intro":"","info_block_position":"","info_block_show_title":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_associations":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_page_title":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}"
    ["version"]=>
    string(2) "12"
    ["ordering"]=>
    int(2)
    ["metakey"]=>
    string(0) ""
    ["metadesc"]=>
    string(0) ""
    ["access"]=>
    string(1) "1"
    ["hits"]=>
    string(1) "0"
    ["metadata"]=>
    string(53) "{"robots":"","author":"","rights":"","xreference":""}"
    ["featured"]=>
    string(1) "0"
    ["language"]=>
    string(1) "*"
    ["xreference"]=>
    string(0) ""
    ["note"]=>
    string(0) ""
  }
  [3]=>
  array(31) {
    ["id"]=>
    string(1) "3"
    ["asset_id"]=>
    string(2) "70"
    ["title"]=>
    string(14) "Organization 2"
    ["alias"]=>
    string(14) "organization-2"
    ["introtext"]=>
    string(18) "Introtext 2"
    ["fulltext"]=>
    string(0) ""
    ["state"]=>
    string(1) "1"
    ["catid"]=>
    string(1) "8"
    ["created"]=>
    string(19) "2021-04-21 08:38:13"
    ["created_by"]=>
    string(3) "844"
    ["created_by_alias"]=>
    string(0) ""
    ["modified"]=>
    string(19) "2021-07-05 15:18:10"
    ["modified_by"]=>
    string(3) "844"
    ["checked_out"]=>
    string(1) "0"
    ["checked_out_time"]=>
    string(19) "0000-00-00 00:00:00"
    ["publish_up"]=>
    string(19) "2021-04-21 08:38:13"
    ["publish_down"]=>
    string(19) "0000-00-00 00:00:00"
    ["images"]=>
    string(269) "{"image_intro":"images\/headers\/raindrops.jpg","float_intro":"","image_intro_alt":"raindrops","image_intro_caption":"raindrops","image_fulltext":"images\/headers\/raindrops.jpg","float_fulltext":"","image_fulltext_alt":"raindrops","image_fulltext_caption":"raindrops"}"
    ["urls"]=>
    string(121) "{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}"
    ["attribs"]=>
    string(667) "{"article_layout":"","show_title":"","link_titles":"","show_tags":"","show_intro":"","info_block_position":"","info_block_show_title":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_associations":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_page_title":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}"
    ["version"]=>
    string(1) "8"
    ["ordering"]=>
    int(3)
    ["metakey"]=>
    string(0) ""
    ["metadesc"]=>
    string(0) ""
    ["access"]=>
    string(1) "1"
    ["hits"]=>
    string(1) "0"
    ["metadata"]=>
    string(53) "{"robots":"","author":"","rights":"","xreference":""}"
    ["featured"]=>
    string(1) "0"
    ["language"]=>
    string(1) "*"
    ["xreference"]=>
    string(0) ""
    ["note"]=>
    string(0) ""
  }
  [4]=>
  array(31) {
    ["id"]=>
    string(1) "4"
    ["asset_id"]=>
    string(2) "71"
    ["title"]=>
    string(14) "Organization 3"
    ["alias"]=>
    string(14) "organization-3"
    ["introtext"]=>
    string(18) "Introtext 3"
    ["fulltext"]=>
    string(0) ""
    ["state"]=>
    string(1) "1"
    ["catid"]=>
    string(1) "8"
    ["created"]=>
    string(19) "2021-04-22 08:38:13"
    ["created_by"]=>
    string(3) "844"
    ["created_by_alias"]=>
    string(0) ""
    ["modified"]=>
    string(19) "2021-07-05 15:18:14"
    ["modified_by"]=>
    string(3) "844"
    ["checked_out"]=>
    string(1) "0"
    ["checked_out_time"]=>
    string(19) "0000-00-00 00:00:00"
    ["publish_up"]=>
    string(19) "2021-04-22 08:38:13"
    ["publish_down"]=>
    string(19) "0000-00-00 00:00:00"
    ["images"]=>
    string(281) "{"image_intro":"images\/headers\/walden-pond.jpg","float_intro":"","image_intro_alt":"walden pond","image_intro_caption":"walden pond","image_fulltext":"images\/headers\/walden-pond.jpg","float_fulltext":"","image_fulltext_alt":"walden pond","image_fulltext_caption":"walden pond"}"
    ["urls"]=>
    string(121) "{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}"
    ["attribs"]=>
    string(667) "{"article_layout":"","show_title":"","link_titles":"","show_tags":"","show_intro":"","info_block_position":"","info_block_show_title":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_associations":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_page_title":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}"
    ["version"]=>
    string(2) "16"
    ["ordering"]=>
    int(4)
    ["metakey"]=>
    string(0) ""
    ["metadesc"]=>
    string(0) ""
    ["access"]=>
    string(1) "1"
    ["hits"]=>
    string(1) "0"
    ["metadata"]=>
    string(53) "{"robots":"","author":"","rights":"","xreference":""}"
    ["featured"]=>
    string(1) "0"
    ["language"]=>
    string(1) "*"
    ["xreference"]=>
    string(0) ""
    ["note"]=>
    string(0) ""
  }
  [5]=>
  array(31) {
    ["id"]=>
    string(1) "5"
    ["asset_id"]=>
    string(2) "78"
    ["title"]=>
    string(6) "French"
    ["alias"]=>
    string(6) "french"
    ["introtext"]=>
    string(0) ""
    ["fulltext"]=>
    string(0) ""
    ["state"]=>
    string(1) "1"
    ["catid"]=>
    string(1) "2"
    ["created"]=>
    string(19) "2021-04-27 08:36:58"
    ["created_by"]=>
    string(3) "844"
    ["created_by_alias"]=>
    string(0) ""
    ["modified"]=>
    string(19) "2021-04-27 08:36:58"
    ["modified_by"]=>
    string(1) "0"
    ["checked_out"]=>
    string(1) "0"
    ["checked_out_time"]=>
    string(19) "0000-00-00 00:00:00"
    ["publish_up"]=>
    string(19) "2021-04-27 08:36:58"
    ["publish_down"]=>
    string(19) "0000-00-00 00:00:00"
    ["images"]=>
    string(173) "{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}"
    ["urls"]=>
    string(121) "{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}"
    ["attribs"]=>
    string(667) "{"article_layout":"","show_title":"","link_titles":"","show_tags":"","show_intro":"","info_block_position":"","info_block_show_title":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_associations":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_page_title":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}"
    ["version"]=>
    string(1) "1"
    ["ordering"]=>
    int(5)
    ["metakey"]=>
    string(0) ""
    ["metadesc"]=>
    string(0) ""
    ["access"]=>
    string(1) "1"
    ["hits"]=>
    string(1) "0"
    ["metadata"]=>
    string(53) "{"robots":"","author":"","rights":"","xreference":""}"
    ["featured"]=>
    string(1) "0"
    ["language"]=>
    string(5) "fr-FR"
    ["xreference"]=>
    string(0) ""
    ["note"]=>
    string(0) ""
  }
  [6]=>
  array(31) {
    ["id"]=>
    string(1) "6"
    ["asset_id"]=>
    string(2) "79"
    ["title"]=>
    string(5) "Dutch"
    ["alias"]=>
    string(5) "dutch"
    ["introtext"]=>
    string(0) ""
    ["fulltext"]=>
    string(0) ""
    ["state"]=>
    string(1) "1"
    ["catid"]=>
    string(1) "2"
    ["created"]=>
    string(19) "2021-04-27 08:37:10"
    ["created_by"]=>
    string(3) "844"
    ["created_by_alias"]=>
    string(0) ""
    ["modified"]=>
    string(19) "2021-04-27 08:37:10"
    ["modified_by"]=>
    string(1) "0"
    ["checked_out"]=>
    string(1) "0"
    ["checked_out_time"]=>
    string(19) "0000-00-00 00:00:00"
    ["publish_up"]=>
    string(19) "2021-04-27 08:37:10"
    ["publish_down"]=>
    string(19) "0000-00-00 00:00:00"
    ["images"]=>
    string(173) "{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}"
    ["urls"]=>
    string(121) "{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}"
    ["attribs"]=>
    string(667) "{"article_layout":"","show_title":"","link_titles":"","show_tags":"","show_intro":"","info_block_position":"","info_block_show_title":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_associations":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_page_title":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}"
    ["version"]=>
    string(1) "1"
    ["ordering"]=>
    int(6)
    ["metakey"]=>
    string(0) ""
    ["metadesc"]=>
    string(0) ""
    ["access"]=>
    string(1) "1"
    ["hits"]=>
    string(1) "0"
    ["metadata"]=>
    string(53) "{"robots":"","author":"","rights":"","xreference":""}"
    ["featured"]=>
    string(1) "0"
    ["language"]=>
    string(5) "nl-NL"
    ["xreference"]=>
    string(0) ""
    ["note"]=>
    string(0) ""
  }
  [7]=>
  array(31) {
    ["id"]=>
    string(1) "7"
    ["asset_id"]=>
    string(2) "80"
    ["title"]=>
    string(7) "English"
    ["alias"]=>
    string(7) "english"
    ["introtext"]=>
    string(0) ""
    ["fulltext"]=>
    string(0) ""
    ["state"]=>
    string(1) "1"
    ["catid"]=>
    string(1) "2"
    ["created"]=>
    string(19) "2021-04-27 08:37:23"
    ["created_by"]=>
    string(3) "844"
    ["created_by_alias"]=>
    string(0) ""
    ["modified"]=>
    string(19) "2021-04-27 08:37:23"
    ["modified_by"]=>
    string(1) "0"
    ["checked_out"]=>
    string(1) "0"
    ["checked_out_time"]=>
    string(19) "0000-00-00 00:00:00"
    ["publish_up"]=>
    string(19) "2021-04-27 08:37:23"
    ["publish_down"]=>
    string(19) "0000-00-00 00:00:00"
    ["images"]=>
    string(173) "{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}"
    ["urls"]=>
    string(121) "{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}"
    ["attribs"]=>
    string(667) "{"article_layout":"","show_title":"","link_titles":"","show_tags":"","show_intro":"","info_block_position":"","info_block_show_title":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_associations":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_page_title":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}"
    ["version"]=>
    string(1) "1"
    ["ordering"]=>
    int(7)
    ["metakey"]=>
    string(0) ""
    ["metadesc"]=>
    string(0) ""
    ["access"]=>
    string(1) "1"
    ["hits"]=>
    string(1) "0"
    ["metadata"]=>
    string(53) "{"robots":"","author":"","rights":"","xreference":""}"
    ["featured"]=>
    string(1) "0"
    ["language"]=>
    string(5) "en-GB"
    ["xreference"]=>
    string(0) ""
    ["note"]=>
    string(0) ""
  }
}