Uploading files to mysql

[sam1]

hi,

I am trying to learn how to upload multiple Music files to server then save information about them in database e.g. albumname, filename, type and maybe url. i have few questions:

1. would i be able to write the albumname in database as the folder i am uploading to. if so how?

2. how would i upload multiple files..

as i am a newbie can you guys please show me an example of this...

thanks

[nav33n]

1. Yes. Since you know where you will be uploading the file, you can save the foldername as albumname
2. By using multiple <input type='file' > tag

I am not sure if the examples in these links work, but, this is how you do it.
http://www.phpeasystep.com/workshopview.php?id=2
http://www.plus2net.com/php_tutorial/php_multi_file_upload.php

[Andrieux]

It's not as hard as you'd think.

Say that that you're creating a Pastebin. You'd have (simplified) the fields id, title, and filename. The filename could be random. For our purposes, $input is what the user is saving in the document, $title is the title, and we'll create the filename.

<?php

$title = mysql_real_escape_string($title);
$filename = rand(1,1000) . substr(0, 5, time());

mysql_query("INSERT INTO `pastebin`(title, filename) VALUES('$title', '$filename')");

$fh = fopen($filename . ".txt", +w);
fwrite($fh, $input);
fclose($fh);

?>

Of course, that's just creating it.

[sam1]

I got the answer to second question basically i will pass the id of textbox to insert.

but how would i actually write the url dynamically upon uploading, to database. say i am uploading into a folder called 'album1' 5 mp3s. now how would i insert in database album1/mp3.mp3, without hardcoding it like $path = "album1";

[nav33n]

but how would i actually write the url dynamically upon uploading, to database. say i am uploading into a folder called 'album1' 5 mp3s. now how would i insert in database album1/mp3.mp3, without hardcoding it like $path = "album1";

Check move_uploaded_file . You have to specify the 'destination' where you want to upload the file. Use the same destination :-/ Right ?