Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 4 of 4
  1. #1
    Junior Member
    Join Date
    Dec 2009
    Posts
    2
    Member #
    20645
    I am currently working on a DJ's website. He wants to have a list of music available on the site, is there a way to take an excel spreadsheet and make a searchable and scrollable list of music in his collection? I was thinking it may be able to be done through php.

  2.  

  3. #2
    WDF Staff mlseim's Avatar
    Join Date
    Apr 2004
    Location
    Cottage Grove, Minnesota
    Posts
    7,724
    Member #
    5580
    Liked
    718 times
    I'll describe the process, but getting there is another story.

    1) He already has an excel spreadsheet with the list that includes,
    title, artist, album, year, keywords, description, and any codes the identify the album.

    2) The excel file gets saved as a .csv (Comma Seperated Variable) type file.

    meanwhile ...

    3) On the webhost, a MySQL database is created that will contain all songs.

    4) A special PHP script is made that takes the .csv file and populates the database.
    This is only used 1 time ... to get the excel data into the online MySQL database.

    5) An PHP admin page is made so any future songs can be uploaded to the database,
    added, deleted, edited, etc.

    6) A PHP script that accesses the online database and displays information.
    Displays by querying the database, searches, groups, albums, keywords, etc.

    All of this will take a lot of time to program and build the structure.

    ===================================

    Another idea is to take an existing script system and install it, then customize it
    for your own use. This will also take time and programming experience.

    This might be a good place to start:
    http://www.google.com/search?q=free+...ase&hl=en&sa=2


  4. #3
    Junior Member
    Join Date
    Dec 2009
    Posts
    2
    Member #
    20645
    Thanks for the reply, looks like this may be a little more complex than I thought. I'll have to look further into it.

  5. #4
    WDF Staff smoseley's Avatar
    Join Date
    Mar 2003
    Location
    Boston, MA
    Posts
    9,729
    Member #
    819
    Liked
    205 times


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 10:34 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com