PHP: Specific Areas for each person

[Luke]

That depends, where would you like to move it? To a sub-directory?

[Bennett 🚀]

Directly to database if possible.. though I have no idea how to display them..

[Luke]

Erm... I don't exactly understand what you are trying to do? Are you trying to add the image into the MySQL database? Not possible.

When uploading the image it should be directly uploaded to the folder you want it to be in. The database, all it really does is store information on that image. (Date uploaded, file name, file location, user, etc.)

[Bennett 🚀]

Oh..
So i need to make a sub-directory, move it to there? then how does the mySQL get the information?

[Luke]

mysql_query("SELECT fname FROM uploaded_images WHERE fname='blah.png' LIMIT 1;");

Have a read on this: w3schools.com/php/php_mysql_intro.asp

[Bennett 🚀]

I know that But is "fname" or "uploaded_images" the sub-directory?

[Luke]

fname would be the column in the database that stores the images file name, and uploaded_images would be the table in the database.

[Bennett 🚀]

... Then where does the sub-directory play in? And btw, do you have a method on how I could rename the file, as in example.png to 2141345.png ?

[Luke]

If you are planning on storing images in different sub-directory's then I suggest you create a new column that stores the directory the image is in.

For changing the image name, when it is uploaded and you are moving it that's when you would change the name.

move_uploaded_file($_FILES['file']['tmp_name'], $newfilename)

[Bennett 🚀]

In lamen's terms please, lol.. and the second part would be like:

$newfilename = rand(0, 9999);
move_uploaded_file($_FILES['file']['tmp_name'], $newfilename)

[Luke]

Well first off if you don't know what I am talking about you should study the structure of a MySQL database. Google it.

[Charles Stover]

It's possible to store images directly to MySQL. Just not recommended, since it's a huge MySQL load and would possibly crash the server if the site got large enough.

Anyway:

SELECT `url` FROM `images` WHERE `user` = $user_id

When they upload a file:
$url = '/images/' . rand(0, 9999) . '.' $extension;
move temporary uploaded file to $url
although I'd recommend replacing rand(0, 9999) to be something alphanumeric.
INSERT INTO `images` (`user`, `url`) VALUES ($user_id, "$url")

[Chris]

Dec 7, 2009 20:26:24 GMT -8 Charles Stover said:

It's possible to store images directly to MySQL. Just not recommended, since it's a huge MySQL load and would possibly crash the server if the site got large enough.

Anyway:

SELECT `url` FROM `images` WHERE `user` = $user_id

When they upload a file:
$url = '/images/' . rand(0, 9999) . '.' $extension;
move temporary uploaded file to $url
although I'd recommend replacing rand(0, 9999) to be something alphanumeric.
INSERT INTO `images` (`user`, `url`) VALUES ($user_id, "$url")

Just since it wasn't mentioned in this post, make sure to also include a part of the script that checks to see if the file already exists and assigns a different random name until it doesn't exist. That way you don't have to worry about a file getting overridden.

Pseudo code for above: (PHP styled, but not necessarily right names.)
while(file_exists($rand_name)){
$rand_name = gen_new_rand_name();
}

Just something like that.

[Bennett 🚀]

Okay.. so mySQL really isn't needed? besides using it in the member area?

[Charles Stover]

Definitely not. You should be storing the images flatfile, not in MySQL.
For guests:
*file is uploaded*
*file is moved to permanent location*
*permanent URL is output for the uploader*

The end.