20,359
社区成员
发帖
与我相关
我的任务
分享
<form action="download_subscription.php" method="post" name="user_form" id="user_form">
<div class="subscription-row">
<input type="text" name="email" id="email" placeholder="E-mail"/>
</div>
<div class="subscription-row">
<input type="text" name="name" id="name" placeholder="Name"/>
</div>
<div class="subscription-button">
<input class="btn-subscription" type="submit" id="dosubmit" name="dosubmit" value="訂閱"/>
</div>
</form>
<script>
$(function(){
$('#email').focus();
var ok1=false;
var ok2=false;
var emailRegex = new RegExp(/^.*@.*$/);
$("#dosubmit").bind("click",function(){
var msgError = '';
if ($('#name').val().trim().length == 0)
{
msgError += '- 必須輸入姓名\r\n';
}else{
ok1=true;
}
if($('#email').val().trim().length == 0){
msgError += '- 必須輸入電郵\r\n';
}else{
var valid = emailRegex.test($('#email').val().trim());
if (!valid) {
msgError += '- 電郵格式不正確\r\n';
} else{
ok2=true;
}
}
if(ok1 && ok2){
$('#user_form').submit();
}else{
msgError = '以下資料必須輸入或選擇:\r\n' + msgError;
alert(msgError);
return false;
}
});
});
$language=$_SESSION['cahkorghk_language'];
$submit = Submit::getinstance();
$arrlist['email'] = $_POST['email'];
$arrlist['name'] = $_POST['name'];
$arrlist['subscribed_datetime'] = date("Y-m-d H:i:s");
$r = $submit->save($language,$arrlist);
public function save($language,$arrlist){
$email = $arrlist['email'];
$sqls = sprintf("SELECT email FROM %s_newslettersubscription WHERE email = '$email'",$this->tablepre_f);
$result = $this->db->getAll($sqls);
if(!$result){
$sql = sprintf("
insert into %s_newslettersubscription
(`name`,`email`,`subscribed_datetime`) values ('%s','%s','%s')",$this->tablepre_f, $arrlist['name'], $arrlist['email'], $arrlist['subscribed_datetime']);
$this->db->query($sql);
$id = $this->db->insertID();
if($id){
if($language == "tc"){
echo "<script>alert('訂閱成功!');history.go(-1);</script>";
}elseif($language == "en"){
echo "<script>alert('Subscribed successfully!);history.go(-1);</script>";
}
}else{
if($language == "tc"){
echo "<script>alert('訂閱失敗!');history.go(-1);</script>";
}elseif($language == "en"){
echo "<script>alert('Subscription failure!');history.go(-1);</script>";
/*echo "<script>self.location=document.referrer;</script>";*/
}
}
}else{
if($language == "tc"){
echo "<script>alert('此電郵已被登記,請重新填寫!');history.go(-1);</script>";
}elseif($language == "en"){
echo "<script>alert('This email address has been registered, please enter again!);history.go(-1);</script>";
}
}
}