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;

preferences:
37.91 ms | 404 KiB | 5 Q