Online PHP editor | refs for 2IHsS

<?php ob_start(function ($str) { ini_set('pcre.jit', '0'); return preg_replace_callback('~(.)\1{2}\K\1{27,}(?=\1{3})~', fn ($m) => '...' . (strlen($m[0]) + 6) . '*...', $str); }); $str = str_repeat('x', 65_540); $str2 = 'y' . $str; $expectedRes = [['v' => $str], ['v' => $str2]]; echo "expected:\n"; print_r($expectedRes); $sql = 'select v from ( select ? v union all select ? v ) t'; $mysqli = new \mysqli('localhost', 'atk4_test', 'XXXXX', 'atk4_test__data'); $stmt = $mysqli->prepare($sql); $stmt->bind_param('ss', $str, $str2); $stmt->execute(); $result = $stmt->get_result(); $row = $result->fetch_all(\MYSQLI_ASSOC); echo "\nactual using mysqli driver:\n"; print_r($row); var_dump($row === $expectedRes); // reproduce the same with pdo_mysql driver $pdo = new \PDO('mysql:host=127.0.0.1;dbname=atk4_test__data', 'atk4_test', 'XXXXX'); $stmt = $pdo->prepare($sql); $stmt->bindValue(1, $str); $stmt->bindValue(2, $str); $stmt->execute(); $res = $stmt->fetchAll(\PDO::FETCH_ASSOC); echo "\nactual using PDO driver:\n"; print_r($row); var_dump($row === $expectedRes);