Image Uploading - mkdir or randomname?

bluns

Hey guys, I have created a script which uploads an image to the http server saving the image path in my mysql database along with the rest of the article.

This works fine, but not if an image is uploaded of the same name as another article, eg the original file is then replaced.

The best way to stop this i think is to create a dir with the same name as as the id field (auto increment). But i am not sure if it is possible to know the next id # before the database is actually created. I know i could do a query to find the highest id# and + 1 but if i deleted the last article, it would ruin the whole script.

Is it possible to find the next auto increment of the id field before you create the database entry?

This way i will just mkdir and save the image path with the id field as the dir fixing my problems

Sorry if my english is bad 🙂

Thanks

planetsim

There maybe an easier way firstly you will need to check if the filename on the server already exists if so create a random file name making sure you keep the file extension the same.


//cut out of one of my scripts
$getFileExt=explode(".",$_FILES['uploadfile']['name']);
$numDot=count($getFileExt);
$_FILES['uploadfile']['name'] = substr(md5(uniqid(mktime())),0,15).".".$getFileExt[($numDot-1)];

As you can see the $_FILES['uploadfile']['name'] stays the same so no need to use extra variables.

Basically the file name wil be 15characters long by using the mktime() The Current Time in a Unix Time Stamp than uses uniqid basically doesnt do much in this script just makes sure it doesnt go all weird. Then the File name is hased you can get rid of the md5() if you rather just see numbers. But to be truly random that just helps.

$getFileExt[($numDot-1)];

That just gets the extension which is checking to make sure there are no extra . within the file name and gets the very last bit of information of the last . this would be the filename.

Hope this helps

TruckStuff

Just give the files a random name, save the file, then created your DB record. Best file time would be along the lines of md5(microtime());

bluns

WoW! Thankyou very very much planetsim!!!!!

That is exactly what I needed!

Thankyou again 😃😃😃