Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- while($otazky = $result -> fetch_assoc()){
- $moznosti = unserialize($otazky['moznosti']);
- $moznosti_lenght = sizeof($moznosti);
- $prazdne_odpovede = array();
- for ($i=1;$i<date('n')+1;$i++){
- $query1 = "SELECT * FROM vyplnene_otazky WHERE id_otazky = '$otazky[id]' AND mesiac = '$i' AND rok = '$year'";
- $result1 = $link->query($query1) or die ($link->error);
- for($k=0;$k<$moznosti_lenght;$k++){
- $prazdne_odpovede[$k] = 0;
- }
- while($vyplnena_otazka = $result1->fetch_assoc()){
- $odpoved = $vyplnena_otazka['odpoved'];
- for($k=0;$k<$moznosti_lenght;$k++){
- if($odpoved == $moznosti[$k]){
- $prazdne_odpovede[$k]++;
- }
- }
- }
- echo "Vyplnene pole odpovedi pre mesiac ".$i." : <br>";
- for($j = 0 ; $j < $moznosti_lenght ; $j++){
- echo $moznosti[$j]." - ".$prazdne_odpovede[$j]."<br>"; ///// tu ukladat do grafu !!! otazky typu 1 moznost
- }
- echo "<br><br><br>";
- }
- echo "<br><br><br>";
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement