The following is problematic in the OP’s code snippet: Missing shortcode_atts() for default attribute handling. Incorrectly defining the shortcode’s input argument, use instead function create_my_shortcode( $attr = [], $content = null ){ … } Not escaping user input, check e.g. wpdb::prepare(). We want to avoid possible SQL injections. Uses hardcoded table prefix, wp_, instead of … Read more
This Should Work? ALTER TABLE wp_usermeta ADD COLUMN old_user_id bigint(20) unsigned; INSERT INTO wp_usermeta (old_user_id) SELECT u.id FROM wp_users AS u; INSERT INTO wp_usermeta (user_id, meta_key, meta_value) SELECT u.id, ‘wp_2_capabilities’, meta_value JOIN wp_users AS u ON u.user_id = u.old_user_id; ALTER TABLE wp_users DROP COLUMN old_user_id;
global $wpdb; $slugs = $wpdb->get_col( “SELECT slug FROM $wpdb->terms LEFT JOIN $wpdb->term_taxonomy ON $wpdb->terms.term_id = $wpdb->term_taxonomy.term_id WHERE $wpdb->term_taxonomy.taxonomy = ‘course'” ); That will return an array of strings representing the taxonomy term slugs for terms in the course taxonomy.
It seems like you’re trying to use $wpdb without first declaring the global $wpdb. You should not need to enqueue admin.php in order to use $wpdb. add: global $wpdb; to the top of your function instead. If you’re trying to run code in a file without passing it via wordpress (i.e. you’re just navigating to … Read more
Just change the action hook to: add_action( ‘update_history’, ‘update_history’, 10, 4 ); It will work.
Replace this with yours: add_action( ‘delete_user’, ‘yg_user_delete’, 10, 1 ); function yg_user_delete( $user_id ) { $user_info = get_userdata($user_id); $user_name = $user_info->user_login; print_r($user_info); wp_delete_term( get_term_by(‘name’, $user_name, ‘user1’)->term_id, ‘user1’, array() ); }
This is potentially a fairly involved question, so I may not be totally rigorous in my answer, but this should give you a good start when creating and deleting tables.. Include the following lines in your plugin _construct() function of class_my_plugin.php: if (is_admin()){ //manage the the database tables when registering or deactivating register_activation_hook($loc, array($this, ‘your_plugin_installation’)); … Read more
$wpdb->get_results() only returns arrays( associative or numeric) or an object. It does not return a string value. If you want a string value, you need to use $wpdb->get_var() instead
First of all, you should never concatenate SQL Query with any variables this way – it will cause SQL Injection vulnerability. Also… get_results method returns just an array of results. You can’t use it as an object and get num_rows from it – there is no such property in an array (it’s a property of … Read more
You can’t find the option to specify the domain because there isn’t one, that’s not how multisite work. Functions always operate on the current site. If you’re in WP Admin the site is the site that WP Admin is for. Additionally, the plugin will run on all sites, so if your code worked the way … Read more