我想获得具有注册配置文件的相同IP地址的用户的昵称。现在我知道我需要做一个if语句，好像ip_adres count（）> 1反映IP地址，但是我如何使IP计数相等。
<?php
$sql = "SELECT ip_adres, nickname2 FROM users";
$alias = $db->prepare($sql);
$alias->execute();
foreach($alias as $a){
$ip_adres = $a['ip_adres'];
$nickname = $a['nickname2'];
if($ip_adres){
echo "<pre>$nickname has a alias profile! $ip_adres</pre> ";
}
}
?>
输出
First has a alias profile! 213.93.99.38
Second has a alias profile! 213.93.99.38
Third has a alias profile! 213.93.45.33
Bla has a alias profile! 213.93.45.33
ZZZZ has a alias profile! 213.93
$sql = "SELECT ip_adres, nickname2 FROM users";
$users = $db->prepare($sql);
$users->execute();
$ips = array();
$aliases = array();
foreach($users as $user) {
if (in_array($user['ip_adres'], $ips))
$aliases[] = $user['ip_adres'];
$ips[] = $user['ip_adres'];
}
if (empty($aliases)) {
echo "Aliases not found";
}
else {
foreach($users as $user) {
if (in_array($user['ip_adres'], $aliases)) {
echo $user['nickname2'] . ' has a alias profile! '. $user['ip_adres'] .'<br/>';
}
}
}
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句