Online PHP editor | perf for 60LkG

@ 2016-01-07T18:18:05Z

<?php   
######## NACITANIE DB ################################################################################
if ($str==1) $str_start=0;  else $str_start=($str*$strankovanie)-$strankovanie;


$_REQUEST["refresh"]="y"; //ak je profil a nieje strana tak refresh=y    


//zoradenie fotografii 0-cas pridania 1-hodnotenie 2-komentare
if ($order==0) $order_by='date';
if ($order==1) $order_by='pocet_hodnotenie';
if ($order==2) $order_by='pocet_koment';
$smer_text="DESC";


######## NACITANIE DB ################################################################################
$hodnotene_foto=array();
$hodnotene_cesta=array();
$pocet_komentovarray=array();
$pocet_hodnoteniearray=array();
$oblubenearray=array();  

if (isset($_REQUEST["refresh"]) ) $refresh=$_REQUEST["refresh"]; else $refresh='n';


$sql ="SELECT fotoalbum.*,
(SELECT user FROM users WHERE users.ID_user=fotoalbum.user_id) AS user,
(SELECT meno FROM users WHERE users.ID_user=fotoalbum.user_id) AS meno,
(SELECT priezvisko FROM users WHERE users.ID_user=fotoalbum.user_id) AS priezvisko,
(SELECT COUNT(*) FROM fotoalbum WHERE style LIKE '%".$kat."') AS count,
(SELECT COUNT(komentar) FROM komentare WHERE komentare.predmet='koment-foto' AND fotoalbum.ID_fotky=komentare.id_predmet ) AS pocet_koment,
(SELECT SUM(znamka) FROM hodnotenie WHERE fotoalbum.ID_fotky=hodnotenie.foto_id ) AS pocet_hodnotenie,
(SELECT oblubene.id_polozky FROM oblubene WHERE oblubene.id_polozky=fotoalbum.ID_fotky AND kategoria='foto-galeria' AND uzivatel='".$user_id."') AS oblubene
FROM fotoalbum 
WHERE fotoalbum.style LIKE '%".$kat."' ".$profilfoto."
GROUP BY fotoalbum.ID_fotky ORDER BY ".$order_by." ".$smer_text;

//echo $sql;
$result_fotoalbum=mysqli_query($con,$sql);
if (mysqli_num_rows($result_fotoalbum)){ 
    while ($row_fotoalbum=mysqli_fetch_assoc($result_fotoalbum))
        { 
        ##### ARRAY FOTOGRAFIE
        $pocet_komentovarray[]=intval($row_fotoalbum['pocet_koment']); 
        $pocet_hodnoteniearray[]=intval($row_fotoalbum['pocet_hodnotenie']);
        $oblubenearray[]=intval($row_fotoalbum['oblubene']);         
        $hodnotene_foto[]=$row_fotoalbum['ID_fotky'];
        $hodnotene_cesta[]=$row_fotoalbum['foto_id'];
        $hodnotene_name[]=$row_fotoalbum['foto_name'];
        $hodnotene_style[]=$row_fotoalbum['style'];
        $hodnotene_foto_name[]=$row_fotoalbum['foto_name']; 
        
        if ($galeria=='profil') $seria=$row_fotoalbum['seria'];
        
        $hodnotene_spolupraca[]=$row_fotoalbum['spolupracovali'];
        
        $hodnotene_under18[]=$row_fotoalbum['under18'];
        
        $nick_pridal=$row_fotoalbum['user'];
        $meno_pridal=$row_fotoalbum["meno"]." ".$row_fotoalbum["priezvisko"];
        if ($meno_pridal!=" ") $meno_pridal=$nick_pridal." (".$meno_pridal.")";
        $hodnotene_menopridal[]=$meno_pridal;
        } 
        
                 
mysqli_free_result($result_fotoalbum) ;
}
      
########################################################################################################



################# STRANKOVANIE        
$count=count($hodnotene_foto);    
if ($count > $strankovanie) $pages= ceil($count/$strankovanie);  else $pages=1;    
$str_end= $str*$strankovanie;
if ($str_end > $count) $str_end=$count;


?>
<div class="frame-full" >
    <div class="perc50 left" style="margin-top:6px;"><?php  echo $tabulkyusersarray[6].' '.($str_start+1).' - '.$str_end.' ('.$tabulkyusersarray[7].' '.$count.')';?></div>  
    <div class="perc50 right" ><div id="pages" style=""><?php  echo strankovanie($ciel,$str, $pages, $count, $strankovanie,10);?></div></div>
</div>
<?php 


#################
$pocet_strip=$str_start+$strankovanie; //pocet foto v jednom stripe
//$key=array_search($id_hodnotenej, $hodnotene_foto); //poradie fotky v array

for ($i=$str_start;$i<$pocet_strip;$i++)
    {  
    if (isset($hodnotene_foto[$i])){    
        
    $pocet_komentov=$pocet_komentovarray[$i];
    $pocet_hodnotenie=$pocet_hodnoteniearray[$i];
    $oblubene=$oblubenearray[$i]; 
    $id_fotky_strip=$hodnotene_foto[$i];
    $foto_id_strip=$hodnotene_cesta[$i];
    $meno_pridal=$hodnotene_menopridal[$i];
    $under18=$hodnotene_under18[$i];
    $foto_name=$hodnotene_foto_name[$i];
    
    
        $foto_name=$hodnotene_name[$i]; 
        $style=$hodnotene_style[$i];
        $spolupraca=$hodnotene_spolupraca[$i];   
       
     


    $sirka=15; $margin="0 5px"; $font="1em"; $width="";
        

           
    if ($pocet_hodnotenie!=0) $img_znamka="<div style='float:left;cursor:help;'><img style='float:left;margin:$margin;' src='".$static."images/others_ico/body.png' border='0' $width alt='z' title='$upload_array[10]'/><div style='float:left;font-size:$font;' title='hodnotenie'>".$pocet_hodnotenie.'</div></div>';  
        else $img_znamka=null;
    if ($pocet_komentov!=0) $img_koment="<div style='float:left;cursor:help;'><img style='float:left;margin:$margin;' src='".$static."images/others_ico/koment.png' border='0' $width alt='k' title='$upload_array[11]'/><div style='float:right;font-size:$font;' title='komentáre'>".$pocet_komentov.'</div></div>';
        else $img_koment=null;
    if ($oblubene!=0) $img_love="<div style='float:right;margin:$margin;cursor:help;'><img style='' src='".$static."images/others_ico/love-min.png' border='0' $width alt='l' title='$upload_array[12]'/></div>";
        else $img_love=null; 

    ## ZOBRAZOVANIE FOTIEK
        $format=189;
        $obrazok=fotalbum_exist($foto_id_strip); //po novom uz ma foto_id aj priponu
     ?>   
        <div class='<?php echo $perc_box;?> box_no_border shade ' style=''>
            <div style='position: relative;'>
               
                        <a class='fancybox' rel='gallery' href='<?php echo $obrazok[0];?>'  title='<?php echo $meno_pridal;?>'>
                 

                <img class="fade" src='<?php echo $obrazok[1];?>' alt='' height='' width='100%' style='' title='' />
                </a>
            </div>
            <div style='height:<?php echo $sirka;?>px;overflow:hidden;'><?php echo $img_znamka.$img_love.$img_koment;?></div>
            <?php if (($id_page==1))  { require "zobrazovanie_galerie_user.php"; }
            //if ($galeria=='galeria_profil') echo '<hr style="margin:3px auto;" /><h3 style="text-align:center;font-size:0.85em;">'.$galeriakategoriearray[$style].'</h3>';
            ?>
        </div>
    
    <?php
    }
    }

?>
<div class="frame-full" >
    <div class="perc50 left" style="margin-top:6px;"><?php  echo $tabulkyusersarray[6].' '.($str_start+1).' - '.$str_end.' ('.$tabulkyusersarray[7].' '.$count.')';?></div>  
    <div class="perc50 right" ><div id="pages" style=""><?php  echo strankovanie($ciel,$str, $pages, $count, $strankovanie,10);?></div></div>
</div>
<script type="text/javascript">
jQuery(document).keydown(function(event){    
    var key=event.which;                
            switch(key) 
                {
              case 37: 
                document.getElementById('stranka_lava').onclick() // Key left.
                break;
              case 39:
                  document.getElementById('stranka_prava').onclick() // Key right.
                  break;
                }   
});
</script>
<script type="text/javascript">
	$(".fancybox")
    .attr('rel', 'gallery')
    .fancybox({
        padding : 0
    });
</script>

Here you find the average performance (time & memory) of each version. A grayed out version indicates it didn't complete successfully (based on exit-code).

Version	System time (s)	User time (s)	Memory (MiB)
8.3.6	0.007	0.017	17.00
8.3.5	0.007	0.011	16.77
8.3.4	0.015	0.000	19.15
8.3.3	0.011	0.011	18.84
8.3.2	0.008	0.000	20.25
8.3.1	0.005	0.003	23.66
8.3.0	0.007	0.000	21.85
8.2.18	0.007	0.007	16.63
8.2.17	0.009	0.006	22.96
8.2.16	0.010	0.003	20.35
8.2.15	0.004	0.004	24.18
8.2.14	0.000	0.008	24.66
8.2.13	0.012	0.006	21.11
8.2.12	0.006	0.003	26.35
8.2.11	0.003	0.006	19.33
8.2.10	0.008	0.004	18.03
8.2.9	0.000	0.009	19.34
8.2.8	0.000	0.008	17.97
8.2.7	0.003	0.006	17.75
8.2.6	0.004	0.004	18.18
8.2.5	0.004	0.004	18.10
8.2.4	0.005	0.003	22.32
8.2.3	0.004	0.004	19.53
8.2.2	0.003	0.008	18.04
8.2.1	0.003	0.005	18.15
8.2.0	0.000	0.008	18.30
8.1.28	0.007	0.014	25.92
8.1.27	0.007	0.011	22.27
8.1.26	0.004	0.004	28.09
8.1.25	0.000	0.008	28.09
8.1.24	0.000	0.008	23.92
8.1.23	0.000	0.012	19.61
8.1.22	0.004	0.004	17.79
8.1.21	0.006	0.003	18.77
8.1.20	0.003	0.007	17.60
8.1.19	0.000	0.008	17.35
8.1.18	0.000	0.008	18.10
8.1.17	0.003	0.005	18.52
8.1.16	0.005	0.003	20.90
8.1.15	0.000	0.008	18.87
8.1.14	0.005	0.003	19.68
8.1.13	0.008	0.000	17.75
8.1.12	0.005	0.002	17.52
8.1.11	0.004	0.004	17.64
8.1.10	0.004	0.004	17.57
8.1.9	0.003	0.005	17.50
8.1.8	0.004	0.004	17.47
8.1.7	0.003	0.005	17.55
8.1.6	0.000	0.010	17.63
8.1.5	0.000	0.008	17.58
8.1.4	0.008	0.000	17.64
8.1.3	0.004	0.004	17.75
8.1.2	0.005	0.003	17.81
8.1.1	0.003	0.005	17.61
8.1.0	0.004	0.004	17.63
8.0.30	0.005	0.003	18.77
8.0.29	0.000	0.009	16.88
8.0.28	0.000	0.007	18.63
8.0.27	0.003	0.005	17.29
8.0.26	0.008	0.000	17.31
8.0.25	0.005	0.003	17.10
8.0.24	0.000	0.007	17.14
8.0.23	0.008	0.000	17.15
8.0.22	0.006	0.003	17.11
8.0.21	0.000	0.007	16.99
8.0.20	0.003	0.003	17.13
8.0.19	0.006	0.003	16.98
8.0.18	0.007	0.000	17.07
8.0.17	0.000	0.008	17.08
8.0.16	0.004	0.004	17.04
8.0.15	0.000	0.007	16.93
8.0.14	0.000	0.009	17.00
8.0.13	0.006	0.000	13.45
8.0.12	0.003	0.005	16.95
8.0.11	0.005	0.002	17.07
8.0.10	0.005	0.003	16.95
8.0.9	0.004	0.004	16.86
8.0.8	0.009	0.006	17.04
8.0.7	0.004	0.004	16.93
8.0.6	0.003	0.005	17.13
8.0.5	0.008	0.000	16.90
8.0.3	0.009	0.011	17.27
8.0.2	0.011	0.011	17.40
8.0.1	0.004	0.004	17.09
8.0.0	0.010	0.009	17.05
7.4.33	0.005	0.000	16.77
7.4.32	0.003	0.003	16.77
7.4.30	0.004	0.004	16.73
7.4.29	0.006	0.003	16.63
7.4.28	0.008	0.000	16.62
7.4.27	0.000	0.007	16.63
7.4.26	0.008	0.004	16.60
7.4.25	0.006	0.003	16.59
7.4.24	0.007	0.000	16.60
7.4.23	0.000	0.007	16.79
7.4.22	0.012	0.008	16.69
7.4.21	0.007	0.008	16.72
7.4.20	0.004	0.004	16.81
7.4.16	0.003	0.014	16.74
7.4.15	0.011	0.007	17.40
7.4.14	0.010	0.010	17.86
7.4.13	0.009	0.009	16.79
7.4.12	0.013	0.009	16.63
7.4.11	0.011	0.007	16.78
7.4.10	0.009	0.009	16.66
7.4.9	0.009	0.015	16.79
7.4.8	0.011	0.006	19.39
7.4.7	0.008	0.014	16.50
7.4.6	0.014	0.004	16.79
7.4.5	0.007	0.010	16.57
7.4.4	0.018	0.000	16.62
7.4.3	0.014	0.003	16.59
7.4.0	0.005	0.012	15.19
7.3.33	0.003	0.003	13.24
7.3.32	0.005	0.000	13.27
7.3.31	0.003	0.003	16.46
7.3.30	0.004	0.004	16.55
7.3.29	0.003	0.004	16.52
7.3.28	0.008	0.010	16.48
7.3.27	0.015	0.003	17.40
7.3.26	0.016	0.007	16.53
7.3.25	0.013	0.010	16.63
7.3.24	0.012	0.006	16.59
7.3.23	0.009	0.010	16.54
7.3.21	0.000	0.018	16.55
7.3.20	0.007	0.010	19.39
7.3.19	0.003	0.014	16.66
7.3.18	0.012	0.006	16.54
7.3.17	0.014	0.003	16.64
7.3.16	0.012	0.009	16.61
7.3.12	0.010	0.010	15.07
7.3.11	0.007	0.010	15.15
7.3.10	0.006	0.013	14.70
7.3.9	0.008	0.004	15.03
7.3.8	0.003	0.012	14.74
7.3.7	0.000	0.013	15.04
7.3.6	0.003	0.010	15.01
7.3.5	0.009	0.003	15.07
7.3.4	0.003	0.012	15.17
7.3.3	0.008	0.008	14.71
7.3.2	0.003	0.010	16.73
7.3.1	0.006	0.006	16.73
7.3.0	0.010	0.005	16.54
7.2.33	0.000	0.026	16.77
7.2.32	0.007	0.017	16.59
7.2.31	0.012	0.006	16.66
7.2.30	0.010	0.010	16.92
7.2.29	0.005	0.011	16.75
7.2.25	0.009	0.009	15.45
7.2.24	0.010	0.011	15.07
7.2.23	0.003	0.009	15.07
7.2.22	0.006	0.006	15.10
7.2.21	0.004	0.007	15.09
7.2.20	0.011	0.004	15.34
7.2.19	0.003	0.010	15.26
7.2.18	0.006	0.006	15.20
7.2.17	0.003	0.014	15.04
7.2.13	0.010	0.006	16.57
7.2.12	0.010	0.006	16.73
7.2.11	0.008	0.008	16.74
7.2.10	0.008	0.008	16.79
7.2.9	0.008	0.008	16.75
7.2.8	0.005	0.006	16.82
7.2.7	0.012	0.005	16.73
7.2.6	0.006	0.010	16.73
7.2.5	0.008	0.006	16.89
7.2.4	0.008	0.008	16.81
7.2.3	0.010	0.007	16.63
7.2.2	0.011	0.005	16.79
7.2.1	0.015	0.003	16.79
7.2.0	0.007	0.005	17.76
7.1.33	0.007	0.007	15.87
7.1.32	0.000	0.009	15.61
7.1.31	0.011	0.003	15.97
7.1.30	0.003	0.010	15.89
7.1.29	0.000	0.012	15.85
7.1.28	0.004	0.014	15.91
7.1.27	0.003	0.010	15.84
7.1.26	0.005	0.005	15.94
7.1.25	0.006	0.010	15.70
7.1.24	0.006	0.008	15.49
7.1.23	0.002	0.011	15.71
7.1.22	0.011	0.005	15.47
7.1.21	0.008	0.005	15.66
7.1.20	0.005	0.007	15.63
7.1.19	0.011	0.004	15.66
7.1.18	0.006	0.005	15.78
7.1.17	0.011	0.004	15.49
7.1.16	0.007	0.009	15.72
7.1.15	0.017	0.000	15.79
7.1.14	0.009	0.005	15.80
7.1.13	0.006	0.011	15.63
7.1.12	0.008	0.004	15.60
7.1.11	0.014	0.003	15.68
7.1.10	0.003	0.008	16.55
7.1.9	0.007	0.010	15.90
7.1.8	0.008	0.005	15.57
7.1.7	0.009	0.007	16.17
7.1.6	0.007	0.008	16.96
7.1.5	0.010	0.003	16.14
7.1.4	0.007	0.006	15.81
7.1.3	0.007	0.009	15.61
7.1.2	0.009	0.002	15.41
7.1.1	0.008	0.004	15.59
7.1.0	0.004	0.031	17.75
7.0.33	0.008	0.004	15.42
7.0.32	0.008	0.007	15.11
7.0.31	0.005	0.008	15.02
7.0.30	0.005	0.006	15.19
7.0.29	0.006	0.009	15.14
7.0.28	0.006	0.008	15.19
7.0.27	0.005	0.007	15.36
7.0.26	0.007	0.005	15.14
7.0.25	0.010	0.005	15.26
7.0.24	0.005	0.011	15.13
7.0.23	0.009	0.006	15.13
7.0.22	0.011	0.008	15.30
7.0.21	0.010	0.005	15.23
7.0.20	0.034	0.004	15.23
7.0.19	0.009	0.004	15.35
7.0.18	0.009	0.004	15.22
7.0.17	0.008	0.006	15.38
7.0.16	0.003	0.010	15.27
7.0.15	0.008	0.005	15.41
7.0.14	0.004	0.009	15.18
7.0.13	0.009	0.003	15.13
7.0.12	0.007	0.004	15.21
7.0.11	0.011	0.005	15.32
7.0.10	0.012	0.017	16.88
7.0.9	0.009	0.019	16.85
7.0.8	0.012	0.025	16.81
7.0.7	0.006	0.020	16.84
7.0.6	0.006	0.027	16.76
7.0.5	0.014	0.025	16.86
7.0.4	0.007	0.016	15.60
7.0.3	0.007	0.020	15.53
7.0.2	0.006	0.036	15.42
7.0.1	0.004	0.028	15.52
7.0.0	0.006	0.020	15.40
5.6.38	0.004	0.009	14.35
5.6.37	0.007	0.010	14.44
5.6.36	0.011	0.003	14.44
5.6.35	0.008	0.009	14.03
5.6.34	0.008	0.008	14.43
5.6.33	0.007	0.007	14.57
5.6.32	0.006	0.007	14.44
5.6.31	0.008	0.005	14.64
5.6.30	0.008	0.004	14.71
5.6.29	0.002	0.011	14.33
5.6.28	0.007	0.013	16.58
5.6.27	0.003	0.007	14.37
5.6.26	0.002	0.007	14.44
5.6.25	0.005	0.020	16.52
5.6.24	0.005	0.027	16.45
5.6.23	0.009	0.028	16.39
5.6.22	0.005	0.022	16.41
5.6.21	0.005	0.022	16.31
5.6.20	0.006	0.021	16.43
5.6.19	0.005	0.026	16.56
5.6.18	0.008	0.019	16.74
5.6.17	0.001	0.024	16.45
5.6.16	0.010	0.018	16.68
5.6.15	0.004	0.024	16.57
5.6.14	0.008	0.019	16.63
5.6.13	0.002	0.020	16.54
5.6.12	0.007	0.020	16.56
5.6.11	0.006	0.030	16.70
5.6.10	0.009	0.025	16.55
5.6.9	0.008	0.022	16.59
5.6.8	0.003	0.026	16.39
5.6.7	0.007	0.027	16.26
5.6.6	0.004	0.021	16.22
5.6.5	0.003	0.024	16.38
5.6.4	0.008	0.027	16.30
5.6.3	0.011	0.015	16.43
5.6.2	0.005	0.024	16.42
5.6.1	0.003	0.024	16.26
5.6.0	0.005	0.029	16.27
5.5.38	0.006	0.028	14.27
5.5.37	0.000	0.023	14.25
5.5.36	0.002	0.024	14.18
5.5.35	0.004	0.026	14.23
5.5.34	0.003	0.024	14.37
5.5.33	0.005	0.019	14.34
5.5.32	0.004	0.020	14.35
5.5.31	0.008	0.015	14.36
5.5.30	0.005	0.022	14.43
5.5.29	0.006	0.018	14.31
5.5.28	0.002	0.021	14.34
5.5.27	0.003	0.028	14.40
5.5.26	0.009	0.020	14.37
5.5.25	0.005	0.026	14.40
5.5.24	0.003	0.026	14.04
5.5.23	0.005	0.030	14.17
5.5.22	0.005	0.018	14.19
5.5.21	0.003	0.031	14.13
5.5.20	0.005	0.027	14.13
5.5.19	0.004	0.020	14.12
5.5.18	0.006	0.020	14.17
5.5.17	0.006	0.005	11.06
5.5.16	0.006	0.025	14.07
5.5.15	0.007	0.028	14.12
5.5.14	0.005	0.019	14.13
5.5.13	0.004	0.021	14.12
5.5.12	0.003	0.024	14.23
5.5.11	0.005	0.020	14.20
5.5.10	0.005	0.030	14.20
5.5.9	0.007	0.020	14.07
5.5.8	0.006	0.018	14.08
5.5.7	0.003	0.019	14.12
5.5.6	0.004	0.022	14.07
5.5.5	0.008	0.018	14.12
5.5.4	0.003	0.023	14.16
5.5.3	0.002	0.018	14.07
5.5.2	0.009	0.018	14.12
5.5.1	0.004	0.019	14.03
5.5.0	0.004	0.019	14.07

preferences:dark modelive preview