You can create a new wpdb object and connect to an external MySQL database, though there will be a performance cost to making a remote connection, don’t expect it to be fast. But, you mentioned it’s an MS SQL database, not MySQL. There won’t be a WordPress based mechanism to do this, you’ll have to … Read more
First, an observation: the line highlighted below is correct as per your logic? This query will set the dstatus and downloadname fields in a row as $_POST[‘dstatuschange’] and $_POST[‘dlname’] if downloadname field is the ‘dlname’ string. Maybe you wanted to put the $_POST[‘dlname’] variable in your WHERE condition? Second, wordpress custom POSTs work much better … Read more
But I would like to use my secondary database connection like a standard WordPress query, so that all of the query builder functions are available. Unless the other database is a WordPress database, with the exact same table structure, you can’t. The query builder functions in WordPress are designed and built only to work with … Read more
There is no programmatic way to get a list of default tables. WordPress does not store a list of them anywhere. The closest thing there is is wp_get_db_schema(). This function returns the raw SQL used to create the default tables, but as you can see from the source, it doesn’t derive it from another source, … Read more
You can get the last inserted ID from $wpdb with the insert_id property: $wpdb->insert( … ); $couponId = $wpdb->insert_id
You’re missing your where statement. You need to tell wpdb which row it should be updating, otherwise you’re looking to insert rather than update. From the $wpdb::update Codex: wpdb->update( string $table, array $data, array $where, array|string $format = null, array|string $where_format = null );
Use $wpdb->base_prefix for ‘users’ table.
If you are trying to fire your function when the WordPress Importer runs, there are a few filters and action hooks available. From the plugin documentation: import_start: occurs after the export file has been uploaded and author import settings have been chosen import_end: called after the last output from the importer https://wordpress.org/plugins/wordpress-importer/
First get data from wp_postmeta table $description = get_post_meta( $post->ID, ‘description’, true ); Try following code to update content $my_post = array( ‘ID’ => $post->ID, ‘post_content’ => $description, ); //Update the post into the database wp_update_post( $my_post );
Okay, here’s what I did. If this happens, hopefully this will work favourably for you. If this is disabled by default, enable wp-debug by changing the value from false to true. Check that you have enabled WP_DEBUG_LOG and WP_LOG_DISPLAY. Try refreshing the page and see what happens. Either using WinSCP or the terminal, go to … Read more