User variable in MYSQL Query

This topic is locked

User variable in MYSQL Query	9/20/2022 4:48:41 PM
PHPRunner General questions
C chrisbee author How do I get this to work in phprunner 10.4? I want the query to ask for a user input before it displays the results.... In a normal MySql query I'd use:- select * From Table Where field1=[$USERINPUT:] How do I get this to work in a PHPRUNNER Query to get user input before the query is performed


	Admin 9/20/2022
	There are many ways to achieve this but the easiest one is to send the user to advanced search page first where they should enter this value. Another option is to use the search panel for the same purpose. You can also use 'Hide data until search' option to force the user enter the search value: https://xlinesoft.com/phprunner/docs/miscellaneous_settings.htm