PHP DBUtil::getResultRowsOfPrepatedQuery方法代码示例

 public static function getImgAddressById($id)
 {
     $query = "SELECT ia.id, r.id AS region_id, r.code AS rcode, r.name AS rname, ia.sity, ia.street, ia.house \n\t\t\tFROM img_address AS ia \n\t\t\tJOIN addr_region AS r on ia.region_id = r.id\n\t\t\tWHERE ia.id = ?";
     $imgAddreses = DBUtil::getResultRowsOfPrepatedQuery($query, "i", $id);
     return $imgAddreses[0];
 }

 public static function getSysNewsCatByID($sysNewsCatID)
 {
     $query = "SELECT  `id`,  `name`,  `pid`  FROM `sys_news_cat` WHERE `id` = ?";
     $sysNewsCats = DBUtil::getResultRowsOfPrepatedQuery($query, "i", $sysNewsCatID);
     return $sysNewsCats[0];
 }

 public static function getImgBlogCatsByAccountId($account_id)
 {
     $query = "SELECT  `id`, `account_id`, `name`,  `pid` FROM `img_blog_cat` WHERE `account_id` = ?";
     $imgBlogCats = DBUtil::getResultRowsOfPrepatedQuery($query, "i", $account_id);
     return $imgBlogCats;
 }

 public static function getImgCurrencies()
 {
     $query = "SELECT  `id`,  `name`,  `weight` FROM  `img_currency`";
     $imgCurrencies = DBUtil::getResultRowsOfPrepatedQuery($query);
     return $imgCurrencies;
 }

 public static function getOrderById($orderID, $accountID)
 {
     $query = "SELECT  o.id,  o.u_email, o.u_name, o.u_phone, o.u_comment,  o.c_date , oacc.sended\n                    FROM `order` as o\n                    JOIN order_account_sended as oacc ON oacc.order_id = o.id\n                    WHERE o.`id` = ? AND oacc.img_account_id = ?";
     $orders = DBUtil::getResultRowsOfPrepatedQuery($query, "ii", $orderID, $accountID);
     return $orders[0];
 }

 public static function getSysNewsArtsByFilter($sys_news_cat_id, $ptile, $start, $lenght)
 {
     $query = "SELECT `id`,  `sys_news_cat_id`,  `title`,  `preview`,  `c_date`,  `main_pict_id`\n\t\t\tFROM `sys_news_art` WHERE 1 = 1 ";
     $ptile = trim($ptile);
     if (NULL != $sys_news_cat_id) {
         $query .= "AND `sys_news_cat_id` = ? ";
     }
     if (0 != strcmp("", $ptile)) {
         $query .= "AND upper(`title`) LIKE upper(?) ";
     }
     $query .= "ORDER BY `c_date` DESC LIMIT ?, ?";
     if (NULL != $sys_news_cat_id && 0 != strcmp("", $ptile)) {
         $ptile = "%" . $ptile . "%";
         $sysNewsArts = DBUtil::getResultRowsOfPrepatedQuery($query, "isii", $sys_news_cat_id, $ptile, $start, $lenght);
     } else {
         if (NULL != $sys_news_cat_id) {
             $sysNewsArts = DBUtil::getResultRowsOfPrepatedQuery($query, "iii", $sys_news_cat_id, $start, $lenght);
         } else {
             if (0 != strcmp("", $ptile)) {
                 $ptile = "%" . $ptile . "%";
                 $sysNewsArts = DBUtil::getResultRowsOfPrepatedQuery($query, "sii", $ptile, $start, $lenght);
             } else {
                 $sysNewsArts = DBUtil::getResultRowsOfPrepatedQuery($query, "ii", $start, $lenght);
             }
         }
     }
     return $sysNewsArts;
 }

 private static function findImgGdsCatIdByProductId($account_id, $productId)
 {
     $query = "SELECT  igc.id as id FROM img_gds_cat igc JOIN img_gds ig ON igc.id = ig.img_gds_cat_id \n\t\tWHERE igc.account_id = ? AND ig.id = ?";
     $imgGdsCatIds = DBUtil::getResultRowsOfPrepatedQuery($query, "ii", $account_id, $productId);
     return $imgGdsCatIds[0]['id'];
 }

 public static function getPropertyValue($key)
 {
     $query = "SELECT `value` FROM `sys_properties` WHERE `name` = ?";
     $props = DBUtil::getResultRowsOfPrepatedQuery($query, "s", $key);
     return $props[0]['value'];
 }

 public static function getImgBlogArtBlocksByArtId($artId)
 {
     $query = "SELECT  `id`,  `img_blog_art_id`,  `block_type`,  `text_content`,  \n            `img_picture_id`,  `pict_desc`,  `order_in_art` \n            FROM `img_blog_art_block`\n            WHERE `img_blog_art_id` = ? ORDER BY `order_in_art` ASC";
     $imgBlogArtBlocks = DBUtil::getResultRowsOfPrepatedQuery($query, "i", $artId);
     return $imgBlogArtBlocks;
 }

 public static function getOrderAccsToMailMessage($orderID)
 {
     $query = "select DISTINCT o.id as oid, iacc.id as accid, iacc.email as accemail, o.u_email as oemail from img_gds as igds \n                    join img_account iacc on igds.img_account_id = iacc.id\n                    join order_gds ogds on ogds.img_gds_id = igds.id\n                    join `order` o on ogds.order_id = o.id\n                    where o.id = ?";
     $orderAccs = DBUtil::getResultRowsOfPrepatedQuery($query, "i", $orderID);
     return $orderAccs;
 }

 public static function getSysStaticPageBlocksByPageId($pageId)
 {
     $query = "SELECT  `id`,  `sys_static_page_id`,  `block_type_id`,  `image_id`,  `image_title`,  `text_content`,  `order_in_page`  FROM  `sys_static_page_blocks` WHERE `sys_static_page_id` = ? ORDER BY `order_in_page` ASC";
     $sysStaticPageBlocks = DBUtil::getResultRowsOfPrepatedQuery($query, "i", $pageId);
     return $sysStaticPageBlocks;
 }

 public static function getImgGdsProps($imgGdsId)
 {
     $query = "SELECT  `id`,  `img_gds_id`,  `name`,  `value` FROM `img_gds_prop` WHERE `img_gds_id` = ?";
     $imgGdsProps = DBUtil::getResultRowsOfPrepatedQuery($query, "i", $imgGdsId);
     return $imgGdsProps;
 }

 public static function getSysAdminByLastUUID($lastUUID)
 {
     $query = "SELECT  `id`,  `login`,  `password`,  `lastuuid` FROM `sys_admins` WHERE `lastuuid` LIKE ?";
     $sysAdmins = DBUtil::getResultRowsOfPrepatedQuery($query, "s", $lastUUID);
     return $sysAdmins[0];
 }

 public static function getImgGdssForOrder($accountID, $orderID)
 {
     $query = "select igds.id, igds.name, igds.UUID, igds.main_pict_id, igds.price, \n                ic.name as price_name, ogds.count_gds from img_gds igds\n                    join order_gds ogds on igds.id = ogds.img_gds_id\n                    join `order` o on o.id = ogds.order_id\n                    join img_currency ic on ic.id = igds.currency_id\n                where o.id = ? and igds.img_account_id = ?";
     $imgGdss = DBUtil::getResultRowsOfPrepatedQuery($query, "ii", $orderID, $accountID);
     return $imgGdss;
 }

 public static function getSysNewsArtBlockById($sysNewsArtId)
 {
     $query = "SELECT  `id`,  `sys_news_art_id`,  `image_id`,  `image_title`,  `text_content`,  `block_type`,  `order_in_art` FROM `sys_news_art_block` WHERE `id` = ? ";
     $sysNewsArtBlocks = DBUtil::getResultRowsOfPrepatedQuery($query, "i", $sysNewsArtId);
     return $sysNewsArtBlocks[0];
 }