URL params in SQL query

Hello @pcescato

Thank you very much for using our plugin.

You can use two recordset fields. The first one reads the URL parameters, and fills a hidden field. The second one uses the hidden field value to get the database records.

Some fields of the form structure would be:

<input type="hidden" name="code">
[cf7-recordset id="recordset_url" type="url-parameters"]
[cf7-link-field recordset="recordset_url" field="code" value="code"]
[cf7-recordset id="mydatas" type="database" query="SELECT id, description FROM {wpdb.prefix}mytable WHERE code={field.code}"]

Best regards.