用以下方法查出来是乱码,请教?
<?
$sql = "select * from tkl_info";
$rs = mysql_query($sql);
$data = @MYSQL_RESULT($rs,0, "image");
$type = @MYSQL_RESULT($rs,0, "type");
header( "Content-type: $type");
while ($row = mysql_fetch_array ($rs)) {
?>
</tr>
<tr>
<td><?=$row['id']?> </td>
<td> <?=$row['type']?> </td>
<td> <?=$row['title']?> </td>
<td> <?=$row['www']?> </td>
<td> <?= $data ?> </td>
<td><a href="info.php?id=<?=$row['id']?>">删除</a> <a href="infoedit.php?id=<?=$row['id']?>&title=<?=$row['title']?>&www=<?= $row['www']?>">修改</a> </td>
</tr>
<?php
}
<?
$sql = "select * from tkl_info";
$rs = mysql_query($sql);
$data = @MYSQL_RESULT($rs,0, "image");
$type = @MYSQL_RESULT($rs,0, "type");
header( "Content-type: $type");
while ($row = mysql_fetch_array ($rs)) {
?>
</tr>
<tr>
<td><?=$row['id']?> </td>
<td> <?=$row['type']?> </td>
<td> <?=$row['title']?> </td>
<td> <?=$row['www']?> </td>
<td> <?= $data ?> </td>
<td><a href="info.php?id=<?=$row['id']?>">删除</a> <a href="infoedit.php?id=<?=$row['id']?>&title=<?=$row['title']?>&www=<?= $row['www']?>">修改</a> </td>
</tr>
<?php
}
图片应该是单独一个页面showimg.php,
HTML里使用<img src=showimg.php>来显示。
<?php
$data = 'iVBORw0KGgoAAAANSUhEUgAAABwAAAASCAMAAAB/2U7WAAAABl'
. 'BMVEUAAAD///+l2Z/dAAAASUlEQVR4XqWQUQoAIAxC2/0vXZDr'
. 'EX4IJTRkb7lobNUStXsB0jIXIAMSsQnWlsV+wULF4Avk9fLq2r'
. '8a5HSE35Q3eO2XP1A1wQkZSgETvDtKdQAAAABJRU5ErkJggg==';
$data = base64_decode($data);$im = imagecreatefromstring($data);
if ($im !== false) {
header('Content-Type: image/png');
imagepng($im);
imagedestroy($im);
}
else {
echo 'An error occurred.';
}
?>