<script>
     function updateOnlineStatus(msg) {
       var status = document.getElementById("status");
       var condition = navigator.onLine ? "ONLINE" : "OFFLINE";
       status.setAttribute("class", condition);
       var state = document.getElementById("state");
       state.innerHTML = condition;
       var log = document.getElementById("log");
       log.appendChild(document.createTextNode("Évènement : " + msg + " ; état=" + condition + "\n"));
     }
     function loaded() {
       updateOnlineStatus("load");
       document.body.addEventListener("offline", function () {
         updateOnlineStatus("offline")
       }, false);
       document.body.addEventListener("online", function () {
         updateOnlineStatus("online")
       }, false);
     }
   </script>
<?PHP
session_start();
require_once("function.php");
$connection = connexion_db ();
header('Content-type: text/html; charset=UTF-8');

	 $reponse=('SELECT pseudo_site FROM online_site');
     $res = $connection->query($reponse);
     while ($result = $res->fetch()) {
		 
     setcookie('pseudo', ''.$result['pseudo_site'].'', time() + 60*60*2, null, null, false, true); // On écrit un cookie
	 }
if(isset($_COOKIE["pseudo"]) == true){
echo'<img src="imdesign/bille_verte.png" width="15" height="15">';
}else{
echo'<img src="imdesign/bille_verte.png" width="15" height="15">';	
}

?>

$requete = 'SELECT pseudo_site as pseudo ,type,(select count(1) from online_site os where os.pseudo = u.pseudo) as connected FROM online_site os ';

$requete = 'SELECT pseudo_site as pseudo ,type,(select count(1) from online_site os where os.pseudo = u.pseudo) as connected FROM online_site os ';
$params = [];
if (!empty($_POST['type'])) {
    // si on a reçu un type, on filtre dessus
    $requete = $requete.' WHERE type=:type';
    // on ajoute la valeur de type aux paramètres d'exécution de la requête
    $params['type']  = $_POST['type'];
}

<?php
if(isset($_SESSION['login_site'])){
    if(isset($_SESSION['type_site'])){
        $requete_nombre_connecte = $connection->prepare('SELECT COUNT(1) pseudo_site FROM online_site WHERE pseudo_site=:pseudo_site');
        if($requete_nombre_connecte->execute(array(':pseudo_site'=> $_SESSION['login_site']))){
            $connecte = $requete_nombre_connecte->fetchColumn();
            if($connecte > 0){
                $udapte_connecte = ('UPDATE online_site SET timestamp=:timestamp WHERE pseudo_site=:pseudo_site');
                $req_connecte = $connection->prepare($udapte_connecte);
                $req_connecte->execute(array(':timestamp'=> date("Y-m-j H:i:s"),':pseudo_site'=> $_SESSION['login_site']));
            }else{
                $connecte_online = array(
                ':timestamp'=> date("Y-m-j H:i:s"),
                ':pseudo_site'=> $_SESSION['login_site'],
                ':type'=> $_SESSION['type_site']);
                
                $values= join(', ',array_keys($connecte_online));
                $req=$connection->prepare( 'INSERT INTO online_site ('.str_replace(':','',$values).') VALUES('.$values.')' );
                $req->execute($connecte_online);
            }
        }
    }
}
$requete = 'SELECT pseudo_site as pseudo ,type,(select count(1) from online_site os where os.pseudo = u.pseudo) as connected FROM online_site os ';
$params = [];
if (!empty($_POST['type'])) {
    // si on a reçu un type, on filtre dessus
    $requete = $requete.' WHERE type=:type';
    // on ajoute la valeur de type aux paramètres d'exécution de la requête
    $params['type']  = $_POST['type'];
}
$connect = $connection->prepare($requete);
$connect->execute($params);
$imgF = 'imdesign/f.png';
$imgH = 'imdesign/h.png';
echo <<<form
<form method="post">
<input type="image" src="{$imgF}" title="Femme" width="30" height="30" border="0" name="type" value="Femme" />
<input type="image" src="{$imgH}" title="Homme" width="30" height="30" border="0" name="type" value="Homme" />
</form>
form;
$baseUrl = 'http://'.$_SERVER['HTTP_HOST'].dirname($_SERVER['PHP_SELF']);
while($result = $connect->fetchObject()){
    $ballColor = 'verte';
    if ($result->connected == 1) {
        $ballColor = 'rouge';
    }
    
    $picto  = $imgF;
    $title = 'Picto Femme';
    if(strtolower($result->type) == 'homme'){
        $picto = $imgH;
        $title = 'Picto Homme';
    }
    
    echo <<<line
    <img src="imdesign/bille_{$ballColor}.png" width="15" height="15"><b>{$result->pseudo}</b>
    <img src="{$picto}" title="{$title}/>
    <a href="{$baseUrl}/envoyez_message.php?destin={$result->pseudo}"><img src="imdesign/envois.png" width="20" height="15" /></a></br>
line;
}
// pas la pein de le faire plusieurs fois ;)
$connection->exec('DELETE FROM online_site WHERE timestamp< DATE_SUB(NOW(), INTERVAL 10 MINUTE)');

<?PHP					
if(isset($_SESSION['login_site'])){
	if(isset($_SESSION['type_site'])){
			
$requete_nombre_connecte = $connection->prepare('SELECT COUNT(*) pseudo_site FROM online_site WHERE pseudo_site=:pseudo_site');
if($requete_nombre_connecte->execute(array(':pseudo_site'=> $_SESSION['login_site']))){
	$connecte = $requete_nombre_connecte->fetchColumn();
	
		if($connecte >0){
                $udapte_connecte = ('UPDATE online_site SET timestamp=:timestamp WHERE pseudo_site=:pseudo_site');	
			    $req_connecte = $connection->prepare($udapte_connecte);			
                $req_connecte->execute(array(':timestamp'=> date("Y-m-j H:i:s"),':pseudo_site'=> $_SESSION['login_site']));	
        }else{
                $connecte_online = array(
				                ':timestamp'=> date("Y-m-j H:i:s"),
				                ':pseudo_site'=> $_SESSION['login_site'],
								':type'=> $_SESSION['type_site']);	
								
                 $values= join(', ',array_keys($connecte_online));
                 $req=$connection->prepare( 'INSERT INTO online_site ('.str_replace(':','',$values).') VALUES('.$values.')' );
                 $req->execute($connecte_online);
		   }
        }
     }
  }
$requete = 'SELECT pseudo_site,type FROM online_site ';
if (!empty($_POST['type'])) {
    // si on a reçu un type, on filtre dessus
    $requete = $requete.' WHERE type=:type';
    // on ajoute la valeur de type aux paramètres d'exécution de la requête
    $params['type']  = $_POST['type'];
}
@$connect = $connection->prepare($requete);
@$connect->execute($params);		
$typef = 'Femme';
$typeh = 'Homme';	 
 echo'<FORM method="POST" action="'.$_SERVER['PHP_SELF'].'">
     <input type="image" src="imdesign/f.png" title="Femme" width="30" height="30" border="0" name="type" value="'.$typef.'" />
	 <input type="image" src="imdesign/h.png" title="Homme" width="30" height="30" border="0" name="type" value="'.$typeh.'" />
     </FORM>';
while($result = $connect->fetch()){
 $online = $result['pseudo_site'];
 $ballColor = 'verte';
  // Test du paramètre d'entrée
  if ($online == 1) {
    $ballColor = 'rouge';
  }
 	
   echo'<img src="imdesign/bille_' , $ballColor , '.png" width="15" height="15"><b>'.$result['pseudo_site'].'</b>
   <a href="http://'.$_SERVER['HTTP_HOST'].dirname($_SERVER['PHP_SELF']).'/envoyez_message.php?destin='.$result['pseudo_site'].'"><img src="imdesign/envois.png" width="20" height="15" /></a></br>';

$connection->exec('DELETE FROM online_site WHERE timestamp< DATE_SUB(NOW(), INTERVAL 10 MINUTE)');
	  }
?>

while($data_online = $online_sortie->fetch(PDO::FETCH_OBJ)){
 $connecte = $data_online->pseudo_site;
  // Test du paramètre d'entrée
  if ($connecte == 1){
    echo'<img src="imdesign/bille_verte.png" width="15" height="15">';
  }
 else{
   echo'<img src="imdesign/bille_rouge.png" width="15" height="15">';
  }
}

à condition que le statut connecte ou non soit bien dans $data_online->pseudo_site

<?php

while($data_online = $online_sortie->fetch(PDO::FETCH_OBJ)){
 $connecte = $data_online->pseudo_site;
 $ballColor = 'rouge';
  // Test du paramètre d'entrée
  if ($connecte == 1) {
    $ballColor = 'verte';
  }
  echo'<img src="imdesign/bille_' , $ballColor , '.png" width="15" height="15">';
}

select user_id,pseudo, (select count(1) from online_site os where os.pseudo = u.pseudo) as connected from users u