/** Luo HTML kysymykselle
* @param $title string
* @param $tags array
* @param $question_id integer
* @param $user_id integer
* @param $username string
* @param $was_sent_at_time string
* @param $describtion string
*/
function create_question($title, $tags, $question_id, $user_id, $username, $was_sent_at_time, $describtion)
{
// TODO include("validate_url_parameters.php");
create_question_count_box($question_id);
create_title($title, $question_id);
create_tags($tags);
create_user_info_box_question($user_id, $username, $was_sent_at_time, $describtion);
echo "</div>";
}
/** Luo HTML sivustolaajuinen tagilistam\"{a}\"{a}r\"{a}t kysymykselle
* @param $question_id integer
*/
function create_global_tag_count_box_for_a_question($question_id)
{
/* $result resource
* $tags_array_summary array
* $figure array
*/
$tags_array_summary = get_tags_for_a_question($question_id);
$dbconn = pg_connect("host=localhost port=5432 dbname=noaa user=noaa password=123");
// to get the amout of tags Globally
$result = pg_prepare($dbconn, "query_tag_amount", 'SELECT count(tag)
FROM tags
WHERE tag = $1');
echo "<div class='tags_summary'>";
echo "<p>tagged</p>";
for ($i = 0; $i < count($tags_array_summary); $i++) {
echo "<div id='one_tag_line'>";
$result = pg_execute($dbconn, "query_tag_amount", array($tags_array_summary[$i]['tag']));
$figure = pg_fetch_all($result);
for ($j = 0; $j < count($figure); $j++) {
create_tags($tags_array_summary[$i]);
echo "<span id='multiplier'> × " . $figure[$j]['count'] . "</span>";
}
echo "</div>";
}
echo "</div>";
}
/** Tee tagilista kysymykselle
* @param $question_id integer
*/
function create_tag_list($question_id)
{
/*
* $tags_array array
*/
$tags_array = get_tag_list($question_id);
echo "<div id='tag_list'>";
for ($i = 0; $i < count($tags_array); $i++) {
create_tags($tags_array[$i]);
}
echo "</div>";
}
