Hook this function to set number of comments to retrieve:
//limit comment
function limit_comments($query) {
$query->query_vars['number'] = 5; //set the number of comments
$query->query_vars['paged'] = 1;
}
add_action('pre_get_comments', 'limit_comments');This code should be placed in the functions.php file of your active theme or a custom functions plugin.
Anchor ads, either sticking on top or bottom, is pretty annoying to me because it sometimes messes up with the navigation bar or other important messages. Further more, It takes pretty much space on mobile devices.
You can completely disable all anchor ads, both top and bottom by
One of my ways of keeping my posts up to date is to update the post_modified value after some of certain actions like commenting, liking…
You shouldn’t use wp_update_post() because it calls wp_insert_post(), which determines that the post exists and sets the post_modified and post_modified variables to the current date.
This process will take way longer than using direct DB query.
function vl_post_modified_update ($post_id) {
global $wpdb;
// Get the current time
$time = current_time('mysql');
$post_modified_gmt = get_gmt_from_date($time);
$post_id = 123; //the post ID;
$res = $wpdb->query("UPDATE $wpdb->posts SET post_modified = '{$time}', post_modified_gmt = '{$post_modified_gmt}' WHERE ID = {$post_id}" );
return $res;
}Next step is to hook this function after user comment is submited
add_action('wp_insert_comment','vl_post_modified_update',99,1);WordPress functions like:
update_post_meta()
update_term_meta()
update_user_meta()will serialize data automatically before adding to the MySQL, so the the data will be stored as serialized string:
$data = Array
(
[123] => 1
[a] => 1
[456] => 1
);
update_term_meta ($termid,'_your_key', $data);a:3:{i:123;i:1;s:1:"a";i:1;i:456;i:1;}If you are using PODS to create metadata, somehow it causes the function not to be serialized correctly, so you have to use the function
$data = maybe_serialized($data) then
update_term_meta ($termid,'_your_key', $data);If you want to get back the data, you have to unserialized the data again.
$data = get_term_meta ($termid,'_your_key');
$data = maybe_unserialize($data);It’s a must practice to sanitize all data from user input before insert to database.
To escape unwanted characters, use the core WordPress core function sanitize_text_field():
$title = sanitize_text_field( $_POST['title'] );
update_post_meta( $post->ID, 'title', $title );Behind the scenes, sanitize_text_field() does the following:
To get the author ID from a post ID, use this code:
$post_id = 422;
$author_id = get_post_field( 'post_author', $post_id );I’m developing a simple “trending hashtags”, which based on tags were used by recent posts. The result will be:
| pid | tags |
| postid2 | tag1,tag2,tag3 |
| postid1 | tag1,tag5,tag6 |
Here is the MySQL:
<?php
global $wpdb;
$results = $wpdb->get_results("SELECT `{$wpdb->prefix}term_relationships`.`object_id` AS pid,
GROUP_CONCAT(`{$wpdb->prefix}term_relationships`.`term_taxonomy_id`) AS tags
FROM `{$wpdb->prefix}term_relationships`
JOIN {$wpdb->prefix}term_taxonomy
ON (`{$wpdb->prefix}term_relationships`.`term_taxonomy_id` = `{$wpdb->prefix}term_taxonomy`.`term_id` AND {$wpdb->prefix}term_taxonomy.taxonomy='post_tag')
WHERE `object_id` IN (SELECT `ID` FROM `{$wpdb->prefix}posts` WHERE `post_type` = 'post' ORDER BY `{$wpdb->prefix}posts`.`post_date` DESC)
GROUP BY `object_id`
ORDER BY `{$wpdb->prefix}term_relationships`.`object_id` DESC LIMIT ", OBJECT );If you want to display custom post type posts along with “default” posts in latest posts page, category page, archive page or tag page, you could you this function. Basically it will add custom post types to the main query before looping:
add_action( 'pre_get_posts', 'add_cpt_to_query' );
function add_cpt_to_query( $query ) {
// Return if in admin area
if( is_admin() ) {
return $query;
}
// add 'cpt' to main_query
if ( is_tag() && $query->is_main_query() || is_archive() && $query->is_main_query() )
$query->set( 'post_type', array( 'post', 'page', 'custom_post_type' ) );
return $query;
}This code should be placed in the functions.php file of your active theme or a custom functions plugin.
If you’re using wp_login_form() inside a custom function and you don’t want wp_login_form() to echo, which is by default, you shoud set the echo to false as following:
function custom_login(){
$acc_menu = wp_login_form(
array(
'echo' => false,
)
);
return $acc_menu;
}
This code should be placed in the functions.php file of your active theme or a custom functions plugin.
If you want to build a custom login page by using the builtin WP function wp_login_form(), you will notice that there is no register or forgot password link.
If you want to take them back, just hook these links as following:
add_action( 'login_form_bottom', 'add_register_lost_password_link' );
function add_register_lost_password_link() {
$add_links = '<a href="/wp-login.php?action=register">Register</a><a href="/wp-login.php?action=lostpassword">Lost your password?</a>';
return $add_links;
}There are 3 hooks available:
This code should be placed in the functions.php file of your active theme or a custom functions plugin.