Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: PHP and MySql

  1. #1
    Join Date
    Oct 2004
    Location
    Posts
    10

    Default PHP and MySql

    [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.

  2. #2
    Join Date
    Oct 2004
    Location
    Posts
    10

    Default Re: PHP and MySql

    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.

  3. #3
    Join Date
    Oct 2004
    Location
    Posts
    10

    Default Re: PHP and MySql

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

  4. #4

    Default Re: PHP and MySql

    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]

  5. #5
    Join Date
    Mar 2004
    Location
    Posts
    312

    Default Re: PHP and MySql

    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?

  6. #6

    Default Re: PHP and MySql

    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]

  7. #7
    Join Date
    Dec 2003
    Location
    South Carolina
    Posts
    63

    Default Re: PHP and MySql

    Very nice guys!

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

    Thanks in advance!

    Bob

  8. #8
    Guest Guest

    Default Re: PHP and MySql

    Quote Originally Posted by Higgens
    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?

  9. #9

    Default Re: PHP and MySql

    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


  10. #10
    Join Date
    Mar 2004
    Location
    Posts
    312

    Default Re: PHP and MySql

    Sounds great! Will be looking forward to that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •