$result = $DB->query("SELECT base_uri, filename, id FROM photos".
" WHERE id=$id");
}
+ else if (isset($_REQUEST["CLOUD"]))
+ {
+ $result = $DB->query("SELECT t.name as name, count(*) as count FROM photo_tags pt ".
+ " LEFT JOIN tags t on t.id=pt.tag_id".
+ " GROUP BY t.id");
+ }
else
{
if (isset($_REQUEST["P"]))
</datalist>
</form>
Current tags:<span id="currenttags"></span>
+ <button class="next" type="button" onclick="cloud()">tag cloud</button>
</div>
<div class="pics"> </div>
load_content(page);
}
+function cloud() {
+
+ url = "<?php echo $webbase?>/getjson.php?CLOUD=1";
+
+ pics.selectAll("li").remove();
+
+ var svgelement=pics.append("li")
+ .append("svg").attr("width",400).attr("height",400);
+
+ /* update pics */
+ d3.json(url, function(json) {
+ svgelement.selectAll("text").data(json).enter().append("text")
+ .style("font-size", function(d){return Math.log(d.count+1)+"em"})
+ .text(function(d) { return d.name; })
+ .on("mouseover", function(d){ d3.select(this).style("color","red")} )
+ .on("mouseout", function(d){ d3.select(this).style("color","white")} )
+ .on("click", function(d) { document.location.href='<?php echo $webbase?>/tag/'+d.name })
+ });
+}
+
function checkbutton()
{