/    Sign up×
Community /Pin to ProfileBookmark

php+database music categorization

Hello

This will be the most complex question I have ever asked… so bare with me ?
In short I would like in near future to create a database for my music collection. I have seen a few turorials about making something like this but the difference is that I don´t care about the artist details and such.

This is what I had in mind of the final view.

There would be somewhat a genres search, but with already fixed values. Each value could be checked and when hitting the search button it will list all of those desired hits that match what was checked

for instance:

There are main genres and then there are like sub genres and then styles or whatever…. Here I just list 2 subdirectory for the sake of simplicity.

[B]Trance ->[/B]
vocal-trance
dreamdance
hard trance
[B]Rock ->[/B]
hardrock
softrock
metal
[B]RnB ->[/B]
soft
ordinary
heavy
[B]HipHop – >[/B]
soft
bore
other

… and then you could search manually for artists and albums
When selecting trance for instance you can then select one or multiple of sub-genres and when clicking on search it will list all the matches.


—————————–

That´s about it,,, and ofcouse some kind of a form to enter new information and perhaps even edit already existing information.

My webhost is already providing all the tools needed, like php, mysql. And there is this cpanel where you can administrate the tables from the MyPhp panel. So those we do not have to install at least ?

Will this be a nightmare to create or is there an almost working script like this already?

to post a comment
PHP

7 Comments(s)

Copy linkTweet thisAlerts:
@themartyJul 27.2006 — [url=http://www.hotscripts.com/PHP/Scripts_and_Programs/Music_Libraries/index.html]hotscripts[/url]

[url=http://www.scripts.com/php-scripts/music-scripts/]Scripts.com[/url]

[url=http://www.google.nl/search?hl=nl&q=php+script+music+library&btnG=Google+zoeken&meta=]google[/url]
Copy linkTweet thisAlerts:
@SiddanauthorJul 27.2006 — Hey, ok so I found a few sites from the hotscripts archive

The Kplaylist is just too much I guess, it is very well done but not so appropriate for me just yet.

Some are able to extract information from the ID tag of the mp3 file, like artist, song, album and comments.

Those are fine but... is it possible to seperate the text within the comments somehow so each seperation will be searchable.

for instance of a song. A trance song that has some vocals and is quite soft, and another that is only soft without vocals. So by typing vocals;soft in the comments for one song and only soft for the other. could I then be able to search for soft and find those both songs that contains the word "soft"?

... if u understand
Copy linkTweet thisAlerts:
@themartyJul 27.2006 — in mysql you can do this:

WHERE field LIKE '%soft%'

it will then return all the rows where the column with name 'field' contains the word 'soft'
Copy linkTweet thisAlerts:
@SiddanauthorJul 27.2006 — ok that sounds great which I might need more help with implementing when the time comes ? But... will it also return the word soft from the song title.. best would be if it only searches in the comments field
Copy linkTweet thisAlerts:
@themartyJul 28.2006 — if you put the comments and the song-title in different columns you can do whatever you want. A search on either one of them or both
Copy linkTweet thisAlerts:
@SiddanauthorJul 28.2006 — that´s what I wanted to hear ? So when time comes I may need some more specific help, thank you so far
Copy linkTweet thisAlerts:
@themartyJul 28.2006 — np

if you post the link to your new topic in this one, i will be notified of it
×

Success!

Help @Siddan spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 5.5,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,

tipper: @Samric24,
tipped: article
amount: 1000 SATS,
)...