etc_query: all things Textpattern

etc · 2021-01-30 12:42:08

A small PHP 8 compatible update.

colak · 2021-01-30 17:07:15

etc wrote #328420:

A small PHP 8 compatible update.

Does it also work on php 7.x?

etc · 2021-01-30 17:13:20

colak wrote #328425:

Does it also work on php 7.x?

It should work on any php 5.3.10+. Its own home is on php 5.4.8.

colak · 2021-01-30 17:49:58

Thanks so much Oleg,
I’ll install it and report if there are any issues.

etc · 2021-05-16 19:20:01

Version 1.4 is released. Main news:

added ini markup, to import ini-formatted arrays;
added sort attribute, to order (flat) multi-dimensional arrays by one or several fields.

etc · 2021-05-19 16:26:43

Version 1.5 is available. Main news:

empowered sort attribute for ordering multi-dimensional (sub-)arrays by several fields.
chainable markup attribute, to enable customizable mixed markups.

Example:

<txp:variable name="winners">
name=Alice
age=11
place=2
--
name=Bob
age=9
place=2
--
name=Cindy
age=10
place=1
</txp:variable>

<txp:etc_query data='<txp:variable name="winners" />'
    markup="list:--, ini"
    sort="[place|age<nat]"
    wraptag="ol" break="li"
>
    {name?} ({age?} years old)
</txp:etc_query>

outputs

Cindy (10 years old)
Bob (9 years old)
Alice (11 years old)

etc · 2021-06-15 14:44:44

Version 1.5.1 is CSV-import-able, thanks to Stef for a possible use case (wrap it into etc_cache if needed):

<txp:etc_query markup="csv" url=".../export?format=csv" wraptag="table">
{$doWrap($|tr|td)}
</txp:etc_query>

lazlo · 2023-02-22 21:56:18

Hey Oleg

I tried to install etc_query 1.5.8 as my first plugin on a completely a brand new 4.8.8 install.

I got this: “Badly formed or empty plugin code.” Sad Trumpet sounds …

Any advice here?

- Les

ax · 2023-08-23 20:27:12

Indeed a very useful plugin, but now I am stuck with the task of reading very many XML files like this:

<?xml version="1.0" encoding="UTF-8"?>
<Image xmlns="http://schemas.microsoft.com/deepzoom/2008"
  Format="jpeg"
  Overlap="1"
  TileSize="256"
  >
  <Size 
    Height="71029"
    Width="62493"
  />
</Image>

The Size parameters are wanted, but no output is generated with this simple code:

<txp:etc_query  markup="xml" 
query="//Image/Size" url="https://example.com/A01.xml" >
Height={Height?}<br />
Width={Width?}<br />
</txp:etc_query>

No luck with smd_xml either. I wonder if it could be the XML syntax that prevents the size parameters from being extracted?

etc · 2023-08-23 21:40:04

Two things:

Your root Image is namespaced, which bothers the parser. Try markup="xml:" (with : after xml).
Height and Width are attributes, thus requiring a corresponding syntax:

Height={@Height?}<br />
<!-- or simply -->
{@Width}<br />

ax · 2023-08-24 05:28:01

Thanks so much. That did the trick!

Textpattern CMS

Textpattern CMS support forum

#361 2021-01-30 12:42:08

Re: etc_query: all things Textpattern

#362 2021-01-30 17:07:15

Re: etc_query: all things Textpattern

etc wrote #328420:

#363 2021-01-30 17:13:20

Re: etc_query: all things Textpattern

colak wrote #328425:

#364 2021-01-30 17:49:58

Re: etc_query: all things Textpattern

#365 2021-05-16 19:20:01

Re: etc_query: all things Textpattern

#366 2021-05-19 16:26:43

Re: etc_query: all things Textpattern

#367 2021-06-15 14:44:44

Re: etc_query: all things Textpattern

#368 2023-02-22 21:56:18

Re: etc_query: all things Textpattern

#369 2023-08-23 20:27:12

Re: etc_query: all things Textpattern

#370 2023-08-23 21:40:04

Re: etc_query: all things Textpattern

#371 2023-08-24 05:28:01

Re: etc_query: all things Textpattern

Board footer