下面是我的php代码,我用它来检索mysql数据库中blob类型的3个图像!
虽然我成功地检索了它们,但我不明白如何嵌入html代码以控制检索图像的高度和宽度!
也在这里我能够检索png类型的图像。
请根据我上传到数据库的图片的格式帮我检索任何格式的图片(例如jpeg)(我已经获得了上传图片的类型)。(如- $images1=getimagesize($_FILES['Image1']['tmp_name']);
$imagetype1=$images1['mime'];)
.
所以我需要两个主要的帮助:
-
调整从上述php代码检索到的图像的宽度和高度
-
检索格式为
的图像<?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);
?>