{"id":9140,"date":"2024-03-14T09:09:08","date_gmt":"2024-03-14T09:09:08","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/"},"modified":"2024-03-20T14:47:30","modified_gmt":"2024-03-20T14:47:30","slug":"how-to-use-php-to-count-the-number-of-online-users","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/","title":{"rendered":"How to use PHP to count the number of online users?"},"content":{"rendered":"<p>To track the number of online users, you can utilize PHP and a database. One simple method for achieving this is as follows:<\/p>\n<ol>\n<li>Create a database table to store information of online users, which includes user ID and last access time.<\/li>\n<li>Add PHP code at the top and bottom of each page to update the user&#8217;s last visit time.<\/li>\n<li>Create a PHP script to count the number of users online. This script will query the database for the number of users who have visited the website in the recent time period, and then output the results.<\/li>\n<li>Display the number of online users in the appropriate location.<\/li>\n<\/ol>\n<p>Below is a simple example code:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-comment\">\/\/ \u8fde\u63a5\u6570\u636e\u5e93<\/span>\r\n<span class=\"hljs-variable\">$conn<\/span> = <span class=\"hljs-title function_ invoke__\">mysqli_connect<\/span>(<span class=\"hljs-string\">\"localhost\"<\/span>, <span class=\"hljs-string\">\"username\"<\/span>, <span class=\"hljs-string\">\"password\"<\/span>, <span class=\"hljs-string\">\"database\"<\/span>);\r\n\r\n<span class=\"hljs-comment\">\/\/ \u66f4\u65b0\u7528\u6237\u6700\u540e\u8bbf\u95ee\u65f6\u95f4<\/span>\r\n<span class=\"hljs-variable\">$userId<\/span> = <span class=\"hljs-variable\">$_SESSION<\/span>[<span class=\"hljs-string\">'userId'<\/span>]; <span class=\"hljs-comment\">\/\/ \u5047\u8bbe\u4f60\u6709\u7528\u6237ID\u4fdd\u5b58\u5728session\u4e2d<\/span>\r\n<span class=\"hljs-variable\">$currentTime<\/span> = <span class=\"hljs-title function_ invoke__\">time<\/span>();\r\n<span class=\"hljs-variable\">$query<\/span> = <span class=\"hljs-string\">\"UPDATE online_users SET last_visit = <span class=\"hljs-subst\">$currentTime<\/span> WHERE user_id = <span class=\"hljs-subst\">$userId<\/span>\"<\/span>;\r\n<span class=\"hljs-title function_ invoke__\">mysqli_query<\/span>(<span class=\"hljs-variable\">$conn<\/span>, <span class=\"hljs-variable\">$query<\/span>);\r\n\r\n<span class=\"hljs-comment\">\/\/ \u7edf\u8ba1\u5728\u7ebf\u4eba\u6570<\/span>\r\n<span class=\"hljs-variable\">$onlineTime<\/span> = <span class=\"hljs-number\">60<\/span>; <span class=\"hljs-comment\">\/\/ \u5047\u8bbe\u5728\u7ebf\u65f6\u95f4\u4e3a60\u79d2\u5185\u7684\u7528\u6237\u4e3a\u5728\u7ebf\u7528\u6237<\/span>\r\n<span class=\"hljs-variable\">$thresholdTime<\/span> = <span class=\"hljs-variable\">$currentTime<\/span> - <span class=\"hljs-variable\">$onlineTime<\/span>;\r\n<span class=\"hljs-variable\">$query<\/span> = <span class=\"hljs-string\">\"SELECT COUNT(*) FROM online_users WHERE last_visit &gt; <span class=\"hljs-subst\">$thresholdTime<\/span>\"<\/span>;\r\n<span class=\"hljs-variable\">$result<\/span> = <span class=\"hljs-title function_ invoke__\">mysqli_query<\/span>(<span class=\"hljs-variable\">$conn<\/span>, <span class=\"hljs-variable\">$query<\/span>);\r\n<span class=\"hljs-variable\">$onlineUsers<\/span> = <span class=\"hljs-title function_ invoke__\">mysqli_fetch_row<\/span>(<span class=\"hljs-variable\">$result<\/span>)[<span class=\"hljs-number\">0<\/span>];\r\n\r\n<span class=\"hljs-comment\">\/\/ \u663e\u793a\u5728\u7ebf\u4eba\u6570<\/span>\r\n<span class=\"hljs-keyword\">echo<\/span> <span class=\"hljs-string\">\"\u5728\u7ebf\u4eba\u6570\uff1a<span class=\"hljs-subst\">$onlineUsers<\/span>\"<\/span>;\r\n<\/code><\/pre>\n<p>Please note that this is just a simple example code and may need to be modified and optimized according to specific requirements. Additionally, this method has some limitations, such as not being able to accurately count the real-time online users and only being able to estimate.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To track the number of online users, you can utilize PHP and a database. One simple method for achieving this is as follows: Create a database table to store information of online users, which includes user ID and last access time. Add PHP code at the top and bottom of each page to update the [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-9140","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to use PHP to count the number of online users? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to use PHP to count the number of online users?\" \/>\n<meta property=\"og:description\" content=\"To track the number of online users, you can utilize PHP and a database. One simple method for achieving this is as follows: Create a database table to store information of online users, which includes user ID and last access time. Add PHP code at the top and bottom of each page to update the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T09:09:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-20T14:47:30+00:00\" \/>\n<meta name=\"author\" content=\"Olivia Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Olivia Parker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/\"},\"author\":{\"name\":\"Olivia Parker\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\"},\"headline\":\"How to use PHP to count the number of online users?\",\"datePublished\":\"2024-03-14T09:09:08+00:00\",\"dateModified\":\"2024-03-20T14:47:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/\"},\"wordCount\":170,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/\",\"name\":\"How to use PHP to count the number of online users? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T09:09:08+00:00\",\"dateModified\":\"2024-03-20T14:47:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to use PHP to count the number of online users?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\",\"name\":\"Olivia Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"caption\":\"Olivia Parker\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to use PHP to count the number of online users? - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/","og_locale":"en_US","og_type":"article","og_title":"How to use PHP to count the number of online users?","og_description":"To track the number of online users, you can utilize PHP and a database. One simple method for achieving this is as follows: Create a database table to store information of online users, which includes user ID and last access time. Add PHP code at the top and bottom of each page to update the [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T09:09:08+00:00","article_modified_time":"2024-03-20T14:47:30+00:00","author":"Olivia Parker","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Olivia Parker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/"},"author":{"name":"Olivia Parker","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9"},"headline":"How to use PHP to count the number of online users?","datePublished":"2024-03-14T09:09:08+00:00","dateModified":"2024-03-20T14:47:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/"},"wordCount":170,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/","name":"How to use PHP to count the number of online users? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T09:09:08+00:00","dateModified":"2024-03-20T14:47:30+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-php-to-count-the-number-of-online-users\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to use PHP to count the number of online users?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9","name":"Olivia Parker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","caption":"Olivia Parker"},"url":"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/9140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=9140"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/9140\/revisions"}],"predecessor-version":[{"id":42303,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/9140\/revisions\/42303"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=9140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=9140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=9140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}