Online PHP editor | perf for uaoEX

<?php case 'updateprice': switch ($task) { case 'update': { if(isset($HTTP_POST_FILES['filename']['name'])) { echo "<h3>Uploading: ".$HTTP_POST_FILES['filename']['name']."</h3><br>"; $handle=fopen($HTTP_POST_FILES['filename']['tmp_name'],"r"); if ($handle) { if (!feof($handle)) $buffer = fgets($handle); while (!feof($handle)&&!stristr(iconv("WINDOWS-1251","UTF-8",$buffer),'Код')) { $buffer = fgets($handle); } if(!stristr(iconv("WINDOWS-1251","UTF-8",$buffer),'Код')) { echo "<h3>Incorrect file<h3>"; exit; } else { $columns=explode("\t",$buffer); $i=0; foreach ($columns as $column) { $column=iconv("WINDOWS-1251","UTF-8",$column); if ($column=="Розница") $price1=$i; if ($column=="Опт1") $price2=$i; if ($column=="Опт2") $price3=$i; if ($column=="Опт3") $price4=$i; if ($column=="Код") $code=$i; $i++; } } echo $database->doSQL("DROP TABLE IF EXISTS #__import"); echo $database->doSQL("CREATE TABLE IF NOT EXISTS #__import ( `code` bigint(20) unsigned NOT NULL, `price1` float NOT NULL default '0', `price2` float NOT NULL default '0', `price3` float NOT NULL default '0', `price4` float NOT NULL default '0', KEY `code` (`code`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1"); $buffer = fgets($handle); while (!feof($handle)) { $buffer = fgets($handle); $row = explode("\t",$buffer); if (array_key_exists(9,$row)) { $out=array("'"," руб."); $row[$price1] = str_replace($out,"",$row[$price1]); $row[$price2] = str_replace($out,"",$row[$price2]); $row[$price3] = str_replace($out,"",$row[$price3]); $row[$price4] = str_replace($out,"",$row[$price4]); $sql = "INSERT INTO #__import (`code`, `price1`, `price2`, `price3`, `price4`) VALUES ('$row[$code]', '$row[$price1]', '$row[$price2]', '$row[$price3]', '$row[$price4]');"; $result = $database->doSQL($sql); } } fclose($handle); } echo "<h3>Import completed</h3><br />"; $database->doSQL("UPDATE #__itemdetails SET `price1` = 0, `price2` = 0, `price3` = 0, `price4` = 0"); echo '<h3>Old prices was nulled</h3><br>'; $sql=""; $database->setQuery('select * from #__itemdetails'); $rows = $database->loadObjectList(); foreach ($rows as $row) { $database->setQuery("select * from #__import where code=$row->code"); $rows1=$database->loadObjectList(); if (!sizeof($rows1)) $errors.=$row->code.', '; else { $database->doSQL("UPDATE #__itemdetails SET `price1` = '".$rows1[0]->price1."', `price2` = '".$rows1[0]->price2."', `price3` = '".$rows1[0]->price3."', `price4` = '".$rows1[0]->price4."' WHERE `code` = ".$row->code); $completed.=$row->code.', '; } } echo '<div align=left><b>The following goods were updated:</b> '.substr($completed,0,strlen($completed)-2).'</div>'; if (isset($errors)) echo '<br><br><div align=left><b><font color=red>The following goods were not found:</b></font> '.substr($errors,0,strlen($errors)-2).'</div>'; exit; } } default: HTML_catalog::ShowUploadPriceForm(); break; } break; ?>

Version	System time (s)	User time (s)	Memory (MiB)
5.4.21	0.019	0.044	12.37
5.4.20	0.022	0.047	12.37
5.4.19	0.026	0.053	12.37
5.4.18	0.024	0.040	12.36
5.4.17	0.016	0.043	12.37
5.4.16	0.018	0.048	12.36
5.4.15	0.019	0.044	12.36
5.4.14	0.021	0.049	12.06
5.4.13	0.018	0.045	12.03
5.4.12	0.020	0.048	12.00
5.4.11	0.019	0.046	12.00
5.4.10	0.022	0.049	12.00
5.4.9	0.018	0.049	12.00
5.4.8	0.019	0.043	12.00
5.4.7	0.019	0.044	12.00
5.4.6	0.025	0.041	11.99
5.4.5	0.015	0.049	11.99
5.4.4	0.018	0.048	11.98
5.4.3	0.014	0.050	11.98
5.4.2	0.020	0.043	11.97
5.4.1	0.018	0.044	11.98
5.4.0	0.015	0.045	11.48
5.3.27	0.017	0.048	12.72
5.3.26	0.020	0.044	12.72
5.3.25	0.017	0.053	12.72
5.3.24	0.018	0.050	12.72
5.3.23	0.016	0.051	12.71
5.3.22	0.016	0.046	12.68
5.3.21	0.024	0.044	12.68
5.3.20	0.020	0.046	12.68
5.3.19	0.015	0.048	12.68
5.3.18	0.019	0.049	12.67
5.3.17	0.024	0.039	12.67
5.3.16	0.014	0.049	12.67
5.3.15	0.020	0.046	12.67
5.3.14	0.019	0.042	12.66
5.3.13	0.016	0.049	12.65
5.3.12	0.022	0.046	12.66
5.3.11	0.020	0.043	12.66
5.3.10	0.020	0.044	12.12
5.3.9	0.028	0.063	12.09
5.3.8	0.014	0.049	12.08
5.3.7	0.022	0.053	12.07
5.3.6	0.023	0.042	12.06
5.3.5	0.023	0.039	12.00
5.3.4	0.022	0.045	12.00
5.3.3	0.018	0.043	11.94
5.3.2	0.019	0.045	11.71
5.3.1	0.013	0.046	11.68
5.3.0	0.014	0.047	11.66