PHP StringHelper::massiveSpecialChars方法代码示例

 public static function updateSysStaticPage($sysStaticPage)
 {
     $query = "UPDATE `sys_static_pages` SET `name` = ?,  `title` = ? WHERE `id` = ?";
     StringHelper::massiveSpecialChars($sysStaticPage, ENT_QUOTES);
     DBUtil::getLastInsertedIdOfPrepatedQuery($query, "ssi", $sysStaticPage['name'], $sysStaticPage['title'], $sysStaticPage['id']);
 }

 public static function updateImgBlogArt($imgBlogArt)
 {
     $query = "UPDATE `img_blog_art` SET `img_blog_cat_id` = ?,  `name` = ?,  `creation_date` = NOW(),  `main_pict_id` = ?,  `preview` = ? WHERE `id` = ?";
     StringHelper::massiveSpecialChars($imgBlogArt, ENT_QUOTES);
     return DBUtil::getLastInsertedIdOfPrepatedQuery($query, "isisi", $imgBlogArt['img_blog_cat_id'], $imgBlogArt['name'], $imgBlogArt['main_pict_id'], $imgBlogArt['preview'], $imgBlogArt['id']);
 }

 public static function insertOrder($order)
 {
     $query = "INSERT INTO `order` (`u_email`, `u_name`, `u_phone`, `u_comment`) VALUES (?, ?, ?, ?)";
     StringHelper::massiveSpecialChars($order, ENT_QUOTES);
     return DBUtil::getLastInsertedIdOfPrepatedQuery($query, "ssss", $order['u_email'], $order['u_name'], $order['u_phone'], $order['u_comment']);
 }

 public static function updateSysNewsCat($sysNewsCat)
 {
     $query = "UPDATE `sys_news_cat` SET  `name` = ?,  `pid` = ? WHERE `id` = ?";
     StringHelper::massiveSpecialChars($sysNewsCat, ENT_QUOTES);
     DBUtil::getLastInsertedIdOfPrepatedQuery($query, "sii", $sysNewsCat['name'], $sysNewsCat['pid'], $sysNewsCat['id']);
 }

 public static function updateGDS($imgGds)
 {
     $query = "UPDATE `img_gds` SET `UUID`=?, `name`=?, `price`=?, `currency_id`=?, `main_pict_id`=?, \n                    `first_pict_id`=?, `second_pict_id`=?, `third_pict_id`=?, `img_account_id`=?, `img_gds_cat_id`=?, \n                    `in_stock`=?, `is_new`=?, `is_recommended`=?, `descr`=?  WHERE `id`=?";
     StringHelper::massiveSpecialChars($imgGds, ENT_QUOTES);
     DBUtil::getLastInsertedIdOfPrepatedQuery($query, "ssiiiiiiiiiiisi", $imgGds['UUID'], $imgGds['name'], $imgGds['price'], $imgGds['currency_id'], $imgGds['main_pict_id'], $imgGds['first_pict_id'], $imgGds['second_pict_id'], $imgGds['third_pict_id'], $imgGds['img_account_id'], $imgGds['img_gds_cat_id'], $imgGds['in_stock'], $imgGds['is_new'], $imgGds['is_recommended'], $imgGds['descr'], $imgGds['id']);
 }

 public static function updateImgAlbum($imgAlbum)
 {
     $query = "UPDATE `img_album` SET `account_id` = ?, `name` = ?, `description` = ? WHERE `id` = ?";
     StringHelper::massiveSpecialChars($imgAlbum, ENT_QUOTES);
     DBUtil::getLastInsertedIdOfPrepatedQuery($query, "issi", $imgAlbum['account_id'], $imgAlbum['name'], $imgAlbum['description'], $imgAlbum['id']);
 }

 public static function updateImgAddress($imgAddress)
 {
     $query = "UPDATE `img_address` SET `region_id` = ?, `sity` = ?, `street` = ?, `house` = ? WHERE `id` = ?";
     StringHelper::massiveSpecialChars($imgAddress, ENT_QUOTES);
     DBUtil::getLastInsertedIdOfPrepatedQuery($query, "isssi", $imgAddress['region_id'], $imgAddress['sity'], $imgAddress['street'], $imgAddress['house'], $imgAddress['id']);
 }

 public static function createImgPicture($imgPicture)
 {
     $query = "INSERT INTO `img_picture` (`account_id`, `album_id`, `name`, `path`) VALUES (?, ?, ?, ?)";
     StringHelper::massiveSpecialChars($imgPicture, ENT_QUOTES);
     return DBUtil::getLastInsertedIdOfPrepatedQuery($query, "iiss", $imgPicture['account_id'], $imgPicture['album_id'], $imgPicture['name'], $imgPicture['path']);
 }

 public static function updateSysNewsArtBlock($sysNewsArtBlock)
 {
     $query = "UPDATE `sys_news_art_block` SET `sys_news_art_id` = ?, `image_id` = ?, `image_title` = ?, `text_content` = ?, `block_type` = ?, `order_in_art` = ? WHERE `id` = ?";
     StringHelper::massiveSpecialChars($sysNewsArtBlock, ENT_QUOTES);
     DBUtil::getLastInsertedIdOfPrepatedQuery($query, "iissiii", $sysNewsArtBlock['sys_news_art_id'], $sysNewsArtBlock['image_id'], $sysNewsArtBlock['image_title'], $sysNewsArtBlock['text_content'], $sysNewsArtBlock['block_type'], $sysNewsArtBlock['order_in_art'], $sysNewsArtBlock['id']);
 }

 public static function updateImgBlogArtBlock($imgBlogArtBlock)
 {
     $query = "UPDATE `img_blog_art_block` SET `img_blog_art_id` = ?, `block_type` = ?, `text_content` = ?, `img_picture_id` = ?, `pict_desc` = ?, `order_in_art` = ? WHERE `id` = ?";
     StringHelper::massiveSpecialChars($imgBlogArtBlock, ENT_QUOTES);
     DBUtil::getLastInsertedIdOfPrepatedQuery($query, "iisisii", $imgBlogArtBlock['img_blog_art_id'], $imgBlogArtBlock['block_type'], $imgBlogArtBlock['text_content'], $imgBlogArtBlock['img_picture_id'], $imgBlogArtBlock['pict_desc'], $imgBlogArtBlock['order_in_art'], $imgBlogArtBlock['id']);
 }

 public static function updateSysNewsArt($sysNewsArt)
 {
     $query = "UPDATE `sys_news_art` SET `sys_news_cat_id` = ?,  `title` = ?,  `preview` = ?,  `main_pict_id` = ? WHERE `id` = ?";
     StringHelper::massiveSpecialChars($sysNewsArt, ENT_QUOTES);
     DBUtil::getLastInsertedIdOfPrepatedQuery($query, "issii", $sysNewsArt['sys_news_cat_id'], $sysNewsArt['title'], $sysNewsArt['preview'], $sysNewsArt['main_pict_id'], $sysNewsArt['id']);
 }

 public static function updateImgAccount($imgAccount)
 {
     $query = "UPDATE `img_account` SET `email` = ?,  `hashpass` = ?,  `show_email` = ?,  `check_code` = ?,  `active` = ?,  \n            `cookie_code` = ?,  `img_name` = ?,  `img_slog` = ?,  `img_phone` = ?,  `show_phone` = ?,  `img_skype` = ?,  \n            `show_skype` = ?,  `img_icq` = ?,  `show_icq` = ?,  `img_address_id` = ?,  `show_address` = ? WHERE `id` = ?";
     StringHelper::massiveSpecialChars($imgAccount, ENT_QUOTES);
     DBUtil::getLastInsertedIdOfPrepatedQuery($query, "ssisissssisisiiii", $imgAccount['email'], $imgAccount['hashpass'], $imgAccount['show_email'], $imgAccount['check_code'], $imgAccount['active'], $imgAccount['cookie_code'], $imgAccount['img_name'], $imgAccount['img_slog'], $imgAccount['img_phone'], $imgAccount['show_phone'], $imgAccount['img_skype'], $imgAccount['show_skype'], $imgAccount['img_icq'], $imgAccount['show_icq'], $imgAccount['img_address_id'], $imgAccount['show_address'], $imgAccount['id']);
 }