need help on storing links in mysql

[dewteks]

Hello all,
can anyone help me with a script to store short video or audio clips in a directory and have mysql store its upload name and the link to the file in a table.I also want to be able to call up the video(s) through the browser with php.

Thanks for your response.

[eelixduppy]

There are a few things you need to deal with here...

First is the uploading of the movie file. Refer to Handling File Uploads [us3.php.net] for more information regarding that process. There are a couple things you should keep in mind, however. Those are to watch out for your server's settings, especially when dealing with movie uploads that could potentially be large and take a lot of time to upload. Make sure you take a look at the following directives because it may cause problems for you down the line:

See also the file_uploads, upload_max_filesize, upload_tmp_dir, post_max_size and max_input_time directives in php.ini

And now for the database part. We have a few threads in the php forum's library that may help you with the process:
[webmasterworld.com...]
[webmasterworld.com...]

And you should definitely take a peek at the mysql functions [php.net] at php.net.

Let's see where this gets you. If you need further help in this area, the general topic is more php related so you might want to take a swing by the php forum [webmasterworld.com] if you run into trouble. There is a plethora of great minds willing to help out.

Good luck :)

[dewteks]

thanks.
What i need to know is do a need a binary datatype for the field to add the links or a normal varchar2 will do.
Im ok with uploading files into a specified directory, just needed info on storing the resulted filename path in a database.