I still can't see any documentation on this. Could you point me to where it is? If there is no documentation yet - could you please provide a quick example?
Thanks for the quick response but I am still not clear as to how to use this. The link only states that placeholders can be used with a PHP Array but provides no examples.
You mention placing %VAR1% in the pre-filter value in a column but this simply overwrites the value passed out of the array.
And want to pass the value stored in %VAR1% to $xx.
If that is possible - then the full query would be $Query = "SELECT col1,col2,col3 WHERE col4=$xx";
Similar to the normal Query with Placeholder we can use with a SQL Source but using a PHP Source instead.
Putting the placeholder into a pre-filter value ignores the output of the PHP Array and just overwrites the Column with the value in VAR1 which isn't very useful. (Unless I am mis-understanding you)
One of are devs was working on the site and screwed things up. It's back up now.
I appreciate you taking the time to look into this
On a separate note I have another table that is displaying Sales Orders in real-time from our CRM (via normal SQL query - not PHP) and it's working perfectly. The filtering and formatting features you guys have included make this one of the best plugins we have.
Now I see what are you trying to achieve. unfortunately something like this is not possible to do with the PHP serialized array and placeholders.
At the moment you can use placeholders VAR1, VAR2 and VAR3 for passing values to filters or shortcode on already loaded data but it can not be used like you are using them for the MySQL tables.
As for the other connections to the databases we are preparing new update where you will be able to use separate connection to other databases and as many as you would like. ( like mysqli, postgre sql etc)
One of the main reasons for me using PHP was to access more than one database - so if that is something you are adding to a future update than that will be great.
Hi
A few weeks back I logged a ticket (via our company account - EntrustICT) regarding documentation for using placeholders in a PHP Serialized Array.
https://tmsplugins.ticksy.com//ticket/1632898/
I still can't see any documentation on this. Could you point me to where it is? If there is no documentation yet - could you please provide a quick example?
e.g. $Var1 = '%VAR1%'; ?
thanks
Jeff
EntrustICT
Hi Jeff,
Thank you for your purchase.
You can take a look at our documentation about placeholders here.
As for the PHP serialized array you can use VAR1 VAR2 etc for example to prefilter the table.
Define the VAR1 in the placeholders tab and put the %VAR1% in the Prefilter value for some column.
Also you can use the VARs in the shotcodes when pasting them in the page.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thanks for the quick response but I am still not clear as to how to use this. The link only states that placeholders can be used with a PHP Array but provides no examples.
You mention placing %VAR1% in the pre-filter value in a column but this simply overwrites the value passed out of the array.
I created a static array for testing as follows:
$SQL_Array[] = array(
'Order ID' => 1,
'Order Status' => $xx,
'Order Summary' => 'BBBB',
'Order Date' => 'CCCC',
'Customer Name' => 'DDDD',
);
echo serialize( $SQL_Array );
And want to pass the value stored in %VAR1% to $xx.If that is possible - then the full query would be $Query = "SELECT col1,col2,col3 WHERE col4=$xx";
Similar to the normal Query with Placeholder we can use with a SQL Source but using a PHP Source instead.
Putting the placeholder into a pre-filter value ignores the output of the PHP Array and just overwrites the Column with the value in VAR1 which isn't very useful. (Unless I am mis-understanding you)
Jeff
Hi Jeff,
Can you please tell me do you maybe have this table as an live example so we can take a look and give you our suggestion.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
HI Jeff,
Unfortunately when I got to that link I receive this error ( attachment)
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Bogdan
I apologise for that.
One of are devs was working on the site and screwed things up. It's back up now.
I appreciate you taking the time to look into this
On a separate note I have another table that is displaying Sales Orders in real-time from our CRM (via normal SQL query - not PHP) and it's working perfectly. The filtering and formatting features you guys have included make this one of the best plugins we have.
thanks
Jeff
Hi Jeff,
I logged in successfully now.
Now I see what are you trying to achieve. unfortunately something like this is not possible to do with the PHP serialized array and placeholders.
At the moment you can use placeholders VAR1, VAR2 and VAR3 for passing values to filters or shortcode on already loaded data but it can not be used like you are using them for the MySQL tables.
As for the other connections to the databases we are preparing new update where you will be able to use separate connection to other databases and as many as you would like. ( like mysqli, postgre sql etc)
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Bogdan
Thanks for looking.
One of the main reasons for me using PHP was to access more than one database - so if that is something you are adding to a future update than that will be great.
Jeff