function get_table_string($field_name, $search_para_str, $que_no, $analytic_array)
{
    global $analytic_array;
    $sql_query_q = 'select ' . $field_name . ', count(*) from feedback_master where (' . $search_para_str . ') group by ' . $field_name . ' order by ' . $field_name;
    $res = mysql_query($sql_query_q) or die(mysql_error('sql error'));
    $data_array = array();
    while ($myrow = mysql_fetch_array($res)) {
        // $myrow["ans5"] = rating
        // $myrow[1] = student count
        $data_array[$myrow[$field_name]] = $myrow[1];
    }
    $que_table_string_new .= '<tr><td align="center">' . que_one_word($que_no) . '</td>';
    for ($i = 0; $i < 10; $i++) {
        $val = $data_array[$i] ? $data_array[$i] : 0;
        $que_table_string_new .= '<td align="center">' . $val . '</td>';
        $analytic_array[$i] += $val;
    }
    $que_table_string_new .= '</tr>';
    return $que_table_string_new;
}
Exemplo n.º 2
0
    ?>
'], [5, '<?php 
    echo que_one_word(5);
    ?>
'],
										[6, '<?php 
    echo que_one_word(6);
    ?>
'], [7, '<?php 
    echo que_one_word(7);
    ?>
'], [8, '<?php 
    echo que_one_word(8);
    ?>
'], [9, '<?php 
    echo que_one_word(9);
    ?>
']] },
										
						bars: { show: true, align:"center" },
						grid: { hoverable: true, clickable: true, xaxis: false },
					}
			
					  $.plot($("#placeholder"), [{data: myData}], Options);
				
				});
				</script>
				<table>
					<tr>
						<td>Batch : <?php 
    echo $batch_name;