[PHP][MYSQL] Resource id #18

[GewoonNico]

Ik probeer via een form een plaatje in een database te mikken...


script:

PHP:

<?
function img_to_db($image,$tablename,$maxthumbwidth,$maxthumbheight,$maxoriginalwidth,$maxoriginalheight)
    {
    // Thumb Maken
    $maxX = $maxthumbwidth; 
    $maxY = $maxthumbheight; 
    $imgsize = getimagesize($image);        
    switch($imgsize[2]) 
        {
        case 1:
            $timg = imageCreateFromGIF($image);
            $type = "gif";
            break;
        case 2:
            $timg = imageCreateFromJPEG($image);
            $type = "jpg";
            break;
        case 3:
            $timg = imageCreateFromPNG($image);
            $type = "png";
            break;
        }

    $type = "jpg";
    $imgX = $imgsize[0];
    $imgY = $imgsize[1];
    $_X = $imgX/$maxX * 100;
    $_Y = $imgY/$maxY * 100;
    if((100-$_X) < (100-$_Y))
        {
        $_K = $_X;
        }
    else 
        {
        $_K = $_Y;
        }
    $newX = floor($imgX/$_K * 100);
    $newY = floor($imgY/$_K * 100);
    $imgh = imageCreateTrueColor($newX, $newY);
    imagecopyresized($imgh, $timg, 0,0,0,0,$newX,$newY,$imgX,$imgY);

    //$db_thumb = ImageJPEG($imgh,"",100);
    //$fullfile = fread(fopen($db_thumb,"r"),filesize($db_thumb)); 
    //$coded = chunk_split(base64_encode($db_thumb)); 
    $coded = addslashes($imgh);

    mysql_query("INSERT INTO ".$tablename." (img_small) VALUES('".$coded."')");
}
?>

Uitleesscript:

PHP:

<?
define("INCMS", "TRUE");
// Extra beveiliging

require("../includes/settings.php");
header("Content-type: image/jpeg"); 

if ($_GET['s'] == "t")  { $size = "img_small"; }
else                    { $size = "img_large"; }

$imageq = mysql_query("SELECT * FROM ".$_GET['t']." WHERE id='".$_GET['id']."'");
$row = mysql_fetch_array($imageq);
$image = $row["".$size.""];

echo("".$image."");

?>

Uitkomst als ik het plaatje wil bekijken:
Resource id #18


in de database staat wel [BLOB - 15 Bytes]
Dus naar mijn mening staat er toch iets in...


Wie kan me helpen....

[T-Blizzard]

//Binaire data van een thumb inlezen
function getBinaryDataT()
{
ob_start();
imagejpeg($this->tempthumb);
$this->binarydataT = ob_get_contents();
ob_end_clean();
}

Ik deed het in mijn classe altijd zo met behulp van output buffering.

[GewoonNico]

Thanx


Voor diegene die t ook eens willen proberen: Dit is mijn uiteindelijke script geworden

PHP:

<?
function getbinarydata($img)
    {
    ob_start();
    imagejpeg($img,"",100);
    $db_img = ob_get_contents();
    return $db_img;
    ob_end_clean();
    }


function img_to_db($image,$tablename,$maxthumbwidth,$maxthumbheight,$maxoriginalwidth,$maxoriginalheight)
    {
    // Thumb Maken
    $maxX = $maxthumbwidth; 
    $maxY = $maxthumbheight; 
    $imgsize = getimagesize($image);        
    switch($imgsize[2]) 
        {
        case 1:
            $timg = imageCreateFromGIF($image);
            $type = "gif";
            break;
        case 2:
            $timg = imageCreateFromJPEG($image);
            $type = "jpg";
            break;
        case 3:
            $timg = imageCreateFromPNG($image);
            $type = "png";
            break;
        }

    $type = "jpg";
    $imgX = $imgsize[0];
    $imgY = $imgsize[1];
    $_X = $imgX/$maxX * 100;
    $_Y = $imgY/$maxY * 100;
    if((100-$_X) < (100-$_Y))
        {
        $_K = $_X;
        }
    else 
        {
        $_K = $_Y;
        }
    $newX = floor($imgX/$_K * 100);
    $newY = floor($imgY/$_K * 100);
    $imgh = imageCreateTrueColor($newX, $newY);
    imagecopyresized($imgh, $timg, 0,0,0,0,$newX,$newY,$imgX,$imgY);
    
    $coded = addslashes(getbinarydata($imgh));
    mysql_query("INSERT INTO ".$tablename." (img_small) VALUES('".$coded."')");
}
?>

[ Voor 6% gewijzigd door GewoonNico op 26-08-2004 18:11 ]

[4Real]

Kleine verandering:

PHP:

$imageq = mysql_query("SELECT * FROM ".$_GET['t']." WHERE id='".$_GET['id']."'"); 
$row = mysql_fetch_array($imageq); 
$image = $row["".$size.""]; 

echo("".$image.""); 

?> 

Naar:

PHP:

$imageq = mysql_query("SELECT * FROM ".$_GET['t']." WHERE id='".$_GET['id']."'"); 
$row = mysql_fetch_array($imageq); 
$image = $row[$size]; 

echo($image); 

?> 

$row["".$size.""]; "".$size."" is overbodig kan ook zonder die "". .""