mobile == "" ) $sender = "02-539-5228"; else $sender = $row->mobile; //$row->phone; $receiver = $_REQUEST['phone']; echo "Message Sending......"; $subj = $_REQUEST['tid']; $smsg = $subj . " AS처리 되었습니다."; // MySQL 서버 SMS DB 접속 $smsconn = mysql_connect('175.207.12.215:3306', 'bumin', 'qnals_ab5228') or die("접속불가"); $smsdb = mysql_select_db('bmwp_sms', $smsconn); mysql_set_charset("utf8"); //mysql_query('set names utf8'); $qry="insert into bmwp_sms.em_tran set tran_phone='".$receiver."',tran_callback='".$sender."',tran_status='1',"; if ( $_REQUEST['rsvDTime'] == "" ) $qry .= " tran_date=now(),"; else $qry .= " tran_date='" . $_REQUEST['rsvDTime'] . "',"; $qry .= " tran_msg='". $smsg ."',tran_type='4'; "; if (!mysql_query($qry)) { echo "전송이 $sum 번째 에서 종료됩니다. 에러를 확인해주세요
입력번호는 숫자만 가능합니다 "; exit(); } mysql_close($smsconn); ?>