By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,278 Members | 1,357 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,278 IT Pros & Developers. It's quick & easy.

uploading and saving images into a mysql database

tolkienarda
100+
P: 316
hi all

i need to allow people to upload images to my site and then save them in a mysql database. i've looked at some prebuilt scripts using iframes but i don't think that will work for me. I want the standard browse button for selecting an image, and when the find a file i want to save into my mysql database later i will need to put this image into an <img> tag i've done some searches through other posts but couldn't find what i was looking for.

i would grateful for any help

eric
Feb 13 '07 #1
Share this Question
Share on Google+
5 Replies


ronverdonk
Expert 2.5K+
P: 4,258
So what are you looking for now? Help with your upload code?
Then show what code you have developed so far.

Ronald :cool:
Feb 13 '07 #2

tolkienarda
100+
P: 316
ok here is my problem

since i didn't write the code below i kinda feel bad asking questions about it. but when i upload an image none of the img data is uploaded but the img title text is saved into it's approate table i the problem could be that php upload isn't enabled for my server i don't know how that is done if it is a command or if you need to get onto the server to do it.

if you want to look at this my site is
http://www.steppinupwebdesign.com/cms/imgupload.php
and the demo of this on the writers site is
http://www.wellho.net/demo/pic_up.php4

thanks for any help

eric

the code is below
[PHP]

if ($_REQUEST[completed] == 1) {
// Need to add - check for large upload. Otherwise the code
// will just duplicate old file ;-)
// ALSO - note that latest.img must be public write and in a
// live appliaction should be in another (safe!) directory.
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 ();
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html><head>
<title>Upload an image</title>
<body bgcolor=white><h2>latest picture</h2>
<font color=red><?= $errmsg ?></font>
<center><img src= width=144><br>
<b><?= $title ?></center>
<form enctype=multipart/form-data method=post>
<input type=hidden name=MAX_FILE_SIZE value=150000>
<input type=hidden name=completed value=1>
File:<input type=file name=imagefile><br>
comment:<input name=whatsit><br>
then: <input type=submit></form><br>
</body>
</html>
[/PHP]
Feb 13 '07 #3

tolkienarda
100+
P: 316
hi

is there any command i can use to determine if php upload is enabled on my server

eric
Feb 13 '07 #4

ronverdonk
Expert 2.5K+
P: 4,258
Run phpinfo() and look at the PHP Core info. The item 'file_uploads' should be set ON.

Ronald :cool:
Feb 13 '07 #5

tolkienarda
100+
P: 316
ok turns out that it was on so now i don't know what my problem is
any ideas based on the code. the mysql query looks kinda funny here it is i've never seen one written like it but i don't know if it is wrong or just different

[PHP]
mysql_query ("insert into pix (title, imgdata) values (\"".
$_REQUEST[whatsit].
"\", \"".
$image.
"\")");
[/PHP]

thanks

eric
Feb 13 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.