sql

Bulk update set of URLs via SQL

OK, so let’s assume you have these URLs in some array (if you don’t, you can easily prepare it using any developer text editor, I guess). Let’s call that array $slugs and let’s say it’s defined like so: $slugs = array( ‘customer-name’ => ‘google-customer-name’, … ); So there are only slugs in there. So now … Read more

How to create index (sql) to a meta_key?

I’m not going to tell you about what will happen. I’ll here give you an example on how you can run that piece of sql without phpMyadmin. Add this to your functions.php for temporary purpose. Not to forget about removing this after one run of your website. $mymeta=”_my_first_meta”; $wpdb->query( $wpdb->prepare(“CREATE INDEX wp_postmeta_my_first_meta ON wp_postmeta (%s)”,$mymeta) … Read more

How do I display SQL query on a specific page of my wordpress site

$result = $wpdb->get_results( “SELECT `account_number`,`consumer_name`,`bill_amount`,`due_date`,`disco_date`,`bill_status` FROM {$wpdb->prefix}_bill_inquiry where `account_number` = ‘$inputnumber’ AND `pin_number` = ‘$inputpin'”, OBJECT ); $wpdb->prefix will automatically print the prefix, then to convert the result in array form you can use the following snippet: $result = json_decode(json_encode($result),true); You can either place it in a template or you can create a shortcode in … Read more

How to set posts to draft in bulk based on the content of the post

You could try to loop through all the posts and if the content contains the link, call this: change_post_status(get_the_ID(),’private’); or try draft if appropriate. Register this function first: function change_post_status($post_id,$status){ $current_post = get_post( $post_id, ‘ARRAY_A’ ); $current_post[‘post_status’] = $status; wp_update_post($current_post); }

Filtering posts for unique titles, only the most recent

You can try this. However, I am sure there must be a better alternative.. $past_events = get_posts(array( ‘post_type’ => Tribe__Events__Main::POSTTYPE, ‘paged’ => $paged, ‘posts_per_page’ => ’10’, ‘eventDisplay’=>’past’, ‘orderby’=> ‘title’, ‘order’ => ‘ASC’, ‘s’ => $searchText ?: ”, )); $post_arr = array(); foreach ( $past_events as $past_event ) { $post_arr[ $past_event->post_title ] = $past_event->ID; } $post_arr … Read more

+ More