PHP该如何显示图片
问题遇到的现象和发生背景
用PHP写了一个查询中药的功能，但是显示图片那一部分不知道应该怎样处理。
现在是在MySQL中插入的图片路径，然后在查询结果中也直接显示了路径(呆)
//没排格式 请忽略
用代码块功能插入代码，请勿粘贴截图
显示结果页面的代码
html>
<html>
<head>
<title>查询结果title>
<meta charset="UTF-8">
head>
<body>
<div id="kuangjia" style="width:1200px">
<div id="header" style="background-color:#99d6ea80;text-align:center">查询结果div>
$conn = mysqli_connect("localhost", "root", "123456") or die("数据库链接错误");
$db_selected=mysqli_select_db($conn,"SafeAskM");
$searchctm = isset($_POST['searchctm']) ? $_POST['searchctm']:'';
if(!empty($searchctm)) {
$sql = "SELECT cmname,anotname,plant,shape,taste,attribute,attention,picture FROM ask_cm WHERE cmname LIKE '%$searchctm%' or anotname LIKE '%$searchctm'";
$query = mysqli_query($conn,$sql);
while($row = mysqli_fetch_row($query)) {
$valuea = '';
foreach($row as $valuea){
echo $valuea;
}
}
}else{
echo"啊哦，页面不见了哦";
}
?>
<div id="footer" style="background-color:#99d6ea80;clear:both;text-align:center">⚠本站结果仅供参考，若有不适请您及时就医⚠div>
div>
body>
html>
数据库结构：
想要让它正常的显示图片！谢谢了！
查询到图片路径后，使用img输出就行
<?php
echo "<img src='你读出来的路径' />";
?>
<!DOCTYPE html>
<html>
<head>
<title>查询结果</title>
<meta charset="UTF-8">
</head>
<body>
<div id="kuangjia" style="width:1200px">
<div id="header" style="background-color:#99d6ea80;text-align:center">查询结果</div>
<?php
$conn = mysqli_connect("localhost", "root", "123456") or die("数据库链接错误");
$db_selected=mysqli_select_db($conn,"SafeAskM");
$searchctm = isset($_POST['searchctm']) ? $_POST['searchctm']:'';
if(!empty($searchctm)) {
$sql = "SELECT cmname,anotname,plant,shape,taste,attribute,attention,picture FROM ask_cm WHERE cmname LIKE '%$searchctm%' or anotname LIKE '%$searchctm'";
$query = mysqli_query($conn,$sql);
while($row = mysqli_fetch_row($query)) {
$valuea = '';
foreach($row as $valuea){
echo $valuea;
}
echo "<img src='".$row["picture"]."' />";
}
}else{
echo"啊哦，页面不见了哦";
}
?>
<div id="footer" style="background-color:#99d6ea80;clear:both;text-align:center">⚠本站结果仅供参考，若有不适请您及时就医⚠</div>
</div>
</body>
</html>
你要将图片回显到哪里？没看到你页面哪里绑定图片
你上传图片没有上传成功吧，给你一个上传图片的程序例子，图片保存成功以后用
<img src="<?php $rs['picurl']?>">
来显示图片：
$picurl=$_FILES["pic"]["name"];
if($picurl==''){
exit("请上传图片！");
}
$core_filetype='.jpg|.jpge|.gif|.png';
$img_type=array("image/gif","image/jpeg","image/jpg","image/pjpeg","image/x-png","image/png");
$core_filesize=400;
if($picurl!=""){
$fileextensionname=strtolower(preg_replace("/.+(\..+)/i","\\1",$picurl));
$filename = $deal_date.'_'.date('YmdHis').$fileextensionname;
if($_FILES["deal_voucher"]["error"]>0){
exit("图片上传失败！");
}elseif(!preg_match("/".$core_filetype."/i",$fileextensionname)){
exit("图片上传失败:上传的文件类型不被容许！");
}elseif(!in_array($_FILES["deal_voucher"]["type"],$img_type)){
exit("图片上传失败:上传的文件类型不被容许！！");
}elseif(($_FILES["deal_voucher"]["size"]/1024)>$core_filesize){
exit("图片上传失败:上传的文件大小超过".$core_filesize."KB限制！");
}else{
$imgsetpath="F:/website/upload/";//图片保存的路径
$directory=date('Y/m');
if(!file_exists($imgsetpath.$directory)){
if (mkdir($imgsetpath.$directory, 0777, true)){//目前不存在就创建
chmod($imgsetpath.$directory, 0777 );
}else{
exit("图片上传失败，创建文件夹失败 ".$imgsetpath.$directory."！");
}
}
if(copy($_FILES["deal_voucher"]["tmp_name"],$imgsetpath.$directory."/".$filename)){
}else{
exit("文件大小:".(round($_FILES["fileimg"]["size"]/1024, 2))."KB图片上传失败!!!！");
}
$picurl="/upload/".$directory."/".$filename;//把这个图片地址存进数据库
}
}
把pictrue字段单独挑出来，然后用一个img标签，给他赋src的值，这样你的图片就显示出来了，但是路径是ip+服务器静态文件存放的路径，不是那个D盘的路径
<!DOCTYPE html>
<html>
<head>
<title>查询结果</title>
<meta charset="UTF-8">
</head>
<body>
<div id="kuangjia" style="width:1200px">
<div id="header" style="background-color:#99d6ea80;text-align:center">查询结果</div>
<?php
$conn = mysqli_connect("localhost", "root", "123456") or die("数据库链接错误");
$db_selected=mysqli_select_db($conn,"SafeAskM");
$searchctm = isset($_POST['searchctm']) ? $_POST['searchctm']:'';
if(!empty($searchctm)) {
$sql = "SELECT cmname,anotname,plant,shape,taste,attribute,attention,picture FROM ask_cm WHERE cmname LIKE '%$searchctm%' or anotname LIKE '%$searchctm'";
$query = mysqli_query($conn,$sql);
while($row = mysqli_fetch_row($query)) {
$valuea = '';
foreach($row as $valuea){
echo $valuea;
}
echo "<img src='".$row["picture"]."' />";
}
}else{
echo"啊哦，页面不见了哦";
}
?>
<div id="footer" style="background-color:#99d6ea80;clear:both;text-align:center">⚠本站结果仅供参考，若有不适请您及时就医⚠</div>
</div>
</body>
</html>
参考代码如下：
<!DOCTYPE html>
<html>
<head>
<title>查询结果</title>
<meta charset="UTF-8">
</head>
<body>
<div id="kuangjia" style="width:1200px">
<div id="header" style="background-color:#99d6ea80;text-align:center">查询结果</div>
<?php
$conn = mysqli_connect("localhost", "root", "123456") or die("数据库链接错误");
$db_selected=mysqli_select_db($conn,"SafeAskM");
$searchctm = isset($_POST['searchctm']) ? $_POST['searchctm']:'';
if(!empty($searchctm)) {
$sql = "SELECT cmname,anotname,plant,shape,taste,attribute,attention,picture FROM ask_cm WHERE cmname LIKE '%$searchctm%' or anotname LIKE '%$searchctm'";
$query = mysqli_query($conn,$sql);
while($row = mysqli_fetch_row($query)) {
$valuea = '';
foreach($row as $valuea){
echo '<img src="$row["picture"]>" />';
}
}
}else{
echo"啊哦，页面不见了哦";
}
?>
<div id="footer" style="background-color:#99d6ea80;clear:both;text-align:center">⚠本站结果仅供参考，若有不适请您及时就医⚠</div>
</div>
</body>
</html>