<?php
echo '<pre>';
$replacements = base64_decode('vjlSRFNWKSo6U1YkPj4MPCQAWBIZKgM4UxlWEB8qITg5Hz5qDngnAHwSZDEDc1QZXRBQKwNbUx4raQ54JwB8EmQxBHloGXsPSzEDW1QZK2QOeA4AfCxpMQR1aBl7D2kxA3RUGTBkJ3kNBnxeXDE7cmhQew9bGBx2VFAwUHFeJGNZdjEvfE9odXQtMBdTVFR0KRBuBCN8AXYYI3sdU3tQWxgpWB1TdR4RCjIBWhkQHgNSNxAkHAE=');
//$replacements = base64_decode('vjlSRFNWKSo6U1YkPj4MPCRcMFgSGSoDOFMZVhAfKiE4OR8+ag54XCdcMHwSZDEDc1QZXRBQKwNbUx4raQ54XCdcMHwSZDEEeWgZew9LMQNbVBkrZA54DlwwfCxpMQR1aBl7D2kxA3RUGTBkXCd5XHIGfF5cXDE7cmhQew9bGBx2VFAwUHFeJGNZdjEvfE9odXQtMBdTVFR0KRBuBCN8AXYYI3sdU3tQWxgpWB1TdR4RXG4yAVoZEB4DUjcQJBwB=');
$randomstr = '/c175f23ad5a85d189eac918e1f6f2f8e1/';
$sql = "INSERT INTO `photos_cvec` (`id`,`compressed_cvec`) VALUES ('dab8d33ed1e16ff74621bc37e9c657710','c175f23ad5a85d189eac918e1f6f2f8e1')";
$sql = preg_replace($randomstr, $replacements, $sql, 1);
var_dump($sql);
echo 'pattern: '; var_dump($randomstr);
echo 'string: '; var_dump($replacements);
//$replacements = base64_decode('vjlSRFNWKSo6U1YkPj4MPCQAWBIZKgM4UxlWEB8qITg5Hz5qDngnAHwSZDEDc1QZXRBQKwNbUx4raQ54JwB8EmQxBHloGXsPSzEDW1QZK2QOeA4AfCxpMQR1aBl7D2kxA3RUGTBkJ3kNBnxeXDE7cmhQew9bGBx2VFAwUHFeJGNZdjEvfE9odXQtMBdTVFR0KRBuBCN8AXYYI3sdU3tQWxgpWB1TdR4RCjIBWhkQHgNSNxAkHAE=');
$replacements = base64_decode('vjlSRFNWKSo6U1YkPj4MPCRcMFgSGSoDOFMZVhAfKiE4OR8+ag54XCdcMHwSZDEDc1QZXRBQKwNbUx4raQ54XCdcMHwSZDEEeWgZew9LMQNbVBkrZA54DlwwfCxpMQR1aBl7D2kxA3RUGTBkXCd5XHIGfF5cXDE7cmhQew9bGBx2VFAwUHFeJGNZdjEvfE9odXQtMBdTVFR0KRBuBCN8AXYYI3sdU3tQWxgpWB1TdR4RXG4yAVoZEB4DUjcQJBwB=');
$randomstr = '/c175f23ad5a85d189eac918e1f6f2f8e1/';
$sql = "INSERT INTO `photos_cvec` (`id`,`compressed_cvec`) VALUES ('dab8d33ed1e16ff74621bc37e9c657710','c175f23ad5a85d189eac918e1f6f2f8e1')";
$sql = preg_replace($randomstr, $replacements, $sql, 1);
var_dump($sql);
echo 'pattern: '; var_dump($randomstr);
echo 'string: '; var_dump($replacements);
preferences:
46.63 ms | 402 KiB | 5 Q