本文整理匯總了PHP中Bin_Query::executequery方法的典型用法代碼示例。如果您正苦於以下問題：PHP Bin_Query::executequery方法的具體用法？PHP Bin_Query::executequery怎麽用？PHP Bin_Query::executequery使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Bin_Query的用法示例。
在下文中一共展示了Bin_Query::executequery方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: addNewsletterSubscription
/**
* This function is used to insert news letter subscription
*
* .
*
* @return string
*/
function addNewsletterSubscription()
{
$email = $_POST['email'];
if ($_POST['email'] == '' || $_POST['email'] == 'Your Email') {
$output = '<div class="alert alert-error">
<button data-dismiss="alert" class="close" type="button">×</button>
' . Core_CLanguage::_(REQUIRED) . '
</div>';
return $output;
} elseif ($_POST['email'] != '') {
$query = new Bin_Query();
$sql = 'select count(*) as count from newsletter_subscription_table where email="' . $email . '"';
$query->executequery($sql);
if ($query->records[0]['count'] > 0) {
$output = '<div class="alert alert-info">
<button data-dismiss="alert" class="close" type="button">×</button>
' . Core_CLanguage::_(SCBSCRIBE_NEWS_LETTER_ALREADY_EMAIL_EXISTS) . '
</div>';
return $output;
}
$checkemail = Core_CUserRegistration::validateEmailAddress($email);
if ($checkemail) {
$sql = "insert into newsletter_subscription_table(email,status) values('" . $email . "',1)";
if ($query->updateQuery($sql)) {
$output = '<div class="alert alert-success">
<button data-dismiss="alert" class="close" type="button">×</button>
' . Core_CLanguage::_(YOUR_REQUEST_FOR_NEWLETTER_ADDED) . '
</div>';
return $output;
} else {
$output = '<div class="alert alert-error">
<button data-dismiss="alert" class="close" type="button">×</button>
' . Core_CLanguage::_(INVALID_EMAIL_FOR_NEWSLETTER) . '
</div>';
return $output;
}
} elseif (!$checkemail) {
$output = '<div class="alert alert-error">
<button data-dismiss="alert" class="close" type="button">×</button>
' . Core_CLanguage::_(INVALID_EMAIL_FOR_NEWSLETTER) . '
</div>';
return $output;
}
}
}