Online PHP editor | output for VZtD2

@ 2023-04-16T23:48:07Z

<?php

$query = "UPDATE `list` set `item`=?,`type`=? WHERE `item` != 'Are you okay?' (`id` = ?);";
$params = array(
    'item' => '1',
    'type' => 'Are you o\'k?',
    'id'   => 2
);

function substitute_params($query, $params) {
    return sprintf(
        "-- Not to be used as a query to database. For demonstration purposes only!\n%s",
        str_replace(
            "\\?",
            "?",
            array_reduce(
                str_replace("?", "\\?", $params),
                fn($query, $param) => preg_replace(
                    '/(?<!\\\\)\\?/', 
                    is_numeric($param) ? $param : "'" . str_replace("'", "''", $param) . "'",
                    $query,
                    1
                ),
                $query
            )
        )
    );
}
echo substitute_params($query, $params);

Output for 8.0.1 - 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: -- Not to be used as a query to database. For demonstration purposes only! UPDATE `list` set `item`=1,`type`='Are you o''k?' WHERE `item` != 'Are you okay2' (`id` = ?);
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