how to save my thumbnail image name into database

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
lukelee
Forum Commoner
Posts: 28
Joined: Wed Sep 10, 2008 2:03 am

how to save my thumbnail image name into database

Post by lukelee »

~pickle | Please use [ code=html ], [ code=php ], etc tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: :arrow: Posting Code in the Forums to learn how to do it too.


Now I can save both thumbnail and original image into folder, but i can only save the original image name into database. I think the problem is thumbnail code is within a class, and 'insert into' is outside of the class, see the red line [Mod note: [ color ] [ /color ] tags don't work inside proper [ code ][ /code ] tags, so it is no longer highlighted. Relevant line is line 124]. can anyone help me with that?

Code: Select all

<?php
require_once('db.php');   
$address = $_POST[house_address];
class resizeimage
{
        var $type;
        var $width;
        var $height;
        var $resize_width;
        var $resize_height;
        var $cut;
        var $srcimg;
        var $dstimg;
        var $im;
 
        function resizeimage($img, $wid, $hei,$c)
        {
 
                $this->srcimg = $img;
                $this->resize_width = $wid;
                $this->resize_height = $hei;
                $this->cut = $c;
 
                $this->type = substr(strrchr($this->srcimg,"."),1);
 
                $this->initi_img();
 
                $this -> dst_img();
 
                $this->width = imagesx($this->im);
                $this->height = imagesy($this->im);
 
                $this->newimg();
                ImageDestroy ($this->im);
        }
        function newimg()
        {
 
 
                $resize_ratio = ($this->resize_width)/($this->resize_height);
           
                $ratio = ($this->width)/($this->height);
                if(($this->cut)=="1")
               
                {
                        if($ratio>=$resize_ratio)
                       
                        {
                                 $newimg = imagecreatetruecolor($this->resize_width,$this->resize_height);
 
                                imagecopyresampled($newimg, $this->im, 0, 0, 0, 0, $this->resize_width,$this->resize_height, (($this->height)*$resize_ratio), $this->height);
 
                       
                                ImageJpeg ($newimg,$this->dstimg);
                                echo " ";
                       
                        }
                        if($ratio<$resize_ratio)
                   
                        {
                                $newimg = imagecreatetruecolor($this->resize_width,$this->resize_height);
                                imagecopyresampled($newimg, $this->im, 0, 0, 0, 0, $this->resize_width, $this->resize_height, $this->width, (($this->width)/$resize_ratio));
 
                                ImageJpeg ($newimg,$this->dstimg);
                                echo " ?";
                       
                        }
 
                }
                else
         
                {
                        if($ratio>=$resize_ratio)
                        {
                                $newimg = imagecreatetruecolor($this->resize_width,($this->resize_width)/$ratio);
                                imagecopyresampled($newimg, $this->im, 0, 0, 0, 0, $this->resize_width, ($this->resize_width)/$ratio, $this->width, $this->height);
 
 
 
                                ImageJpeg ($newimg,$this->dstimg);
                                echo " ";
                       
                        }
                        if($ratio<$resize_ratio)
                        {
                                $newimg = imagecreatetruecolor(($this->resize_height)*$ratio,$this->resize_height);
                                imagecopyresampled($newimg, $this->im, 0, 0, 0, 0, ($this->resize_height)*$ratio, $this->resize_height, $this->width, $this->height);
 
 
                               
 
                                ImageJpeg ($newimg,$this->dstimg);
                                echo " ";
                       
                        }
                }
 
               
        }
             
        function initi_img()
        {
                if($this->type=="jpg")
                {
                        $this->im = imagecreatefromjpeg($this->srcimg);
                }
                if($this->type=="gif")
                {
                        $this->im = imagecreatefromgif($this->srcimg);
                }
                if($this->type=="png")
                {
                        $this->im = imagecreatefrompng($this->srcimg);
                }
        }
     
        function dst_img()
        {
                $full_length  = strlen($this->srcimg);
                $type_length  = strlen($this->type);
                $name_length  = $full_length-$type_length;
                $name         = substr($this->srcimg,0,$name_length-1);
                $this->dstimg = $name."_small.".$this->type;
                # Highlighted line            
                $new_small = basename($this->dstimg);
            echo "Image has been edited, will go back to previous page in 3 sencond";
 
        }
}
 
$tempimgname = strtolower($_FILES["image1"][name]);
 
$tempimgname = mb_convert_encoding(   $tempimgname,   "gb2312",   "utf-8");
 
$tmpfiletype = substr(strrchr($tempimgname,"."),1);
 
if($tmpfiletype=="jpg" || $tmpfiletype=="gif" || $tmpfiletype=="png")
{
        if(copy($_FILES["image1"]["tmp_name"],strtolower("upload/".date("Y-m-d-h-m-s",time()).$tempimgname)))
        {
         
          $image1 = basename(strtolower("upload/".date("Y-m-d-h-m-s",time()).$tempimgname));
         $class = new resizeimage("upload/".date("Y-m-d-h-m-s",time()).$tempimgname, 260, 260, 1);
         $query = mysql_query("insert into house (address,thumb,imagedata1,imagedata) values ('$address','1','$new_small','$image1')");
                       
        }
        else
        {
            echo "Upload failed"."<br>";
        }
   
}
else
{
    echo "image only allows jpg,gif,png";
}
?>
~pickle | Please use [ code=html ], [ code=php ], etc tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: :arrow: Posting Code in the Forums to learn how to do it too.
User avatar
it2051229
Forum Contributor
Posts: 312
Joined: Tue Dec 25, 2007 8:34 pm

Re: how to save my thumbnail image name into database

Post by it2051229 »

i dont get it. You could do a mysql query after the red line so you could insert the name into the database.
Post Reply