Image upload, insert in to MySql, and Resize

esmith999 · February 13, 2012

Okay, so I found this code on-line that uploads images via a form, inserts them in to MySQL and displays the images on the page. It works great! Problem is, I spent a long time hacking this script to make it work with my site just to realize it did not re-size the image after it uploaded (dumb me). I have found other code that do this but I really do not want to start over at this point and my level of expertise with PHP are a step below what I need to figure this out. I am attaching the "original" code. If anyone knows how to add the necessary lines of code to make every image re-size (reduce) itself. I would very much appreciate it. Thanks

<?php

$con=mysql_connect("localhost", "root", "rootwdp")or die("cannot connect");

mysql_select_db("student",$con)or die("cannot select DB");

if(isset($_POST['upload']))

{

$img=$_FILES["image"]["name"];

foreach($img as $key => $value)

{

$name=$_FILES["image"]["name"][$key] ;

$tname=$_FILES["image"]["tmp_name"][$key];

$size=$_FILES["image"]["size"][$key];

$oext=getExtention($name);

$ext=strtolower($oext);

$base_name=getBaseName($name);

if($ext=="jpg" || $ext=="jpeg" || $ext=="bmp" || $ext=="gif"){

if($size< 1024*1024){

if(file_exists("upload/".$name)){

move_uploaded_file($tname,"upload/".$name);

$result = 1;

list($width,$height)=getimagesize("upload/".$name);

$qry="select id from img where `img_base_name`='$base_name' and `img_ext`='$ext'";

$res=mysql_fetch_array(mysql_query($qry));

$id=$res['id'];

$qry="UPDATE img SET `img_base_name`='$base_name' ,`img_ext`='$ext' ,`img_height`='$height' ,`img_width`='$width' ,`size`='$size' ,`img_status`='Y' where id=$id";

mysql_query($qry);

echo "Image '$name' updated<br />";

}

else{

move_uploaded_file($tname,"upload/".$name);

$result = 1;

list($width,$height)=getimagesize("upload/".$name);

$qry="INSERT INTO `img`(`id` ,`img_base_name` ,`img_ext` ,`img_height` ,`img_width`, `size` ,`img_status`)VALUES (NULL , '$base_name', '$ext', '$height', '$width', '$size', 'Y');";

mysql_query($qry);

echo "Image '$name' uploaded<br />";

}

else{

echo "Image size excedded.<br />File size should be less than 1Mb<br />";

}

else{

echo "Invalid file extention '.$oext'<br />";

}

function getExtention($image_name){

return substr($image_name,strrpos($image_name,'.')+1);

}

function getBaseName($image_name){

return substr($image_name,0,strrpos($image_name,'.'));

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

function addItems()

{

var table1 = document.getElementById('tab1');

var newrow = document.createElement("tr");

var newcol = document.createElement("td");

var input = document.createElement("input");

input.type="file";

input.name="image[]";

newcol.appendChild(input);

newrow.appendChild(newcol);

table1.appendChild(newrow);

}

function remItems()

{

var table1 = document.getElementById('tab1');

var lastRow = table1.rows.length;

if(lastRow>=2)

table1.deleteRow(lastRow-1);

}

</script>

a.tooltip:hover span{display:inline; position:absolute; border:2px solid #cccccc; background:#efefef; color:#333399;}

a.tooltip span

{display:none; padding:2px 3px; margin-left:8px; width:150px;}

</style>

</head>

<body>

<tr>

</tr>

</table>

</table>

</form>

<?

$qry="select * from img where img_status='Y' order by id";

$res=mysql_query($qry);

$i=0;

if(mysql_num_rows($res)){ ?>

<?

while($fetch=mysql_fetch_array($res)){

$hratio=120/$fetch['img_height'];

$wratio=120/$fetch['img_width'];

$ratio=($hratio < $wratio) ? $hratio : $wratio;

$hth=$fetch['img_height']*$ratio;

$wth=$fetch['img_width']*$ratio;

?>

<li style="width:120px; height:180px; border:0px solid #333;float:left;list-style:none outside none; padding-right:5px;"><img src="upload/<? echo $fetch['img_base_name'].'.'.$fetch['img_ext']; ?>" width="<? echo $wth; ?>" height="<? echo $hth; ?>" title="<? echo "image : ".$fetch['img_base_name'].".".$fetch['img_ext']; ?>" /><br />

<?

if($i==0)

$fp=fopen("fileInfo.txt",'w');

else

$fp=fopen("fileInfo.txt",'a');

fwrite($fp,"Image : ".++$i ."\r\n");

fwrite($fp,"Name : ".$fetch['img_base_name'].".".$fetch['img_ext']."\r\n");

fwrite($fp,"width X height :

".$fetch['img_width']." X ".$fetch['img_height']."\r\n");

fwrite($fp,"Size : ".round($fetch['size']/1024,1)."Kb\r\n");

fwrite($fp,"____________________________________\r\n");

fclose($fp);

echo $fetch['img_base_name'].".".$fetch['img_ext'].'<br />';

echo $fetch['img_width'].' X ';

echo $fetch['img_height'].'<br />';

echo round($fetch['size']/1024,1) .'Kb';

?>

</li>

<?

}?>

</ul>

</div><? }?>

</td></tr></table>

</body>

</html>

scootstah · February 13, 2012

I'm not going to attempt to look at that code, on account of you didn't put it in code tags and you have absolutely no indentation. I'm too tired for that headache.

However, the PHP manual shows you how to resize images: http://php.net/manual/en/function.imagecopyresampled.php

Sign In

Image upload, insert in to MySql, and Resize

Recommended Posts

esmith999

Link to comment

Share on other sites

scootstah

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information