I would like to know whether or not this plugin, in conjunction with Formidable Forms, can be used to present a query form to a user, search an existing WP database table for an entered value, and then present the results dynamically in a wp post or page.
simply: form entry of "dave" returns all members with "dave" in the "first-name" field of WPDB table "users"....
I would like to move to a user-friendlier plugin format to replace some custom code embedded in outdated theme page templates.
With wpDataTables you can create tables from the form entries and you can later filter the table further to display the desired information if needed. Please note that the form needs to be filled in first and the table created manually for this to work.
I am not sure quite understand your scenario so if you can please provide us with an example so we can give you the best solution.
I purchased the premium "basic" serial number / license. How do I download the upgraded plugin, or add the serial number to the "lite" version installed in wordpress ? What do I do with the purchased license ? All I have now is "lite", and can't find a place in the dashboard to add a license so I can access the database.
2. my scenario is as follows, suggestions would be appreciated, or an online example:
present an input screen to users: NAME:------------
entry of a string of characters into that form results in a query to the "users" table of the site wordpress database.
any and all entries that match the above entered "name" in the "name" field of the "users" wpdb will display to the user in response to the above click.
well, I powered thru the past questions. Now, things get a little bit trickier.
Is there an example or tutorial that can help show the use of the SQL query builder to access wp_usermeta data, that is additional user fields in addition to the wp_users table fields ?
If there's no example, is there an sample sql query with the joins to do that ?
I'm glad to hear you were able to download and install the full version
Do you have examples of what you would like to achieve exactly so we can get a better picture? You can add new entries to the table through the form and you can later filter the table per some value but I am not sure you will be able to filter per new entry.
You can have a look at our MySQL query-based tables. If you're not that good with MySQL, you can try using our Query Constructor, but please note that this constructor is just a helper - it's not an ultimate query generator.
It constructs a suggestion of a query, that you often need to modify to get the data you need. Included support for the plugin doesn't cover writing custom queries, so we wouldn't be able to help you with that.
You will not be able to generate a table based on a form entry as the table need to be created manually. You will be able to add a new entry to the table you already created and then manually filter the table per the desired value. I'm afraid there is no way to do all this automatically.
It might be possible with some custom work, but our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in near future.
But we can recommend these services for customization:
This can only be achieved using MySQL query-based tables. If you're not that good with MySQL, you can try using our Query Constructor, but please note that this constructor is just a helper - it's not an ultimate query generator.
It constructs a suggestion of a query, that you often need to modify to get the data you need. Included support for the plugin doesn't cover writing custom queries, so we wouldn't be able to help you with that.
I would like to know whether or not this plugin, in conjunction with Formidable Forms, can be used to present a query form to a user, search an existing WP database table for an entered value, and then present the results dynamically in a wp post or page.
simply: form entry of "dave" returns all members with "dave" in the "first-name" field of WPDB table "users"....
I would like to move to a user-friendlier plugin format to replace some custom code embedded in outdated theme page templates.
Hi David
Thank you for reaching out to us.
With wpDataTables you can create tables from the form entries and you can later filter the table further to display the desired information if needed. Please note that the form needs to be filled in first and the table created manually for this to work.
I am not sure quite understand your scenario so if you can please provide us with an example so we can give you the best solution.
OK, now I have 2 questions, not just one... ;-)
I purchased the premium "basic" serial number / license. How do I download the upgraded plugin, or add the serial number to the "lite" version installed in wordpress ? What do I do with the purchased license ? All I have now is "lite", and can't find a place in the dashboard to add a license so I can access the database.
2. my scenario is as follows, suggestions would be appreciated, or an online example:
present an input screen to users: NAME:------------
entry of a string of characters into that form results in a query to the "users" table of the site wordpress database.
any and all entries that match the above entered "name" in the "name" field of the "users" wpdb will display to the user in response to the above click.
well, I powered thru the past questions. Now, things get a little bit trickier.
Is there an example or tutorial that can help show the use of the SQL query builder to access wp_usermeta data, that is additional user fields in addition to the wp_users table fields ?
If there's no example, is there an sample sql query with the joins to do that ?
Thanks !
Hi David
I'm glad to hear you were able to download and install the full version
Do you have examples of what you would like to achieve exactly so we can get a better picture? You can add new entries to the table through the form and you can later filter the table per some value but I am not sure you will be able to filter per new entry.
You can have a look at our MySQL query-based tables. If you're not that good with MySQL, you can try using our Query Constructor, but please note that this constructor is just a helper - it's not an ultimate query generator.
It constructs a suggestion of a query, that you often need to modify to get the data you need. Included support for the plugin doesn't cover writing custom queries, so we wouldn't be able to help you with that.
the example of what I want to do exactly:
present a query form to a user asking for a typed in search term entry. Let's say "username" and user puts in "dave"
on submit , using "username" field entry dave, wpdatatables returns a table of all wp_user data with the "username" equal to "dave"
simply put, generate a table of the results of a form entry field that is a subset of the wp-users table ?
Can I do this ?
Hi David
You will not be able to generate a table based on a form entry as the table need to be created manually. You will be able to add a new entry to the table you already created and then manually filter the table per the desired value. I'm afraid there is no way to do all this automatically.
It might be possible with some custom work, but our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in near future.
But we can recommend these services for customization:
https://codeable.io/?ref=l1TW1
https://wpkraken.io/?tms-plugins
OK, let's make it less complicated.
Can I create one table with both wp-users data, and wp-users-meta data for display in a page ?
If so, I could just use the search built in to find the desired entries.
Hi David
This can only be achieved using MySQL query-based tables. If you're not that good with MySQL, you can try using our Query Constructor, but please note that this constructor is just a helper - it's not an ultimate query generator.
It constructs a suggestion of a query, that you often need to modify to get the data you need. Included support for the plugin doesn't cover writing custom queries, so we wouldn't be able to help you with that.