db(); $client = $db->getClient(); $statement = $client->prepare("INSERT into testretrieve (`value`) values" /> Skip to main content

Replied to a post on github.com :

```
$key = str_pad("A Long Post ", 2000000, 'x');

$db = \Idno\Core\Idno::site()->db();
$client = $db->getClient();

$statement = $client->prepare("INSERT into testretrieve (`value`) values (:value)");
if ($result = $statement->execute([':value' => $key])) {
echo "Saved\n";

$statement2 = $client->prepare("SELECT * from testretrieve where value = :value");

if ($result2 = $statement2->execute([':value' => $key])) {
print_r($statement2->fetch(\PDO::FETCH_ASSOC));
}
}
```

returns as expected...