Load table into jquery UI Tab via ajax is possible?

Hi Darek,

thanks for your post, and sorry for the trouble.

No, sorry, AJAX loading support (especially with the JS functions like sort, search, etc.) is not possible yet with TablePress.

Regards,
Tobias

OK, no problem. Good to know it is impossible yet in wordpress.

Other plugins (qtip2) not working with admin-ajax as well. Looks like the wordpress ajax mechanism is not ready yet for real ajax works. It is only good for simple ajax calls like read file or something simple like that.

Probably to do so I should make my own wordpress that is able to run plugins in ajax calls ?? or I should read the db by myself via ajax php, send data to jquery and generate the table myself via jquery ?? Too much work, not worth it yet, I guess.

Thanks,
Darek

Hi,

the problem is not admin-ajax.php itself, but that plugin will need to add explicit support in their code for what should happen during an AJAX request.

Best wishes,
Tobias

I was reading that admin-ajax.php works with admin permissions. It is used by wordpress mainly in admin panel. WordPress should execute plugins and everything like it would be normal page via jQuery.load() and without any additional things but… admin-ajax.php is not designed to be real AJAX manager… real shi*** ??

Hi,

no, that’s not true. You can run AJAX requests without being logged-in with admin-ajax.php. They are called “unpriv” in their names.

Regards,
Tobias

Tobias, Yes, I tested the wp_ajax_ method too but the WordPress should be designed to make it all easy. If plugin works normally it should be returned by wordpress in ajax call (especially by jQuery().load()) exactly the same without extra work of plugin author.

Hi,

well, then the jQuery().load() call has to go to the frontend page that (for example) shows a Shortcode. Just because the request goes to admin-ajax.php, that doesn’t mean anything.

Regards,
Tobias

IMHO, The WordPress should execute all php, plugins and shortcodes on the server side and return correct page under jQuery.load or correct data in ajax response. I think they make it too complicated. But it is because the admin-ajax.php is in wordpress mainly for some primitive tasks in admin panel ??

Hi,

but that’s exactly what a page view on the frontend does! That loads all PHP, plugins, and Shortcodes. And WordPress can only execute Shortcodes that are registered, and that’s done by plugins. And some plugins (TablePress included) don’t register their Shortcodes in the admin area, as that’s overhead in most scenarios.

Regards,
Tobias

Tobias,

but that’s exactly what a page view on the frontend does! That loads all PHP, plugins, and Shortcodes.

I am not sure I understood. PHP and plugins are on the server side (backend). JQuery, Javascripts are on the client side (frontend). JQuery and Javascript don’t have access to db. You can read db only via php and e.g. send results via admin-ajax.php to jquery or javascripts. Of course PHP can generate pages but it works on the server side and overload server especially when You need reload page each time do get the same data again and again.

The kk Star Ratings shortcode is in db (TablePress table cell). TablePress return table with empty cell via admin-ajax.php (not registred shorcode? – but it should be done automatically via wordpress for all plugins). Moreover the sort and search functionality and other scripts from other plugins not works too.

Correct?

Hi,

looks like we are using a different terminology here: In WordPress, “backend” usually means that wp-admin area, whereas “frontend” is the site as viewed by a visitor. Your backend/frontend descriptions are just “server side” and “client side”.

Registering Shortcodes can not be done “automatically via wordpress for all plugins”. Plugins explicitly have to register a Shortcode, and some choose to not do that for admin-ajax.php.
The sort and search functions can never work, as those are loaded in the footer of the page. If an AJAX request only returns data, those would not be included and are never executed. Even if they had been executed, they can not cope with the data suddenly changing. After each processed AJAX request, they would have to be reinitialized.

Regards,
Tobias

Tobias,

we are using a different terminology

Agree 100%. I am mean different wordpress design. In case of “ajax design” the admin-ajax.php should be controller, PHP should only get data from db (backend) and jQuery, Javascripts (frontend) should only generate content based on the data sent from admin-ajax.php (controller).

Current wordpress design is old and overload servers not client side. As You mention, now in wordpress some part of PHP code is backend, some part is controller and some part generate pages (frontend). Very old poor style.

My problem (empty cell) is because the “kk Star Ratings” plugin didn’t register the shortcode for ajax (I really don’t get it why it cannot be automatic for all plugins?). This is not problem of TablePress plugin. Sort and search options just need to load datatables scripts to get it to work.

Regards,
Darek

Hi,

I don’t really agree here. admin-ajax.php gives a plugin all flexibility, i.e. a plugin is very flexible in adding support for AJAX in the way that you describe.
And just like you have to retrieve the TablePress table data yourself (as TablePress does not offer an AJAX endpoint), you could simply register the KK Star Ratings Shortcode yourself, if it isn’t registered.

Regards,
Tobias

you could simply register the KK Star Ratings Shortcode yourself, if it isn’t registered.

I guess this is the problem. How to do that? init hook? but if I have so many different shorcodes in table like e.g. [kkstar id=1], [kkstar id=2], [kkstar id=3], etc…

Hi,

no, you’d have to register the Shortcode itself (in the same way as the KK Star Plugin registers it, i.e. look for add_shortcode() in its code). You will of course also have to make sure that Shortcodes are evaluated in the tables, i.e. there need’s to be a do_shortcodes() in your code somewhere.

Regards,
Tobias