Try to use wp_update_post() in place of wp_insert_post for update. $id = wp_exist_post_by_title($post[‘post_title’]); if($id !== false) { $post[‘ID’] = $id[“0”]; // Create Post $post_id = wp_update_post( $post ); } else { $post_id = wp_insert_post( $post ); }
this called waitlist you can use this free plugin
wpdb doesn’t have a built in regex replace function. The easiest solution would be to loop through all of their posts, check the contents for the incorrectly formatted shortcode, and perform the regex replace on the post contents. It might not be as fast as a pure-SQL solution, but it would be less prone to … Read more
You need 2 table joins since there are effectively 2 meta keys in your WHERE clause: SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta AS um1 ON (wp_users.ID = um1.user_id) INNER JOIN wp_usermeta AS um2 ON (wp_users.ID = um2.user_id) WHERE (wp_users.user_login LIKE ‘%little%’ OR wp_users.user_email LIKE ‘%little%’ OR wp_users.user_url LIKE ‘%little%’ OR wp_users.display_name LIKE … Read more
The solution to this will require server level changes, this isn’t something you can fix by changing PHP files. Your host needs to install the mysqli PHP extension
So if you want to get the posts that were commented within the last xx hours, e.g. 12 hours, then try one of the following: Note though, I’m selecting only published posts (post_status=”publish”) and of the post type (post_type=”post”). And just replace the value of $hours with your preferred number of hours. Using TIMESTAMPDIFF(). $hours … Read more
I don’t see PHP syntax errors (like unwanted brackets) in your code, but there are two WordPress-specific issues that need to be fixed: Note that wpdb::prepare() needs one or more placeholders (e.g. %s for strings and %d for numbers) and the replacement value for each placeholder. So in your case, the correct $wpdb->prepare() would be: … Read more
You can achieve the OR relation using the tax_query argument like so: $query->set( ‘tax_query’, array( ‘relation’ => ‘OR’, array( ‘taxonomy’ => ‘category’, ‘terms’ => array( 2, 3 ), ), array( ‘taxonomy’ => ‘post_tag’, ‘terms’ => array( 10, 13 ), ), ) );
You are mentioning the mysqldump, and it might be linked to the problem. If your mysqldump takes long time, and lock tables, it might cause the requests to your server when tryig to save posts, to time out. It could also just be a plugin that is messing something up, server-side settings that have errors … Read more
I don’t have gravity forms but I experience in creating autocomplete fields using data from DB, csv, apis and so one. The concept remains the same, it’s just how you call and receive the date that changes, depending in your source. Starting with my csv, I looked for country names to stay as close to … Read more