最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
php把上传的图保存到数据库并显示代码
时间:2010-05-25 编辑:简简单单 来源:一聚教程网
// Connect to database
代码如下 | 复制代码 |
$errmsg = ""; if (! @mysql教程_connect("localhost","root","")) { $errmsg = "Cannot connect to database"; } @mysql_select_db("db1"); $q = << pid int primary key not null auto_increment, title text, imgdata longblob) CREATE; @mysql_query($q); |
// Insert any new image into database
代码如下 | 复制代码 |
if ($_REQUEST[completed] == 1) { move_uploaded_file($_FILES['imagefile']['tmp_name'],"latest.img"); $instr = fopen("latest.img","rb"); $image = addslashes(fread($instr,filesize("latest.img"))); if (strlen($instr) < 149000) { mysql_query ("insert into pix (title, imgdata) values ("". $_REQUEST[whatsit]. "", "". $image. "")"); } else { $errmsg = "Too large!"; } } |
// Find out about latest image
代码如下 | 复制代码 |
$gotten = @mysql_query("select * from pix order by pid desc limit 1"); if ($row = @mysql_fetch_assoc($gotten)) { $title = htmlspecialchars($row[title]); $bytes = $row[imgdata]; } else { $errmsg = "There is no image in the database yet"; $title = "no database image available"; // Put up a picture of our training centre $instr = fopen("../wellimg/ctco.jpg","rb"); $bytes = fread($instr,filesize("../wellimg/ctco.jpg")); } |
// If this is the image request, send out the image
if ($_REQUEST[gim] == 1) {
header("Content-type: image/jpeg");
print $bytes;
exit ();
}
?>
代码如下 | 复制代码 |
Here's the latest picture= $errmsg ?> = $title ?> Please upload a new picture and title |
-
上一个: php google地图应用实例代码
相关文章
- PHP导出数据超时的优化建议解读 10-31
- PHP之mysql位运算解析 10-31
- Laravel实现登录跳转功能解析 10-31
- php双向队列解读 10-31
- Laravel异常上下文解决教程 10-24
- php数组查询元素位置方法介绍 10-24