1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| <?php
require_once 'connexion_db.php';
$conn = new mysqli($ah,$un,$pw,$db);
if($conn->connect_error) die ("FAILED TO CONNECT to mysql database".mysqli_connect_error());
$id_user = mysql_entities_fix_string($conn,$_POST['id_user']);
$id_game = mysql_entities_fix_string($conn,$_POST['id_game']);
$query = "SELECT user,id_user FROM users WHERE id_partie_actuelle = '$id_game'";
$result = $conn->query($query);
if(!$result) die ('No users found!');
$rows = $result->num_rows;
for ($j = 0 ; $j < $rows ; ++$j)
{
$result->data_seek($j);
$row = $result->fetch_array(MYSQLI_ASSOC);
if($row['id_user']!= $id_user){
echo 'name : '. $row['user'];
}
}
$result->close();
$conn->close();
?> |