sirbdc969

Sorry, a paying project took me over.

This reply was not a real help for using this option n WPDA. I know what a plugin is and I know how to make shortcodes and php function files to be used by pages and custom templates in WordPress. But I need to add to a ***WPDA*** data entry form, to add a button that then calls up another WPDA data entry form that is prepopulated with the ID and data of the sub record so we can offer a workflow that is more than 2 relational levels deep. Or does this mean that I should not use WPDA data entry forms at all and just completely code my own data entry forms from scratch? In that case, it’s 1999 again but at least it is going to work :).

I have paid for the premium unlimited sites version. I guess it is ok to call that the cost of learning and realize that the best route for end-user data entry is to create a real database UI system (using non-wordpress code) and upload the data for dumb data display, but I was hoping to get around that and use WPDA for end users to do their own data entry IN their wordpress.

I guess what I am trying to get out of the product just isn’t what it (or any wordpress database option) is going to provide. Good to know.

Forgive my extreme ignorance but, where do we use these options? I am very sorry, I come from years of development but not with php/wordpress so I must be overthinking this and my brain is missing the platform-specific jump from “there are these code options that will work” to “here is exactly where you can use them in code files to make them work”.

I get this: “Use action hook wpda_before_simple_form to add HTML and JavaScript before a data entry form. Argument $self contains a reference to your simple form instance, which allows you to interact with your data entry form through public members and methods.” Great. I get it. It is understandable code.

But I don’t have the experience to know where to put that code in WPDA’s files to make a button on a WPDA form to call that code – for instance to show a button that calls another form instance into the same or another browser tab. Could someone provide a simple example of where to put the code to show a button that calls code from a specific WPDA data entry form? Again, my sincere apologies for the ignorance. Maybe there is a link that I have missed to a page with a demonstration of using the wpda_ hooks in contenxt? Thanks so much.

Thanks Peter I will look into these options and try to figure out direct urls of prepopulated secondary master records to make life make more sense for the users. Much appreciated.

By the way, this is not a knock on WPDA at all, I have looked at a number of wordpress and other online based database tools for creating end-user data entry and this appears to be something everyone has in common. One to many = easy. Lots of one to manys off of a main table = easy (you have those pages/tabs). Many To Many wth intermediate cde tables, that thins the herd real quick (yay for WPDA). But more than one level deep? Just seems to be a core limitation. Probably 90+% of sites don’t need it, pizza orders and pizza customers do fine with one to manys. But Books have editions and editions have Authors, Editors, Illustrators and ISBNs and EANs and ASINs; Magazines and Journals have issues with articles that have contributors; TV Shows have seasons with episodes that have writers, actors, best boys. The hierarchies for librarians quickly go farther than Master/Detail. If an “Add Link Button To Jump To Another Form” button setting could be added to the data entry form designer that links a Parent’s child record editor form to another premade form to be auto-filled with the id of the currently active child record… you’d crack a nut that no other tool that I have seen has cracked. You’re using javascript so there are no direct urls for linking to dataentry forms but… maybe something is possible?

OR maybe this is old news and the answer is so obvious that I missed it (that happens all the time!)

Dagnabbit. Tracked it down. The one plug-in that I never removed from the test site was the Hosts’ own branded plugin. I hesitated because, you know, they are my host and they have been absolutely great compated to others I have tested. I figured that theirs was really important to keep above all else in any deployment. Deactivated it and viola… Manage works and SQL Editor returns values.

I am so very happy because after testing a number of “Database” products and all of them having one limitation or another with my spec yours, with actual Database connectivity, looked like a winner. And with this complete noob silliness on my part figured out, I can move on to testing that actual spec.

Thanks so much Peter.

host (Bluehost) redirected debug, found error.log. no entries related to this OR any new test crashes – lots for another “not-really-a-db” product’s testing last week ;). no admin-ajax.php entries at all. Maybe host blocking a port? No port settings seen in WPDA settings.

SQL editor doesn’t even return for a SELECT ‘this is text’ AS ”; test. No errors, no crash, just the Executing spinner spinning then nothing.

Thank you Peter, I sincerely appreciate your reply. The error that the wordpress admin raises are in the original post. I see no debug.log entries. admin-ajax.php is a new one to me, forgive my ignorance, so I will have to lookup information on doing that.

Your system is truly wonderful in scope. I see that many, many, many people are using it to do Actual Database work beyond just forms and so I know that this can be figured out.

Deactivated all plugins (Jetpack, Yoast and Google Analytics were all there was in this brand new WP staging site). Flipped on wp debug log. Still SQL Editor does not show any results for any SELECTS (tables viewed in phpmyadmin show the records from INSERTS in the tables). the Table Explorer > Table > Manage link crashes with above error.

No errors in debug.log.
Weird.

Is everyone else having no problems with the current, updated just days ago, installation code?

Is there a previous version available to use as a test?

fyi: used SQL editor to insert records in tables, the Tale Explorer shows the count of records in the table so INSERT INTO is working. BUT that is all I can do with SQL explorer, doing a SELECT COUNT(*) or SELECT([column name]) returns nothing visible, the Executing spinner spins then stops… no error or results grid that I can see. Maybe not seeing a results display in the SQL editor is related? (Maybe not).