01.<?php
02. $objConnect = mysql_connect("localhost","root","root");
03. $objDB = mysql_select_db("mydatabase");
04.
05. $strEmail = "benz@hotmail.com";
06.
07. $strSQL = "SELECT * FROM members WHERE Email = '".trim($strEmail)."' ";
08. $objQuery = mysql_query($strSQL);
09. $objResult = mysql_fetch_array($objQuery);
10. if(!$objResult)
11. {
12. echo "Not Found Username or Email!";
13. }
14. else
15. {
16. echo "Your password send successful.<br>Send to mail : ".$objResult["Email"];
17.
18. $strTo = $objResult["Email"];
19. $strSubject = "Your Account information username and password.";
20. $strHeader = "Content-type: text/html; charset=windows-874\n";
21. $strHeader .= "From: webmaster@thaicreate.com\nReply-To: webmaster@thaicreate.com";
22. $strMessage = "";
23. $strMessage .= "Welcome : ".$objResult["Firstname"]."<br>";
24. $strMessage .= "Password : ".$objResult["Password"]."<br>";
25. $strMessage .= "=================================<br>";
26. $strMessage .= "ThaiCreate.Com<br>";
27. $flgSend = mail($strTo,$strSubject,$strMessage,$strHeader);
28.
29. }
30. mysql_close($objConnect);
31.?>
Load balance : Server 04
