jandrews Posted March 18, 2009 Share Posted March 18, 2009 Hello all, I am currently in the process of making a new web site for musicians. The basis of the site is an archive/folder of mp3 files containing the file names: "artist-track.mp3" I have been making static html web-sites for some time and I am fairly new to PHP but I do have some understanding of PHP code. So far, I have made a web-site template which includes a working PHP forum talking to a mysql database. But I struggling to find a way to make my several thousand mp3 tracks easily navigable by artist name and then by track. I need some kind of way (instead of manually integrating thousands of mp3 files) of being able to do the following: 1. An alphabetical navigation bar for querying and displaying all artists by that letter. 2. This artists page will display query results as hyperlinks to take the user to a page for that artist. 3. A page for each artist with a list of their tracks (these query results will be hyperlinked to take the user to a page for that particular track. 4. Once a user has navigated to the page containing a particular track, a flash player will appear on the page to play the mp3 file. 5. A link on the track page to download the mp3 file. I know this is a big ask but I have been trying to figure out a way to do this for some time and any help to point me in the right direction will be greatly appreciated. Thanks James Quote Link to comment https://forums.phpfreaks.com/topic/149987-oh-all-knowledgeable-ones-please-help-me-mysql-database-driven-navigation/ Share on other sites More sharing options...
Maq Posted March 18, 2009 Share Posted March 18, 2009 This is a pretty big task. I suggest you read up on Database Normalization and follow this tutorial on Basic Pagination. Quote Link to comment https://forums.phpfreaks.com/topic/149987-oh-all-knowledgeable-ones-please-help-me-mysql-database-driven-navigation/#findComment-787694 Share on other sites More sharing options...
KielSolomon18 Posted May 5, 2009 Share Posted May 5, 2009 My suggestion is try to search web site with free templates for you web site. Quote Link to comment https://forums.phpfreaks.com/topic/149987-oh-all-knowledgeable-ones-please-help-me-mysql-database-driven-navigation/#findComment-826435 Share on other sites More sharing options...
RussellReal Posted May 5, 2009 Share Posted May 5, 2009 look into php freelancers.. I am one myself, and I could possibly create the search feature, pm me if you're interested Quote Link to comment https://forums.phpfreaks.com/topic/149987-oh-all-knowledgeable-ones-please-help-me-mysql-database-driven-navigation/#findComment-826491 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.