Thanks for the kind words. I am not being notified of new support tickets so I missed this last week (working on this).
I will try to add a bit more documentation where needed, but fundamentally php is going to be required for using this plugin. Not a huge amount of php, but enough to correctly create an array of arguments and call a single function.
From the docs, this sort of thing can be added anywhere in the functions file, though towards the top will ensure it is available for things later in the functions file.
// This just checks the plugin is enabled so that we
// dont error calling somthing that doesnt exist
if(function_exists('add_db_table_editor')){
// this calls the function creating the interface and
// opens the args array
add_db_table_editor(array(
// Each thing here will be:
// "option-name" => "a value",
// "option-name" => $a_value_in_a_var
'title'=>'Event Registrations',
'table'=>'event_registrations',
'sql'=>'SELECT * FROM event_registrations ORDER BY date_entered DESC'
// Any of the options listed in the docs can be included here.
));
}
Thanks very much – that helps. I’m particularly interested in using your plug-in as an aid to membership management, so I will need to write the SQL JOIN statements for using data from both wp_users and wp_usermeta tables. Do you see any reason why the plug-in shouldn’t deal with this? (I don’t, but as I said before, I’m not a PHP wiz.) I’m also keen on a ‘search’ facility, but I may be able to code this myself. Thanks again for such a prompt and helpful reply.
The problem I forsee with using this plugin to accomplish your goal is that, if you are using JOINs you will have to write custom insert/update/delete call backs to handle the data in the joins. As you dont have a great deal of PHP experience, I fear this may quickly get over your head.
If your goal is to interact better with users / usermeta, there are pretty good plugins out there that do this directly. The user meta plugin seemed fairly good from what I recall. I have also been pretty happy with the Types plugin, which also allows managing user meta data. Both of these are robust plugins with far more specialized capablities than what db-table-editor provides (which by its nature is trying to be very general).
Hope this helps and cheers
Thanks – I hadn’t come across Types before – I’ll take a look. What I really want is to be able to bulk edit users – a bit similar to what you’d do if you were using an Excel spreadsheet. I’ve found a few things that come close, but nothing quite right! Thanks again for your help – appreciated.
If you are not able to get anything working that satisfies your needs, my company Acceleration.net would be happy to write the code for you. I can’t imagine the cost would be too high, assuming we just need to get the joined data saving.
Otherwise good luck with your endeavors
Thanks. This is a site I maintain on behalf of a client. If I don’t have any luck with a search of the plug-ins repository, I’ll put that to them.