Wordpress query runs twice

Question

My Wordpress plugin contains the following class to measure the views of my Wordpress posts. The code works, but the query inserts 2 records every time. How can I prevent this?

class my_plugin_class {

    function insert_into_wpdb()
    {
    global $wpdb;
    $datetime       = date("Y-m-d H:i:s");
    $post_id        = get_the_title();
    $ip             = $_SERVER['REMOTE_ADDR'];

        $sql = $wpdb->prepare("INSERT INTO plugin_db 
                     (datetime, ip, post_id, count) 
                     VALUES (%s, %s, %d, %d) 
                     ON DUPLICATE KEY UPDATE count = count +1", 
                     $datetime, $ip, $post_id, 1);
        $wpdb->query($sql);
    }
}

add_action('wp_footer',function(){
        $var = my_plugin_class; 
        $var->insert_into_wpdb();
    });

henrywright · Accepted Answer · 2014-07-13 19:57:56Z

4

Sometimes pre-fetching can add extra views. Add this to your theme's functions.php file to see if it resolves the problem:

remove_action( 'wp_head', 'adjacent_posts_rel_link_wp_head', 10, 0 );

See here for more info: https://core.trac.wordpress.org/ticket/14568

answered Jul 13, 2014 at 19:57

henrywright

10.3k25 gold badges98 silver badges154 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Wordpress query runs twice

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related