db에 입력값 저장 후 폼메일 전송 채택완료

</p>

<p><?php</p>

<p>// db에 값 insert

include_once("./_common.php");

$first_name  = $_REQUEST[first_name];

$email   = $_REQUEST[email];

$telephone   = $_REQUEST[telephone];

$comments   = $_REQUEST[comments];

$pf_no1   = $_REQUEST[pf_no1];

$pf_no2   = $_REQUEST[pf_no2];

$pf_no3   = $_REQUEST[pf_no3];

$pf_time  = $_REQUEST[pf_time];

$pf_time  = $_REQUEST[pf_type];

$ip       = $_SERVER[REMOTE_ADDR];

$result=sql_query("insert into {$g5['phone_table']} (first_name,email,telephone,comments,ip,regdate,status) values ('$first_name','$email','$telephone','$comments','$ip',now(),0)");

// 

if($result) {</p>

<p>  if(isset($_POST['email'])) {</p>

<p>

    $email_to = "donna79337412@gmail.com";

    $email_subject = "[폼메일] 문의사항입니다.";

    $email_subject = '=?UTF-8?B?'.base64_encode($email_subject).'?=';</p>

<p>    function died($error) {

        // your error code can go here

      echo "<script> alert('메일발송을 실패하였습니다.');";

      echo "history.go(-1);";

      echo "</script>";

      die();

    }</p>

<p>    // validation expected data exists

    if(!isset($_POST['first_name']) ||

      !isset($_POST['email']) ||

      !isset($_POST['telephone']) ||

      !isset($_POST['comments'])) {

      died('We are sorry, but there appears to be a problem with the form you submitted.');       

  }</p>

<p>    $first_name = $_POST['first_name']; // required

    $email_from = $_POST['email']; // required

    $telephone = $_POST['telephone']; // not required

    $comments = $_POST['comments']; // required</p>

<p>    $error_message = "";

    $email_exp = '/^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+.[A-Za-z]{2,4}$/';

    if(!preg_match($email_exp,$email_from)) {

      $error_message .= 'The Email Address you entered does not appear to be valid.
';

    }

    

    if(strlen($comments) < 2) {

      $error_message .= 'The Comments you entered do not appear to be valid.
';

    }

    if(strlen($error_message) > 0) {

      died($error_message);

    }

    $email_message = "";</p>

<p>    function clean_string($string) {

      $bad = array("content-type","bcc:","to:","cc:","href");

      return str_replace($bad,"",$string);

    }</p>

<p>    $email_message .= "성명 : ".clean_string($first_name)."\n\n";

    $email_message .= "이메일주소 : ".clean_string($email_from)."\n\n";

    $email_message .= "연락처 : ".clean_string($telephone)."\n\n";

    $email_message .= "의견 혹은 문의 : ".clean_string($comments)."\n\n";</p>

<p>

// create email headers

    $headers = 'From: '.$email_from;

// 제목이 깨질경우 아래 캐릭터셋 적용</p>

<p>    @mail($email_to, $email_subject, $email_message, $headers);  

    ?></p>

<p>    <!-- include your own success html here --></p>

<p>    <script>

      alert ("메일이 발송되었습니다.\n빠른 시일안에 답변드리겠습니다.");

      location.href='../';

    </script></p>

<p>

    <?php</p>

<p>  }

} else { 

  alert("접수가 실패했습니다.");

  history.back();

  exit();

}</p>

<p>