관리-도구
편집 파일: sendemail.php
<?php include("../connect.php"); if ($_POST['SubmitMail']) { $to = $_POST['mailfrom']; $subject = $_POST['mailsubject']; $from = $_POST['mailfrom']; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; $headers .= 'Bcc: ' . $_POST['toList'] . "\r\n"; $headers .= "From: $from"; $message = $_POST['editor1']; $mail_sent = @mail($to,$subject,$message,$headers); //header("location:emailsent.php"); echo $mail_sent ? "Mail sent" : "Mail failed"; } $sql = "select id, emailaddress from member order by emailaddress"; $res = mysql_query($sql); $selectedemailto = ""; while ($row = mysql_fetch_row($res)) { $chkname = 'chkmem' . $row[0]; if ($_POST[$chkname] == 'Y') { $selectedemailto .= $row[1] . ", "; } } $sql = "select id,grpname from memgroup order by grpname"; $res = mysql_query($sql); while ($row = mysql_fetch_row($res)) { $chkname = 'chkgrp' . $row[0]; if ($_POST[$chkname] == 'Y') { $sql1 = "select * from memgroup where grpname='".$row[1]."'"; $res1 = mysql_query($sql1); while ($row1 = mysql_fetch_row($res1)) { $sql1x = "select emailaddress from member where id='".$row1[3]."'"; $res1x = mysql_query($sql1x); $row1x = mysql_fetch_row($res1x); $selectedemailto .= $row1x[0] . ", "; } } } $selectedemailto .= "anshulbhaigupta@yahoo.co.in"; //$selectedemailto = trim(substr($selectedemailto,0,strlen(trim($selectedemailto))-1)); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title></title> <style type="text/css"> <!-- .style1 { font-family: Arial, Helvetica, sans-serif; font-size: 14px; font-weight: bold; } .style12 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10; } .style13 {font-size: 10} --> </style> <script type="text/javascript" src="ckeditor/ckeditor.js"></script> <script src="ckeditor/_samples/sample.js" type="text/javascript"></script> <link href="ckeditor/_samples/sample.css" rel="stylesheet" type="text/css" /> </head> <body> <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#000000"> <tr> <td><table width="100%" border="0" cellspacing="1" cellpadding="4"> <tr> <td bgcolor="#FFFFFF"><form id="form1" name="form1" method="post" action="sendemail.php"> <table width="100%" border="0" cellspacing="2" cellpadding="4"> <tr> <td height="43" colspan="2"><div align="center"><span class="style1">Send Mass Email Communication </span></div></td> </tr> <tr> <td width="18%" align="right"><span class="style12">From : </span></td> <td width="82%"><span class="style13"> <input type="text" name="mailfrom" /> <input type="hidden" name="toList" value="<?php echo $selectedemailto; ?>" /> </span></td> </tr> <tr> <td align="right"><span class="style12">Subject : </span></td> <td><span class="style13"> <input type="text" name="mailsubject" /> </span></td> </tr> <tr> <td align="right" valign="top"><span class="style12">Email Body : </span></td> <td><span class="style13"><textarea cols="80" id="editor1" name="editor1" rows="10"></textarea></span></td> </tr> <script type="text/javascript"> //<![CDATA[ CKEDITOR.replace( 'editor1', { fullPage : true }); //]]> </script> <tr> <td height="52" colspan="2" align="center" valign="middle"><div align="center"> <input type="submit" name="SubmitMail" value="Send Email" /> </div></td> </tr> </table> </form> </td> </tr> </table></td> </tr> </table> </body> </html>