upload jpeg images using mysql and php

LumpLesh

I'm new to this site and also a true newbie. I am trying to make a site and am using mysql and php. I want my site to allow users to submit photos of themselves. Does anyone have a very simple script that will allow a user to upload a pic to my server in a file and at the same time put the info in a table in mysql that tells the name of the file, filetype and the users id or member name. Oh yes, almost forgot...how to retrieve the image too. Thanks everyone!!🙂

[deleted]

Give this a try:

http://codewalkers.com/tutorials/35/1.html

should get you started anyways...

OwenTheSamoan

I'm interested in this also, but I want to store my image in a file on a remote server not as a blob in a database. But I would like to store in a table in my database all info about the image and the site member that it belongs to.

stolzyboy

don't ever put images IN your database,IT IS SLOW AND UNRELIABLE, the following will store information about the file you are placing in the folder you specify, this is for a doc uploader, but just replace the a href with an img tag and the info from the mysql data and it will pull it back correctly


<?
$conn = mysql_connect("localhost", "mysqluser", "mysqlpass") or die ("Could not connect to database!"); 
$db = mysql_select_db("databasename") or die ("Could not select database"); 
$queryview = "select * from tablename"; 
$resultview = mysql_query($queryview) or die ("Could not upload file"); 

while ($rowview = mysql_fetch_array($resultview)) 
{ 
?> 
<a href="<? echo $row['fieldname1']; ?>" target="_blank"><? echo $row 'fieldname1']; ?>"></a><br><br> 
} 
<? 
if (isset($upload)) 
{ 
$conn = mysql_connect("localhost", "mysqluser", "mysqlpass") or die ("Could not connect to database!"); 
$db = mysql_select_db("databasename") or die ("Could not select database"); 

if ($doc_type == "application/pdf") // this will be different depending on file type ie a jpg would be "image/pjpeg" it checks more than just the extension so if someone made a vbscript file and changed the extension to .jpg, it wouldn't let you upload 

{ 
copy($doc, "file path" . $doc_name); // make sure you have write permissions to directory 
echo "<br>File uploaded successfully"; 

$query = "insert into table name (fieldname1) values ('$doc_name');"; 
$result = mysql_query($query) or die ("Could not upload file"); 
} 
else 
{ 
echo "<br>Files must have certain extension"; 
} 
} 
else 
{ 
?> 
<br> 
<FORM ACTION="samename.php" METHOD="POST" ENCTYPE="multipart/form-data"> 
<input name="doc" type="file"> 
<input type="submit" value="Upload File" name="upload"> 
</form> 
<? 
}
?>

OwenTheSamoan

Thanks for the reply. Please bare with me, I am really new to
this. I made a few changes to the script to work with jpegs
and I changed "doc" in the script to "image" is that right?
This is what I did. Also I notice that you only have one field
for the database? Another is I want to have it that the image
appears in a profile automatically when I set the select
statement like this "select * from table where userid= '$userid'"
How do I set up the rest so that it takes the info from the database
and then calls up the image from the file on the server.
Can you please give me the rest of the scrip to create the
database table and the to call up the image?
Thanks so much. I've been having a lot of trouble with this.

<?
$conn = mysql_connect("localhost", "mysqluser", "mysqlpass") or die ("Could not connect to database!");
$db = mysql_select_db("databasename") or die ("Could not select database");
$queryview = "select * from tablename";
$resultview = mysql_query($queryview) or die ("Could not upload file");

while ($rowview = mysql_fetch_array($resultview))
{
?>
<img src="<? echo $row['fieldname1']; ?>" target="_blank"><? echo $row 'fieldname1']; ?>"></a><br><br>
}
<?
if (isset($upload))
{
$conn = mysql_connect("localhost", "mysqluser", "mysqlpass") or die ("Could not connect to database!");
$db = mysql_select_db("databasename") or die ("Could not select database");

if ($image_type == "image/pjpeg") // this will be different depending on file type ie a jpg would be "image/pjpeg" it checks more than just the extension so if someone made a vbscript file and changed the extension to .jpg, it wouldn't let you upload

{
copy($image, "file path" . $image_name); // make sure you have write permissions to directory
echo "<br>File uploaded successfully";

$query = "insert into table name (fieldname1) values ('$image_name');";
$result = mysql_query($query) or die ("Could not upload file");
}
else
{
echo "<br>Files must have certain extension";
}
}
else
{
?>
<br>
<FORM ACTION="samename.php" METHOD="POST" ENCTYPE="multipart/form-data">
<input name="image" type="file">
<input type="submit" value="Upload File" name="upload">
</form>
<?
}
?>

stolzyboy

you can have any number of items in your form that input into the database, then if you want a pic to be assigned to a certain person, you would put something like

$member . "" . $image in the copy function, then you can use the variable before the "" to find the pics and then write them to the screen

OwenTheSamoan

Thanks for getting back to me, but I am still very confused.
I can't seem to get this right. In the script you have
target="_blank". What am I supposed to put in here?
Also for my database table I want the fields of "username",
and whatever necessary fields I need to make this work.
I seem to be naming the fields improperly. Could you PLEASE
show me the script to create a proper database table
to match the script and the proper script to call up the image?
I'm trying but I can't seem to get it right. I really am
new at this. Thanks again.

stolzyboy

are you able to use some sort of mysql tool to create tables, or are you only able to do this thru telnet/ssh, or thru php scripts, the first is the easiest, as far as the target="_blank", you can take that out, that was to open a pdf into a new window, not an html attribute for the img tag, with the tables you can do

CREATE TABLE `table` (
`username` VARCHAR(255), 
`password` VARCHAR(255), 
`imagename` VARCHAR(255)
);

you can add as many fields as you want

OwenTheSamoan

I'm using telenet and php scripts to make my tables
so if I just copy and paste the table into the dos prompt
that's not a problem. Don't I need more fields in my
table to make this work? Just take out "target"?
Don't I need a filed in my table with the correct path
or anymore info in my tables to make this work?
How about a script to call up the image?

I'm very lost at this moment.

Thanks for getting back to me so quickly.

stolzyboy

yes just take out the target="_blank" in your image tag, you asked me about this, and it depends on what you want to store on the members on how many fields you want, the bare minimum should probably be a username, password, imagename, and id field, id field for easier deletion later, and auto increment the id field also, to show the image in a script, do as i said before, draw the image dependent on the user then display it, you will need to query the database dependent on the users name if you want, or you can just choose a random image and put that in the img tab

<img src="path/$imagename"> this will be the variable you set after you query the database, this stuff is really hard to explain to a true newb, sorry if this isn't any help

OwenTheSamoan

I'm following you, but not 100% could you please put the
whole thing into a script from beginning to end to show
me how this would work? I've been looking everywhere
but I can't find the whole process from beginning to end
on this. I need the complete mysql table set up and the
script to pull out the images based on a username. I do
appreciate your help but I really do need to see the
complete thing from beginning to end to see how it all
comes together because I can't seem to get it right.
Thanks again. If you don't have the whole thing
from beginning to end do you know where I might
find the whole script for this. Something not too
complicated. Thanks!

stolzyboy

why don't you send me a private message with your email message and i will work on something and get back to you, may take a little while, but i will work on something

OwenTheSamoan

I'll do that. Thank so much!. I really do appreciate it!!!

wannasub

Hi guys ive been looking for ther same thing...ive written a script that users use to create a profile and upload an image I need to rewrite my script so that they can upload a set amount of pics but I need it to resize the original image to a set size as at the moment the pics are far too big for my design and its messing the whole thing up.

Could either of you help me.

my email is aaron@adultinfo4u.co.uk

thanks

OwenTheSamoan

If you're using mysql to store some of the info of the person and pic you can try this to limit the number. Lets use 5 pics as a limit.

$sql_userid_check=mysql_query("select userid from table where whatever='$whatever'");

$userid_check=mysql_num_rows($sql_userid_check);

if($userid_check >=5){
echo " You are allowed only five photos per profile";
}
else {
Then put in your script that you're using to load the image to the profile.

This is what I am going to try to limit the amount of pics per profile. I use this for other things and it works. Not sure about limiting the size of the pic though after it's been loaded. You may want to try limiting the size before they load the pic.

I'd love to see the script you are using to add pics to the profiles. I'm having a lot of trouble with this.

wannasub

thanks for the reply

if ($file1_name != "") {
		mkdir ("uploads/$user", 0777);
		copy("$file1", "uploads/$user/$file1_name");
		$pic = $url."/uploads/".$user."/".$file1_name;
		}

the $url variable is held within my config.php and is just the url to the uploads directory

I think what I am going to try and get the user data into the database first then get them to upload the pics after but I will need to carry their user id over to the image processing page any idea how this is done?

OwenTheSamoan

sounds like you're having the same problem as I am. There are scripts out there where the user can upload a pic to a file and at the same time store all the info about the user and the pic in a database table. I'm still hoping to find a script that shows me all of this. If you want to carry the userid into the table you can carry it over to the page using sessions. Are you using sessions or cookies to register different variables when the user logs in?

	session_register('userid');
	$_SESSION['userid'] = $userid;

Then just put "userid" as one of your values in part of your "insert script that you'll use to store the picture info in a table. You can use "username" also in place of userid.