I'm wondering what i'm gonna do. If i want to resize an image when i insert it into the db.. I know that it's better to don't save image on database.. But i have to do this for save space on my little server.. Currently i use this code to save the image:
if (isset($_FILES['immagine']) && $_FILES['immagine']['size'] > 0)
{
$imageName = $_FILES["immagine"]["name"];
$imageData = file_get_contents($_FILES["immagine"]["tmp_name"]);
$imageType = $_FILES["immagine"]["type"];
if(substr($imageType,0,5)=="image")
{
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $dbh->prepare("UPDATE `".$_SESSION['id']."` SET immagine = ?, type = ?, profilo = 1 WHERE profilo = 1");
$stmt->bindParam(1,$imageData,PDO::PARAM_LOB);
$stmt->bindParam(2,$imageType,PDO::PARAM_STR);
$stmt->execute();
}
}