<?php
$pdo = new PDO('sqlite::memory:');
$pdo->exec('CREATE TABLE test (a INTEGER, b BLOB);');
$fp = tmpfile();
fwrite($fp, 'Random stuff!');
fseek($fp, 0);
$stmt = $pdo->prepare('INSERT INTO test VALUES (?, ?);');
$stmt->bindValue(1, 42);
$stmt->bindParam(2, $fp, PDO::PARAM_LOB);
$stmt->execute();
var_dump(gettype($fp));
- Output for 7.0.0 - 7.0.33, 7.1.0 - 7.1.33, 7.2.0 - 7.2.34, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.33, 8.2.0 - 8.2.29, 8.3.0 - 8.3.25, 8.4.1 - 8.4.12
- string(6) "string"
- Output for 5.6.0 - 5.6.40
- string(8) "resource"
preferences:
151.57 ms | 407 KiB | 5 Q