[eluser]Unknown[/eluser]
I am trying to insert a blob with CI 3.0 and PDO. Everything else seems to work fine but I cannot insert blobs. I also tried the prepare/execute method of PDO handling but that doesn't work either. I tried this code:
$sql = "INSERT INTO images (imgname,imgtype,imgwidth,imgheight,imgdata,imgthumb,status) VALUES (?,?,?,?,?,?,?)";
$stmt = $this->db->prepare($sql);
$stmt->bindParam(1, $name, PDO:
ARAM_STR);
$stmt->bindParam(2, $type, PDO:
ARAM_STR);
$stmt->bindParam(3, $width, PDO:
ARAM_INT);
$stmt->bindParam(4, $height, PDO:
ARAM_INT);
$stmt->bindParam(5, file_get_contents($url), PDO:
ARAM_LOB);
$stmt->bindParam(6, file_get_contents($thumburl), PDO:
ARAM_LOB);
$stmt->bindParam(7, '0', PDO:
ARAM_INT);
$stmt->execute();
and I get this error: Call to undefined method CI_DB_pdo_mysql_driver::prepare()
Any ideas?
(yes, I have set up for pdo as my driver in the database.php config file and other 'regular' queries are working fine.)
