[原创]请教高手--在线等--一起PHP技术联盟

[原创]请教高手--在线等

在下面有2个文件，问题是：我想从数据库中读取图片数据的内容（图片存放在Blob字段中）在浏览器中显示，但是，运行list.php后，不显示图片。请高手赐教！
1、list.php   内容如下：

<body>
<form action="" method="post">
<table width="100%" align="center" bordercolor="#00CC33" bgcolor=#CCCCCC class="listTable">
  <tr class = "border">
    <td width="6%"><div align="center" class="style1"><strong>id</strong></div></td>
    <td width="10%"><div align="center" class="style1"><strong>图片预览</strong></div></td>
    <td width="7%"><div align="center" class="style1"><strong>文件名</strong></div></td>
    <td width="7%"><div align="center" class="style1"><strong>类型</strong></div></td>
    <td width="7%"><div align="center" class="style1"><strong>描述</strong></div></td>
    <td width="11%"><div align="center" class="style1"><strong>分类</strong></div></td>
    <td width="16%"><div align="center" class="style1"><strong>日期</strong></div></td>
    <td width="22%"><div align="center" class="style1"><strong>作者</strong></div></td>
  </tr>
  <?php
  if( isset($_GET['page']) ){
$page = intval( $_GET['page'] );
}
else{
$page = 1;
}
$page_size = 20;
$sql = "select count(*) as amount from hetal_photos";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$amount = $row["amount"];
if( $amount ){
if( $amount < $page_size ){ $page_count = 1; }
if( $amount % $page_size ){
$page_count = (int)($amount / $page_size) + 1;
}else{
$page_count = $amount / $page_size;
}
}
else{
$page_count = 0;
}
$page_string = '';
if( $page == 1 ){
$page_string .= '第一页 | 下一页|';
}
else{
$page_string .= '<a href=?page=1>第一页</a>|<a href=?page='.($page-1).'>上一页</a>|';
}
if( ($page == $page_count) || ($page_count == 0) ){
$page_string .= '下一页 | 尾页';
}
else{
$page_string .= '<a href=?page='.($page+1).'>下一页</a>|<a href=?page='.$page_count.'>
尾页</a>';
}
if( $amount )
{
$sql = "select * from hetal_photos order by id desc limit ". ($page-1)*$page_size .", $page_size";
$result = mysql_query($sql);
while ( $row = mysql_fetch_array($result) )
{
  ?>
  <tr class = "border">
<td><?php echo $row["id"]; ?>
  <div align="center"></div></td>
<td><img src="include/show.php?id=<?php echo $row["id"]; ?>" width=102 height=76>
  <div align="center"></div></td>
<td><?php echo $row["filename"]; ?>
  <div align="center"></div></td>
<td><?php echo $row["filetype"]; ?>
  <div align="center"></div></td>
<td><?php echo $row["describe"]; ?>
  <div align="center"></div></td>
<td><?php echo $row["sort"]; ?>
  <div align="center"></div></td>
<td><?php echo $row["datetime"]; ?>
  <div align="center"></div></td>
<td><?php echo $row["user"]; ?>
  <div align="center"></div></td>
<td><div align="center"><a href="add.php">增加 </a> | <a href="modify.php?id=<?php echo $row["id"]; ?>">修改</a> | <a href="delete.php?id=<?php echo $row["id"]; ?>">删除</a></div></td>
  </tr>

  <?php
}
}
else
{
$rowset = array();
}
  ?>
     <tr>
<td colspan="9"><?php echo $page_string; ?></td>
  </tr>
</table>
</form>
</body>

2、show.php  内容如下

<?php
include("cfg.php");
//include("common.php");

//$id=1;
//echo $id."nothing is output";
if($id)
{
$query="select * from hetal_photos where id=$id";
//echo $query;
$result=mysql_query($query);
if($result)
{
$row=mysql_fetch_object($result);
//$data=mysql_result($result,0,"bindata");
//$type=mysql_result($result,0,"filetype");
//$describle=mysql_result($result,0,"describle");
Header( "Content-type: image/gif");

//Header("Content-type:$type");
echo  $row->bindata;
}
else{
echo "wrong!";echo $id;
}
}
?>

	页数1/1: 首页 « 1 » 末页
发表回复：您还没有登陆，无法发表回复。请先[登陆]