If you want to integrate properly with WordPress consider using Custom Post Types instead of creating tables in the database. In your case you could have two new post types: Events Event participants Here you can find more information about custom post types: https://codex.wordpress.org/Post_Types#Custom_Post_Types This site is handy for generating the initial code that facilitates … Read more
I cannot change anything in my wordpress database from within wordpress?
database – multiple wordpress installations using same database – can they share plugin settings?
Try a plugin like Query Monitor to see if there are queries or things you can identify quickly. A DB may need a log rotated or you could have some DEBUG process turned on that is logging. Backups running on your server will also have an impact. It’s something you’ll have to look into. Same … Read more
As suggested by other its recommended to use rest-api or else you can write your own class to output required data as JSON
Correct permissions for SQLite database
Extracted CSV as Array for Custom Query Loop
How much post meta data is too much?
Thanks to helpful prodding from TheDeadMedic, I see my problem is caused by my own application environment, which I failed to provide in the question because I didn’t think it was relevant. Sorry about that! I usually do briefly describe the environment when posting a question, but it has never been relevant before, so I … Read more
Turns out this works. global $wpdb; $postsTable = $wpdb->posts; $results = $wpdb->get_results( ‘SELECT * FROM ‘.$postsTable.’ WHERE post_type = “page” OR post_type = “post” AND post_status = “publish”‘);