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

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 );

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 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 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