3v4l.org

run code in 300+ PHP versions simultaneously
<?php /** * 安全地执行SQL语句. * * 该函数会将所有参数经过安全地转义, 用来替换SQL命令中的占位符, 最后送至服务器进行执行. * * 占位符是 %s , 如果需要在SQL命令中包含百分号, 请连写两个百分号. * * @param resource $conn 由 mysql_connect() 建立的MySQL数据库连接资源 * @param string $sql SQL语句, 可以包含占位符 * @param mixed $more... 用来替换占位符的参数 * * @return resource 该函数会返回 mysql_query() 的返回值. */ function safeSQL($conn,$sql,$more=NULL) { $args=func_get_args(); array_shift($args); array_shift($args); $offset=0; foreach($args as $i) { if(preg_match("/%([sS])/",$sql,$result,PREG_OFFSET_CAPTURE,$offset)) { $fStr=$result[1][0]; $pos=$result[1][1]; $tPos=$pos-1; while($sql[$pos]=="%") $tPos--; if(!(($pos-$tPos)%2)) continue; $value=strval($i); $sql=substr($sql,0,$pos-1) . $value . substr($sql,$pos+1); $offset=$pos + 1; } } $sql=str_replace("%%", "%", $sql); echo $sql."\n"; } safeSQL(0,"SELECT * FROM `user`"); safeSQL(0,"SELECT * FROM `user` WHERE `uname`='%s'","jybox"); safeSQL(0,"UPDATE `%s` SET `email`='%t' WHERE `uname`='%s'","user","m@jybox.net","jybox"); safeSQL(0,"SELECT * FROM `user` WHERE `uname` LIKE ='%%%s%%'","jybox"); safeSQL(0,"SELECT * FROM `user`");

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).

VersionSystem time (s)User time (s)Memory (MiB)
8.3.70.0140.00718.77
8.3.60.0150.00618.43
8.3.50.0150.00322.05
8.3.40.0160.00618.95
8.3.30.0130.00319.01
8.3.20.0090.00018.89
8.3.10.0080.00021.27
8.3.00.0000.00823.66
8.2.180.0120.00617.13
8.2.170.0110.00422.96
8.2.160.0100.00320.39
8.2.150.0150.00024.18
8.2.140.0080.00024.66
8.2.130.0080.00026.16
8.2.120.0080.00019.91
8.2.110.0060.00320.55
8.2.100.0070.00417.97
8.2.90.0020.00519.25
8.2.80.0000.00917.97
8.2.70.0080.00017.88
8.2.60.0000.00818.04
8.2.50.0030.00618.07
8.2.40.0000.00918.34
8.2.30.0050.00319.57
8.2.20.0000.00718.02
8.2.10.0040.00418.07
8.2.00.0000.00817.92
8.1.280.0060.01025.92
8.1.270.0080.00023.99
8.1.260.0160.00326.35
8.1.250.0110.00028.09
8.1.240.0100.00022.67
8.1.230.0040.00821.09
8.1.220.0040.00418.77
8.1.210.0050.00319.23
8.1.200.0060.00317.60
8.1.190.0040.00417.66
8.1.180.0000.00818.10
8.1.170.0040.00418.88
8.1.160.0040.00418.94
8.1.150.0050.00318.90
8.1.140.0040.00417.70
8.1.130.0030.00517.87
8.1.120.0000.00717.62
8.1.110.0000.01017.66
8.1.100.0080.00017.65
8.1.90.0000.00717.64
8.1.80.0000.00817.67
8.1.70.0070.00017.63
8.1.60.0050.00217.82
8.1.50.0070.00017.67
8.1.40.0040.00417.72
8.1.30.0040.00417.84
8.1.20.0040.00417.82
8.1.10.0040.00417.77
8.1.00.0040.00417.68
8.0.300.0000.00720.10
8.0.290.0000.00717.18
8.0.280.0000.00718.55
8.0.270.0030.00517.34
8.0.260.0030.00317.00
8.0.250.0000.00817.16
8.0.240.0030.00517.12
8.0.230.0000.00817.12
8.0.220.0050.00317.04
8.0.210.0000.00717.06
8.0.200.0060.00017.14
8.0.190.0080.00017.11
8.0.180.0040.00417.06
8.0.170.0070.00017.15
8.0.160.0000.00717.14
8.0.150.0000.00717.07
8.0.140.0070.00317.05
8.0.130.0060.00013.38
8.0.120.0070.00017.11
8.0.110.0070.00017.09
8.0.100.0040.00416.96
8.0.90.0050.00317.21
8.0.80.0030.01317.13
8.0.70.0040.00417.00
8.0.60.0040.00417.01
8.0.50.0070.00017.04
8.0.30.0110.01017.48
8.0.20.0140.00417.40
8.0.10.0080.00017.21
8.0.00.0100.01116.97
7.4.330.0030.00313.43
7.4.320.0030.00316.83
7.4.300.0030.00316.87
7.4.290.0000.00716.90
7.4.280.0040.00416.79
7.4.270.0030.00316.88
7.4.260.0030.00313.70
7.4.250.0040.00416.89
7.4.240.0000.00716.90
7.4.230.0040.00416.98
7.4.220.0090.01516.78
7.4.210.0050.01216.95
7.4.200.0070.00017.04
7.4.190.0050.00216.73
7.4.160.0070.01016.79
7.4.150.0090.00917.40
7.4.140.0080.01117.86
7.4.130.0060.01316.86
7.4.120.0110.00616.86
7.4.110.0080.00816.73
7.4.100.0090.00916.54
7.4.90.0150.00916.77
7.4.80.0070.01019.39
7.4.70.0170.00616.91
7.4.60.0160.00716.54
7.4.50.0030.00516.71
7.4.40.0090.00922.52
7.4.30.0070.01016.66
7.4.00.0070.01115.25
7.3.330.0000.00613.39
7.3.320.0050.00013.34
7.3.310.0070.00016.56
7.3.300.0000.00816.54
7.3.290.0060.00916.54
7.3.280.0070.01116.54
7.3.270.0090.00917.40
7.3.260.0150.00318.24
7.3.250.0080.00916.63
7.3.240.0090.00916.69
7.3.230.0050.01216.72
7.3.210.0200.00716.65
7.3.200.0060.01519.39
7.3.190.0060.01516.52
7.3.180.0130.00316.56
7.3.170.0090.00616.88
7.3.160.0120.00916.45
7.3.120.0090.00714.99
7.3.110.0110.00714.95
7.3.100.0140.00015.21
7.3.90.0080.00415.00
7.3.80.0100.00315.24
7.3.70.0030.00814.82
7.3.60.0040.01114.86
7.3.50.0000.01015.10
7.3.40.0040.01114.82
7.3.30.0120.00015.23
7.3.20.0030.01016.85
7.3.10.0100.00716.98
7.3.00.0100.00616.77
7.2.330.0140.00316.74
7.2.320.0120.00616.99
7.2.310.0140.01116.99
7.2.300.0130.01017.00
7.2.290.0060.01116.84
7.2.250.0090.00615.37
7.2.240.0030.01715.30
7.2.230.0030.01315.37
7.2.220.0060.00615.36
7.2.210.0110.00315.15
7.2.200.0040.01114.93
7.2.190.0080.00815.11
7.2.180.0000.01315.23
7.2.170.0110.00715.20
7.2.160.0100.00315.23
7.2.150.0060.00917.14
7.2.140.0070.00717.20
7.2.130.0100.00617.09
7.2.120.0070.00716.95
7.2.110.0040.01116.91
7.2.100.0040.00817.15
7.2.90.0060.00917.27
7.2.80.0070.00717.27
7.2.70.0090.00617.26
7.2.60.0060.00917.18
7.2.50.0000.01216.89
7.2.40.0040.01117.23
7.2.30.0000.01417.03
7.2.20.0000.01616.94
7.2.10.0000.01317.07
7.2.00.0060.00818.49
7.1.330.0100.00716.01
7.1.320.0000.01315.97
7.1.310.0100.00716.04
7.1.300.0000.01515.80
7.1.290.0070.00716.17
7.1.280.0080.00815.75
7.1.270.0000.01415.80
7.1.260.0070.00716.00
7.1.250.0030.01416.13
7.1.240.0100.00715.83
7.1.230.0070.01015.92
7.1.220.0030.01415.96
7.1.210.0000.01416.00
7.1.200.0090.00615.99
7.1.190.0110.00415.80
7.1.180.0040.01115.56
7.1.170.0060.00615.91
7.1.160.0040.00816.02
7.1.150.0030.01315.74
7.1.140.0000.01315.75
7.1.130.0030.00716.00
7.1.120.0070.00716.16
7.1.110.0040.00816.16
7.1.100.0030.00917.22
7.1.90.0050.00516.18
7.1.80.0030.00915.95
7.1.70.0030.01016.65
7.1.60.0040.01617.69
7.1.50.0120.01725.46
7.1.40.0040.01116.08
7.1.30.0060.00616.07
7.1.20.0000.01416.00
7.1.10.0030.01015.73
7.1.00.0080.03019.18
7.0.330.0100.00315.74
7.0.320.0070.01015.76
7.0.310.0090.00015.71
7.0.300.0060.00315.80
7.0.290.0000.01315.72
7.0.280.0090.00615.34
7.0.270.0060.00315.48
7.0.260.0090.00615.42
7.0.250.0030.01415.54
7.0.240.0030.01015.74
7.0.230.0070.00715.65
7.0.220.0060.00615.61
7.0.210.0070.00715.61
7.0.200.0060.00516.40
7.0.190.0090.00615.68
7.0.180.0120.00315.62
7.0.170.0060.00315.63
7.0.160.0090.00615.54
7.0.150.0040.00415.67
7.0.140.0020.04518.76
7.0.130.0090.00015.75
7.0.120.0000.01015.73
7.0.110.0060.00915.61
7.0.100.0090.00615.82
7.0.90.0030.01015.78
7.0.80.0040.00715.59
7.0.70.0090.04318.63
7.0.60.0060.04818.80
7.0.50.0070.03818.78
7.0.40.0040.04416.80
7.0.30.0030.05216.98
7.0.20.0020.05116.77
7.0.10.0070.04216.79
7.0.00.0080.04516.82
5.6.400.0000.01514.76
5.6.390.0040.00814.38
5.6.380.0040.01114.39
5.6.370.0080.00314.79
5.6.360.0000.01114.63
5.6.350.0080.00314.37
5.6.340.0060.01014.48
5.6.330.0030.00714.20
5.6.320.0160.00014.61
5.6.310.0100.00014.82
5.6.300.0040.01214.36
5.6.290.0090.00614.81
5.6.280.0070.03517.54
5.6.270.0150.00314.32
5.6.260.0040.01114.41
5.6.250.0080.00814.25
5.6.240.0060.00614.68
5.6.230.0000.01514.52
5.6.220.0070.04517.58
5.6.210.0020.04017.41
5.6.200.0060.03817.65
5.6.190.0080.04517.69
5.6.180.0020.03417.78
5.6.170.0050.04517.91
5.6.160.0050.04417.87
5.6.150.0090.04217.84
5.6.140.0100.04017.79
5.6.130.0000.03317.74
5.6.120.0030.04917.84
5.6.110.0070.04917.81
5.6.100.0050.04717.73
5.6.90.0030.04817.65
5.6.80.0060.04317.44
5.6.70.0090.04017.46
5.6.60.0100.04017.46
5.6.50.0050.04517.59
5.6.40.0020.04517.35
5.6.30.0070.03117.48
5.6.20.0030.04817.35
5.6.10.0120.02717.57
5.6.00.0050.04317.29
5.5.380.0060.00614.63
5.5.370.0000.01114.42
5.5.360.0050.04117.34
5.5.350.0050.04717.42
5.5.340.0140.02517.62
5.5.330.0000.05417.73
5.5.320.0020.04717.60
5.5.310.0000.04317.72
5.5.300.0050.04517.57
5.5.290.0080.04317.70
5.5.280.0020.04217.63
5.5.270.0030.04817.82
5.5.260.0080.03817.45
5.5.250.0050.04617.46
5.5.240.0110.02817.29
5.5.230.0070.04517.13
5.5.220.0060.03917.38
5.5.210.0110.04017.24
5.5.200.0090.03717.28
5.5.190.0070.04317.30
5.5.180.0080.04217.12
5.5.170.0060.00614.55
5.5.160.0040.04517.24
5.5.150.0060.04017.42
5.5.140.0070.04417.22
5.5.130.0070.04317.21
5.5.120.0080.02717.39
5.5.110.0050.04217.23
5.5.100.0050.04517.01
5.5.90.0070.04417.14
5.5.80.0090.02517.14
5.5.70.0080.04017.15
5.5.60.0060.04217.17
5.5.50.0060.02717.27
5.5.40.0020.03717.27
5.5.30.0080.02317.06
5.5.20.0020.05317.15
5.5.10.0030.02717.25
5.5.00.0030.04517.16
5.4.450.0070.03915.26
5.4.440.0050.04315.26
5.4.430.0070.03815.30
5.4.420.0050.04315.25
5.4.410.0070.03915.05
5.4.400.0030.04315.15
5.4.390.0070.03715.12
5.4.380.0050.02315.27
5.4.370.0050.03815.07
5.4.360.0050.05015.31
5.4.350.0070.03915.12
5.4.340.0030.03515.24
5.4.330.0050.00211.00
5.4.320.0050.03515.22
5.4.310.0020.04315.18
5.4.300.0070.03815.13
5.4.290.0040.04015.22
5.4.280.0050.03615.13
5.4.270.0080.03015.00
5.4.260.0030.02815.08
5.4.250.0010.04415.04
5.4.240.0050.04015.18
5.4.230.0040.04215.31
5.4.220.0030.03015.12
5.4.210.0030.02315.14
5.4.200.0060.02515.21
5.4.190.0020.02915.12
5.4.180.0050.02915.00
5.4.170.0080.04115.25
5.4.160.0030.04214.98
5.4.150.0130.03814.98
5.4.140.0020.04413.77
5.4.130.0040.04113.70
5.4.120.0030.03013.94
5.4.110.0070.03513.75
5.4.100.0010.04513.87
5.4.90.0030.03213.72
5.4.80.0040.03513.88
5.4.70.0020.04013.92
5.4.60.0050.04213.66
5.4.50.0050.03413.86
5.4.40.0050.02513.79
5.4.30.0020.03913.78
5.4.20.0090.03413.79
5.4.10.0050.04013.66
5.4.00.0020.02713.58
5.3.290.0070.04212.78
5.3.280.0040.03112.62
5.3.270.0040.03312.72
5.3.260.0070.03512.66
5.3.250.0030.04112.62
5.3.240.0030.04012.63
5.3.230.0050.04112.71
5.3.220.0030.04112.58
5.3.210.0050.04212.64
5.3.200.0030.03912.44
5.3.190.0050.04012.54
5.3.180.0050.03512.54
5.3.170.0040.03312.67
5.3.160.0030.04212.64
5.3.150.0050.04112.52
5.3.140.0050.04212.68
5.3.130.0050.04312.43
5.3.120.0040.03512.60
5.3.110.0000.04712.62
5.3.100.0040.02412.37
5.3.90.0060.03312.45
5.3.80.0020.04212.21
5.3.70.0020.04212.26
5.3.60.0070.03712.30
5.3.50.0050.03312.33
5.3.40.0030.03312.34
5.3.30.0030.02912.21
5.3.20.0020.03612.19
5.3.10.0020.04312.15
5.3.00.0060.03812.06
5.2.170.0070.05313.17
5.2.160.0030.06013.17
5.2.150.0030.05313.17
5.2.140.0000.04013.17
5.2.130.0100.05313.17
5.2.120.0030.07313.17
5.2.110.0000.06013.17
5.2.100.0070.06013.17
5.2.90.0000.06313.17
5.2.80.0000.05713.17
5.2.70.0000.05013.17
5.2.60.0000.06313.17
5.2.50.0000.06013.17
5.2.40.0030.05713.17
5.2.30.0030.05313.17
5.2.20.0000.06713.17
5.2.10.0030.04713.17
5.2.00.0030.04313.17
5.1.60.0000.05313.17
5.1.50.0000.05713.17
5.1.40.0000.03713.17
5.1.30.0070.05013.17
5.1.20.0030.05313.17
5.1.10.0030.03713.17
5.1.00.0070.03013.17
5.0.50.0030.03713.17
5.0.40.0000.04313.17
5.0.30.0000.03313.17
5.0.20.0000.02013.17
5.0.10.0000.02013.17
5.0.00.0000.04013.17
4.4.90.0030.03313.17
4.4.80.0000.03013.17
4.4.70.0070.02313.17
4.4.60.0030.02713.17
4.4.50.0000.03013.17
4.4.40.0000.03013.17
4.4.30.0000.02713.17
4.4.20.0030.01713.17
4.4.10.0030.01313.17
4.4.00.0000.03013.17
4.3.110.0000.03313.17
4.3.100.0030.01313.17
4.3.90.0000.02713.17
4.3.80.0070.01713.17
4.3.70.0000.01313.17
4.3.60.0000.01713.17
4.3.50.0000.01313.17
4.3.40.0000.03313.17
4.3.30.0000.02013.17
4.3.20.0000.01713.17
4.3.10.0000.01713.17
4.3.00.0000.01713.17

preferences:
54.29 ms | 401 KiB | 5 Q