Resizing a picture

[freeflow]

Hi everyone,

Can you help me with this code? I would like to resize a picture from a MySQL
database using PHP and the variable in a link to select the picture (..php?s=...)
What’s the best way to do this?

 

[todosa]

at first get your image data

	$query = "SELECT * from  binary_data where id='$id' ";		

	$sql_result = mysql_query($query,$config[connection]) or sql_error("Connection Error");
	while( $row = mysql_fetch_array( $sql_result) ) {

				$data = $row[bin_data];
	}

then optimize it to your rules

$width = 100;
$height = 100;

$im = imagecreatefromstring($data);
$new = imagecreatetruecolor($width, $height);
$x = imagesx($im);
$y = imagesy($im);
imagecopyresampled($new, $im, 0, 0, 0, 0, $width, $height, $x, $y);
imagedestroy($im);
header('Content-type: image/jpeg');
imagejpeg($new, null, 95);

thats all

 

[freeflow]

Perfect! It worked, thanks.

 

[albertosandras]

Well, I guess I am pretty late
someone's problem has already been resolved

anyways, for any further SQL related queries,
you can pm me

regards!!!