Hi,

I am trying to use the %VAR1% in the shortcode. I searched the documentation and did not find any examples.

I am building a mysql table that contain the Bible verses, and have a column for ID, column for Book, Column for Chapter and column for verse.

When I want to show the verses of chapter 2 only, this sql works:

SELECT wp_bible.id,
       wp_bible.book,
       wp_bible.chapter,
       wp_bible.verse,
       wp_bible.SVD
FROM wp_bible
WHERE wp_bible.chapter = %VAR1%

when I specify the %VAR1% as 2 in the "placeholders" part in the backend.

However, I can't find a way to specify the %VAR1% in the shortcode.

what I am trying to achieve is to use one shortcode and change the chapter and book values of them.

I don't want to create a separate table for each chapter. this will be a massive unnecessary work.

Can you please help?

thanks

Hi Milos,

thanks a lot for the quick reply.

I followed your instructions and was able to show only the verses from Chapter2. 

However, when I tried to use %var2% to show only verse1 of chapter 2, it didn't work.

it still shows all the verses of chapter 2.

here is my sql:

SELECT wp_bible.id,
       wp_bible.book,
       wp_bible.chapter,
       wp_bible.verse,
       wp_bible.SVD
FROM wp_bible
WHERE wp_bible.chapter >= %VAR1% AND wp_bible.verse >= %VAR2%

here is the shortcode i used:

[wpdatatable id=4 var1=2 var2=1]

the result is here:

https://coptic-treasures.com/wp/bible-trial-001/5/

I have added 2 verses to chapter 2, so var=1 works, but var2=1 should show only verse 1, but the result is still showing the 2 verses.

any clue why?

thanks

Hi Milos,

thanks a lot. you are right. I was just so excited about the "var" option as it will save me creating hundreds of tables.

Much appreciated.

Hi Milos.

Thanks. I will do so straight way.

I need to highlight to you that when I duplicated a table, the new table got the same css id, even though it has a new number and a new shortcode.

I duplicated a table 3 times, then changed the css for one of them, but discovered that all of them saw the same changes. then I realised that all of them got thesame css id. you might want to look at this in future updates.

Also, if you can please have a look at my other support ticket here: 

https://tmsplugins.ticksy.com/ticket/919076/

thanks a lot.

Hi Milos.

Here is the original table. It has ID=4

https://coptic-treasures.com/wp/bible-trial-001/

here are the duplicate tables:

https://coptic-treasures.com/wp/bible-trial-001/2/
https://coptic-treasures.com/wp/bible-trial-001/3/

If you right clicked on the tables and inspected them, you will find that the 3 tables have:

<table id="table_4" clas=bla bla bla..etc

Now, one of the tables is LTR and the others are RTL. when I inspected the LTR one, I added the following css:

#table_4 {
direction: ltr !important;
}

So I found that the 3 tables changed to LTR.

then I discovered that the 3 tables have the same id, so when I applied the css, all 3 changed direction.

while in reality each table has its own shortcode with its own number.

BTW, I left a good review. Thanks to your support.

Cheers.

Atef

Hi Milos,

sorry I don't understand the styling option you mentioned.

can you please give an example?

thanks

Hi Milos,

thanks for the example. Actually this is very disappointing.

First, because it is not the optimum way to add styling.

second, on a large scale project like what I am planing for, it is very time consuming. this hinders the time save with the Vars.

third, I have pasted one of the tables shortcode in a new post that did not have any tables before, and it gave id_2.

so I will need to publish the page, then get the id then add the styling. then if anything happens and this id changed, then i will need to go back to the page and re-change the styling.

is there any other way to give the table a class to control it?

here is the trial post:

https://coptic-treasures.com/wp/test-post-2/

thanks