3v4l.org

run code in 300+ PHP versions simultaneously
<?php $Models = [ 'users' => 'm_users', 'products' => 'm_products', 'customers' => 'm_customers']; $string = "SELECT users as Name,`users`.`family` AS Family, products.id AS PID, `customers`.`id` AD CID FROM users INNER JOIN customers INNER JOIN products WHERE customers.customers = 1 and users.users = 2 and `products`.`id` = 1 and products.name = 'me' ORDER BY customers.id DESC"; $string_1 = "SELECT users FROM users"; foreach ($Models as $alias => $table) { $string = preg_replace("/(\s|,)`?{$alias}`?/", "$1`{$table}`", $string); } echo $string;
Output for 5.4.0 - 5.4.45, 5.5.0 - 5.5.38, 5.6.0 - 5.6.30, 7.0.0 - 7.0.23, 7.1.0 - 7.1.33, 7.2.6 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.33, 8.2.0 - 8.2.29, 8.3.0 - 8.3.28, 8.4.1 - 8.4.14, 8.4.16, 8.5.0 - 8.5.1
SELECT `m_users` as Name,`m_users`.`family` AS Family, `m_products`.id AS PID, `m_customers`.`id` AD CID FROM `m_users` INNER JOIN `m_customers` INNER JOIN `m_products` WHERE `m_customers`.customers = 1 and `m_users`.users = 2 and `m_products`.`id` = 1 and `m_products`.name = 'me' ORDER BY `m_customers`.id DESC
Output for 8.4.15
/bin/php-8.4.15: /usr/lib/libm.so.6: version `GLIBC_2.38' not found (required by /bin/php-8.4.15) /bin/php-8.4.15: /usr/lib/libm.so.6: version `GLIBC_2.35' not found (required by /bin/php-8.4.15) /bin/php-8.4.15: /usr/lib/libc.so.6: version `GLIBC_2.34' not found (required by /bin/php-8.4.15) /bin/php-8.4.15: /usr/lib/libc.so.6: version `GLIBC_2.38' not found (required by /bin/php-8.4.15)
Process exited with code 1.
Output for 4.4.2 - 4.4.9, 5.1.0 - 5.1.6, 5.2.0 - 5.2.17, 5.3.0 - 5.3.29
Parse error: syntax error, unexpected '[' in /in/Rq8mb on line 3
Process exited with code 255.
Output for 4.3.0 - 4.3.1, 4.3.5 - 4.3.11, 4.4.0 - 4.4.1, 5.0.0 - 5.0.5
Parse error: parse error, unexpected '[' in /in/Rq8mb on line 3
Process exited with code 255.
Output for 4.3.2 - 4.3.4
Parse error: parse error in /in/Rq8mb on line 3
Process exited with code 255.
preferences:
223.98 ms | 411 KiB | 5 Q