Online PHP editor | output for YtN8T

@ 2020-07-02T18:32:53Z

<?php
function escape(string $query) {
    return preg_replace_callback('/{(([^.}]+?)\.)?(.*?)}/', function ($matches) {
          $quoted = '';

          // Quote table name. If there is an explicit database, quote it, too.
          if ($matches[2] !== '') {
              $quoted .= '`' . $matches[2] . '`.';
          }

          // Quote the table name, keeping curly brackets so potential prefixes can
          // be added later.
          $quoted .= '`{' . $matches[3] . '}`';

          return $quoted;
      }, $query);
}

var_dump(escape('SELECT * FROM system'));
var_dump(escape('SELECT * FROM {system} '));
var_dump(escape('SELECT * FROM {db.system}'));
var_dump(escape('SELECT * FROM db.system'));

Output for 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: string(20) "SELECT * FROM system" string(25) "SELECT * FROM `{system}` " string(29) "SELECT * FROM `db`.`{system}`" string(23) "SELECT * FROM db.system"
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