我们从用户数据库中获取电子邮件地址。然后我们想在 api 中检查这些电子邮件地址并返回违规次数。
问题是现在它似乎只检查第一个电子邮件地址。当我们有多个时，第一个获得正确的违规次数，第二个仅获得 0。
<?php
ini_set("allow_url_fopen", 1);
include '/home/actiorwd/include/dbinfo.php';
$servername = "localhost";
$dbname = "actiorwd_websec";
// Create connection
$conn = new mysqli($servername, $user, $passw, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
//users contains two columns; email and breaches.
$sql = "SELECT * FROM users";
$result = $conn->query($sql);
$ch = curl_init();
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
$url = 'https://haveibeenpwned.com/api/v2/breachedaccount/';
$url.= $row["email"];
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch,CURLOPT_USERAGENT,'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.13) Gecko/20080311 Firefox/2.0.0.13');
curl_setopt($ch, CURLOPT_URL, $url);
$results = curl_exec($ch);
curl_close($ch);
$obj = json_decode($results, TRUE);
$usermail = $row["email"];
$newbreaches = count($obj);
//run if new breaches are found
if($row["breaches"]!==$newbreaches){
require_once('/home/actiorwd/public_html/PHPMailer/PHPMailerAutoload.php');
$mail = new PHPMailer;
$mail->isSMTP(); // Set mailer to use SMTP
$mail->Host = 'cpanel40.proisp.no'; // Specify main and backup SMTP servers
$mail->SMTPAuth = true; // Enable SMTP authentication
$mail->Username = '[email protected]'; // SMTP username
$mail->Password = 'PASSWORDHERE'; // SMTP password
$mail->SMTPSecure = 'ssl'; // Enable TLS encryption, `ssl` also accepted
$mail->Port = 465; // TCP port to connect to
$mail->setFrom('[email protected]', 'WebSec');
$mail->addAddress($row["email"]); // Add a recipient
$mail->addReplyTo('[email protected]', 'WebSec');
$mail->isHTML(true); // Set email format to HTML
$mail->Subject = 'Breached!!!!';
$mail->Body = 'Someone breached your account, there are: '.$newbreaches."breaches";
$mail->AltBody = 'Someone breached your account in plain text';
$mail->send();
/*
if(!$mail->send()) {
echo 'Message could not be sent.';
echo 'Mailer Error: ' . $mail->ErrorInfo;
} else {
echo 'Message has been sent';
}
*/
$updatebreach = "INSERT INTO users (`email`, `breaches`) VALUES ('$usermail', '$newbreaches') ON DUPLICATE KEY UPDATE `breaches` = '$newbreaches' ";
//echo $updatebreach;
if ($conn->query($updatebreach) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $updatebreach . "<br>" . $conn->error;
}
}
}
} else {
echo "0 results";
}
$conn->close();
?>
查看您的循环，或者更好地查看循环之前的行。你在做：
$ch = curl_init();- 所以你初始化一个 cURL 会话。你只做一次，因为它在循环之外。
然后，几行之后，你正在做：
curl_close($ch);- 您关闭了 cURL 会话。每次调用后都这样做，因为它在你的循环中。所以主要是你初始化，运行 cURL 的东西（这就是为什么它适用于第一个）然后它停止工作，因为你关闭了你的 cURL 会话并且永远不会打开一个新的会话。
只需curl_close$ch);从循环中取出您的并将其放在文件的末尾，这样您就可以使用同一个会话执行所有请求。然后它应该工作:)
您的文件末尾应如下所示：
}
curl_close($ch);
$conn->close();
?>
希望它有所帮助。
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句