本文整理汇总了PHP中DBUtil::getLastInsertedIdOfPrepatedQuery方法的典型用法代码示例。如果您正苦于以下问题:PHP DBUtil::getLastInsertedIdOfPrepatedQuery方法的具体用法?PHP DBUtil::getLastInsertedIdOfPrepatedQuery怎么用?PHP DBUtil::getLastInsertedIdOfPrepatedQuery使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DBUtil
的用法示例。
在下文中一共展示了DBUtil::getLastInsertedIdOfPrepatedQuery方法的14个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: putProperty
public static function putProperty($key, $value)
{
$cnt = self::getCountPropertyValue($key);
if (0 == cnt) {
$query = "UPDATE `sys_properties` SET `value`=? WHERE `name`=?";
} else {
$query = "INSERT INTO `sys_properties` (`value`, `name`) VALUES (?, ?)";
}
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "ss", $value, $key);
}
示例2: deleteImgAlbumByID
public static function deleteImgAlbumByID($imgAlbumID, $withPictures)
{
$query = "DELETE FROM `img_album` WHERE `id` = ?";
if ($withPictures) {
$pict_query = "DELETE FROM `img_picture` WHERE `album_id` = ?";
} else {
$pict_query = "UPDATE `img_picture` SET `album_id` = NULL WHERE `album_id` = ?";
}
DBUtil::getLastInsertedIdOfPrepatedQuery($pict_query, "i", $imgAlbumID);
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "i", $imgAlbumID);
}
示例3: deleteSysStaticPageById
public static function deleteSysStaticPageById($sysStaticPageId)
{
$query = "DELETE FROM `sys_static_pages` WHERE `id` = ?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "i", $sysStaticPageId);
}
示例4: setSendedOrder
public static function setSendedOrder($order_id)
{
$query = "UPDATE `order` SET `sended`=1 WHERE `id`=?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "i", $order_id);
}
示例5: deleteImgBlogArtById
public static function deleteImgBlogArtById($imgBlogArtId)
{
$queryBlock = "DELETE FROM `img_blog_art_block` WHERE `img_blog_art_id` = ?";
DBUtil::getLastInsertedIdOfPrepatedQuery($queryBlock, "i", $imgBlogArtId);
$queryArt = "DELETE FROM `img_blog_art` WHERE `id` = ?";
DBUtil::getLastInsertedIdOfPrepatedQuery($queryArt, "i", $imgBlogArtId);
}
示例6: deleteGDSById
public static function deleteGDSById($imgGdsId)
{
$query = "DELETE FROM `img_gds` WHERE `id` = ?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "i", $imgGdsId);
}
示例7: deleteSysNewsCatById
public static function deleteSysNewsCatById($sysNewsCatId)
{
$query = "DELETE FROM `sys_news_cat` WHERE `id` = ?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "i", $sysNewsCatId);
}
示例8: deleteImgAddressById
public static function deleteImgAddressById($imgAddressId)
{
$query = "DELETE FROM `img_address` WHERE `id` = ?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "i", $imgAddressId);
}
示例9: deleteImgBlogCatById
public static function deleteImgBlogCatById($imgBlogCatId)
{
$query = "DELETE FROM `img_blog_cat` WHERE `id` = ?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "i", $imgBlogCatId);
}
示例10: deleteImgPictureById
public static function deleteImgPictureById($imgPictureId)
{
$query = "DELETE FROM `img_picture` WHERE `id` = ?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "i", $imgPictureId);
}
示例11: insertOrderGds
public static function insertOrderGds($order_gds)
{
$query = "INSERT INTO `order_gds` (`order_id`, `img_gds_id`, `count_gds`) VALUES (?, ?, ?)";
return DBUtil::getLastInsertedIdOfPrepatedQuery($query, "iii", $order_gds['order_id'], $order_gds['img_gds_id'], $order_gds['count_gds']);
}
示例12: deleteSysNewsArtBlocksByNewsArtId
public static function deleteSysNewsArtBlocksByNewsArtId($sysNewsArtId)
{
$query = "DELETE FROM `sys_news_art_block` WHERE `sys_news_art_id` = ?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "i", $sysNewsArtId);
}
示例13: updateOrderAccountRelation
public static function updateOrderAccountRelation($orderID, $accountID, $sended)
{
$query = "UPDATE `order_account_sended` SET `sended`=? WHERE `order_id`=? AND `img_account_id`=?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "iii", $sended, $orderID, $accountID);
}
示例14: updateSysAdmin
public static function updateSysAdmin($sysAdmin)
{
$query = "UPDATE `sys_admins` SET `login`=?, `password`=?, `lastuuid`=? WHERE `id`=?";
DBUtil::getLastInsertedIdOfPrepatedQuery($query, "sssi", $sysAdmin['login'], $sysAdmin['password'], $sysAdmin['lastuuid'], $sysAdmin['id']);
}