WTB Music videos script (DB + XHTML is provided) - PHP

Discussion in 'Programming' started by old games & abandonware, Jul 5, 2009.

  1. #1
    I have a big music database and design in XHTML. I need the "engine" in PHP (barely any XHTML+CSS work needed).

    There are only three different pages:

    homepage - just links to categories
    two types of categories - one name based and second genre based (both are the same with just different selection of artists) - only links, nothing else
    artist page - embedded videos (I will provide links to Yahoo! Music in DB), images (again generated directly from DB), biography (also provided in DB) in IFRAME.

    I need automatic page generation from the database = one artist = one page => my db contains over 7000 artists & 27000 videos & images. Videos will be embedded from Yahoo! music. I need the script to download, rename (to artistname-songname.jpg) and store the images from yimg.com to local storage (it should be easy task).

    I need a fast and efficient (and cheap of course :-D) engine. Something that will not loop through 7000 rows every time user loads a page...

    I don't need any backend at the moment. I don't want to add categories, artists etc.

    Here's some sketch of the layout of the three pages. http://img246.imageshack.us/img246/6871/wtd.png

    Database example:
    First table:
    INSERT INTO `artists` (`id`, `name`, `slug`, `biography`, `bio_author`) VALUES
    (1, '10,000 Maniacs', '10000Maniacs', '10,000 Maniacs (named after the low-budget horror movie 2,000 Maniacs) was formed in Jamestown, NY, in 1981 by singer Natalie Merchant and guitarist John Lombardo. Other members of the sextet were Robert Buck (guitar), Steven Gustafson (bass), Dennis Drew (keyboards), and Jerry Augustyniak (drums). The group gigged extensively and recorded independently before signing with Elektra and making The Wishing Chair in 1985. Co-founder Lombardo left the band in 1986, and they continued as a quintet, releasing their second album, In My Tribe, in 1987. This album broke into the charts, where it stayed 77 weeks, peaking at number 37. Blind Man''s Zoo, the 1989 follow-up, hit number 13 and went gold. <p>\nAfter 1992''s Our Time in Eden had finished its run on the charts, Merchant announced that she was leaving for a solo career. MTV Unplugged was released a few months after her departure. The remaining 10,000 Maniacs decided to continue performing, adding the folk-rock duo John & Mary (original member Lombardo and violinist/vocalist Mary Ramsey). The new lineup released Love Among the Ruins. Merchant released her first solo album, Tigerlily, in the summer of 1995 and a follow-up, Ophelia, in 1998. In 1999, the remaining Maniacs released The Earth Pressed Flat on Bar/None. Sadly a year later lead guitarist and founding member Robert Buck, who co-wrote some of the band''s classics like "Hey Jack Kerouac," "What''s The Matter Here?," and "These Are Days," died of liver failure. He was 42. ~ William Ruhlmann, All Music Guide', 'William Ruhlmann'),
    
    Code (markup):
    Second table:
    INSERT INTO `categories` (`id`, `category`) VALUES
    (1, '1980s Hip Hop'),
    
    Code (markup):
    Third table:
    INSERT INTO `videos` (`id`, `artist_id`, `category_id`, `yahoo_id`, `title`, `slug`, `url`, `thumb_url`) VALUES
    (1, 1924, 1, '2161725', 'Real Compton City G''s', 'Real-Compton-City-G''s', 'http://new.music.yahoo.com/Eazy-E/videos/view/Real-Compton-City-G''s--2161725', 'http://d.yimg.com/ec/image/v1/video/2161725'),
    
    Code (markup):
    Of course SEO URLS (there is a column in DB called slug which contains SEOd name of the row).

    Price? Time? Any references? Higher iTrader = better.
     
  2. old games & abandonware

    old games & abandonware Active Member

    Messages:
    429
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    90
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    Work done by Spawny.

    Thanks everyone