|
Welcome, Guest. Please Login or Register.
Aug 27th, 2008, 10:39pm
Author |
Topic: PHP and MySql (Read 1279 times) |
|
Higgens
Newbie
I love YaBB 1G - SP1!
Posts: 10
|
 |
PHP and MySql
on: Nov 1st, 2004, 10:01pm |
Quote | Modify
|
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.
|
|
 IP Logged |
|
|
|
Higgens
Newbie
I love YaBB 1G - SP1!
Posts: 10
|
 |
Re: PHP and MySql
Reply #1 on: Jan 19th, 2005, 2:02pm |
Quote | Modify
|
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.
|
|
IP Logged |
|
|
|
PlatinumSM
Junior Member
I love YaBB 1G - SP1!
Posts: 14
|
|
Re: PHP and MySql
Reply #3 on: Jan 28th, 2005, 8:50pm |
Quote | Modify
|
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
|
|
IP Logged |
|
|
|
pheisholt
Senior Member
WWW | Email
Posts: 306
|
|
Re: PHP and MySql
Reply #4 on: Feb 4th, 2005, 3:29pm |
Quote | Modify
|
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?
|
|
IP Logged |
- paul -
|
|
|
PlatinumSM
Junior Member
I love YaBB 1G - SP1!
Posts: 14
|
|
Re: PHP and MySql
Reply #5 on: Feb 4th, 2005, 6:19pm |
Quote | Modify
|
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
|
|
IP Logged |
|
|
|
rcarljohnson
Full Member
Who lives in a pineapple under the sea?
Posts: 58
|
|
Re: PHP and MySql
Reply #6 on: Feb 7th, 2005, 4:37am |
Quote | Modify
|
Very nice guys!
Please, share your experiences and let us know how you are performing your magic.
Thanks in advance!
Bob
|
|
IP Logged |
Want a Free iPod Photo?
Want a Free iPod Mini?
|
|
|
O-N-E
Guest
Email
|
on Jan 19th, 2005, 2:03pm, Higgens wrote: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?
|
|
IP Logged |
|
|
|
PlatinumSM
Junior Member
I love YaBB 1G - SP1!
Posts: 14
|
|
Re: PHP and MySql
Reply #8 on: Feb 13th, 2005, 10:12am |
Quote | Modify
|
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
|
|
IP Logged |
|
|
|
pheisholt
Senior Member
WWW | Email
Posts: 306
|
|
Re: PHP and MySql
Reply #9 on: Feb 13th, 2005, 3:02pm |
Quote | Modify
|
Sounds great! Will be looking forward to that.
|
|
IP Logged |
- paul -
|
|
|
O-N-E
Guest
Email
|
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
|
|
IP Logged |
|
|
|
PlatinumSMatWork
Guest
Email
|
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.
|
|
IP Logged |
|
|
|
PlatinumSMatWork
Guest
Email
|
err.. i mean on the searching that you can search both artists and album titles.
|
|
IP Logged |
|
|
|
Higgens
Newbie
I love YaBB 1G - SP1!
Posts: 10
|
|
Re: PHP and MySql
Reply #14 on: Feb 18th, 2005, 3:25am |
Quote | Modify
|
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.
|
|
IP Logged |
|
|
|
|
