2. PHPRunner General questions
  3. [SOLVED]  How To FILTER EDIT page as List Page is filtered
This topic is locked
[SOLVED]

 How To FILTER EDIT page as List Page is filtered

 		4/11/2014 10:48:00 AM
PHPRunner General questions
D
 Domenico Giacchero author

In: List Page: Before SQL Query I added:
$myvar = $_SESSION['uservar'];

$strWhereClause = "recfield='".$myvar."'";
where 'uservar' is USER TABLE field and recfield is TABLE's field managed in List Page.
THis is working very well
BUT if I edit a record, when I am in EDIT PAGE and I click on NEXT Record (or PREVIOUS) button, the filter is not working.
I tried to put the same code in the EDIT Page Before SQL Query, but it does not work.
Any Idea?
Thank You
Sergey Kornilov admin 4/11/2014

Use the suggested method to filter data i.e. AfterTableInit event:

http://xlinesoft.com/phprunner/docs/modify_sql_query_on_the_fly.htm
In this case Next/Prev buttons on the Edit page will work as expected.
D
 		Domenico Giacchero author 4/11/2014



Use the suggested method to filter data i.e. AfterTableInit event:

http://xlinesoft.com/phprunner/docs/modify_sql_query_on_the_fly.htm
In this case Next/Prev buttons on the Edit page will work as expected.


Thank you. It works fine.