thumbnails

[corillo181]

<?php
// The file name you wish to get
$filename = 'images/pic.jpg';

// Content type
header('Content-type: image/jpeg');

//takes the with and height of file
list($width, $height) = getimagesize($filename);

$newWidth=120;

$newHeight=intval($height*$newWidth/$width);

$oldImage=ImageCreateFromJPEG("$filename");

$newImage=ImageCreateTrueColor($newWidth,$newHeight);

imagecopyresampled($newImage,$oldImage,0,0,0,0,$newWidth,$newHeight,$width,$height);

ImageJPEG($newImage,"TN"."jhon.jpg");
?>


i got this code, but i would like to know how can i make this so i can put it on mysql..


becuase the imageJPEG() function saves the picture and makes the picture show on the page i just want to keep the picture in a variable so i can insert it in the sql table i got set up..

if you need a better explanation please let me know..

[corillo181]

why are pictures realated question so hard for people to answer?
everytime i got one i get a response in like weke or 2..

and i cna never find a tutorial that focus on everything about image..
is there something else better to use image then php?

[fert]

what are you asking?

[corillo181]

i'm asking that code i posted how can i make it so i can save the picture turned into a thumbnail in to a mysql table.

[fert]

[code]
$cn=@mysql_connect("host","username","password") or die(mysql_error());
@mysql_select_db("name",$cn) or die(mysql_error());

$file=@fopen("test.jpg","r");
$text=@fread($file,filesize("test.jpg"));
@fclose($file);

@mysql_query("INSERT INTO `table` (picture) VALUES('$text')",$cn) or die(mysql_error());
[/code]
in the table picture must be a BLOB

[corillo181]

not trying to save the actual picture in mysql..

i just want to get the name as a variable tha tis what i dont know how to do..

get a variable name out of the code i showed..