How to get visitor data & store detail in database in magento2












0















I want to get visitor data when any visitor visit magento website. In visitor detail, I want to get IP address, browser name , Operating System Name , First Visit Time, & Last Visit time. How is it possible? This Feature must working on all page of magento website.



Please Help Me.



Thanks in advance. :-)










share|improve this question














bumped to the homepage by Community 11 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
















  • This works. Check customer_visitor table in admin panel. But it doesnt have all the data you want. That you need to code differently.

    – Kingshuk Deb
    Apr 5 '17 at 13:44











  • Try this method getVisitorData() to get Data from session object. Check what you can get. If not... try to get data from request header like http_user_agent to get the browser, remote_addr to get the IP address etc etc.

    – Kingshuk Deb
    Apr 5 '17 at 13:52













  • MagentoCustomerModelVisitor is the class where Magento is setting visitors information by using setVisitorData inside initByRequest() function.

    – Kingshuk Deb
    Apr 5 '17 at 13:54






  • 1





    Please put code here if you have.

    – Rohan Hapani
    Apr 6 '17 at 7:12
















0















I want to get visitor data when any visitor visit magento website. In visitor detail, I want to get IP address, browser name , Operating System Name , First Visit Time, & Last Visit time. How is it possible? This Feature must working on all page of magento website.



Please Help Me.



Thanks in advance. :-)










share|improve this question














bumped to the homepage by Community 11 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
















  • This works. Check customer_visitor table in admin panel. But it doesnt have all the data you want. That you need to code differently.

    – Kingshuk Deb
    Apr 5 '17 at 13:44











  • Try this method getVisitorData() to get Data from session object. Check what you can get. If not... try to get data from request header like http_user_agent to get the browser, remote_addr to get the IP address etc etc.

    – Kingshuk Deb
    Apr 5 '17 at 13:52













  • MagentoCustomerModelVisitor is the class where Magento is setting visitors information by using setVisitorData inside initByRequest() function.

    – Kingshuk Deb
    Apr 5 '17 at 13:54






  • 1





    Please put code here if you have.

    – Rohan Hapani
    Apr 6 '17 at 7:12














0












0








0








I want to get visitor data when any visitor visit magento website. In visitor detail, I want to get IP address, browser name , Operating System Name , First Visit Time, & Last Visit time. How is it possible? This Feature must working on all page of magento website.



Please Help Me.



Thanks in advance. :-)










share|improve this question














I want to get visitor data when any visitor visit magento website. In visitor detail, I want to get IP address, browser name , Operating System Name , First Visit Time, & Last Visit time. How is it possible? This Feature must working on all page of magento website.



Please Help Me.



Thanks in advance. :-)







magento2 database frontend






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Apr 5 '17 at 13:20









Rohan HapaniRohan Hapani

6,83731865




6,83731865





bumped to the homepage by Community 11 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.







bumped to the homepage by Community 11 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.















  • This works. Check customer_visitor table in admin panel. But it doesnt have all the data you want. That you need to code differently.

    – Kingshuk Deb
    Apr 5 '17 at 13:44











  • Try this method getVisitorData() to get Data from session object. Check what you can get. If not... try to get data from request header like http_user_agent to get the browser, remote_addr to get the IP address etc etc.

    – Kingshuk Deb
    Apr 5 '17 at 13:52













  • MagentoCustomerModelVisitor is the class where Magento is setting visitors information by using setVisitorData inside initByRequest() function.

    – Kingshuk Deb
    Apr 5 '17 at 13:54






  • 1





    Please put code here if you have.

    – Rohan Hapani
    Apr 6 '17 at 7:12



















  • This works. Check customer_visitor table in admin panel. But it doesnt have all the data you want. That you need to code differently.

    – Kingshuk Deb
    Apr 5 '17 at 13:44











  • Try this method getVisitorData() to get Data from session object. Check what you can get. If not... try to get data from request header like http_user_agent to get the browser, remote_addr to get the IP address etc etc.

    – Kingshuk Deb
    Apr 5 '17 at 13:52













  • MagentoCustomerModelVisitor is the class where Magento is setting visitors information by using setVisitorData inside initByRequest() function.

    – Kingshuk Deb
    Apr 5 '17 at 13:54






  • 1





    Please put code here if you have.

    – Rohan Hapani
    Apr 6 '17 at 7:12

















This works. Check customer_visitor table in admin panel. But it doesnt have all the data you want. That you need to code differently.

– Kingshuk Deb
Apr 5 '17 at 13:44





This works. Check customer_visitor table in admin panel. But it doesnt have all the data you want. That you need to code differently.

– Kingshuk Deb
Apr 5 '17 at 13:44













Try this method getVisitorData() to get Data from session object. Check what you can get. If not... try to get data from request header like http_user_agent to get the browser, remote_addr to get the IP address etc etc.

– Kingshuk Deb
Apr 5 '17 at 13:52







Try this method getVisitorData() to get Data from session object. Check what you can get. If not... try to get data from request header like http_user_agent to get the browser, remote_addr to get the IP address etc etc.

– Kingshuk Deb
Apr 5 '17 at 13:52















MagentoCustomerModelVisitor is the class where Magento is setting visitors information by using setVisitorData inside initByRequest() function.

– Kingshuk Deb
Apr 5 '17 at 13:54





MagentoCustomerModelVisitor is the class where Magento is setting visitors information by using setVisitorData inside initByRequest() function.

– Kingshuk Deb
Apr 5 '17 at 13:54




1




1





Please put code here if you have.

– Rohan Hapani
Apr 6 '17 at 7:12





Please put code here if you have.

– Rohan Hapani
Apr 6 '17 at 7:12










1 Answer
1






active

oldest

votes


















0














Ok. So try this. But this wont save your data in customer_visitor table at least not the fields i added.



public function initByRequest($observer) //MagentoCustomerModelVisitor - PATH
{
if ($this->skipRequestLogging || $this->isModuleIgnored($observer)) {
return $this;
}
if ($this->session->getVisitorData()) {
$this->setData($this->session->getVisitorData());
}

$this->setLastVisitAt((new DateTime())->format(MagentoFrameworkStdlibDateTime::DATETIME_PHP_FORMAT));
$this->setHttpUserAgent($_SERVER['HTTP_USER_AGENT']); // setting user browser to object
$this->setUserRemoteAddr($_SERVER['REMOTE_ADDR']); //setting user ip to object

if (!$this->getId()) {
$this->setSessionId($this->session->getSessionId());
$this->save();
$this->_eventManager->dispatch('visitor_init', ['visitor' => $this]);
$this->session->setVisitorData($this->getData());
}
return $this;
}


Now remove your cookies from browser and try to get the value like this



$this->session->getVisitorData(); // Or where you want to get the data by initializing session object and get it.



Now you will get something like this Array ( [last_visit_at] =>
2017-04-06 07:35:44 [http_user_agent] => Mozilla/5.0 (Windows NT 6.1;
WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.133
Safari/537.36 [user_remote_addr] => 127.0.0.1 [session_id] =>
9c2uc36v01is5mn30q890o1ih2 [visitor_id] => 22 )







share|improve this answer
























    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "479"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f167796%2fhow-to-get-visitor-data-store-detail-in-database-in-magento2%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    Ok. So try this. But this wont save your data in customer_visitor table at least not the fields i added.



    public function initByRequest($observer) //MagentoCustomerModelVisitor - PATH
    {
    if ($this->skipRequestLogging || $this->isModuleIgnored($observer)) {
    return $this;
    }
    if ($this->session->getVisitorData()) {
    $this->setData($this->session->getVisitorData());
    }

    $this->setLastVisitAt((new DateTime())->format(MagentoFrameworkStdlibDateTime::DATETIME_PHP_FORMAT));
    $this->setHttpUserAgent($_SERVER['HTTP_USER_AGENT']); // setting user browser to object
    $this->setUserRemoteAddr($_SERVER['REMOTE_ADDR']); //setting user ip to object

    if (!$this->getId()) {
    $this->setSessionId($this->session->getSessionId());
    $this->save();
    $this->_eventManager->dispatch('visitor_init', ['visitor' => $this]);
    $this->session->setVisitorData($this->getData());
    }
    return $this;
    }


    Now remove your cookies from browser and try to get the value like this



    $this->session->getVisitorData(); // Or where you want to get the data by initializing session object and get it.



    Now you will get something like this Array ( [last_visit_at] =>
    2017-04-06 07:35:44 [http_user_agent] => Mozilla/5.0 (Windows NT 6.1;
    WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.133
    Safari/537.36 [user_remote_addr] => 127.0.0.1 [session_id] =>
    9c2uc36v01is5mn30q890o1ih2 [visitor_id] => 22 )







    share|improve this answer




























      0














      Ok. So try this. But this wont save your data in customer_visitor table at least not the fields i added.



      public function initByRequest($observer) //MagentoCustomerModelVisitor - PATH
      {
      if ($this->skipRequestLogging || $this->isModuleIgnored($observer)) {
      return $this;
      }
      if ($this->session->getVisitorData()) {
      $this->setData($this->session->getVisitorData());
      }

      $this->setLastVisitAt((new DateTime())->format(MagentoFrameworkStdlibDateTime::DATETIME_PHP_FORMAT));
      $this->setHttpUserAgent($_SERVER['HTTP_USER_AGENT']); // setting user browser to object
      $this->setUserRemoteAddr($_SERVER['REMOTE_ADDR']); //setting user ip to object

      if (!$this->getId()) {
      $this->setSessionId($this->session->getSessionId());
      $this->save();
      $this->_eventManager->dispatch('visitor_init', ['visitor' => $this]);
      $this->session->setVisitorData($this->getData());
      }
      return $this;
      }


      Now remove your cookies from browser and try to get the value like this



      $this->session->getVisitorData(); // Or where you want to get the data by initializing session object and get it.



      Now you will get something like this Array ( [last_visit_at] =>
      2017-04-06 07:35:44 [http_user_agent] => Mozilla/5.0 (Windows NT 6.1;
      WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.133
      Safari/537.36 [user_remote_addr] => 127.0.0.1 [session_id] =>
      9c2uc36v01is5mn30q890o1ih2 [visitor_id] => 22 )







      share|improve this answer


























        0












        0








        0







        Ok. So try this. But this wont save your data in customer_visitor table at least not the fields i added.



        public function initByRequest($observer) //MagentoCustomerModelVisitor - PATH
        {
        if ($this->skipRequestLogging || $this->isModuleIgnored($observer)) {
        return $this;
        }
        if ($this->session->getVisitorData()) {
        $this->setData($this->session->getVisitorData());
        }

        $this->setLastVisitAt((new DateTime())->format(MagentoFrameworkStdlibDateTime::DATETIME_PHP_FORMAT));
        $this->setHttpUserAgent($_SERVER['HTTP_USER_AGENT']); // setting user browser to object
        $this->setUserRemoteAddr($_SERVER['REMOTE_ADDR']); //setting user ip to object

        if (!$this->getId()) {
        $this->setSessionId($this->session->getSessionId());
        $this->save();
        $this->_eventManager->dispatch('visitor_init', ['visitor' => $this]);
        $this->session->setVisitorData($this->getData());
        }
        return $this;
        }


        Now remove your cookies from browser and try to get the value like this



        $this->session->getVisitorData(); // Or where you want to get the data by initializing session object and get it.



        Now you will get something like this Array ( [last_visit_at] =>
        2017-04-06 07:35:44 [http_user_agent] => Mozilla/5.0 (Windows NT 6.1;
        WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.133
        Safari/537.36 [user_remote_addr] => 127.0.0.1 [session_id] =>
        9c2uc36v01is5mn30q890o1ih2 [visitor_id] => 22 )







        share|improve this answer













        Ok. So try this. But this wont save your data in customer_visitor table at least not the fields i added.



        public function initByRequest($observer) //MagentoCustomerModelVisitor - PATH
        {
        if ($this->skipRequestLogging || $this->isModuleIgnored($observer)) {
        return $this;
        }
        if ($this->session->getVisitorData()) {
        $this->setData($this->session->getVisitorData());
        }

        $this->setLastVisitAt((new DateTime())->format(MagentoFrameworkStdlibDateTime::DATETIME_PHP_FORMAT));
        $this->setHttpUserAgent($_SERVER['HTTP_USER_AGENT']); // setting user browser to object
        $this->setUserRemoteAddr($_SERVER['REMOTE_ADDR']); //setting user ip to object

        if (!$this->getId()) {
        $this->setSessionId($this->session->getSessionId());
        $this->save();
        $this->_eventManager->dispatch('visitor_init', ['visitor' => $this]);
        $this->session->setVisitorData($this->getData());
        }
        return $this;
        }


        Now remove your cookies from browser and try to get the value like this



        $this->session->getVisitorData(); // Or where you want to get the data by initializing session object and get it.



        Now you will get something like this Array ( [last_visit_at] =>
        2017-04-06 07:35:44 [http_user_agent] => Mozilla/5.0 (Windows NT 6.1;
        WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.133
        Safari/537.36 [user_remote_addr] => 127.0.0.1 [session_id] =>
        9c2uc36v01is5mn30q890o1ih2 [visitor_id] => 22 )








        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Apr 6 '17 at 7:43









        Kingshuk DebKingshuk Deb

        806724




        806724






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Magento Stack Exchange!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f167796%2fhow-to-get-visitor-data-store-detail-in-database-in-magento2%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Last logged in always never, not logging

            Colouring column values based on a specific condition. How could I do this?

            Iĥnotaksono