Reply to thread

Message

<blockquote data-quote="Chuckie_" data-source="post: 461646" data-attributes="member: 86709">Make a PHP page that will return the amount of online users.[CODE=php]&lt;?php$connection = new mysqli(&quot;db_host&quot;, &quot;db_user&quot;, &quot;db_password&quot;, &quot;db_name&quot;);$sql = &quot;SELECT COUNT(*) FROM users WHERE online='1'&quot;;$result = $connection-&gt;query($sql);echo $result;$connection-&gt;close();[/CODE]Save it as online.php or something in your pages folder, so that you can get the online count by going to the <a href="https://yourhotel.com/online" target="_blank">https://yourhotel.com/online</a> url.Then add a script in your client.php that fetches the online amount every x seconds. In this example every 10 seconds (the fetchInterval variable).[CODE=javascript]&lt;script&gt;const fetchInterval = 30000 // Time between each fetch query 30000/1000 = 30 seconds.let getOnline = () =&gt; {&nbsp; &nbsp; fetch('/online').then(res =&gt; {&nbsp; &nbsp; &nbsp; &nbsp; document.querySelector(&quot;#online-element&quot;).innerHTML(res);&nbsp; &nbsp; })}setInterval(getOnline, fetchInterval);&lt;/script&gt;[/CODE]This assumes that you will be having some kind of HTML element with the id [ICODE]online-element[/ICODE], where it will output the current online amount. You can rip it off someone else's client page or design your own, I won't spoonfeed you that much.Please note, this should be considered pseudo code, as I haven't done PHP and vanilla JS in ages.Good luck <img src="/styles/default/xenforo/smilies/emojione/smile.png"&nbsp; class="smilie" loading="lazy" alt=":)" title="Smile&nbsp; &nbsp; :)" data-shortname=":)" /></blockquote>

[QUOTE="Chuckie_, post: 461646, member: 86709"] Make a PHP page that will return the amount of online users. [CODE=php]<?php $connection = new mysqli("db_host", "db_user", "db_password", "db_name"); $sql = "SELECT COUNT(*) FROM users WHERE online='1'"; $result = $connection->query($sql); echo $result; $connection->close();[/CODE] Save it as online.php or something in your pages folder, so that you can get the online count by going to the [URL]https://yourhotel.com/online[/URL] url. Then add a script in your client.php that fetches the online amount every x seconds. In this example every 10 seconds (the fetchInterval variable). [CODE=javascript]<script> const fetchInterval = 30000 // Time between each fetch query 30000/1000 = 30 seconds. let getOnline = () => { fetch('/online').then(res => { document.querySelector("#online-element").innerHTML(res); }) } setInterval(getOnline, fetchInterval); </script>[/CODE] This assumes that you will be having some kind of HTML element with the id [ICODE]online-element[/ICODE], where it will output the current online amount. You can rip it off someone else's client page or design your own, I won't spoonfeed you that much. Please note, this should be considered pseudo code, as I haven't done PHP and vanilla JS in ages. Good luck :) [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members