Hexadecimal string cut when doing Insert with PDO

Question

Good afternoon, you guys! I would like some help from you to solve a problem that is happening to me. I have a hexadecimal string containing an images that should be added to the database, when I do the Insert with PDO without the bindValue, passing the variable value directly to the SQL string, works perfectly:

$sql = "INSERT INTO arquivos (arquivo) Value($this->Arquivo)";

try{
$stmt = $this->db->prepare( $sql );
//outros campos...
$stmt->execute();
}...

however, if I do via bindValue:

$sql = "INSERT INTO arquivos (arquivo) Value(:Arquivo)";
try{
$stmt = $this->db->prepare( $sql );
$stmt->bindValue( ':Arquivo', $this->Arquivo );
$stmt->execute();
}...

the value is cut, and the image gets corrupted.

How do I fix this? is it a setup? I’d like to use it all via bindValue.

Answer 1

The rray that’s right.

For large content (type BLOB for example), you must enter the data type: PDO::PARAM_LOB

The code would look like this:

$sql = "INSERT INTO arquivos (arquivo) Value(:Arquivo)";
try{
    $stmt = $this->db->prepare( $sql );
    $stmt->bindValue( ':Arquivo', $this->Arquivo, PDO::PARAM_LOB);
    $stmt->execute();
}

Other version:

$sql = "INSERT INTO arquivos (arquivo) Value(?)";
try{
    $stmt = $this->db->prepare( $sql );
    $stmt->bindParam(1, $this->Arquivo, PDO::PARAM_LOB);
    $stmt->execute();
}

If it doesn’t work, add the code below before the EXECUTE, and check if this property actually contains the correct string:

echo '<pre>';
var_dump($this->Arquivo);
echo '</pre>';

I suggest you read this article on the subject: Writing BD files using PHP PDO