Little Help

[Muscab]

<div class="UsersCreated"><strong>Time Online

/strong> <?php echo $user['OnlineTime']; ?></div>

The current code above, shows the whole user base on the hotel's online-time on 1 page, spamming the MYSQL, i would like that code alterd and make it show just that current user who logged in for his stats

 

[Jo$h]

What CMS are you using, and for that CMS, is there a code (that you can access) that tells you which user is viewing the page?

 

[Muscab]

What CMS are you using, and for that CMS, is there a code (that you can access) that tells you which user is viewing the page?

PhoenixPHP & i dont think so

 

[Jo$h]

PhoenixPHP & i dont think so

There has to be a system for that? You could simply create a form like this:

<form action="checkusers.php" method="post">
Your Username: <input type="text" name="user"> <br />
<input type="submit" name="time" value="Check Time!">
</form>

<?php

if (!isset['time']) {
$result = mysql_query("SELECT * FROM TABLEHERE WHERE user = '$_POST[user]'");

while($user = mysql_fetch_array($result))
  {
  echo "$user['OnlineTime']";
  }

?>

 

[Meow]

wow that's very nice thanks for it Josh

 

[Kryptos]

Is that showing 1) The all users list that are online or 2) Number of users online.

RESPONSE:
1.- Delete dat shit.
2.- That's insignificant, it's not "spamming MySQL", don't worry.

 

[Meow]

Is that showing 1) The all users list that are online or 2) Number of users online.

RESPONSE:
1.- Delete dat shit.
2.- That's insignificant, it's not "spamming MySQL", don't worry.

Eehh what do you mean with ''Its not spamming MYSQL'' He has a problem with uploading his database.

 

[Muscab]

Don't work 100% cause it will show all the users online time ;p

 

[Jo$h]

errrm forgot bracket... Try this:

<form action="checkusers.php" method="post">
Your Username: <input type="text" name="user"> <br />
<input type="submit" name="time" value="Check Time!">
</form>

<?php

if (!isset['time']) {
$result = mysql_query("SELECT * FROM TABLEHERE WHERE user = '$_POST[user]'");

while($user = mysql_fetch_array($result))
  {
  echo "$user['OnlineTime']";
  }
  }
?>