Looking at this article on WP.org it seems you have to create your database first, with some SQL: function mp_install_table() { global $wpdb; $table_name = $wpdb->prefix . “countries”; $sql = “CREATE TABLE $table_name ( id mediumint(9) NOT NULL AUTO_INCREMENT, name tinytext NOT NULL, labour_cost INT, overheads FLOAT, profits FLOAT );”; require_once( ABSPATH . ‘wp-admin/includes/upgrade.php’ ); … Read more
WordPress already has both user and post meta data tables, and associated API for handling the data. Storing an array of post IDs for each user in user meta sounds like it would work for your application.
I’m not sure if suggesting plugins here is still taboo, but I’m going to go that route for you, because it’s going to be the most effective and simple method for you to achieve this. Install two plugins: Custom Post Type UI, and Advanced Custom Fields Alternatively, forego CPTUI (it’s just nice to have a … Read more
Most of the complex tables in admin are produced using WP_List_Table class. Despite being formally private, it has been widely used by third party extensions for years now. It’s not exactly friendly to work with, so you should research it and consider if your requirements merit reusing it or just replicating markup to achieve same … Read more
Welcome to WordPress development! There’s a few things to answer about your question, the first is regarding the hanging on a blank page. Usually that means there is an error of some sort; one of the most helpful things you’ll find during development is turning on WordPress’ DEBUG mode, which will instruct PHP to print … Read more
…there’s no way to include the style in WordPress posts, at all? You need to add the style tag to the list of allowed post tags, and also ensure TinyMCE recognises it in the editor: function wpse_180472_wp_kses_allowed_html( $tags, $context ) { if ( $context === ‘post’ ) $tags[‘style’] = array(); return $tags; } add_filter( ‘wp_kses_allowed_html’, … Read more
This is possible with a custom plugin, but lot of effort. I like the way about css in the front end. The table button in TinyMCE creates a default table, without classes, like: <table> <tr> <td>Text</td> <td>Text</td> <td>Text</td> </tr> <tr> <td>Text</td> <td>Text</td> <td>Text</td> </tr> <tr> <td>Text</td> <td>Text</td> <td>Text</td> </tr> </table> Below a simple example to … Read more
Users created in Site_A have roles assigned to them. Same users are available in Site_B but they have no roles assigned. Create a PHP script sync-admins.php with the following code in it: <?php // load WordPress environment require( ‘wp-load.php’ ); // REPLACE ‘siteb_’ with table prefix of Site_B in line below! $tblPrefixOfSite_B = ‘siteb_’; // … Read more
Try edit Privileges for your wordpress database user from phpMyAdmin.
First of all you are trying to combine both of the tables by post_parent. $wpdb->posts.post_parent = $wpdb->ftcalendar_events.post_parent I guess data in the ftcalendar_events has children of posts table, try $wpdb->posts.ID = $wpdb->ftcalendar_events.post_parent Also you can try joining tables: SELECT * FROM $wpdb->posts JOIN $wpdb->ftcalendar_events ON $wpdb->posts.ID = $wpdb->ftcalendar_events.post_parent WHERE $wpdb->posts.post_status=”publish” AND $wpdb->posts.post_type=”post” ORDER BY $wpdb->posts.post_date … Read more