$how_many = count($cb); if ($how_many > 0) { echo 'Users Approved<br>'; } for ($i = 0; $i < $how_many; $i++) { echo $i + 1 . '- ' . $cb[$i] . '<br>'; } echo "<br><br>"; } //$result=mysql_query(" update REGISTRATION set USER_STATUS=1 where UserName='******';"); //$res = mysql_query("SELECT EMAIL FROM REGISTRATION where UserName='******';"); //while($row = mysql_fetch_array($result)) //{ $K = $row['EMAIL']; echo $K . "<br>"; $mail = new PHPGmailer(); $mail->Username = '******'; $mail->Password = '******'; $mail->From = 'KKK'; $mail->FromName = 'Team Work'; $mail->Subject = 'conformation mail'; $mail->AddAddress('*****@*****.**'); $mail->Body = "\n\nthank uu for registering with us ur \n\nuser name:" . $K . "\npassword is: manumanu\n\nThanking you,\nTools Team"; if (!$mail->Send()) { echo "Message did not sent<p>"; echo "Mailer error: " . $mail->ErrorInfo; } else { echo "Your Pre-orientation form has been sent to EnhanceEdu Implementation team. Thank You."; } // } mysql_close($con);
echo $i + 1 . '- ' . $cb[$i] . '<br>'; } echo "<br><br>"; } $con = mysql_connect("localhost", "root", "root"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("subversion", $con); for ($i = 0; $i < count($cb); $i++) { $result = mysql_query(" update REGISTRATION set USER_STATUS=1 where UserName='******';"); $res = mysql_query("SELECT EMAIL FROM REGISTRATION where UserName='******';"); while ($row = mysql_fetch_array($res)) { $K = $row['EMAIL']; //echo $K."<br>"; $mail = new PHPGmailer(); $mail->Username = '******'; $mail->Password = '******'; $mail->From = 'KKK'; $mail->FromName = 'SVN'; $mail->Subject = 'conformation mail'; $mail->AddAddress($K); $mail->Body = "\nYou have been successfully approved by Admin.\n\nuser name:" . $cb[$i] . "\npassword is: starstar\n\nYour Usename and Password are given above.\nPlease login to the repository using them\nThanking you,\nSVN Team"; if (!$mail->Send()) { echo "Message did not sent<p>"; echo "Mailer error: " . $mail->ErrorInfo; } else { echo "Mailed Usename and Password successfully"; } } }