PHP and MySql

[avelde]

[url]http://avelde.mine.nu/music/music.php[/url]

This is my first try with php. Now I have to make it look like my own. This one is, of course completely based on the CMI style, but I'm working on it.

Just take a look.

[avelde]

I've made a new one, because of the problems with combined sets, like DVDs and CDs. The database for DVDs is different, so I've changed the database for CDs also.

Hope you like it. It is somewhat based on the template from DVDdb.

[avelde]

Forgot to mention the URL:
[url]http://avelde.mine.nu/items/index.php[/url]

[PlatinumSM]

Higgens, this is an absolutely fantastic feature.

Any chance you could share your experience to help me get up to speed with what you have created? I have a somewhat large collection that I am bringing from a customized Andromedia ASP site into Orange and I was hoping for some database interactivity with it.

Is the web script something that you generate as part of the export template? or are you exporting your database into some other format ? (XML, delimited flat file, etc) that your PHP script feeds on or maybe you transofrm it to a MySQL db?

here is the collection I am hoping to dynamisize.
[url]http://www.mp3t.com[/url]

[pheisholt]

Nice work, Higgens.
Would you mind telling the forum a little more about how you created your php/mysql based music site.

How do you add new albums to the site? Do you run a complete export from OCD each time you want to update your site?

[PlatinumSM]

I have communicated with him and seen some of the basic structure of this great idea. I am going to see if I can make a few modifications of the idea and see what it does.

for now:

HTML generated output from Orange: [url]http://www.mp3t.com[/url]

PHP version with mySQL: [url]http://www.mp3t.com/mp3catalog/music.php[/url]

[rcarljohnson]

Very nice guys!

Please, share your experiences and let us know how you are performing your magic.

Thanks in advance!

Bob

[Guest]

Forgot to mention the URL:
[url]http://avelde.mine.nu/items/index.php[/url]

PLEASE! Could I get this php-script? Especially the search function, because to be honest, the html export really sucks without being able to search. Can it also be modified easily to enable searching song titles?

[PlatinumSM]

I plan on releasing a version of the .dax for SQL export plus some PHP script soon, now that i have purchased Orange.

Artist Rollups
Proper artist and album sorting (Artist ,The; Artist, De)
Searching

[pheisholt]

Sounds great! Will be looking forward to that.