调整图像大小和图像格式


Resizing images and image formats

下面是我的php代码,我用它来检索mysql数据库中blob类型的3个图像!

虽然我成功地检索了它们,但我不明白如何嵌入html代码以控制检索图像的高度和宽度!

也在这里我能够检索png类型的图像。

请根据我上传到数据库的图片的格式帮我检索任何格式的图片(例如jpeg)(我已经获得了上传图片的类型)。(如- $images1=getimagesize($_FILES['Image1']['tmp_name']); $imagetype1=$images1['mime'];) .

所以我需要两个主要的帮助:

  1. 调整从上述php代码检索到的图像的宽度和高度

  2. 检索格式为

    的图像
    <?php
            require("includes/db.php");
            $sql="SELECT * FROM `order` ";
            $result=mysqli_query($db,$sql);
    echo "<table>";
    
    while($row=mysqli_fetch_array($result))
    {
    echo"<tr>";
     echo"<td>";
    echo $row["OrderNo."];
     echo "<br>";
     echo"</td>";
     echo"<td>";
    echo $row["NIC"];
     echo "<br>";
     echo"</td>";
     echo"<td>";
    echo $row["DP"];
     echo "<br>";
     echo"</td>";
     echo"<td>";
    echo $row["Address"];
     echo "<br>";
     echo"</td>";
     echo"<td>";
    echo $row["DPTime"];
     echo "<br>";
     echo"</td>";
     echo"<td>";
    echo $row["Telephone"];
     echo "<br>";
     echo"</td>";
     echo"<td>";
    echo $row["Email"];
     echo "<br>";
     echo"</td>";
    echo"<td >";
    echo '<img src="data:image/png;base64,'.base64_encode( $row['Image1'] ).' " />';
    echo "<br>";
     echo"</td>";
    echo"<td >";
    echo '<img src="data:image/png;base64,'.base64_encode( $row['Image2'] ).' "/>';
    echo "<br>";
     echo"</td>";
      echo"<td >";
     echo '<img src="data:image/png;base64,'.base64_encode( $row['Image3'] ).' "/>';
    echo "<br>";
     echo"</td>";
     echo"</tr>";
    }
    echo "</table>";
    ?>
    
  <?php
// This is the temporary file created by PHP
$uploadedfile ="search.png";
// Create an Image from it so we can do the resize
 $info = getimagesize($uploadedfile);
if ($info['mime'] == 'image/jpeg') 
        $src = imagecreatefromjpeg($uploadedfile);
    elseif ($info['mime'] == 'image/gif') 
        $src = imagecreatefromgif($uploadedfile);
    elseif ($info['mime'] == 'image/png') 
        $src = imagecreatefrompng($uploadedfile);
//$src = imagecreatefromjpeg($uploadedfile);

list($width,$height)=getimagesize($uploadedfile);
$newwidth=80;
$newheight=($height/$width)*80;
$tmp=imagecreatetruecolor($newwidth,$newheight);

imagecopyresampled($tmp,$src,0,0,0,0,$newwidth,$newheight,$width,$height);

$filename =$uploadedfile;
imagejpeg($tmp,$filename,100);
imagedestroy($src);
imagedestroy($tmp);





?>