Topic: Mysql Data Base Creation

[mishawakaguy50]

I have Mysql version 5.0.91 installed on my web server along with php version 5.2.12. I have embeed a music player on my site called flash mp3 player which requires PHP. It works fine with no problems. What I want to do if it is possible, I had to create a folder called mp3 on my server which I have done, and I uploaded  all of my mp3 files to my server into this directory. Since MYSQL is already installed on my server, is it possible to create a database of all my mps files? I want to create this data base so I can create a text file of all my songs and put the list on my website. I'm new to MYSQL and would appreciate any help or suggestions!

[fenway]

Database hwo?

[Berre]

You should probably learn the basics of MySQL before you ask questions. No one are here to make scripts for other people, but rather help with getting them to work properly.

http://www.google.com/search?q=mysql+AND+php+AND+(tutorial+OR+introduction)

[gizmola]

PHP could absolutely accomplish this goal.  MP3's support a tag header that is read by players, and this same tagging system (known as id3) can be read in a number of ways, within a php script.  There is an extension and several libraries out there that can ready the id3.

Here's a link to 2:

http://www.php.net/manual/en/function.id3-get-tag.php
http://getid3.sourceforge.net/


In short what your script would need to do is:
-traverse all the files in the directory
-call one of the id3 functions
-use this to create a row in your song table in the mysql database

So in short, you are able to do this with php, but as stated, this is a help site, and you need to gain a modicum of skill, and actually create some code, before people will help you.