{"id":67,"date":"2025-06-04T04:27:15","date_gmt":"2025-06-04T04:27:15","guid":{"rendered":"https:\/\/gurencodes.com\/blog\/wordpress\/?p=67"},"modified":"2025-06-04T05:08:20","modified_gmt":"2025-06-04T05:08:20","slug":"project-26-a-simple-hit-counter-page-using-php-and-sql","status":"publish","type":"post","link":"https:\/\/gurencodes.com\/blog\/wordpress\/index.php\/2025\/06\/04\/project-26-a-simple-hit-counter-page-using-php-and-sql\/","title":{"rendered":"Project #26:\u00a0A simple hit counter page using PHP and SQL."},"content":{"rendered":"\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/safebooru.org\/\/images\/4367\/5d116c33988ff2a4cd9d2cea34224ad8bc2c4916.jpg?5820618\" alt=\"breasts brown_eyes brown_hair hand_against_hip hedge highres long_skirt maison_ikkoku medium_breasts medium_hair parted_lips path poppowerhearts skirt stone_walkway v yagami_ibuki\"\/><\/figure>\n\n\n\n<p><a href=\"https:\/\/gurencodes.com\/pages\/databasehitcounter\" data-type=\"link\" data-id=\"https:\/\/gurencodes.com\/pages\/databasehitcounter\">Link<\/a><\/p>\n\n\n\n<p><strong>Estimated date of creation:<\/strong>&nbsp;May 15th, 2025<\/p>\n\n\n\n<p><strong>Status:<\/strong>&nbsp;Online \ud83d\udfe2<\/p>\n\n\n\n<p>This is a very simplistic hit counter system that just tracks how many people the page has been viewed by, or, really, how many times the page has been loaded. It just has an integer &#8220;hit&#8221; counter that goes up by 1 every time the PHP script runs, and that happens when the page is loaded. The &#8220;hit&#8221; column in the SQL database is semi-permanent. It&#8217;s permanent as long as the database or the computer is never destroyed.<\/p>\n\n\n\n<p>This isn&#8217;t all that interesting, it&#8217;s only interesting because it can be used for a &#8220;views&#8221; tracker on a large website later.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Link Estimated date of creation:&nbsp;May 15th, 2025 Status:&nbsp;Online \ud83d\udfe2 This is a very simplistic hit counter system that just tracks how many people the page has been viewed by, or, really, how many times the page has been loaded. It just has an integer &#8220;hit&#8221; counter that goes up by 1 every time the PHP [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-67","post","type-post","status-publish","format-standard","hentry","category-code-projects"],"_links":{"self":[{"href":"https:\/\/gurencodes.com\/blog\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/67","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gurencodes.com\/blog\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gurencodes.com\/blog\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gurencodes.com\/blog\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gurencodes.com\/blog\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=67"}],"version-history":[{"count":2,"href":"https:\/\/gurencodes.com\/blog\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/67\/revisions"}],"predecessor-version":[{"id":93,"href":"https:\/\/gurencodes.com\/blog\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/67\/revisions\/93"}],"wp:attachment":[{"href":"https:\/\/gurencodes.com\/blog\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=67"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gurencodes.com\/blog\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=67"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gurencodes.com\/blog\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=67"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}