/** 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>"; }