Online PHP editor | output for BMpPR

@ 2018-12-18T14:19:56Z

<?php

$re = '/\bsite_[a-zA-Z0-9]*/';
$query = 'SELECT * FROM site_customers LEFT JOIN site_products';

preg_match_all($re, $query, $matches, PREG_SET_ORDER, 0);

// Print the entire match result
var_dump($matches);

// Replace old tables with new ones
$old = [
    $matches[0][0], // First table name
    $matches[1][0], // Second table name
];

$new = [
    $matches[0][0] . '_02', // Append _02
    'new_' . $matches[1][0], // Prepand new_
];

$query = str_replace($old, $new, $query);

// Print the new query
echo $query;

Output for 5.6.38, 7.0.33, 7.1.25, 7.2.0 - 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.5.0 - 8.5.1: array(2) { [0]=> array(1) { [0]=> string(14) "site_customers" } [1]=> array(1) { [0]=> string(13) "site_products" } } SELECT * FROM site_customers_02 LEFT JOIN new_site_products
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.

preferences:dark modelive previewkey bindings