如何從MySQL數(shù)據(jù)庫檢索圖像并在html標(biāo)記中顯示我使用phpmyadmin創(chuàng)建了一個(gè)帶有表的MySQL數(shù)據(jù)庫。我用BLOB列創(chuàng)建了這個(gè)表來保存jpeg文件。我對php變量有問題。$result這里。到目前為止，我的代碼：(Director.php)：<body><?php
$link = mysql_connect("localhost", "root", "");
mysql_select_db("dvddb");
$sql = "SELECT dvdimage FROM dvd WHERE id=1";
$result = mysql_query("$sql");
mysql_close($link);?><img src="" width="175" height="200" /></body>如何將PHP中的變量$結(jié)果輸入到HTML中，以便將其顯示在<img>標(biāo)簽？
3 回答
函數(shù)式編程
TA貢獻(xiàn)1807條經(jīng)驗(yàn) 獲得超9個(gè)贊
<body><img src="getImage.php?id=1" width="175" height="200" /></body>
<?php
$id = $_GET['id'];
// do some validation here to ensure id is safe
$link = mysql_connect("localhost", "root", "");
mysql_select_db("dvddb");
$sql = "SELECT dvdimage FROM dvd WHERE id=$id";
$result = mysql_query("$sql");
$row = mysql_fetch_assoc($result);
mysql_close($link);
header("Content-type: image/jpeg");
echo $row['dvdimage'];?>
莫回?zé)o
TA貢獻(xiàn)1865條經(jīng)驗(yàn) 獲得超7個(gè)贊
<img src="data:image/jpeg;base64,<?php echo base64_encode( $image_data ); ?>" />
心有法竹
TA貢獻(xiàn)1866條經(jīng)驗(yàn) 獲得超5個(gè)贊
while($row = mysql_fetch_array($result)) {
echo "img src='",$row['filename'],"' width='175' height='200' />";}添加回答
舉報(bào)
0/150
提交
取消