bonjour je voudrais recherche et comparé 3 données (mac adresse , ip , hwid) dans ma table users et retourné la valeur si il est banned ou pas
je comprend pas mon erreur il ne retourne rien
voici mon code
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
 
 
 
//////////////////////////
	/* RECUPERATION VARIABLE */ { 
 
		$Id = 0;
		$Name= "";
		$Email = "";
		$Password = "";
		$Active = "";		
		$Mac = make_safe($_GET['mac']);
		$Hwid = make_safe($_GET['hwid']);
		$Banned = "";
		$Ip = make_safe($_GET['ip']);
		$Code = "";
 
	}
 
 
//////////////////////////
	/*  REQUETE */ { 
 
		$RequestMac = "SELECT id,name,email,password,active,macAdresses,hwid,banned,ip,code FROM users WHERE macAddresses= ? and ip= ? and hwid= ? ";
 
	}
 
//////////////////////////
	/* CONNECTION */ { 
 
		$connexion     =     ($GLOBALS["___mysqli_ston"] = mysqli_connect($db_host, $db_user, $db_password)) or die(((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_error($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false)));
		$select     =     ((bool)mysqli_query($GLOBALS["___mysqli_ston"], "USE " . $db_name)) or die(((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_error($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false)));  
		mysqli_query($GLOBALS["___mysqli_ston"], "set character_set_server='utf8'");
		mysqli_query($GLOBALS["___mysqli_ston"], "set names 'utf8'");
	}
 
 
if(mysqli_stmt_prepare($initMac, $RequestMac))
		{
			echo "rentre";
 
			mysqli_stmt_bind_param($initMac,'s',$Mac);
			mysqli_stmt_execute($initMac);
			mysqli_stmt_bind_result($initMac, $Id,$Name,$Email,$Password,$Active,$Mac,$Hwid,$Banned,$Ip,$Code);
			$smtp =	mysqli_stmt_store_result($initMac);
			if($smtprow = mysqli_num_rows($smtp) >0)
			{
				if(mysqli_fetch_array($smtpRow))
				{
					if($Banned == 0)
					{
						echo "non banni";
					}
					else
				{
					echo "banni";
				}
 
				}
 
 
			}
			else
			{
				echo "existe pas";
			}
 
 
			mysqli_stmt_close($initMac); 
		}