ArticleImage::GetArticlesThatUseImage PHP Method

    public static function GetArticlesThatUseImage($p_imageId)
    {
        global $g_ado_db;
        $article = new Article();
        $columnNames = $article->getColumnNames();
        $columnQuery = array();
        foreach ($columnNames as $columnName) {
            $columnQuery[] = 'Articles.' . $columnName;
        }
        $columnQuery = implode(',', $columnQuery);
        $queryStr = 'SELECT ' . $columnQuery . ' FROM Articles, ArticleImages ' . ' WHERE ArticleImages.IdImage=' . $p_imageId . ' AND ArticleImages.NrArticle=Articles.Number' . ' ORDER BY Articles.Number, Articles.IdLanguage';
        $rows = $g_ado_db->GetAll($queryStr);
        $articles = array();
        if (is_array($rows)) {
            foreach ($rows as $row) {
                $tmpArticle = new Article();
                $tmpArticle->fetch($row);
                $articles[] = $tmpArticle;
            }
        }
        return $articles;
    }

<?php
camp_load_translation_strings("media_archive");
require_once($GLOBALS['g_campsiteDir'].'/classes/Input.php');
require_once($GLOBALS['g_campsiteDir'].'/classes/Article.php');
require_once($GLOBALS['g_campsiteDir'].'/classes/Image.php');
require_once($GLOBALS['g_campsiteDir'].'/classes/ImageSearch.php');
require_once($GLOBALS['g_campsiteDir'].'/classes/Log.php');

$f_image_id = Input::Get('f_image_id', 'int', 0);

if (!Input::IsValid()) {
	camp_html_goto_page("/$ADMIN/media-archive/index.php");
}
$imageObj = new Image($f_image_id);
$articles = ArticleImage::GetArticlesThatUseImage($f_image_id);

$crumbs = array();
$crumbs[] = array(getGS("Content"), "");
$crumbs[] = array(getGS("Media Archive"), "/$ADMIN/media-archive/index.php");
if ($g_user->hasPermission('ChangeImage')) {
	$crumbs[] = array(getGS('Change image information'), "");
}
else {
	$crumbs[] = array(getGS('View image'), "");
}
$breadcrumbs = camp_html_breadcrumbs($crumbs);

include_once($GLOBALS['g_campsiteDir']."/$ADMIN_DIR/javascript_common.php");

echo $breadcrumbs;