php上传图片的代码

代码是朋友给我的。
在xampp创建一个database叫picture。

然后创建table，类型是MyISAM:
CREATE TABLE `binary_data` (
`id` int(11) NOT NULL auto_increment,
`file` longblob NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=65 ;

---

创建connect.php

<?php
$link = mysql_connect("localhost","root","") or die('Could not connect : ' .mysql_error());
mysql_select_db("picture",$link);
?>

创建test1.php

<?
if($_POST['confirm'] != "")
{
$pic = $_FILES["pic"]['tmp_name'];

$pic1 = addslashes(fread(fopen($pic,"r"),filesize($pic)));

include("connect.php");
$sql = "insert into binary_data(file) values ('$pic1')";

mysql_query($sql);
}
?>
<form name="form123" method="post" action="test1.php" enctype="multipart/form-data">
<input type="file" name="pic">
<input type="submit" name="confirm" value="ok">

<?
include("connect.php");
$sql1 = "select * from binary_data ORDER BY id";
$result = mysql_query($sql1);

if (mysql_num_rows($result)>0)
{
while($display=mysql_fetch_array($result))
{
$id_row = $display["id"];
?><br><a href="test3.php?id=<?echo $id_row;?>">view</a><?
}
}

/*$row = mysql_fetch_object($result);
$num_row = mysql_num_rows($result);

for($i=$id_row;$i<=$num_row; $i++)
{
?>

<?}*/?>
</form>

创建test2.php

<?
if(isset($_GET['id']))
{
$id = $_GET['id'];

include("connect.php");

$sql = "select file from binary_data where id='$id'";
$result = mysql_query($sql);

$picpic = MYSQL_RESULT($result,0,"file");
echo $picpic;
}

?>

创建test3.php

<script>
function saveImageAs (imgOrURL) {
if (typeof imgOrURL == 'object')
imgOrURL = imgOrURL.src;
window.win = open (imgOrURL);
setTimeout('win.document.execCommand("SaveAs")', 500);
}
</script>

<?
if($_GET['id'] != "")
{
?>

<a href="#" ONCLICK="saveImageAs(document.getElementById('embedImage')); return false" >
<img id="embedImage" src=test2.php?id=<?echo $_GET['id'];?>></a>
<?}?>
<br><center><a href="test1.php">Back</a></center>