本文整理汇总了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;
}