How to: Upload images using PHP

[toplisek]

store in a database and display the results where you want

Do you know what function (code) to use if I would like to store files like e.g. images and what function to use for showing results?

[Sheldon]

well sorry i didnt really answer that very well, its been a long day

If it were me and i havnt really looked at the code,
but here

// now let's move the file to its final location and allocate the new filename to it
@move_uploaded_file($_FILES[$fieldname]['tmp_name'], $uploadFilename)
    or error('receiving directory insuffiecient permission', $uploadForm);
    
// If you got this far, everything has worked and the file has been successfully saved.
// We are now going to redirect the client to a success page.
header('Location: ' . $uploadSuccess); 

I would add a mySQL insert script

like this

// now let's move the file to its final location and allocate the new filename to it
@move_uploaded_file($_FILES[$fieldname]['tmp_name'], $uploadFilename)
    or error('receiving directory insuffiecient permission', $uploadForm);
 //in addition to Bokeh's script you can insert each record into a database.

$q = "INSERT INTO table_name (`filename`,`date`) VALUES ('$uploadFilename',$date(dMy))"; 
$s = mysql_query($q);
//if an error
echo(mysql_error());

// If you got this far, everything has worked and the file has been successfully saved.
// We are now going to redirect the client to a success page.
header('Location: ' . $uploadSuccess); 

and to display it would be a simple select script

[myztic]

I suck at this. I'm more than a newbie, I'm a baby. I want to create a webpage that will allow a friend of mine to upload pictures using my website. I have read so much on formhandlers and php that now I am dizzy and even more confused. Is there someone out there that can help me make this webpage along with step by step instructions on how to impliment it. I use frontpage 2003. I also need it to be able to do multiple files. thank you

[Sheldon]

then dump frontpage and download bokehs multiple upload script and put it in your root dir. It will just work as long as you have php enabled on your server.

[tylivia]

Would you like FTP view or showing results on web site?

I would like the results on the web site...more specifically to show on the page once uploaded.

I figured that it would have to go into a database, but I am a rookie at databases.

How would I get the pics that were uploaded to view on a page in real-time?

[Sheldon]

Refer to my post following toplisek's reponse. assuming you konw how to set up a database and have access to a mySQL database. Thats would be the first thing to check.

then you want something like this.

[housey]

Hi,

OK, the image uploads ok, now I want to stick the filename into an existing row field. I don't get an error and the redirect works after the upload. Also I don't want to insert the whole path just the filename, am I using $uploadFilename ?

My code is:

// If you got this far, everything has worked and the file has been successfully saved.
// We are now going to redirect the client to the success page.
// But first add the image filename to the database
require_once('includes/connect.php');
$regid = $_SESSION['ladyid'];
$sql = "UPDATE femaleusers SET image = '$uploadFilename' WHERE id = '$regid'";  
header('Location: ' . $uploadSuccess); 

$regid holds the correct value and so does $uploadFilename as I echo'd them out to test.

Many thanks if anyone can shed some light on this!

[bokeh]

Are you actually running the query, because the the query in your post is followed by header(Location:...) which in therory would cause a user abort.

[housey]

Yes, thanks.... although now I have the whole path and file name, like 'C:\blah\file.jpg'.

Which variable should I use??

[bokeh]

Where are those backslashes coming from?

[Sheldon]

I thought this was a sticky?

as Bokeh said, You need to run the query before sending them away with a header request.

// If you got this far, everything has worked and the file has been successfully saved.
// We are now going to redirect the client to the success page.
// But first add the image filename to the database
require_once('includes/connect.php');
$regid = $_SESSION['ladyid'];
$sql = "UPDATE femaleusers SET image = '$uploadFilename' WHERE id = '$regid'";  
mysql_query($sql);//run the query
echo(mysql_error));//echo any errors
header('Location: ' . $uploadSuccess); 

$_SESSION['ladyid']; ?? what are you building? a porn site?

[bokeh]

I thought this was a sticky?

The tutorial is sticky and it links to this one.

[rch10007]

$_SESSION['ladyid']; ?? what are you building? a porn site?

He should post the URL so we can check the code and make sure it is standards compliant!

[housey]

@ALL
Thanks for all the help on this...

Where are those backslashes coming from?

Sorry, my mistake when typing... more like C:/blah/file.jpg

mysql_query($sql);//run the query
echo(mysql_error));//echo any errors
header('Location: ' . $uploadSuccess);

I've now got the query running, if I put echo(mysql_error));//echo any errors in there I get an error with header('Location... saying header already sent... anyway it DOES now insert the filename in the correct field in the db but I have the whole upload path, I just want file.jpg but couldn't see what variable to use instead of $uploadFilename.

$_SESSION['ladyid']; ?? what are you building? a porn site?

Hehe... nope, not quite.. its a site for introductions more than anything... the ladies are all Thai.

Thanks again for all the help....

[housey]

hi,

I know I haven't looked at this in awhile but I just thought i'd post my solution, simple for a non-newbie but I thought someone might find it useful.

I added an extra variable after the while loop (for giving the file a unique name):

//name var for image
$imagename = $now.'-'.$_FILES[$fieldname]['name']; 

This gives me a variable of just the filename so I can insert it in the image field in the db with the sql query:

$sql = "UPDATE femaleusers SET image = '$imagename' WHERE id = '$regid'";  
mysql_query($sql);//run the query 

Not rocket science but maybe helps someone...