PHP DbHelper::execute方法代码示例

 public static function addtoNewsLetterSubscriptionList($email = '')
 {
     global $tableprefix;
     if (!empty($email)) {
         // Check email address exists in subscribers list
         $resCat = DbHelper::execute("SELECT nId FROM " . $tableprefix . "newsletter_subscribers WHERE vEmail ='" . mysql_real_escape_string($email) . "' ");
         $data = DbHelper::fetchOne($resCat);
         // If alraedy exists return false
         if ($data) {
             $emailSubscribed = 'exists';
         } else {
             // Insert Email id to subscriberlist
             $resInsert = DbHelper::execute("INSERT INTO " . $tableprefix . "newsletter_subscribers\n                                                (vEmail)VALUES('" . mysql_real_escape_string($email) . "')");
             $constantcontactSettings = getconstantcontactSettings();
             $_SESSION['constantaction'] = 'Add Email';
             $userinfo = array();
             $userinfo['emailAddress'] = mysql_real_escape_string($email);
             $userinfo['firstName'] = '';
             $userinfo['lastName'] = '';
             $userinfo['lists'] = array($constantcontactSettings['constantcontactlistId']);
             $_SESSION['constantparam']['redirecturl'] = SITE_URL . '/checkout.php';
             //header("location:".$constantcontactSettings['verificationURL']);
             $emailSubscribed = 'added';
         }
         return $emailSubscribed;
     }
 }

 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;
         }
     }
 }

if ($_SESSION["sess_userid"] != "") {
    productViewedReport(GetSQLValueString($productid, "text"), $_SESSION["sess_userid"]);
    $USER_ID = $_SESSION["sess_userid"];
}
/* Items Bought By */
$resIB = DbHelper::execute("SELECT od.product_id,od.product_name,op.image_small,op.image_big\n            FROM " . $tableprefix . "order_details od\n                INNER JOIN " . $tableprefix . "product_options op ON od.product_option_id = op.product_option_id\n                INNER JOIN  " . $tableprefix . "products p ON p.product_id \t = op. \tproduct_id\n                    WHERE od.order_id IN (SELECT GROUP_CONCAT(DISTINCT d.order_id ORDER BY d.order_id DESC SEPARATOR ', ') FROM " . $tableprefix . "order_details d WHERE d.product_id = '" . mysql_real_escape_string($_GET['productid']) . "')\n                     AND p.deleted = 'N'   AND od.product_id != '" . $_GET['productid'] . "'  AND od.item_status IN(1, 3, 4) GROUP BY od.product_id LIMIT 0,12");
/*$resIB = DbHelper::execute("SELECT DISTINCT od.product_id,od.product_name,op.image_small,op.image_big
  FROM ".$tableprefix."order_details od
      LEFT JOIN ".$tableprefix."product_options op
          ON
          od.product_option_id = op.product_option_id LIMIT 12");*/
$IBArr = DbHelper::fetchAll($resIB);
/* Other Intrested Items Bought By */
//$resOI = DbHelper::execute("SELECT p.product_id,p.product_name,op.image_small,op.image_big FROM ".$tableprefix."products p LEFT JOIN ".$tableprefix."product_options op ON p.product_id = op.product_id WHERE p.vIntrest='Y' AND p.product_id != '".$_GET['productid']."' GROUP BY p.product_id LIMIT 0,12");
$sql_interest = "SELECT p.product_id,p.product_name,op.image_small,op.image_big FROM " . $tableprefix . "products p\n    LEFT JOIN " . $tableprefix . "product_options op ON p.product_id = op.product_id\n    INNER JOIN " . $tableprefix . "categories c ON c.category_id  = p.product_category\n        WHERE p.vIntrest='Y' AND p.product_id != '" . mysql_real_escape_string($_GET['productid']) . "'\n         AND p.deleted = 'N' AND c.vEnable='Y' GROUP BY p.product_id LIMIT 0,12";
$resOI = DbHelper::execute($sql_interest);
$OIArr = DbHelper::fetchAll($resOI);
/* display the active template */
$active_template = displayTemplate();
include "includes/htmltop.php";
/* Top File Name */
include_once "includes/" . $active_template[0];
$quantity = getWholesaleProductCount($prow["product_option_id"]);
// Check product is whole sale item or not
$eWholesaleItem = isWholesaleItem($productid);
//Check Selected Option Added to Wish List
$wishItemCount_Product = getWishItemsCount_Product($productid, $prow["product_option_id"]);
// Current Stock Available for a product
$currentStockAvailable = getCurrentStockAvailable($productid, $prow["product_option_id"]);
?>
<!--<script

 public static function getsubCategoryIds($categoryId)
 {
     global $tableprefix;
     if (!empty($categoryId)) {
         $resSet = DbHelper::execute("SELECT category_id from " . $tableprefix . "categories cat where cat.route REGEXP '^" . $categoryId . ",|,^" . $categoryId . "|," . $categoryId . ",|," . $categoryId . "\$|^" . $categoryId . "\$' ");
         $data = DbHelper::fetchAll($resSet);
         if (count($data) > 0) {
             foreach ($data as $data_value) {
                 $category_array[] = $data_value->category_id;
             }
             $categoryString = implode("','", $category_array);
         }
     }
     return $categoryString;
 }

</div>
<div class="clear"></div>

<?php 
/* Product list carousel*/
/*$productListingFee = getSettingsValue('product_listing_fee');
$sql ="SELECT p.product_id,p.product_name,po.image_small,po.image_big FROM ".$tableprefix."products p
                INNER JOIN ".$tableprefix."product_options po ON po.product_id = p.product_id AND po.default_option='YES'
                INNER JOIN ".$tableprefix."artists s ON p.product_artist_id = s.artist_id
                WHERE p.product_artist_id='".$artistid."' AND  p.vapproved = 'Y' AND s.vapproved='Y'
                    AND s.plan_expired='N'";
    if($productListingFee > 0) {
        $sql .= " AND p.payment_status='COMPLETED' ";
    }
    $sql .= " AND p.deleted !='Y'  LIMIT 0,100";

$resOV = DbHelper::execute($sql);
$OVArr = DbHelper::fetchAll($resOV);*/
$sql = "SELECT ap.* FROM " . $tableprefix . "artists a INNER JOIN " . $tableprefix . "mybusiness ap ON a.artist_id = ap.artistid  WHERE ap.artistid = '" . addslashes($artistid) . "' LIMIT 0,100";
$resOV = DbHelper::execute($sql);
$OVArr = DbHelper::fetchAll($resOV);
if (count($OVArr) > 0) {
    ?>
<div class="txtblue">Click on thumbnail for a virtual tour of our business...</div>
<?php 
    include_once BASE_URL . '/product_details_page_carousel.php';
    clsCreateCarousel::showVendorBusinessCurozileItems($OVArr);
}
?>
</div>

 public static function getVendorNamesByOrderId($orderId = 0)
 {
     global $tableprefix;
     $query = "SELECT DISTINCT CONCAT(ar.first_name ,' ', ar.last_name) as name, ar.artist_id FROM " . $tableprefix . "order_details od\n\t\t\t\t\t\tINNER JOIN  " . $tableprefix . "artists ar ON od.artist_id = ar.artist_id\n                                                WHERE od.order_id = '" . mysql_real_escape_string($orderId) . "'";
     $resCat = DbHelper::execute($query);
     $data = DbHelper::fetchAll($resCat);
     return $data;
 }

 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;
 }

                $intrestCount = $intrestArr[0]->cntInt;
                if ($intrestCount < 12) {
                    //  echo "UPDATE ".$tableprefix."products SET vIntrest='Y' WHERE product_id IN ($productStr)";
                    DbHelper::execute("UPDATE " . $tableprefix . "products SET vIntrest='Y' WHERE product_id  = '" . mysql_real_escape_string($chkProductId) . "'");
                    echo 1;
                    exit;
                    /*  foreach($prodArr as $itemProd){
                            DbHelper::execute("UPDATE ".$tableprefix."products SET vIntrest='Y' WHERE product_id=".$itemProd);
                            $msg =1;
                        }*/
                } else {
                    echo 2;
                    exit;
                }
            } else {
                DbHelper::execute("UPDATE " . $tableprefix . "products SET vIntrest='N' WHERE product_id  = '" . mysql_real_escape_string($chkProductId) . "'");
                echo 4;
                exit;
            }
        } else {
            echo 3;
            exit;
        }
    }
    echo 2;
    exit;
}
if (isset($_POST['txtProductId'])) {
    $ids = $_POST['txtProductId'];
    if (empty($ids)) {
        $message .= "Please select Products which you need to delete.<br>";

        $imageurl = "<img src='" . $portfoliodir . "noimage.jpg' width='191' height='183' border='0' >";
        $sellerProfileImageURL = $imageurl;
        $sellerProfileImage = $portfoliodir . "noimage.jpg";
    } else {
        $imageurl = "<img src='" . $portfoliodir . $txtArtistPhoto . "' border='0' width='191' height='183' >";
        $sellerProfileImageURL = $imageurl;
        $sellerProfileImage = $portfoliodir . $txtArtistPhoto;
    }
    // Seller Rating
    $sellerRes = DbHelper::execute("SELECT IFNULL(ROUND(AVG(rating),0),0) as rating FROM " . $tableprefix . "artist_feedbacks WHERE published = 'Y' AND artist_id =" . $artistid);
    $sellerRatingArr = DbHelper::fetchAll($sellerRes);
    // Total rating
    $sellerRating = $sellerRatingArr[0]->rating;
    // End Seller Rating
    // User Info
    $userInfoRes = DbHelper::execute("SELECT email,user_name FROM " . $tableprefix . "users WHERE user_id = '" . $_SESSION["sess_userid"] . "'");
    $userInfoArr = DbHelper::fetchAll($userInfoRes);
    $email_address = $userInfoArr[0]->email;
    $contact_name = $userInfoArr[0]->user_name;
    if (strstr($contact_name, 'Guest') != '') {
        $contact_name = '';
    }
    // User Info
}
/*----------Multicart 2.0 Upgradation Starts------------*/
if ($enable_seller_friendly == "Y") {
    $artist_name = $row['artist_name'];
}
/*----------Multicart 2.0 Upgradation Ends------------*/
/*display the active template*/
$active_template = displayTemplate();