DaniWeb Forum Index > Web Development > PHP

Uploading files to mysql

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2004

Posts: 257

Reputation: sam1 is an unknown quantity at this point

Solved Threads: 1

sam1

Offline

Posting Whiz in Training

Uploading files to mysql

Feb 26th, 2009

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

•

Join Date: Nov 2007

Posts: 3,760

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: Uploading files to mysql

Feb 26th, 2009

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...ile_upload.php

Last edited by nav33n; Feb 26th, 2009 at 8:49 am.

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Jan 2009

Posts: 60

Reputation: Andrieux is an unknown quantity at this point

Solved Threads: 4

Andrieux

Offline

Junior Poster in Training

Re: Uploading files to mysql

Feb 26th, 2009

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.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?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);
 
?>
<?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.

•

Join Date: Nov 2004

Posts: 257

Reputation: sam1 is an unknown quantity at this point

Solved Threads: 1

sam1

Offline

Posting Whiz in Training

Re: Uploading files to mysql

Feb 26th, 2009

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";

Last edited by sam1; Feb 26th, 2009 at 11:01 am.

•

Join Date: Nov 2007

Posts: 3,760

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: Uploading files to mysql

Feb 26th, 2009

•

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 ?