mishawakaguy50 Posted February 9, 2012 Share Posted February 9, 2012 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! Quote Link to comment https://forums.phpfreaks.com/topic/256752-mysql-data-base-creation/ Share on other sites More sharing options...
fenway Posted February 9, 2012 Share Posted February 9, 2012 Database hwo? Quote Link to comment https://forums.phpfreaks.com/topic/256752-mysql-data-base-creation/#findComment-1316285 Share on other sites More sharing options...
Berre Posted February 10, 2012 Share Posted February 10, 2012 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) Quote Link to comment https://forums.phpfreaks.com/topic/256752-mysql-data-base-creation/#findComment-1316423 Share on other sites More sharing options...
gizmola Posted February 10, 2012 Share Posted February 10, 2012 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. Quote Link to comment https://forums.phpfreaks.com/topic/256752-mysql-data-base-creation/#findComment-1316471 Share on other sites More sharing options...
mishawakaguy50 Posted February 10, 2012 Author Share Posted February 10, 2012 Thank you for your responce gizmola, it helped and I have properly set up the data base and it works fine. As for the responce by berre, I NEVER asked anyone to write any kind of a script for me! I was asking a simple question. So once again thanks gizmola I appreciate your help. Quote Link to comment https://forums.phpfreaks.com/topic/256752-mysql-data-base-creation/#findComment-1316542 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.