Online PHP editor | perf for gRHnc

<?php function display_table(){ global $mysqli; $phpself = $_SERVER["PHP_SELF"]; $user = $_SESSION['user']; echo<<<TABLE <html> <head> <title>Insert new record</title> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <meta name="description" content="" /> <meta name="keywords" content="" />  <script src="js/jquery.min.js"></script> <script src="js/jquery.dropotron.min.js"></script> <script src="js/skel.min.js"></script> <script src="js/skel-layers.min.js"></script> <script src="js/init.js"></script> <link rel="stylesheet" type="text/css" media="screen" href="css-table.css" /> <script type="text/javascript" src="js/jquery-1.2.6.min.js"></script> <script type="text/javascript" src="js/style-table.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script> <script type="text/javascript"> jQuery.expr[':'].contains = function(a,i,m){ return jQuery(a).text().toUpperCase().indexOf(m[3].toUpperCase())>=0; }; $(document).ready(function(){ $('input[name="search"]').keyup(function(){ var searchterm = $(this).val(); if(searchterm.length >2) { var match = $('tr.data-row:contains("' + searchterm + '")'); var nomatch = $('tr.data-row:not(:contains("' + searchterm + '"))'); match.addClass('selected'); nomatch.css("display", "none"); } else { $('tr.data-row').css("display", ""); $('tr.data-row').removeClass('selected'); } }); }); </script> <noscript> <link rel="stylesheet" href="css/skel.css" /> <link rel="stylesheet" href="css/style.css" /> <link rel="stylesheet" href="css/style-noscript.css" /> </noscript>   </head> <body class="no-sidebar loading">  <header id="header"> <h1 id="logo"><a href="home.php">HOME <span>PAGE</span></a></h1> <nav id="nav"> <ul> <li class="current"><a href="home.php">Welcome, $user</a></li> <li class="submenu"> <a href="">Options</a> <ul> <li class="submenu"> <a href="">View Database</a> <ul> <li><a href="example.php">Prospects </a></li> <li><a href="clients.php">Clients </a></li> </ul> </li> <li><a href="excel.php">Download report</a></li> <li class="submenu"> <a href="">Add Record</a> <ul> <li><a href="import.php">Import file</a></li> </ul> </li> <li><a href="backup.php">Backup Database</a></li> <li><a href="restore.php">Import Database</a></li> </ul> </li> <li> <a href="index.php" class="button special">Sign Out </a></li> </ul> </nav> </header>  <article id="main"> <header class="special container"> <span class="icon fa-mobile"></span> <h2>Backup Database Files</h2> <p></p> </header>  <section class="wrapper style4 container"> <form action="$phpself" method="post"> <center>Choose Type :   <select name='type'> <option>prospects</option> <option>clients</option> </select><br/><br/><input type="submit" name="submit" value="Backup SQL Database Now"> </center><br/> </form> </section>  </article>  <footer id="footer"> <ul class="icons"> <li><a href="#" class="icon circle fa-twitter"><span class="label">Twitter</span></a></li> <li><a href="#" class="icon circle fa-facebook"><span class="label">Facebook</span></a></li> <li><a href="#" class="icon circle fa-google-plus"><span class="label">Google+</span></a></li> <li><a href="#" class="icon circle fa-github"><span class="label">Github</span></a></li> <li><a href="#" class="icon circle fa-dribbble"><span class="label">Dribbble</span></a></li> </ul> <span class="copyright">© Untitled. All rights reserved. Design: <a href="http://html5up.net">HTML5 UP</a>.</span> </footer> </body> </html> TABLE; } function badinput($msg){ echo <<<BADINPUT <html> <head> <title>Bad input</title> </head> <body> <h1>Error</h1> <p>Input could not be used because $msg.</p> </body> </html> BADINPUT; } // CLEAN QUERIES function clean($str) { if(@isset($str)){ $str = @trim($str); if(get_magic_quotes_gpc()) { $str = stripslashes($str); } return mysql_real_escape_string($str); } else{ return 'NULL'; } } // DATABASE BACKUP CREATING FUNCTION function backup_Database($hostName,$userName,$password,$DbName,$tables = '*') { // CONNECT TO THE DATABASE $con = mysql_connect($hostName,$userName,$password) or die(mysql_error()); mysql_select_db($DbName,$con) or die(mysql_error()); // GET ALL TABLES if($tables == '*') { $tables = array(); $result = mysql_query('SHOW TABLES'); while($row = mysql_fetch_row($result)) { $tables[] = $row[0]; } } else { $tables = is_array($tables) ? $tables : explode(',',$tables); } $return = 'SET FOREIGN_KEY_CHECKS=0;' . "\r\n"; $return.= 'SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";' . "\r\n"; $return.= 'SET AUTOCOMMIT=0;' . "\r\n"; $return.= 'START TRANSACTION;' . "\r\n"; foreach($tables as $table) { $result = mysql_query('SELECT * FROM '.$table) or die(mysql_error()); $num_fields = mysql_num_fields($result) or die(mysql_error()); $data.= 'DROP TABLE IF EXISTS '.$table.';'; $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table)); $data.= "\n\n".$row2[1].";\n\n"; for ($i = 0; $i<$num_fields; $i++) { while($row = mysql_fetch_row($result)) { $data.= 'INSERT INTO '.$table.' VALUES('; for($x=0; $x<$num_fields; $x++) { $row[$x] = addslashes($row[$x]); //$row[$x] = ereg_replace("\n","\\n",$row[$x]); $row[$x] = clean($row[$x]);// CLEAN QUERIES if (isset($row[$x])) { $data.= '"'.$row[$x].'"' ; } else { $data.= '""'; } if ($x<($num_fields-1)) { $data.= ','; } } // end of the for loop 2 $data.= ");\n"; } // end of the while loop } // end of the for loop 1 $data.="\n\n\n"; } // end of the foreach*/ $return .= 'SET FOREIGN_KEY_CHECKS=1;' . "\r\n"; $return.= 'COMMIT;'; //SAVE THE BACKUP AS SQL FILE $handle = fopen($DbName.'-Database-Backup-'.$table.date('Y-m-d @ h-i-s').'.sql','w+'); fwrite($handle,$data); fclos($handle); /* gz format $gzdata = gzencode($data, 9); $handle = fopen($DbName.'-Database-Backup-'.date('Y-m-d @ h-i-s').'.sql.gz','w+'); fwrite($handle, $gzdata); fclose($handle);*/ if($data) return true; else return false; } // end of the function function addnewdata(){ global $mysqli; $utype = $_POST["type"]; $tables = $utype; $backup_response = backup_Database('ptjobstation.com','csci311','020809','user',$tables); if($backup_response) { echo <<<SUCCESSRESPONSE <html> <head> <title>New record inserted</title> </head> <body> <h1>Database Backup Successfully Created!</h1> <p>Please wait, link will be auto redirected</p> <script>setTimeout(function(){window.location.href='backup.php'},4000);</script> </body> </html> SUCCESSRESPONSE; } else { echo 'Errors in Database Backup Creating!'; } } session_cache_limiter ('private, must-revalidate'); $cache_limiter = session_cache_limiter(); // session_cache_expire(60); // 60 minutes session_start(); $user = $_SESSION['user']; function connectToDatabase(){ global $mysqli; $mysqli = new mysqli('ptjobstation.com','csci311','020809','user'); // Check for connection errors if(mysqli_connect_errno()){ $problem = mysqli_connect_error(); badinput($problem); exit; } } $method = $_SERVER["REQUEST_METHOD"]; if($method=="POST"){ addnewdata(); } else{ display_table(); } ?>

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	17.00
8.3.5	0.007	0.013	22.01
8.3.4	0.012	0.003	18.77
8.3.3	0.009	0.006	19.21
8.3.2	0.008	0.000	20.46
8.3.1	0.006	0.003	23.65
8.3.0	0.000	0.008	19.18
8.2.18	0.009	0.009	18.54
8.2.17	0.012	0.003	22.96
8.2.16	0.014	0.007	20.48
8.2.15	0.005	0.003	24.18
8.2.14	0.004	0.004	24.66
8.2.13	0.006	0.003	26.16
8.2.12	0.011	0.004	20.79
8.2.11	0.004	0.004	22.24
8.2.10	0.004	0.007	18.09
8.2.9	0.005	0.003	19.18
8.2.8	0.004	0.004	17.97
8.2.7	0.008	0.000	17.75
8.2.6	0.003	0.005	18.16
8.2.5	0.024	0.014	18.07
8.2.4	0.003	0.005	20.01
8.2.3	0.007	0.000	18.29
8.2.2	0.004	0.004	17.93
8.2.1	0.005	0.002	18.32
8.2.0	0.000	0.008	18.00
8.1.28	0.011	0.007	25.92
8.1.27	0.010	0.000	22.19
8.1.26	0.004	0.004	26.35
8.1.25	0.006	0.003	28.09
8.1.24	0.004	0.004	22.29
8.1.23	0.006	0.006	19.35
8.1.22	0.009	0.000	17.91
8.1.21	0.004	0.004	18.77
8.1.20	0.006	0.003	17.48
8.1.19	0.003	0.006	17.22
8.1.18	0.004	0.004	18.10
8.1.17	0.005	0.003	18.76
8.1.16	0.004	0.004	22.06
8.1.15	0.003	0.006	18.76
8.1.14	0.000	0.008	17.55
8.1.13	0.004	0.004	17.89
8.1.12	0.000	0.007	17.57
8.1.11	0.000	0.007	17.52
8.1.10	0.004	0.004	17.44
8.1.9	0.000	0.007	17.53
8.1.8	0.004	0.004	17.50
8.1.7	0.004	0.004	17.54
8.1.6	0.003	0.006	17.67
8.1.5	0.006	0.003	17.52
8.1.4	0.000	0.008	17.50
8.1.3	0.005	0.003	17.80
8.1.2	0.004	0.004	17.71
8.1.1	0.000	0.008	17.62
8.1.0	0.000	0.008	17.56
8.0.30	0.000	0.008	18.77
8.0.29	0.005	0.003	17.30
8.0.28	0.000	0.007	18.53
8.0.27	0.004	0.004	17.34
8.0.26	0.003	0.003	17.27
8.0.25	0.003	0.003	17.07
8.0.24	0.007	0.003	16.98
8.0.23	0.005	0.002	16.95
8.0.22	0.003	0.003	17.01
8.0.21	0.000	0.007	16.91
8.0.20	0.003	0.003	16.96
8.0.19	0.004	0.004	17.00
8.0.18	0.004	0.004	17.12
8.0.17	0.006	0.003	17.14
8.0.16	0.000	0.007	16.97
8.0.15	0.004	0.004	16.98
8.0.14	0.005	0.002	17.04
8.0.13	0.003	0.003	13.38
8.0.12	0.005	0.003	16.89
8.0.11	0.005	0.003	17.02
8.0.10	0.004	0.004	17.07
8.0.9	0.004	0.004	17.15
8.0.8	0.013	0.003	17.05
8.0.7	0.000	0.007	17.02
8.0.6	0.000	0.007	16.87
8.0.5	0.004	0.004	17.05
8.0.3	0.013	0.007	17.23
8.0.2	0.008	0.011	17.40
8.0.1	0.004	0.004	17.22
8.0.0	0.010	0.008	16.77
7.4.33	0.007	0.000	15.00
7.4.32	0.004	0.004	16.68
7.4.30	0.003	0.003	16.49
7.4.29	0.007	0.000	16.44
7.4.28	0.000	0.008	16.65
7.4.27	0.003	0.005	16.54
7.4.26	0.000	0.008	16.56
7.4.25	0.004	0.004	16.47
7.4.24	0.006	0.001	16.59
7.4.23	0.004	0.004	16.57
7.4.22	0.007	0.013	16.64
7.4.21	0.008	0.008	16.66
7.4.20	0.004	0.004	16.51
7.4.19	0.004	0.004	16.70
7.4.16	0.011	0.007	16.82
7.4.15	0.010	0.011	17.40
7.4.14	0.011	0.011	17.86
7.4.13	0.007	0.009	16.67
7.4.12	0.009	0.009	16.69
7.4.11	0.010	0.013	16.63
7.4.10	0.008	0.012	16.80
7.4.9	0.009	0.009	16.66
7.4.8	0.009	0.015	19.39
7.4.7	0.015	0.006	16.62
7.4.6	0.009	0.009	16.55
7.4.5	0.003	0.006	16.55
7.4.4	0.003	0.013	16.55
7.4.3	0.012	0.012	16.68
7.4.0	0.007	0.010	14.87
7.3.33	0.000	0.006	13.30
7.3.32	0.000	0.005	13.51
7.3.31	0.007	0.000	16.53
7.3.30	0.005	0.003	16.50
7.3.29	0.007	0.007	16.49
7.3.28	0.011	0.009	16.48
7.3.27	0.009	0.009	17.40
7.3.26	0.012	0.006	16.71
7.3.25	0.010	0.011	16.56
7.3.24	0.008	0.010	16.54
7.3.23	0.010	0.007	16.50
7.3.21	0.011	0.007	16.49
7.3.20	0.011	0.007	19.39
7.3.19	0.004	0.014	16.42
7.3.18	0.015	0.006	16.42
7.3.17	0.014	0.007	16.61
7.3.16	0.014	0.003	16.64
7.3.12	0.005	0.012	15.12
7.3.11	0.007	0.010	15.01
7.3.10	0.004	0.011	14.73
7.3.9	0.006	0.009	14.72
7.3.8	0.008	0.005	15.07
7.3.7	0.012	0.006	15.05
7.3.6	0.003	0.013	14.96
7.3.5	0.014	0.000	14.86
7.3.4	0.014	0.000	14.96
7.3.3	0.003	0.010	14.97
7.3.2	0.004	0.011	16.54
7.3.1	0.004	0.012	16.82
7.3.0	0.004	0.008	16.76
7.2.33	0.010	0.010	16.59
7.2.32	0.010	0.010	16.95
7.2.31	0.012	0.009	16.51
7.2.30	0.017	0.003	16.85
7.2.29	0.008	0.011	16.52
7.2.25	0.007	0.013	15.32
7.2.24	0.007	0.014	14.97
7.2.23	0.000	0.015	15.21
7.2.22	0.006	0.010	15.08
7.2.21	0.006	0.009	15.27
7.2.20	0.004	0.015	15.16
7.2.19	0.012	0.003	15.05
7.2.18	0.000	0.012	15.02
7.2.17	0.006	0.009	15.17
7.2.6	0.004	0.011	16.61
7.2.0	0.007	0.007	19.37
7.1.33	0.007	0.007	15.89
7.1.32	0.007	0.007	15.61
7.1.31	0.000	0.016	15.86
7.1.30	0.008	0.008	15.65
7.1.29	0.008	0.008	15.70
7.1.28	0.006	0.006	15.62
7.1.27	0.000	0.011	15.79
7.1.26	0.007	0.010	15.78
7.1.20	0.003	0.012	15.93
7.1.10	0.012	0.009	18.01
7.1.7	0.004	0.008	16.86
7.1.6	0.011	0.011	19.46
7.1.5	0.013	0.013	17.02
7.1.0	0.000	0.080	22.54
7.0.20	0.003	0.007	16.61
7.0.14	0.000	0.077	22.00
7.0.8	0.010	0.077	19.94
7.0.7	0.000	0.087	19.95
7.0.6	0.010	0.070	20.05
7.0.5	0.010	0.087	20.23
7.0.4	0.003	0.093	20.08
7.0.3	0.010	0.050	20.15
7.0.2	0.010	0.083	20.05
7.0.1	0.017	0.063	20.03
7.0.0	0.013	0.080	19.95
5.6.28	0.000	0.077	20.95
5.6.23	0.000	0.087	20.63
5.6.22	0.003	0.053	20.68
5.6.21	0.000	0.090	20.77
5.6.20	0.007	0.090	21.07
5.6.19	0.010	0.080	21.05
5.6.18	0.007	0.077	21.11
5.6.17	0.003	0.087	21.06
5.6.16	0.003	0.090	21.18
5.6.15	0.000	0.087	21.18
5.6.14	0.007	0.040	21.06
5.6.13	0.000	0.047	21.21
5.6.12	0.010	0.080	20.97
5.6.11	0.010	0.083	21.09
5.6.10	0.020	0.073	21.13
5.6.9	0.010	0.080	20.98
5.6.8	0.003	0.053	20.48
5.6.7	0.003	0.080	20.49
5.6.6	0.017	0.073	20.51
5.6.5	0.003	0.077	20.50
5.6.4	0.017	0.073	20.41
5.6.3	0.017	0.070	20.36
5.6.2	0.010	0.073	20.33
5.6.1	0.007	0.070	20.34
5.6.0	0.007	0.077	20.46
5.5.37	0.013	0.073	20.38
5.5.36	0.013	0.080	20.42
5.5.35	0.017	0.073	20.49
5.5.34	0.013	0.080	20.86
5.5.33	0.010	0.073	20.91
5.5.32	0.017	0.077	20.94
5.5.31	0.010	0.080	20.86
5.5.30	0.003	0.043	20.77
5.5.29	0.010	0.077	20.86
5.5.28	0.003	0.087	20.76
5.5.27	0.010	0.043	20.93
5.5.26	0.007	0.080	20.75
5.5.25	0.003	0.090	20.60
5.5.24	0.013	0.067	20.22
5.5.23	0.007	0.083	20.30
5.5.22	0.007	0.053	20.31
5.5.21	0.007	0.070	20.31
5.5.20	0.010	0.070	20.16
5.5.19	0.013	0.077	20.15
5.5.18	0.013	0.070	20.31
5.5.16	0.013	0.070	20.24
5.5.15	0.007	0.077	20.11
5.5.14	0.007	0.057	20.14
5.5.13	0.010	0.073	20.24
5.5.12	0.010	0.073	20.21
5.5.11	0.010	0.077	20.26
5.5.10	0.017	0.073	20.01
5.5.9	0.017	0.067	20.13
5.5.8	0.007	0.077	19.98
5.5.7	0.007	0.080	20.20
5.5.6	0.013	0.070	20.09
5.5.5	0.000	0.073	20.03
5.5.4	0.013	0.040	20.09
5.5.3	0.007	0.077	20.08
5.5.2	0.000	0.080	20.18
5.5.1	0.013	0.053	20.11
5.5.0	0.007	0.080	20.07
5.4.45	0.000	0.080	19.48
5.4.44	0.003	0.090	19.20
5.4.43	0.007	0.080	19.22
5.4.42	0.010	0.080	19.45
5.4.41	0.007	0.083	19.43
5.4.40	0.010	0.077	19.05
5.4.39	0.007	0.080	19.21
5.4.38	0.010	0.073	19.04
5.4.37	0.017	0.067	18.96
5.4.36	0.017	0.073	19.23
5.4.35	0.020	0.073	19.05
5.4.34	0.007	0.080	19.04
5.4.32	0.017	0.070	19.21
5.4.31	0.010	0.070	18.95
5.4.30	0.003	0.063	19.11
5.4.29	0.010	0.077	19.18
5.4.28	0.010	0.077	19.03
5.4.27	0.017	0.037	19.02
5.4.26	0.003	0.053	19.14
5.4.25	0.003	0.040	19.04
5.4.24	0.007	0.077	19.16
5.4.23	0.007	0.040	18.90
5.4.22	0.007	0.077	19.18
5.4.21	0.017	0.060	18.86
5.4.20	0.000	0.050	18.87
5.4.19	0.017	0.063	19.11
5.4.18	0.000	0.050	18.84
5.4.17	0.007	0.073	19.11
5.4.16	0.010	0.067	19.03
5.4.15	0.017	0.070	19.16
5.4.14	0.003	0.073	16.44
5.4.13	0.003	0.073	16.45
5.4.12	0.010	0.070	16.47
5.4.11	0.003	0.080	16.51
5.4.10	0.017	0.063	16.39
5.4.9	0.000	0.080	16.45
5.4.8	0.010	0.070	16.38
5.4.7	0.003	0.077	16.52
5.4.6	0.000	0.070	16.51
5.4.5	0.003	0.070	16.48
5.4.4	0.003	0.080	16.45
5.4.3	0.007	0.063	16.37
5.4.2	0.020	0.040	16.38
5.4.1	0.003	0.077	16.46
5.4.0	0.013	0.063	15.88
5.3.29	0.007	0.073	14.64
5.3.28	0.017	0.057	14.75
5.3.27	0.010	0.067	14.58
5.3.26	0.010	0.067	14.71
5.3.25	0.007	0.070	14.71
5.3.24	0.013	0.073	14.74
5.3.23	0.007	0.077	14.78
5.3.22	0.010	0.060	14.58
5.3.21	0.003	0.060	14.55
5.3.20	0.007	0.067	14.73
5.3.19	0.010	0.067	14.73
5.3.18	0.017	0.067	14.62
5.3.17	0.013	0.063	14.76
5.3.16	0.010	0.073	14.57
5.3.15	0.010	0.070	14.72
5.3.14	0.007	0.077	14.62
5.3.13	0.003	0.080	14.54
5.3.12	0.007	0.077	14.55
5.3.11	0.003	0.083	14.65
5.3.10	0.003	0.043	14.14
5.3.9	0.010	0.067	14.04
5.3.8	0.003	0.060	14.04
5.3.7	0.010	0.077	14.20
5.3.6	0.010	0.070	13.95
5.3.5	0.010	0.067	14.02
5.3.4	0.003	0.080	14.01
5.3.3	0.007	0.053	14.09
5.3.2	0.007	0.073	13.86
5.3.1	0.010	0.063	13.62
5.3.0	0.007	0.073	13.61