php把上传的图片保存到数据库并显示代码
发布:smiling 来源: PHP粉丝网 添加日期:2014-09-12 09:16:54 浏览: 评论:0
- // Connect to database
- $errmsg = "";
- if (! @mysql_connect("localhost","root","")) {
- $errmsg = "Cannot connect to database";
- }
- @mysql_select_db("db1");
- $q = <<<CREATE
- create table pix (
- 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 ();
- }
- ?>
- 代码如下 复制代码
- <html><head>
- <title>Upload an image to a database</title>
- <body bgcolor=white><h2>Here's the latest picture</h2>
- <font color=red><?= $errmsg ?></font>
- <center><img src= width=144><br>
- <b><?= $title ?></center>
- <hr>
- <h2>Please upload a new picture and title</h2>
- <form enctype="multipart/form-data" method="post">
- <input type="hidden" name="MAX_FILE_SIZE" value=150000>
- <input type="hidden" name="completed" value=1>
- Please choose an image to upload: <input type="file" name="imagefile"><br>
- Please enter the title of that picture: <input name="whatsit"><br>
- then: <input type="submit"></form><br>
- //开源代码phpfensi.com
- </body>
- </html>
Tags: php上传图片 php保存数据库
推荐文章
热门文章
最新评论文章
- 写给考虑创业的年轻程序员(10)
- PHP新手上路(一)(7)
- 惹恼程序员的十件事(5)
- PHP邮件发送例子,已测试成功(5)
- 致初学者:PHP比ASP优秀的七个理由(4)
- PHP会被淘汰吗?(4)
- PHP新手上路(四)(4)
- 如何去学习PHP?(2)
- 简单入门级php分页代码(2)
- php中邮箱email 电话等格式的验证(2)