I think I have answer to my own question. After loading data into wp_woocommerce_attribute_taxonomies as part of the function detailed above, it is necessary to create serailised array of attributes and their meta data, and post it into wp_options.As far as I can tell wp_options contains a range of transient data used by wordpress as … Read more
The direct answer to the question “Is there a way to get 3+ dimensional array from a single MySql command” would be yes, sort of – WordPress routinely stores and retrieves multidimensional data from MySQL rows by serialize()ing and unserialize()ing structured data to/from a string format, so it’s certainly possible using WordPress’s database interaction mechanisms. … Read more
You need to turn WP_DEBUG on in your wp-config.php: define( ‘WP_DEBUG’, true ); That’ll help a lot with working out where that 500 error is coming from. Based on the PHP versions you’ve mentioned, I’m 99.999% sure that the error is due to a feature that isn’t available in PHP 5.2.17. You’re probably looking at … Read more
Looks to me you should be seeking a woocommerce purchase completion hook. This would be when you could add that a donation has been made and at what amount, then you could grab any user information, amounted donated and other info you need and save it to your donor table. use this: add_action(‘woocommerce_order_status_completed’, ‘save_to_donors’,10,1); instead … Read more
Yes – absolutely. Simply enter the appropriate hostname and credentials in wp-config.php. Instead of the default localhost use the hostname provided by your database provider. Example: define( ‘DB_HOST’, ‘mysql.example.com:3307’ ); https://codex.wordpress.org/Editing_wp-config.php#Set_Database_Host
dbDelta() is for creating new tables or change the structure (not the data) of existing ones. You need $wpdb->insert( $tablename, $zips ); when you want to insert data. Hence the name. 🙂 And this method returns the number of affected rows, exactly as you need it. If it returns false, look at $wpdb->last_error to see … Read more
Honestly, the time writing this question and waiting for an answer, is longer than just going into screen options, setting the posts to about 200, and just doing bulk move to trash, and emptying the trash – if you speed is high, you can probably do even more than 200. else there is a nice … Read more
Look into wp_set_object_terms() You could do something along the lines of: wp_set_object_terms( $post_id, ‘exclude-from-catalog’, ‘product_visibility’ ); Getting all posts by status, use Wp_Query. I added the ‘fields’ => ‘ids’ param to limit the query to only ids, rather than gathering whole post objects. On an array of posts that have Draft or Pending as a … Read more
With WP_Query it’s only possible to sort by a single meta value by setting the meta_key argument to which key you want to be able to sort by, and orderby to meta_value (or meta_value_num if the value is to be sorted numerically). This is what the arguments would look like: $args = array( ‘meta_key’ => … Read more
I guess you want it to know in which article you need to edit and add featured image. You can create some file in the worpdress root folder and just use WP_Query to get all the posts and to check if there is no feature image you can use the has_post_thumbnail(). Change the post_type if … Read more