Online PHP editor | perf for 5qu0C

@ 2015-11-12T16:59:49Z

<?php

/* IMPORT SPORTS CATEGORIES */
foreach ($wanted_languages as $lang) {
echo "import categories for lang=$lang\n";
 $url = "https://www.bet3000.com/".$lang."/jsonrpc/?jsonrpc=2.0&id=0&method=sportsbook.get_active_categories";
 try {
        $data = file_get_contents($url);
        $data = json_decode($data, true);

$query = "UPDATE home_categories SET active=0";
    if (!$debug) { mysql_query($query); }

        $cat_lvl_ids[0] = array("id" => 0,"label" => "");
        $prev_lvl = 0;
        $parent_id = 0;
        $index = 0;
        $flag = false;
    $sortid=0;
    foreach   ($data ['categories'] as $key => $value){
	   $sortid++;
                $cat = new Category($value);
                $lvl = $cat->get_level();
                $id = $cat->get_id();
        $active = $cat->get_activated_id();
                $cat_lvl_ids[$lvl]["id"] = $id;
                $parent_id = $cat_lvl_ids[$lvl-1]["id"];
                $parent_lbl = "";
                if(!empty($cat_lvl_ids[$lvl-1]["label"])) {
                        $parent_lbl = $cat_lvl_ids[$lvl-1]["label"]." / ";
                }
                $path = $parent_lbl . $cat->get_label();
                $cat_lvl_ids[$lvl]["label"] = $path;
                $explode = explode(" / ",$path);
                $detail = $explode[count($explode)-1];
                $sport = $explode[0];
        $qcheck="SELECT * FROM `home_categories` WHERE cid=".$id." AND lang='".$lang."'";
        $rcheck=mysql_query($qcheck);
        if (mysql_num_rows($rcheck)>0) {
            $ocheck=mysql_fetch_object($rcheck);
            $sqladd ="";
            $sqladd.= ",path='".trim(mysql_real_escape_string($path))."', detail='".trim(mysql_real_escape_string($detail))."'";
                        // UPDATE path,detail,sortid,active
                        $querynew="UPDATE home_categories SET active=".$active.",sortid=".$sortid.$sqladd." WHERE cid=".$id." AND lang='".$lang."'";
                        mysql_query($querynew);
            echo mysql_error();
                }
        else {
             $sqlheaderadd="";
             $sqladd ="";

                 $query = "INSERT IGNORE INTO `home_categories` (cid,lang,detail,path,topcatid,stufe,sport,sortid,active) VALUES (".
                                $id.", ".
                "'".$lang."', ".
                                "'".trim(mysql_real_escape_string($detail))."', ".
                                "'".trim(mysql_real_escape_string($path))."', ".
                                $parent_id.", ".
                                $lvl.", ".
                                "'".trim(mysql_real_escape_string($sport))."', ".
                $sortid.", ".
                $active.
                                ")";
         $resultInsert = mysql_query($query);
         if(!$resultInsert)
            echo mysql_error()."<br>$query";
        }
                $prev_lvl = $lvl;
        }

        //foreach($result as $v) {
        //      echo $value."<br>";
        //}
 }
 catch(Exception $e) {
         echo $e->getMessage();
 }
}
echo 'Categories added to database';

class Category {

        private $id;
        private $lvl;
        private $label;
        private $activated_id;
        private $children;

        public function __construct($cat) {
                $this->id =  $cat['id'];
                $this->lvl = $cat['level'];
                $this->label = $cat['label'];
                $this->activated_id = $cat['activated_id'];
                $this->children = array();
        }

        public function get_id() {
                return $this->id;
        }
        public function get_level() {
                return $this->lvl;
        }
        public function get_label() {
                return $this->label;
        }
        public function get_activated_id() {
                return $this->activated_id;
        }
        public function get_children() {
                return $this->children;
        }
        public function set_id($id) {
                $this->id = $id;
        }
        public function set_level($lvl) {
                $this->lvl = $lvl;
        }
        public function set_label($label) {
                $this->label = $label;
        }
        public function set_children($children) {
                $this->children = $children;
        }
        public function add_child($child) {
                $this->children[] = $child;
        }
        public function get_child($index) {
                return $this->children[$index];
        }
        public function remove_child($child,$index) {
                $this->children[] = null;
        }
        public function __toString() {
                return "Category Lvl:".$this->get_level()." - ".$this->get_id(). ":".$this->get_label();
        }
}

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.012	0.003	16.63
8.3.5	0.009	0.009	17.80
8.3.4	0.015	0.000	18.81
8.3.3	0.011	0.004	18.67
8.3.2	0.004	0.004	20.33
8.3.1	0.007	0.000	23.68
8.3.0	0.004	0.004	19.25
8.2.18	0.006	0.009	16.75
8.2.17	0.010	0.010	22.96
8.2.16	0.007	0.007	20.47
8.2.15	0.000	0.007	24.18
8.2.14	0.008	0.000	24.66
8.2.13	0.009	0.000	17.75
8.2.12	0.004	0.004	26.35
8.2.11	0.003	0.006	20.47
8.2.10	0.004	0.007	18.05
8.2.9	0.005	0.003	19.36
8.2.8	0.000	0.009	17.97
8.2.7	0.006	0.003	17.74
8.2.6	0.000	0.009	17.80
8.2.5	0.008	0.000	18.07
8.2.4	0.008	0.000	19.51
8.2.3	0.006	0.003	20.79
8.2.2	0.004	0.004	17.67
8.2.1	0.004	0.004	17.98
8.2.0	0.004	0.004	18.01
8.1.27	0.007	0.003	23.96
8.1.26	0.005	0.003	28.09
8.1.25	0.004	0.004	28.09
8.1.24	0.004	0.004	22.39
8.1.23	0.004	0.007	17.66
8.1.22	0.000	0.009	17.74
8.1.21	0.008	0.000	18.77
8.1.20	0.006	0.003	17.35
8.1.19	0.003	0.005	17.35
8.1.18	0.008	0.000	18.10
8.1.17	0.004	0.004	19.21
8.1.16	0.002	0.005	22.03
8.1.15	0.004	0.004	18.89
8.1.14	0.000	0.009	19.54
8.1.13	0.004	0.004	17.72
8.1.12	0.004	0.004	17.49
8.1.11	0.000	0.007	17.54
8.1.10	0.004	0.004	17.47
8.1.9	0.003	0.006	17.43
8.1.8	0.006	0.003	17.52
8.1.7	0.004	0.004	17.46
8.1.6	0.000	0.009	17.53
8.1.5	0.006	0.003	17.61
8.1.4	0.004	0.004	17.47
8.1.3	0.004	0.004	17.59
8.1.2	0.000	0.008	17.55
8.1.1	0.004	0.004	17.60
8.1.0	0.000	0.008	17.46
8.0.30	0.003	0.006	18.77
8.0.29	0.002	0.005	17.00
8.0.28	0.007	0.000	18.44
8.0.27	0.007	0.004	17.30
8.0.26	0.004	0.004	17.30
8.0.25	0.007	0.000	17.00
8.0.24	0.003	0.003	17.04
8.0.23	0.008	0.000	16.98
8.0.22	0.004	0.004	16.94
8.0.21	0.004	0.004	16.94
8.0.20	0.000	0.007	17.07
8.0.19	0.008	0.000	17.08
8.0.18	0.000	0.008	16.93
8.0.17	0.009	0.000	17.03
8.0.16	0.005	0.003	17.07
8.0.15	0.003	0.005	16.84
8.0.14	0.004	0.004	16.84
8.0.13	0.003	0.003	13.43
8.0.12	0.005	0.003	16.95
8.0.11	0.003	0.005	16.98
8.0.10	0.007	0.000	16.84
8.0.9	0.002	0.005	17.07
8.0.8	0.013	0.009	16.92
8.0.7	0.004	0.004	16.88
8.0.6	0.004	0.004	16.99
8.0.5	0.006	0.003	16.78
8.0.3	0.010	0.010	17.15
8.0.2	0.009	0.014	17.42
8.0.1	0.000	0.008	17.01
8.0.0	0.008	0.009	16.75
7.4.33	0.005	0.000	16.73
7.4.32	0.003	0.003	16.64
7.4.30	0.000	0.007	16.56
7.4.29	0.007	0.000	16.66
7.4.28	0.008	0.000	16.57
7.4.27	0.000	0.007	16.70
7.4.26	0.000	0.007	16.59
7.4.25	0.004	0.004	16.45
7.4.24	0.005	0.003	16.55
7.4.23	0.005	0.002	16.49
7.4.22	0.003	0.016	16.58
7.4.21	0.010	0.007	16.71
7.4.20	0.005	0.002	16.54
7.4.16	0.009	0.006	16.56
7.4.15	0.004	0.014	17.40
7.4.14	0.017	0.009	17.86
7.4.13	0.013	0.006	16.54
7.4.12	0.012	0.006	16.55
7.4.11	0.012	0.012	16.53
7.4.10	0.010	0.007	16.47
7.4.9	0.014	0.005	16.61
7.4.8	0.012	0.006	19.39
7.4.7	0.007	0.010	16.58
7.4.6	0.008	0.008	16.63
7.4.5	0.006	0.006	16.39
7.4.4	0.012	0.006	16.63
7.4.3	0.012	0.006	16.62
7.4.0	0.007	0.011	15.08
7.3.33	0.006	0.000	13.48
7.3.32	0.000	0.006	13.27
7.3.31	0.005	0.002	16.36
7.3.30	0.003	0.003	16.42
7.3.29	0.003	0.003	16.26
7.3.28	0.009	0.008	16.39
7.3.27	0.012	0.006	17.40
7.3.26	0.004	0.013	16.77
7.3.25	0.010	0.011	16.52
7.3.24	0.008	0.013	16.57
7.3.23	0.013	0.007	16.61
7.3.21	0.048	0.017	16.44
7.3.20	0.004	0.014	16.65
7.3.19	0.006	0.003	16.46
7.3.18	0.004	0.012	16.45
7.3.17	0.008	0.015	16.43
7.3.16	0.006	0.010	16.54
7.3.1	0.006	0.006	16.35
7.3.0	0.000	0.015	16.62
7.2.33	0.004	0.013	16.75
7.2.32	0.003	0.015	16.49
7.2.31	0.011	0.009	16.75
7.2.30	0.012	0.006	16.66
7.2.29	0.006	0.011	16.74
7.2.13	0.007	0.007	17.03
7.2.12	0.009	0.006	16.98
7.2.11	0.009	0.009	16.50
7.2.10	0.004	0.008	16.80
7.2.9	0.003	0.013	16.91
7.2.8	0.000	0.015	16.92
7.2.7	0.003	0.009	16.99
7.2.6	0.008	0.007	16.84
7.2.5	0.003	0.006	16.59
7.2.4	0.008	0.004	16.96
7.2.3	0.003	0.007	16.95
7.2.2	0.004	0.008	16.82
7.2.1	0.007	0.008	16.68
7.2.0	0.002	0.014	18.13
7.1.25	0.007	0.003	15.45
7.1.20	0.009	0.003	15.27
7.1.10	0.012	0.006	17.90
7.1.7	0.004	0.004	17.09
7.1.6	0.004	0.008	17.22
7.1.5	0.016	0.006	16.84
7.1.0	0.003	0.077	22.42
7.0.20	0.000	0.008	16.73
7.0.6	0.003	0.047	20.16
7.0.5	0.000	0.063	17.96
7.0.4	0.023	0.073	20.12
7.0.3	0.023	0.073	20.24
7.0.2	0.023	0.080	20.22
7.0.1	0.017	0.050	20.12
7.0.0	0.010	0.040	20.09
5.6.28	0.000	0.033	20.95
5.6.21	0.007	0.087	20.60
5.6.20	0.007	0.083	18.23
5.6.19	0.007	0.077	20.46
5.6.18	0.037	0.073	20.41
5.6.17	0.020	0.047	20.39
5.6.16	0.013	0.077	20.71
5.6.15	0.010	0.067	18.18
5.6.14	0.023	0.060	18.30
5.6.13	0.003	0.047	18.17
5.6.12	0.007	0.043	20.93
5.6.11	0.010	0.077	21.04
5.6.10	0.020	0.057	21.05
5.6.9	0.010	0.067	21.13
5.6.8	0.007	0.063	20.41
5.5.35	0.423	0.047	20.37
5.5.34	0.003	0.083	17.97
5.5.33	0.010	0.040	20.37
5.5.32	0.000	0.050	20.42
5.5.31	0.027	0.030	20.23
5.5.30	0.003	0.083	18.05
5.5.29	0.003	0.040	18.18
5.5.28	0.010	0.080	20.81
5.5.27	0.013	0.070	20.99
5.5.26	0.007	0.083	20.79
5.5.25	0.010	0.067	20.53
5.5.24	0.033	0.050	20.19

preferences:dark modelive preview