open(); echo("TO $to_mail[$i] FROM $from_mail MSG $msg BODY $body\n"); $sendmail->send($to_mail[$i], $from_mail, trim($msg), $body); $sendmail->close(); } /* if($id != "" && $pw != "" && $msg != "") { $dbConnPgSql = new DB_Sql; $strSqlpg = "SELECT group_seq "; $strSqlpg .= "FROM t_group "; $strSqlpg .= "WHERE group_id = '".$id."' AND group_password = '".$pw."' AND deleted_yn = 'N'"; $dbConnPgSql->query($strSqlpg); if($dbConnPgSql->nf() == 1) { $dbConnPgSql->next_record(); $group_seq = $dbConnPgSql->f("group_seq"); if($group_seq != "") { $strSqlpg = "SELECT member_cellphone "; $strSqlpg .= "FROM t_group_member "; $strSqlpg .= "WHERE group_seq = ".$group_seq; //$strSqlpg .= " AND member_cellphone='0117454849'"; //$strSqlpg .= "LIMIT 1 "; //echo $strSqlpg."
"; $dbConnPgSql->query($strSqlpg); //echo $dbConnPgSql->nf()."
"; if($dbConnPgSql->nf() != 0) { $tmpSqlmy = ""; $tmpSqlpg = ""; //echo "1"."
"; $dbConnMySql = new dbconnect('211.39.134.109', 'sh_trans', 'sh_trans', 'midc', __FILE__, __LINE__); //echo "2"; while($dbConnPgSql->next_record()) { $cellphone = $dbConnPgSql->f("member_cellphone"); $tmpSqlmy = "INSERT INTO sms(id, dstaddr, msg, deliver) "; $tmpSqlmy .= "VALUES ('SH_".$id."', '".$cellphone."', '".$msg."', 9)"; //echo "$tmpSqlmy"; $dbConnMySql->query($tmpSqlmy,__FILE__, __LINE__); $tmpSqlpg .= "INSERT INTO t_sms_log (group_seq, sms_id, sms_cellphone, sms_message, reg_datetime, update_datetime) "; $tmpSqlpg .= "VALUES (".$group_seq.", 'SH_".$id."', '".$cellphone."', '".$msg."', now(), now()); "; } $dbConnPgSql->query($tmpSqlpg); } //echo "3"; } } } */ ?>