Tag Information

$value) $GLOBALS[$key] = $value; } elseif (isset($_REQUEST)) { foreach($_REQUEST as $key => $value) $GLOBALS[$key] = $value; } if (!$tag) { echo ("

No tag specified!

"); exit(); } $tag = rawurldecode($tag); include_once '../index/indexingfuncs.php'; connect_to_database(); $infoSQL = $dbh->prepare("SELECT TagParagraph FROM TagDetails WHERE Tag = :tagname"); $infoSQL->bindParam(":tagname", $tag); if ($infoSQL->execute()) { $paragraph = $infoSQL->fetchColumn(); if ($paragraph != "") { echo "

".$tag." " . $paragraph . "

\n"; } $infoSQL->closeCursor(); } else { echo "

Error performing query:

";
	print_r ($infoSQL->errorInfo());
	$infoSQL->debugDumpParams();
	exit();
}



echo ("Pages with tag ".$tag.":
\n\n");

$tagSQL = $dbh->prepare("SELECT ItemID FROM Tags LEFT JOIN IndexEntry USING(`ItemID`) WHERE Tag = :tagname AND PrimaryLink = 1 ORDER BY LinkText");
$tagSQL->bindValue(":tagname", $tag);
if ($tagSQL->execute()) {
	$itemSQL = $dbh->prepare("SELECT * FROM `Item` WHERE `ItemID` = :itemid LIMIT 1");
	$itemSQL->bindParam(":itemid", $itemid);
	while ($itemid = $tagSQL->fetchColumn()) {
		if ($itemSQL->execute()) {
			$itemrow = $itemSQL->fetchAll()[0];     // Using just fetch() gave an error,
			                                        //  something to do with unfinished prepared statements --BR
			echo " " . make_item_line($itemrow) . "\n";
		} else {
			echo "Error performing query:
";
			print_r ($tagSQL->errorInfo());
			$tagSQL->debugDumpParams();
		}
	}
	echo "";
} else {
	echo "Error performing query:
";
	print_r ($tagSQL->errorInfo());
	$tagSQL->debugDumpParams();
}


?>