Log in

View Full Version : PHP and MySql



avelde
11-02-2004, 02:01 AM
http://avelde.mine.nu/music/music.php

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
01-19-2005, 06:02 PM
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
01-19-2005, 06:03 PM
Forgot to mention the URL:
http://avelde.mine.nu/items/index.php

PlatinumSM
01-29-2005, 12:50 AM
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.
http://www.mp3t.com

pheisholt
02-04-2005, 07:29 PM
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
02-04-2005, 10:19 PM
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: http://www.mp3t.com

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

rcarljohnson
02-07-2005, 08:37 AM
Very nice guys!

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

Thanks in advance!

Bob

Guest
02-09-2005, 01:27 AM
Forgot to mention the URL:
http://avelde.mine.nu/items/index.php
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
02-13-2005, 02:12 PM
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
02-13-2005, 07:02 PM
Sounds great! Will be looking forward to that.

rcarljohnson
02-14-2005, 09:31 AM
Yes... Very much looking forward to that!

Thanks!!!

Bob

Guest
02-14-2005, 04:09 PM
Ok, it's sound good. But do you mean mysql or ms sql, cuz I only use mysql :-/ . and for me right now the only REAL problem is that you cant search in the exported html, the other problems i can live with. of cause it would be nice with som automatic export or even mysql and php. i dont really need the ability to add directly on-line, so just using the application would work fine since it's awesome! But with out the ability search on web (i want my collection on-line) I don't want to buy this product and I will look for an alternative :-/

Guest
02-14-2005, 06:19 PM
The .dax will let you output a SQL script file that you can upload to a database of your choice. I am using both MYSql and SQL Server 2000 for testing.

Also I will include the PHP and ASP script for displaying artists, albums and searching each of the following.

I will release it just as soon as I finish testing both versions.

:P

Guest
02-14-2005, 06:20 PM
err.. i mean on the searching that you can search both artists and album titles.

avelde
02-18-2005, 07:25 AM
Hi,

I'm trying to get some more features in the site. If I log on as administrator, I can change the template, use FreeDB, change information like names, song titles, etc., add artists, genres, search song titles and artists, change site configuration.

The things I just want to change is to add new CDs and to add the possibility to have songs and video's on one item. This isn't possible in OCD.
And of course more pictures with one item. So I have a directory with pictures with front, back, inside, book front, book back, etc. This isn't working at all, but necessary.

I use OCD only for CDs. But I want to add items like books with CDs, music DVDs etc.
I export the database with the SQL statement. But than I change it to fit in in my MySQL database. The database consists now of 10 tables and I'm not finished.

All the HTML is made by PHP. So that's the reason that you can choose a template. All the data is in a MySQL database, except the pictures. The pictures have the name of the item and a number saying what kind of picture it is, like front, back, etc. For example, 10_0100.jpg is the name for the front of item 100. The thumbnail is 99_0100.jpg.