Read / Edit Table via PHP

Hi,

thanks for your post, and sorry for the trouble.

Just to be sure, you are referring to TablePress tables here, or maybe more general (mySQL) database tables?

For TablePress, there’s no specific functionality for this, you would have to use the internal PHP functions, as e.g. done in the class-controller-admin.php file.
Now, that holds if you want your changes to be permanently saved. If you are more interested in making modifications before a table is rendered for the site visitor, you could use the available plugin filter hooks, see class-render.php.

Regards,
Tobias

Hi Tobias,

Thanks for your reply. I was thinking about switching to a Database solution with ORM, but I think it is a bit oversized for our project and Tablepress suits our requirements in many ways, so I consider to write a solution from scratch for the reading & editing use case.

Best,
Benedikt

Hi,

ok, but if you are planning to rewrite the reading and editing part of TablePress with a custom storage, what exact features are you after then?

Regards,
Tobias

I’m loving the pluging, thankyou.
I need to read from the table that I have to used the scores in another php page. How can I do that?
(No modification just reading data)
EG: tableName: scores
Player | Score
Tester | 1
Brian | 5

$data = $_POST[‘Scores’]
… loop through data if player==”Brian” …
… echo Score …

Found it here
https://www.ads-software.com/support/topic/access-table-data-in-php-program/

Thanks

Hi,

yes, nice find! This should be a good solution for this kind of search problem ??

Best wishes,
Tobias

Hi,

I think it’s mainly for utility and helper methods, do access data by criteria, sorting, …

So mysql statements would allow that, but I want to keep Tablepress as it fits our requirements in many ways. I think I am going to write some helper classes using native php filtering, etc. This should be the best solution, as some of our use cases are very specific.

Thanks for your help!
Best,
Benedikt

Hi,

ok, I see. Yes, it might be possible to just use the relevant features or classes then.

Best wishes,
Tobias
?
P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!