Here is the tested solution- // Your sample array $sample_array = array( 0 => array( ‘meta_key’ => ‘cpf_first_name’, ‘meta_value’ => ‘John’ ), 1 => array( ‘meta_key’ => ‘cpf_first_name’, ‘meta_value’ => ‘James’ ), 2 => array( ‘meta_key’ => ‘cpf_first_name’, ‘meta_value’ => ‘Jane’ ), 3 => array( ‘meta_key’ => ‘cpf_gender’, ‘meta_value’ => ‘Male’ ), 4 => array( … Read more
I’ve written a filter for you. It will filter the character before the post get saved in the database and it’s using the WordPress way. If you use this I think you’re not gonna be needed the trigger. Here it is- add_filter( ‘wp_insert_post_data’ , ‘the_dramatist_filter_content_before_insert’ , ’99’, 2 ); function the_dramatist_filter_content_before_insert( $data , $postarr ) … Read more
Should I Use only wpdb Class to Write Custom Queries?
First of all, never ever use Plain SQL query to WordPress, because it’s too dangerous. Try $wpdb class, if you need to. BTW, adding posts, post description, assigning featured image, etc. there are wrapper functions designated for these particular tasks, like: wp_insert_post() set_post_thumbnail() – for assigning featured images Always, try to consult Codex or Developer … Read more
Try using $wpdb->replace(); method. It updates a row if it exists and inserts a new one if it doesn’t. See the documentation. Is that what you are looking for?
Seems like there’s a plugin out there that does quite this! It’s VersionPress! In this blog post is explained what they used to track all the complicated changes. Instead of using the ‘query’ filter they use the option to create a db.php file in the wp-contents directory to extend $wpdb like explained in this post: … Read more
Answering my own question just in case someone comes across it looking for an answer. Managed to figure it out! We have to get the URL as follows, we can’t just reference it like we normally would on a server plugins_url( ‘products.csv’, __FILE__ ); The above code returns the information we need, rather than just … Read more
HyperDB failover Delay
To move a site from localhost i usually do the following: 1, Install adminer plugin on your localhost (lets you download the database file) 2, Use an FTP to upload all files 3, Change the php config files details to work on host 4, Open the mysql file saved from Adminer and then edit the … Read more
Im not sure this can be done on a separate sever hosts but if you have two websites that are on different URLs but hosted on the same server host this can be done with using the same database and using different prefix for each install. This link will show you how. share users