Add user input filter to where clause

Starting from version 3.1.5, the plugin allows to add a filter to a where clause based on user input:

  • Add an argument to your request (supports POST and GET)
  • Give your argument the name of your column prefixed with wpda_search_column_

Example

<input name="wpda_search_column_first_name" type="text" value="Sacha" />

Adds condition

first_name = 'Sacha'

Peter Schulz is a lecturer in information technology at the HAN university of applied sciences. He is an experienced programmer with more than 25 years experience in Oracle databases and tools. Peter is the developer of WordPress plugin WP Data Access.

Leave a Reply

Your email address will not be published. Required fields are marked *