ContextBoxArticle::OnContextBoxDelete PHP Метод

OnContextBoxDelete() публичный статический Метод

Remove the given context box articles.
public static OnContextBoxDelete ( integer $contextBoxId ) : void
$contextBoxId integer
Результат void
    public static function OnContextBoxDelete($contextBoxId)
    {
        global $g_ado_db;
        $contextBoxId = (int) $contextBoxId;
        if ($contextBoxId < 1) {
            return;
        }
        $queryStr = 'DELETE FROM context_articles' . " WHERE fk_context_id = '{$contextBoxId}'";
        $g_ado_db->Execute($queryStr);
    }

Usage Example

Пример #1
0
 /**
  * Remove the context box for the given article.
  * @param int $articleNumber
  * @return void
  */
 public static function OnArticleDelete($articleNumber)
 {
     global $g_ado_db;
     $articleNumber = (int) $articleNumber;
     if ($articleNumber < 1) {
         return;
     }
     $queryStr = 'SELECT * FROM context_boxes' . " WHERE fk_article_no = '{$articleNumber}'";
     $boxes = $g_ado_db->GetAll($queryStr);
     foreach ($boxes as $box) {
         ContextBoxArticle::OnContextBoxDelete($box['id']);
     }
     $queryStr = 'DELETE FROM context_boxes' . " WHERE fk_article_no = '{$articleNumber}'";
     $g_ado_db->Execute($queryStr);
 }