To answer your questions: Is this possible with an SQL command or just manually? Possibly. This would require you to map the data from your old table to the new WordPress table, since your old custom PHP script won’t be on WordPress. Merging your data from your old recipe table into WordPress won’t work since … Read more
Your question is slightly ambiguous, but I read it this way: given an author and you want to know the three categories in which has published most posts. Let’s use wp_query to get there. $author=”johndoe”; $author_posts = new WP_Query (array ( ‘author’ => $author, ‘posts_per_page’=>-1, )); Now we have an array of all posts by … Read more
Removing the table names from the column names when using $wpdb->insert() is what worked for me: function add_to_affuser($user_id) { global $wpdb; $user_info = get_userdata($user_id ); $wpdb->insert( ‘mytbl_A’, array(‘name’ => $user_info->user_login, ’email’ => $user_info->user_email ), array(‘%s’, ‘%s’) ); } add_action( ‘user_register’, ‘add_to_affuser’); function add_to_aff($user_id) { global $wpdb; $user_info = get_userdata($user_id); $wpdb->insert( ‘mytbl_B’, array(‘user_id’ => $user_info->ID ), … Read more
database sent to a JSON file
The problem is from wp_insert_user and the fact that your value for user_pass is empty. You should update your code as so $random_password = wp_generate_password(8,false); $user_data = array( ‘user_login’ => $first_name, ‘user_pass’ => $random_password, ‘user_email’ => $trainer_email, ‘first_name’ => $first_name, ‘last_name’ => $last_name, ‘role’ => ‘trainer’ ); And remove this line wp_set_password($random_password, $user_id); You should … Read more
wp-cli can do all you need from the list. This is an elegant way to work with WordPress. Furthermore, you probably need some bash scripting to automate things even further. I would go with that. For instance. Backup the database and download the database backup; wp db export it will export the database to a … Read more
You may try this amateur code. SELECT COUNT(ID) FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (1) ) AND wp_posts.post_type=”post” AND ((wp_posts.post_status=”publish”)) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC Note the term_taxonomy_id IN (1) is where your category ID is 1. You may remove the line for published … Read more
Hope this below SQL query will solve your problem- INSERT INTO wp_postmeta (post_id, meta_key, meta_value) (SELECT post_id, ‘tnid’, meta_value FROM wp_postmeta WHERE meta_key = ‘name’ AND post_id IN (SELECT id FROM wp_posts WHERE post_type LIKE ‘post’)) Please try it first. I haven’t got the chance to try it.
How do I join a $wpdb query with user meta using default value if not exist?
It might be unsafe in some cases. You should export DATABASE .SQL file and search inside that, all string containing the phrase: var/www and var\www and var\\www and change those entries too. (you can do that in phpmyadmin too)