本文整理匯總了PHP中DbHelper::fetchRow方法的典型用法代碼示例。如果您正苦於以下問題：PHP DbHelper::fetchRow方法的具體用法？PHP DbHelper::fetchRow怎麽用？PHP DbHelper::fetchRow使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類DbHelper的用法示例。
在下文中一共展示了DbHelper::fetchRow方法的3個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: checkCouponcodeExists
public static function checkCouponcodeExists($couponcode = '', $userId = "")
{
global $tableprefix;
$currentDate = date('Y-m-d');
if (!empty($couponcode)) {
// Check email address exists in subscribers list
$query = "SELECT o.couponCode FROM " . $tableprefix . "orders o\n WHERE o.user_id = '" . mysql_real_escape_string($userId) . "' AND\n o.couponCode ='" . mysql_real_escape_string($couponcode) . "' ";
$resCat = DbHelper::execute($query);
if (mysql_num_rows($resCat) == 0) {
$query = "SELECT cc.* FROM " . $tableprefix . "couponcode cc WHERE cc.ccCode='" . mysql_real_escape_string($couponcode) . "' AND\n cc.ccStatus='Y' AND cc.subscriptionStatus='Y'\n AND cc.ccStartDate<='" . mysql_real_escape_string($currentDate) . "' AND\n cc.ccEndDate>='" . mysql_real_escape_string($currentDate) . "'";
$resCat = DbHelper::execute($query);
$data = DbHelper::fetchRow($resCat);
}
// If couopon code valid then return coupon percenatage
if ($data) {
return $data;
}
}
}示例2: getOrderTaxDetailsByOrderId
public static function getOrderTaxDetailsByOrderId($orderId = 0)
{
global $tableprefix;
$query = "SELECT ot.* FROM " . $tableprefix . "order_tax ot WHERE ot.orderid = '" . mysql_real_escape_string($orderId) . "'";
$resCat = DbHelper::execute($query);
$data = DbHelper::fetchRow($resCat);
return $data;
}示例3: getVendorFeedback
public static function getVendorFeedback($feedback_id)
{
global $tableprefix;
$sql = " SELECT f.*, a.first_name,a.last_name FROM " . $tableprefix . "artist_feedbacks f\n\t\tINNER JOIN " . $tableprefix . "artists a ON f.artist_id = a.artist_id\n WHERE f.artist_feedback_id = " . $feedback_id . "";
$result = DbHelper::execute($sql);
$feedback = DbHelper::fetchRow($result);
return $feedback;
}